Category: Manuals

[How To] Online Backup Innodb Tables

[How To] Online Backup Innodb Tables

Backup the database inevitable cause MySQL server unavailable to applications because when exporting, all tables acquired a global read lock using FLUSH TABLES WITH READ LOCK at the beginning of the dump until finish. So …
MySQL

[How To] Export, Backup Or Dump A MySQL Database

To export a MySQL database into a dump file, simply type the following command syntax in the shell. mysqldump -u username –ppassword database_name > dump.sql Replace username, password, database_name and dump.sql as your needs. All …
MySQL

[How To] Export A MySQL Database Structure

If You need to export only the MySQL database’s tables’ structures use –no-data switch. mysqldump -u username -ppassword –no-data database_name > dump.sql Don’t put space after -p and then password
MySQL

[How To] Backup Only Data of a MySQL Database

For exporting MySQL database’s only the data, use –no-create-info option. The dump will not re-create the database, tables, fields, and other structures when importing. mysqldump -u username -ppassword –no-create-info database_name > dump.sql Use this …
[How To] Backup MySQL Databases

[How To] Backup MySQL Databases

There are two methods to backup MySQL, first method is by copying all files such have extentions *.frm, *.MYD, and *.MYI, and second is by using mysqlhotcopy utility, this methods are only for MyISAM tables.