Taking a backup of a MySQL table and restoring it

Use the command below to take a backup of only one table:

# mysqldump -u db_username -p mydatabase table1 > table1.sql

Use the command below to restore the table:

#mysql -u db_username -p mydatabase < table1.sql

Vimal Monday 28 October 2013 - 08:05 am | | Default
Used tags: , , , ,

No comments

(optional field)
(optional field)

Comment moderation is enabled on this site. This means that your comment will not be visible until it has been approved by an editor.

Remember personal info?
Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.
« Steps to Reset the Da… | Home | How to configure e-ma… »