SQLite to MySQL FAQ

[SQLite to MySQL Converter] [Introduction] [Tutorial]

Below are the most frequently asked questions regarding SQLite to MySQL converter. If your question is not covered by this FAQ, please contact Intelligent Converters specialists via Feedback Form

What versions of SQLite and MySQL are supported?
Is it possible to convert SQLite to MySQL straight forward?
How to resolve "The program does not support authentication protocol requested by server..." error?
Does SQLite to MySQL converter support automation?
What kind of SQLite data is converted to MySQL?
What are the limitations of SQLite to MySQL converter?
How to change destination table name?
It is possible to connect to MySQL over SSH with SQLite to MySQL converter?
Why I cannot find resulting MySQL script and/or log file?

What versions of SQLite and MySQL are supported?
SQLite to MySQL converter supports the following variations of source and destination DBMS:

all versions of SQLite
on-premises MySQL, MariaDB and Percona
cloud Azure for MySQL
cloud Amazon RDS and Aurora
Google Cloud SQL for MySQL

Go to Top

Is it possible to convert SQLite to MySQL straight forward?
Some specialists suggest the quick and easiest way to migrate SQLite to MySQL including the following two steps:

Export SQLite database to dump file using SQLite .dump command.
```
sqlite3 sample.db .dump > dump.sql
```

import SQLite dump into the MySQL database

mysql -p -u root -h {MySQL host} {MySQL database} < dump.sql

This solution can work with simple databases that are not affected by the grammar differences between MySQL and SQLite:

SQLite uses double quotes to enclose database entry names, while MySQL uses backticks for the same
Auto-increment columns are declared as AUTOINCREMENT in SQLite and AUTO_INCREMENT in MySQL

So, for the real SQLite databases this migration method most likely will not work.

How to resolve "The program does not support authentication protocol requested by server..." error?
Old versions of MySQL (before 4.1.0) uses the authentication based on a password hashing algorithm that is not supported by SQLite to MySQL converter. You can make the particular account compatible with the converter using OLD_PASSWORD function. Login to the target MySQL server under account having administrator privileges and run the following statements:

    mysql> USE mysql;
    mysql> UPDATE user SET Password = OLD_PASSWORD('some_pass')
        -> WHERE Host = 'some_host' AND User = 'some_user';
    mysql> FLUSH PRIVILEGES;

Replace 'some_pass', 'some_host' and 'some_user' by the actual values. Now the 'some_user' MySQL account can be used for SQLite to MySQL converter.
Go to Top

Does SQLite to MySQL converter support automation?
SQLite to MySQL converter does not support automation directly. However, there is console version of the program l2sagent.exe in the installation directory. This tool accepts command line arguments and so it can be called from any script. It is possible to write a simple batch script calling l2sagent.exe with necessary parameters and execute it recurrently using Windows Task Scheduler. Please refer to Command line article to learn more about l2sagent.exe.
Go to Top

What kind of SQLite data is converted to MySQL?
SQLite to MySQL converter handles table definitions with all necessary attributes, data, indexes and foreign keys.
Go to Top

What are the limitations of SQLite to MySQL converter?
The program does not migrate stored procedures, triggers and views. Besides, free demo (trial) version of the tool converts not more than 50 records per table and does not convert foreign keys.
Go to Top

How to change destination table name?
SQLite to MySQL converter allows to rename tables and to edit attributes of every column as well as excluding a column from migration. You can access this feature by double-clicking on the corresponding selected item on "Select Tables" wizard page. In the appeared dialog box you can modify table name.
Go to Top

It is possible to connect to the target database server over SSH from SQLite to MySQL converter?
Yes, SQLite to MySQL converter supports SSH connection to MySQL server. Please refer to this article for the further information.
Go to Top