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