Convert MySQL and SQLite

SQLite ----> MySql

  1. Download sqlite3.exe on http://www.sqlite.org
  2. Export the SQLite database with sqlite3.exe and command parameter ".dump" (Nate, ".export" doesn't exist!), an example :
    sqlite3 mySQLiteDataBase .dump .quit >> myDumpSQLite
  3. 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"
  4. The dump is ready to get imported in a MySQL server

MySql ----> SQLite

  1. Export the database in an ASCII compatible format. (functionnality available in phpMyAdmin 2.6.1)
  2. Import to SQLite with command line : sqlite3 mySQLiteDataBase < dumpMySQL
Convert MySQL and SQLite Convert MySQL and  SQLite Reviewed by D' Karimun C-11 on 14.54 Rating: 5

2 komentar:

  1. sipp catatannya Om, gw juga lagi nyari nih

    BalasHapus

  2. IONQQ menyediakan permainan poker, domino99, bandarq, bandarpoker,aduq,sakong,perang bacarat dan capsa :D
    ayo ditunggu apa lagi
    WA : +855 1537 3217

    BalasHapus

Diberdayakan oleh Blogger.