Idea for DB Backup
Permalink
I did not know where else to put this.
I love that you have include the DB Backup utility in 5.4. I also really like the way it works in general for moving databases back and forth from dev to production easliy.
I have a simple suggestion to make the SQL script less error prone. That is to change the "DROP TABLE" syntax to "DROP TABLE IF EXISTS".
When using the sql script to move portions or entire dbs between machines, sometimes it is easier to run the script directly in MySQL. This allows it to run in a blank db without errors.
I have made this change in my copy and find it much easier to work with.
Just a suggestion.
I love that you have include the DB Backup utility in 5.4. I also really like the way it works in general for moving databases back and forth from dev to production easliy.
I have a simple suggestion to make the SQL script less error prone. That is to change the "DROP TABLE" syntax to "DROP TABLE IF EXISTS".
When using the sql script to move portions or entire dbs between machines, sometimes it is easier to run the script directly in MySQL. This allows it to run in a blank db without errors.
I have made this change in my copy and find it much easier to work with.
Just a suggestion.
