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

Forums | Webyog

Tools to manage and monitor MySQL databases

Export/Import

This topic is empty.

Viewing 2 reply threads

Author

Posts
- February 14, 2003 at 3:07 pm #13738
  
  Ritesh
  Member
  
  Quote:
  
  So SQLyog don't support the “Export to another Database” and “Export to another Host/DB” option.
  
  SQLyog does have the option. Select the database and choose Copy Database… option from the Popup menu. It allows you to copy the database into another host/db.
  
  Quote:
  
  Then I notice that the SQLEditor doesn't have the save/load to file functions. It's only
  
  You can do that. Choose File->Open… and File->Save… option.
  
  Quote:
  
  After a big data import test with executing a batch script file I notice that it
  
  Can you tell us your config and the file size? Under all our test condition, SQLyog has been found to execute query in Batch File faster then other Front ends.
  
  Hope it helps.
- February 14, 2003 at 3:43 pm #13739
  
  bass
  Member
  
  My .sql file is a dump file of a database with over hundered of MyISAM
  
  tables.
  
  It's size is 1.991 KB and it has approximatly 13000 SQL statements.
  
  I loaded the file in the SQL-Editor of both programs and started
  
  the script.
  
  With the Mysql-Front program it took 2min 30sec
  
  with SQLyog the executing process not stoped over 9min…
  
  maybe ther is a bug??
- February 14, 2003 at 4:19 pm #13740
  
  Ritesh
  Member
  
  The fastest way to execute a batch script in SQLyog is to use Tools->Execute Batch File… option ( Ctrl+Shift+Q ) and just provide the name of the SQL file.
  
  Using this method you dont have to “open” the file in the editor window before executing it. This option has been optimized for VERY large batch scripts. It will also tell you the time take to execute the entire file. Pls. try it out and let us know your feedback.
Author

Posts

Viewing 2 reply threads

You must be logged in to reply to this topic.