adrianosaaquino

## gist:5372dd87414ff65c07f9
Create dump.

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

Restore dump.

$ mysql -uroot -proot schema_name < file.sql

## gist:97c7f505e3ab50235c78
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';

## gist:2808e2493f478117250e
CREATE SCHEMA `name` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

## gist:2208979
/etc/mysql/my.cnf
default-storage-engine=innodb
	Create dump.

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

	Restore dump.

	$ mysql -uroot -proot schema_name < file.sql
	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';