Interested to Buy Any Domain ? << Click Here >> for more details...
How can we take a backup of a mysql table and how can we
restore it. ?
- 7 Answers
- 18212 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
What is singleton design pattern in php?
Is php pass by reference or value?
What is the difference between php and java?
Explain about objects in PHP?
What is a collection in php?
How to write php function in html onclick?
How can you pass a variable by reference?
Tell me how can we display information of a variable and readable by human with php?
What are global variables in php?
What is cookie?
What is prepared statement in php?
Why session timeout is important?
Tell me what the difference between the 'bitwise and' operator and the 'logical and' operator?
Is nan in javascript?
How to remove leading and trailing spaces from user input values?
