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
Write a program using while loop?
What is __ construct in php?
What are the disadvantages of php?
What is PHP? Who is the father or inventor of PHP?
How the values are ordered in an array?
Tell me what is htaccess?
What is the use of trim function in php?
What is php how it works?
Do you know what does mvc stand for and what does each component do?
What is use of count() function in php?
What is use of in_array() function in php?
What is php limit?
How to create a session? How to remove data from a session?
What does the unlink() function means?
Why is php so popular?