I'm currently working on a little PHP-project, where I would like the possibillety of automatically upgrading the MySQL-tables, so that users don't have the need to drop the database, and then run the installscript again, from a mysqldump of the original database I'm running.
What I was thinking, is a PHP-script that parses the running database, and a mysqldump --no-data of my database, and checks if it's something that doesn't match, and the run an ALTER TABLE of that..... Instead of reinventing the wheel; I was wondering if anyone has a better solution to it.... Is mysqldump capable of if not exists field... alter table add column.... ? Any ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
