Syncing the structure of two databases?

From: Date: Fri, 14 Mar 2003 02:10:12 +0000
Subject: Syncing the structure of two databases?
Groups: php.db 
Request: Send a blank email to php-db+get-26369@lists.php.net to get a copy of this message
Dear list, I'm developing an intranet-based application using PHP and MySQL. We release new versions of our application regularly, and synchronizing the structure of the databases is beginning to be a headache. Do any tools exist that would let me sync the structure of two databases? Ideally, I'd like to include a "mysqldump --no-data" (or something analogous) file with each of our releases, and run a script on the client's server that would update the structure of their own local database from that file. We're cross-platform (windows, linux, and mac). And, all servers are behind their own firewalls. I'm aware of sqlyog (http://www.webyog.com/sqlyog/download.html), but I need something that can be written in php, and works without a "live" connection to the "master" database. Any clues? Thanks, Matt

« previous php.db (#26369) next »