How can we take a backup of a mysql table and how can we
restore it. ?
Answer Posted / kishore
mysqldump is an effective tool to backup MySQL database. It
creates a *.sql file with DROP table, CREATE table and
INSERT into sql-statements of the source database. To
restore the database, execute the *.sql file on destination
database.
Ex:
backup: # mysqldump -u root -p[root_password]
[database_name] > dumpfilename.sql
restore:# mysql -u root -p[root_password] [database_name] <
dumpfilename.sql
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Does php have a future?
How to check if a string contains a character or word in php?
What is the value for this auto incremented field user_pri_id?
What is the difference between for and foreach in php?
Tell me how do I check if a given variable is empty?
How to replace a substring in a given string in php?
Tell us how can we display the output directly to the browser?
How do you measure variables?
What is difference between array_merge and array_combine in php?
What are magic methods?
How is php different from other languages?
What is php limit?
What is the use of die in php?
What are the main error types in php and how do they differ?
Is php dying 2018?