Hello –
One of the goals of our project is to be able for me to export data automatically at specific times and my colleague on the other side of the world be able to import that same data automatically, shortly thereafter.
He does not want me to be updating his database direclty, so the database sync wizard is out.
So we thought that if we both scheduled jobs, mine being an export followed by an ftp, and his being an import from a file someplace on his system, we would be good to go. However…
We seem to be stumbling on two points…
1. I don't see how to do an export of a .csv file automatically using the SQLyog job scheduler. I can see how to export SQL however.
2. On the other side, he says he can't import SQL from a file as a datasource in an automated job from SQLyog. However, he could import .csv as an automated job using SQLyog if I could output .csv. (Which I can't see how to do in the job scheduler.)
Any ideas or suggestions?
Thanks kindly,
Priscilla