Перенос базы с SQLite на MySQL

[shaman3D]

Подскажите как осуществить перенос базы?

[nissin]

http://sqlite.phxsoftware.com/forums/p/941/4725.aspx
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

In addition you should replace the following too in case you have boolean columns with default values:
* DEFAULT 't' -> DEFAULT '1'
* DEFAULT 'f' -> DEFAULT '0'

[toxi]

Как можно конвертировать MySQL в SQlite?
И нужно ли будет переустанавливать форум?

[nissin]

Примерно так:
http://forums.mysql.com/read.php?145,68269,92627

Код: Выделить всё

#!/bin/sh

mysqldump --compact --compatible=ansi --default-character-set=binary mydbname |
grep -v ' KEY "' |
grep -v ' UNIQUE KEY "' |
perl -e 'local $/;$_=<>;s/,\n\)/\n\)/gs;print "begin;\n";print;print "commit;\n"' |
perl -pe '
if (/^(INSERT.+?)\(/) {
$a=$1;
s/\\'\''/'\'\''/g;
s/\\n/\n/g;
s/\),\(/\);\n$a\(/g;
}
' |
sqlite3 output.db

Список конвертеров:
http://www.sqlite.org/cvstrac/wiki?p=ConverterTools