Home > Documentation >
MS Access to MySQL > Tutorial
Step 2 of 7. MySQL script file settings
This wizard page allows to specify how the resulting dump file should be
formatted. There are following settings available:
- MySQL version - determines the syntax of SQL statements.
'Old' versions (before 3.23.6) put more restrictions on database object
names. 'Old' syntax is accepted by 'new' versions of the server but not
vice versa. Use 'old' syntax whenever you are not sure about the version
of MySQL server.
- Line breaks - specifies how to separate text lines in the dump
file. 'MS Windows style' option means to use '\r\n', 'Unix style' means to use
'\n' as end of line.
- Add lock for write around 'INSERT' statements - makes import of
the dump file into database much faster. To use this feature in MySQL 4.0
and higher it requires global LOCK TABLES privilege and SELECT privilege
on the involved tables. In MySQL 3.23 and earlier you need to have SELECT,
INSERT, DELETE and UPDATE privileges for the tables.
- Insert 'CREATE DATABASE' statement
- Insert 'CREATE TABLE' statements - always select this option in order
to get valid dump file. The only exception is appending the data to existing
- Insert comments
See Import MySQL dump files article to
learn how to import script file to MySQL server. Have questions?