MySQL backup & restore

Backup database

• mysqldump.exe -u root db_name > \temp\db_backup_structure.sql
• mysqldump.exe –no-data -u root db_name > \temp\db_backup_structure.sql

Restore database

• mysql.exe -u root db_name < \temp\db_backup.sql

Web reference

http://tinyurl.com/9d9hw

http://www.silzenna.net/2009/01/31/mysql-backup-restore/

MySQL in pillole

Estrazione dell’intera struttura del db.

SQL Maestro for MySQL permette l’estrazione dell’intera struttura del database con il comando Tools > Extract database.