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

Copy Database To Other Host

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Copy Database To Other Host

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • September 12, 2005 at 3:15 pm #9219
      peterlaursen
      Participant

      copy database to other host does not seem to work (yet?).

      See atached. View, procedures and functions are greyed out. there are 4 Views and 2 procedures in database that I copy from, but nothing gets copied.

      Forgot it ? 😛

      EDIT: changed 'table' to 'database'

    • September 13, 2005 at 7:20 am #19154
      Ritesh
      Member

      This is due to the fact that MySQL returns the SP, Function, Trigger definition with database name in it. Thus it looks like:

      create procedure db.table.xxxxxx ( …. )

      It is very difficult to correctly strip out the database name and execute it in a different context automatically.

      We have had a discussion with MySQL AB people and they said that they address this issue in v5.x. As of now, all the three options will be enabled when you copy the database to a different database with the same name.

    • September 13, 2005 at 1:46 pm #19155
      peterlaursen
      Participant

      Yes … it works! 😀

      I just did an extensive test with 4.2 and SSH-tunnelling between two machines. Among other things i also tested “copy database …” using SSH-tunneling. VIEWS and ROUTINES are transferred correctly when Database names are identical.

    • September 13, 2005 at 2:06 pm #19156
      Ritesh
      Member

      We should put in the FAQs

    • September 13, 2005 at 4:42 pm #19157
      peterlaursen
      Participant

      done!

      http://webyog.com/faq/index.php?action=art…d=32&artlang=en

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