#1227 - Better development workflow for database management

Identifier #1227
Issue type Feature request or suggestion
Title Better development workflow for database management
Status Completed
Handling member Chris Graham
Addon core
Description Create and bundle scripts for making and importing SQL dumps. _config.php is read to determine what database details to use. It is assumed whoever running the db_init.sh script knows the MySQL root password and can type it in when prompted.
Steps to reproduce

Use a standard filename (db.sql), and block reading of it in the recommended.htaccess and plain.htaccess files.

db_init.sh -- creates database using "mysql -uroot -p -e <sql>" where SQL is similar to here http://jetpackweb.com/blog/2009/07/20/bash-script-to-create-mysql-database-and-user/

db_export.sh -- runs mysqldump to db.sql.

db_import.sh -- runs mysql -u<user> -p<pass> <database> < db.sql

Funded? No
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Rating

Unrated