How can we take a backup of a mysql table and how can we
restore it. ?
- 7 Answers
- 16715 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
Can you specify the "new line" character in single-quoted strings?
Tell me which programming language does php resemble to?
What is fetch array in php?
Where session is stored?
Tell me how to strip whitespace (or other characters) from the beginning and end of a string?
What is overriding in php?
What are the different types of statements that are present in php?
What are the different opening and closing tags available in PHP?
Tell me how is it possible to parse a configuration file?
Which of the data type is compound datatype supported by PHP?
What is mvc in php?
Is false empty php?
What is the use of Mbstring?
What PHP stands for?
Explain what does the expression exception::__tostring means?
