Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Exporting And Importing

forums forums SQLyog Using SQLyog Exporting And Importing

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • #11678
      Junk1958
      Member

      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

Viewing 0 reply threads
  • You must be logged in to reply to this topic.