From:       To:      

Home > Documentation > MS Excel to MySQL > Tutorial

Step 2 of 5. MySQL script file settings

On this page Excel to MySQL converter allows to specify how the resulting script 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 tables.
  • Insert comments

See Import MySQL dump files article to learn how to import script file to MySQL server. Have questions? Contact us