Databases

[Drakath]

Does anyone know a converter from MySQL to SQLite3?

Is MySQL better than SQLite3? (I'm talking about performance)

[Woovie]

http://sqlitebrowser.sourceforge.net/

[Drakath]

This browser can not open sql files and I want to convert sql to sqlite.

Also is MySQL better than SQLite3?

[Woovie]

Yes, it can.

Import and export databases from/to SQL dump files

MySQL is more robust. For 99% of MTA servers, SQLite is fine.

[Drakath]

When I try to import database from SQL server I get this: "Error importing data at line 41980268". It created a file but it is 115 MB less then my original database.

[Drakath]

Never mind, I tried it with a smaller database and it worked. This software is probably too weak to handle huge databases.

[Woovie]

Or you have an error at line 41980268

[Drakath]

There aren't even that many lines in my database. There are about 5 million lines.

[Woovie]

No, but the code is going to be bigger than the database. When you do a .sql dump, it stores information in a way I could see it possible having 41mil lines. Try opening it with Notepad++.