exporting and importing MySQL databases

gistfile1.sh

# Export database from MySQL:
sudo mysqldump -u database_username database_name > path_to_file_to_export_to.sql

gistfile2.sql

# Create new database in MySQL:
CREATE DATABASE database_name;

gistfile3.sql

# Grant privileges on the database:
GRANT ALL PRIVILEGES ON database_name.* TO 'db_username'@'localhost' IDENTIFIED BY 'password';

gistfile4.sh

# Import the Database data:
sudo mysql -h db_server db_name < file_to_import_from.sql

# example
sudo mysql -h localhost project_dev < project_dev-2009-01-01.sql