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
- 17980 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 file upload?
Is php a strongly typed language?
What is the difference between php and javascript?
What is the use of mysql_real_escape_string in php?
How do you put a space in html?
What is the difference between $name and $$name?
What is session in c#?
What is the use of anonymous function in php?
Explain what is meant by pear in php?
Explain what are psrs?
How to Retrieve the Session ID of the Current Session?
Is null function in php?
How are sessions maintained?
Is php developer in demand?
Why php is used in html?
