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 1 reply thread
  • Author
    Posts
    • May 9, 2006 at 6:24 pm #9677
      Marcus Baffa
      Member

      Hi everybody,

      I am new in MySQL and SQLYog, I am using SQLYOG 5.02 with MYSQL 5.0.

      I have made a backup, using Run MYSQL Backup Command. All the files, frm and MYD were created. I am trying now to restore it with Run MYSQL Restore Command.

      The problem is that SQLYog returns an error saying that the “tables already exists, will not ovewrite on restore”.

      Well I know the tables exists what I want in fact is to overwrite them.

      I looked for a setup parameter but I could not find it. Maybe this is because I dont have experience in SQLYog.

      What must I do ????

      I need to restore the database

      Thanks in advance

    • 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 1 reply thread
  • You must be logged in to reply to this topic.