从测试数据库更新生产数据库的脚本

Question

On my local computer I have a test environment running XAMPP. I am working on a PHP / MySQL application.

Now I often make changes to the local website, but when I want to upload I have to do a lot of work. This is what I do now.

I export my local DB trough phpMyAdmin
I clear my remote DB I import the exported DB.

Sometimes the DB is kind of large so it takes a lot of time. Is there a script I can use that speeds up this process.

I have no remote access to the production DB
When I make changes to the local DB the website is turned off, so its just a mirror when done

Answer 1

You could use Phing's DBDeploy Task to manage your database migrations. This has the advantage that any changes to your database become an integral part of your versioning system.

Here is an article describing how to do it:

• http://www.davedevelopment.co.uk/2008/04/14/how-to-simple-database-migrations-with-phing-and-dbdeploy/ (now 404 - see comments)

Alternatives are Rob Allen's Akrabat_Schema_Manager and I think Doctrine has one too.