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 python similar to php?
What Is a Persistent Cookie?
What are php data types?
Explain the installation of PHP on UNIX systems?
What is the best website to learn php?
Tell me what type of operation is needed when passing values through a form or an url?
How to enable error reporting in php?
What is PHP's configuration file called?
iam mca post graduate in 2010 not getting job in JAVA so iam looking for carear in php as market demand is high so it is best option to try for php or not
How to initiate a session in php?
What is the use of header() function in PHP? What the Limitation of HEADER()?
What does php exit do?
Explain the changes in php versions?
Which is better php praogramming or cad/cam scope wise and also salaray wise?
Explain about switch statement in PHP?