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

Exporting / Syncing Database

forums › forums › SQLyog › Using SQLyog › Exporting / Syncing Database

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • April 25, 2011 at 4:27 pm #12314
      xpose
      Member

      II am planning to export/sync a database that is 2.5 gig in size between two boxes. Is SQLyog the best option for this or should I use the command line mysqldump?

    • April 25, 2011 at 9:35 pm #32174
      peterlaursen
      Participant

      If SQLyog is installed on the same machine as the MySQL server it does not matter as mysqldump and SQLyog are equally fast here (they do almost the same). But if not on same machine you will need a very fast connection to dump 2.5 GB to a remote client machine efficiently. In this case it will be faster to dump using mysqldump on the server. But next you will need to download the dump – so it could end up almost the same in total.

      But still I think that mysqldump+download will be somewhat faster than SQLyog dump to a remote client machine in this scenario in most cases.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.