Re: Best way to automatically get mySQL database.

thanks thought there was something simpler Jay Blanchard wrote:

[snip] We've got a local system (PHP intranet) and we need to connect to a live mySQL server get some of the tables (contents) and overwrite the same tables in the local mySQL database. This needs to be done with PHP. Im wondering the best to do this. Is it to get all the information into result sets for each table and then delete the contents of each local table and then looping through the result sets just insert the information into the local tables? This seems like a good solution but I wonder if there are any out there before going ahead with development. [/snip] TRUNCATE local_table; SELECT remote_stuff INTO local_table;

-- ------------------------------------------------------------------------ Angelo Zanetti Systems developer ------------------------------------------------------------------------ *Telephone:* +27 (021) 552 9799 *Mobile:* +27 (0) 72 441 3355 *Fax:* +27 (0) 86 681 5885 * Web:* http://www.zlogic.co.za *E-Mail:* angelo@zlogic.co.za <mailto:angelo@zlogic.co.za>