Navigation
Features
Manual
What's new
FAQ
Imprint

FAQ

Contents     Index    << Previous    Next >>    PDF

SQL File

Menu: File / Import / SQL File


Executes all SQL queries from the specified file in the selected database.

SQL queries are executed directly without first loading the entire file into the SQL Editor. This means the execution is much faster and saves system resources.



Error Handling: (Only CSV file)

Deactivates MySQL-Front error handling. This means data records are written to the database much faster.  

Error show:
Only shows errors that occurred without informing the user explicitly.  
 
Error Save in file:
Saves the sections with an error during importing to a file.  


Important note:
Unfortunately the different MySQL version are not absolutely compatible. This means if you try to import a SQL file of MySQL 5.x to a 4.0 database this forces a lot of problems.  
 
This is not a bug of MySQL-Front or a bug of MySQL. This is an incompatibility only.  
 
To copy data from one MySQL to an other MySQL you can use Transfer feature.