Skip to content

Files

Latest commit

 

History

History

yuzhouwan-hacker-python

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 

Use MySQL instead of SQLite

generate

$ sqlite3 sqlite_database.db .dump > sqlite_database.sql
$ python sqlite2mysql.py sqlite_database.sql sql_database

import schema & data

# run com.yuzhouwan.common.util.StrUtilsTest.sqlData
mysql> source ~/sqlite_database.sql.database.sql

# run until all tables are created
mysql> source ~/sqlite_database.sql.schema.sql
mysql> source ~/sqlite_database.sql.data_normal.sql

# run until all throw duplication error
mysql> source ~/sqlite_database.sql.data_primary.sql