How can we take a backup of mysql table and restore it?


Top Questions

These are the simplest method to backup and restore the MySQl table

For taking the bakup of all the databases

mysqldump --user {user} --password {password} -A > {file name to dump}

To take the backup of a specific database

mysqldump --user {user} --password {password} dbname > {filename to dump}

To restore a SQL dump please use this

mysql --user {user} --password {password} dbName < {filename to restore}

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
3 + 1 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Check It !

Tweet It

W3 Updates

Stay informed on our latest news!

Syndicate content