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

When Executing A Backup Sql File

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › When Executing A Backup Sql File

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • November 18, 2015 at 12:19 pm #13444
      A Stahl
      Member

      Hi all,

       

      It would be great when trying to restore tables from a sql backup if it would show the tables that are in the backup file.

       

      Then allow you to pick and choose the tables you would like to restore.

       

      Also why is there a mix of CR/LF’s and LF’s within the .sql file?

       

      Ashley

    • November 19, 2015 at 1:55 pm #35550
      A Stahl
      Member

      Hi All,

       

      Never mind I have found that one can do this by changing one backs up the tables.

       

      Ashley

    • November 23, 2015 at 3:41 pm #35551
      Sibin A S
      Moderator

      Hello A Stahl,

       

      It is possible to import data from a sql file as a whole, and there isn’t an option to select certain tables to be imported as the sql statements in the sql file are executed as they appear in the file and it is not able to parse only certain statements from a sql file. 

       

      Mean while, you can execute the sql script into a database and then perform the sync with the existing database to import certain tables.

       

      In the later imports, you can try backing up the database with “Scheduled Backups” with the option to create separate files for objects by selecting the option “Separate file for each object” under the title “How do you want to generate the script?” in the same dialog that enables you to create a sql backup file for individual table which would help you in the further stages while importing only certain tables into the database.

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