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
- 17684 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
Tell me what is the use of isset() in php?
Is laravel an oop?
What is the current stable version of php?
What type of operation is needed when passing values through a form or an url?
Which is the correct way to check if a session has already been started ?
Explain what is the main difference between require() and require_once()?
What is use of echo in php?
When is a conditional statement ended with endif?
Tell me what does pear stands for?
> symbol is used to redirect the output of a command. State Whether True or False?
How to close a session properly?
Why do you need to filter out empty files?
Can I learn php without knowing c?
What are the three parts of an http request?
What is a php tag?
