Move local SQL table data to remote MySQL table
Posted by: Doug Perkinson
Date: July 22, 2011 08:53AM

After 3 frustrating days of reading and trying ideas I found on various forums, I've decided to ask my questions here to the real MySQL experts..

I have local app with SQL backend. I have created a nightly schedule that pulls my desired data into a single SQL table, or I could also put into a Excel table if that works better. I also have a ftp scheduler which will move that table up to my webhost. Now here is my problem that should be easy, but i cannot seem to grasp.


On the webhost, I have a php app running with MySQL backend. Each night, I need the data in the existing MySQL table to be deleted, and then import/migrate the SQL (or Excel) table into the MySQL table. These steps would need to be automated via a script or scheduler of some sorts.

So that my problem...Any help would be appreciated. -- Doug

Options: ReplyQuote


Subject
Written By
Posted
Move local SQL table data to remote MySQL table
July 22, 2011 08:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.