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

Backup Multiple Databases With One Command

forums › forums › SQLyog › Using SQLyog › Backup Multiple Databases With One Command

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 25, 2006 at 9:10 am #9909
      Mike Zmuda
      Member

      Is it possible to backup multiple databases and their respective tables with one command using WebYog Enterprise? If so, how? If not, feature request?

      Also, is it possible to backup the whole user / priveleges (sp?) area as well (at the same time?) Also, how?

      Thanks –

      Mike Z.

    • September 25, 2006 at 10:01 am #22529
      peterlaursen
      Participant

      I think you asked the same question in a ticket?

      Please keep it one place!

      I replied this:

      “

      SQLyog 'export' tool and 'backup' powertool allow for backup of one database at a time. Wiht the 'backup powertool' you can create a batch-job like explained here:

      http://webyog.com/faq/27_35_en.html

      a comment to ” .. and related users / priviliges”

      BTW: It is NOT advisable to backup User Privileges and restore at another server unless you backup and restore a COMPLETE server. MySQL privileges' system is not designed for that!

      In a shared environment that will give you problems if it is possible at all! All users and privileges are stored in tables in the 'mysql' database.

      If it is your own server you can use the mysql 'mysqldump' program for a server side backup of the complete server.”

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