You could use replication of the occasional MySQLDump. Replication will make your development server a slave to your production server, causing every query done on the master to be reproduced on the slave.
See http://www.mysql.com/doc/en/Replication.html for more info. Mysqldump will create a script that will dump the data from production to your development box. If you will be manipulating the data on the dev server extensively, you will need this method to bring it back to conformance, as replication slaves (your dev box) would not be able to handle non-SELECT queries. See http://www.mysql.com/doc/en/mysqldump.html for info. Regards, Mike Hillyer www.vbmysql.com > -----Original Message----- > From: Leo Genyuk [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2003 12:54 PM > To: MYSQL-List (E-mail) > Subject: Updating MySQL db's > > > I have two server running Appache + PHP + MySQL. > > Server #1 is production and server#2 is development. > > I would like to keep MySQL DB on server#2 up to date. That is any > changes happening on server#1 I would like to be reflected on > server#2. > > Does anyone know how to do this? > > Thank you in advance. > > Leo. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]