How can we take a backup of a mysql table and how can we
restore it. ?
- 7 Answers
- 16613 Views
- Brain Infosys, Oracle, I also Faced
- E-Mail Answers
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
discuss the issue of software theft in ghana and how it has affected the economy
What is isset in php?
Can we use session in mvc?
Explain about switch statement in PHP?
What is preg_match?
What is url encoding and decoding in php?
What is php key?
What is apache and php?
How to block direct directory access in PHP?
What is empty php?
What is php rest api?
What is the use of final class in php?
What are psrs?
What is singleton pattern in php?
Explain the types of functions for Splitting String?
