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 Los Usuarios han Encontrado Esto Útil
¿Fue útil la respuesta?

Related Articles

Backup Mysql Database Using PHPMyAdmin

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