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

Batch File For Copying Databases

forums › forums › SQLyog › Using SQLyog › Batch File For Copying Databases

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • October 17, 2009 at 6:55 am #11713
      bkelley
      Member

      Hi, I have 50 MySQL databases on my server that I would like to copy to my home computer. I know that I can use the GUI command “Copy Database to Different host/database” for each one, but I'd like to find a way to avoid having to do that one-by-one. Is there a way to create a batch file that will do this? I don't want to do a “scheduled backup” that produces an SQLdump, for I want a copy of these databases on my home machine so that I can work with them with Crystal Reports, and also use them as backups. My data is changed only once every 90 days. Is there a way that I can make this task a bulk/batch file task?

      thanks for any help you can provide.

      best, Brian

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