Importing data

Importing SQL

When importing data as SQL, the Import Assistant will walk you through the following steps:

Select a file

The first step is to select the file you would like to import. You can use the Choose button to select the file, or you can drag & drop the file on to the the file name display (which says <Unknown> by default). You should then select SQL as the format of the file and press the forward button in the bottom right corner.

Select a database (Optional)

If you are importing into a database that requires selection of a database (like MySQL), you will now be prompted to select which database to import the SQL into.

Error handling

Select what MacSQL should do if an error occurs during the import. For servers with transaction support, the entire import can be wrapped in a transaction that will be rolled-back on error. Otherwise, MacSQL can ignore errors or stop at the first error.

Do the import

The final step is to press the Start Import button. A progress bar will appear showing you how far along MacSQL is in the import. You will be notified once the import is complete.

---

Table of Contents