View source for Kexi/Migration/MySQL/Migration from file-based project to a MySQL database project

This is sqlite3 to mysql conversion using python script sqlite3-to-mysql.py, see also this [http://www.redmine.org/boards/2/topics/12793 thread].

Steps for importing mydb project from file into a MySQL db server:

1. Execute:
 % sqlite3 mydb.kexi .dump > mydb.sql
2. Download [[Kexi/Migration/sqlite3-to-mysql.py|sqlite3-to-mysql.py]] and run:
 % ./sqlite3-to-mysql.py mydb.sql > mydb.mysql
3. Create empty MySQL database
 % mysqladmin -p -u ..... create mydb
4. Finally, import
 % mysql -p -u ..... mydb < mydb.mysql

Notes:
*This tool can fail if large photos where stored in the database.
*This tool is pretty slow.
*Final solution will be just one click away in Kexi.