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 0 reply threads
  • Author
    Posts
    • 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 0 reply threads
  • You must be logged in to reply to this topic.