Backup and Restore Mysql Database using Mysqldump

Below are mysqldump commands for backup and restore mysql database:

WINDOWS:

Backup:
C:\mysql\bin> mysqldump --opt --user=username --password database > dumbfile.sql

Restore:
C:\mysql\bin>mysql --user=username --password database < dumpfile.sql

UNIX / LINUX

Backup:
mysqldump --opt --user=username --password database > dumbfile.sql

Restore:
mysqldump --opt --user=username --password database < dumbfile.sql

Notes:
- dumbfile.sql contains SQL command for creating tables and data. (CREATE,INSERT,DROP etc.)

  • 0 Els usuaris han Trobat Això Útil
Ha estat útil la resposta?

Related Articles

Backup Mysql Database Using PHPMyAdmin

1. Log into PHPMyAdmin. (You can get your PHPMyAdmin URL inside your cPanel / HELM) 2. Select...