Importing Batch Files

You can use the import command on the main menu to quickly import a list of objects into the database, or execute a sequence of queries. The import dialog provides you with the option to use simple sql files, along with other compressed file formats that can be directly uploaded for data import. The formats that can be used depend upon the php modules that are available on the server. If you do not find a particular compression format supported in your MyWebSQL import dialog, please contact the server administrator or try enabling the respective modules in your php installation.

The size of the import file is also dependent upon the maximum allowed filesize that your server can upload. This is also a server side setting and can be modified to allow the filesize of your choice that can be used for the import operation.

If you check the option ‘Continue even if error occurs’, then the import command will continue execution even when a query fails. You should use this option with caution. Also review your database after import containing errors.

The result of import operation shows a success message and affected records, or an error showing the last query that caused the error. If the above mentioned option was checked, then you will shown the number of successful and failed queries and the number of affected records.