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

Backup And Restore

forums › forums › SQLyog › Using SQLyog › Backup And Restore

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • May 9, 2006 at 6:53 pm #21583
      peterlaursen
      Participant

      You may delete the database before restoring … but most likely you would prefer to rename the tables in it instead … Right-click each table and 'rename table' from 'tablename' to 'tablename_bak' for instance. Once you get the backup restored, and you are sure that that is what you want you can delete the *bak tables.

      Now when exporting please consider how many options you have … You have chosen NOT to include 'drop table' statements in the backup file! That is why 'create table' generates an error. Yo cannot create something that is!

      Also 5.1.x is recommended if you have non-english and non-ASCII characters in your data, as it backs-up using uft8 encoding.

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