SQLite ----> MySql
- Download sqlite3.exe on http://www.sqlite.org
- Export the SQLite database with sqlite3.exe and command parameter ".dump" (Nate, ".export" doesn't exist!), an example :
sqlite3 mySQLiteDataBase .dump .quit >> myDumpSQLite - Adapt the dump to get it compatible for MySQL
- Replace " (double-quotes) with ` (grave accent)
- Remove "BEGIN TRANSACTION;" "COMMIT;", and lines related to "sqlite_sequence"
- Replace "autoincrement" with "auto_increment" - The dump is ready to get imported in a MySQL server
MySql ----> SQLite
- Export the database in an ASCII compatible format. (functionnality available in phpMyAdmin 2.6.1)
- Import to SQLite with command line : sqlite3 mySQLiteDataBase < dumpMySQL
Convert MySQL and SQLite
Reviewed by D' Karimun C-11
on
14.54
Rating:
sipp catatannya Om, gw juga lagi nyari nih
BalasHapus
BalasHapusIONQQ menyediakan permainan poker, domino99, bandarq, bandarpoker,aduq,sakong,perang bacarat dan capsa :D
ayo ditunggu apa lagi
WA : +855 1537 3217