View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 1227 | Composr | core | public | 2013-04-29 21:31 | 2013-06-14 21:58 |
| Reporter | Chris Graham | Assigned To | Chris Graham | ||
| Priority | normal | Severity | feature | ||
| Status | resolved | Resolution | fixed | ||
| Summary | 1227: Better development workflow for database management | ||||
| 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 | ||||
| Tags | No tags attached. | ||||
| Attach Tags | |||||
| Time estimation (hours) | 8 | ||||
| Sponsorship open | |||||
