Re: duplicating databases

2003-10-08 Thread Cal Evans
Check out sqlyog. (www.sqlyog.com) It has a structure sync tool. After making the first change, you could generate a script to make the change to the next database and then take that script and parameterize it so that a PHP script could use it to update all of your database. HOWEVER, A better

duplicating databases

2003-10-08 Thread Steve Buehler
I am running PHP/MySQL for a program that I am writing. We will have 100's or 1000's of databases that will be duplicates in structure. The problem is when I make a change to the database, I have to go to every database manually and make the change. All of the databases start with "a_" and