adrianosaaquino

/etc/mysql/my.cnf
default-storage-engine=innodb

adrianosaaquino

CREATE SCHEMA `name` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

adrianosaaquino

USE information_schema;

SELECT * FROM KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_NAME = 'table_name' AND REFERENCED_COLUMN_NAME = 'table_column' and TABLE_SCHEMA = 'schema_name';

adrianosaaquino

Create dump.

$ mysqldump -uroot -proot --no-data schema_name > file.sql

Restore dump.

$ mysql -uroot -proot schema_name < file.sql

adrianosaaquino

Create dump.

$ mysqldump -uroot -proot schema_name > file.sql

Restore dump.

$ mysql -uroot -proot schema_name < file.sql

adrianosaaquino

Create dump.

$ mysqldump -uroot -proot schema | gzip -c > file.sql.gz

Restore dump.

$ gunzip < file.sql.gz | mysqldump -uroot -proot schema

adrianosaaquino

Create dump.

$ mysqldump --single-transaction --skip-add-locks --skip-comments -uroot -proot schema | gzip -c > file.sql.gz

Restore dump.

$ gunzip < file.sql.gz | mysql -uroot -proot schema

adrianosaaquino

Create dump.

$ mysqldump -uroot -proot -B schema --table table_name | gzip > file_schema_table.sql.gz

Restore dump

$ gunzip file_schema_table.sql.gz | mysqldump -uroot -proot schema

adrianosaaquino

Create dump.

$ mysqldump -uroot -proot --all-databases | gzip > file.sql.gz

Restore dump.

$ gunzip file.sql.gz | mysqldump -uroot -proot

adrianosaaquino

Create dump.

$ mysqldump -uroot -proot schema_name table_name -w "date between '2013-01-01 00:00:00' and now()" | \ 
gzip > schema_name_table_name.sql.gz

Restore dump.

$ gunzip schema_name_table_name.sql.gz | mysql -uroot -proot schema_name