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
Is laravel an oop?
What is the use of pear in php?
Is php easy language to learn?
What is csrf token and why it is required?
What is the correct and the most two common way to start and finish a php block of code?
How a constant is defined in a php script?
Do you know what is the differences between $a != $B and $a !== $B?
How to find the index of an element in an array php?
What are the rules in creating php variable?
Tell me what is the main difference between require() and require_once()?
What does $globals mean?
Which is better #define or enum?
What is php default argument?
How to join multiple strings into a single string?
How to track no of user logged in?