SQLite to MySQL migration

[PieterV]

Hello everyone.

Let me start of by saying I have very little experience with this stuff.
( I can set basic stuff in Plesk, PhpMyAdmin, do FTP transfers/CHMOD and follow guides to the letter, but that's about as far as it goes )

Long story short:
I am member on a forum which is hosted by an unreliable host.
I've suggested to host the forum instead. I already have a working SMF running, so no troubles there.

The migrating is giving me issues though:

Admin sent me a backup of the SQLite database (with .db extension) he made in the admin CP.
Database is fairly large, 33MB (7MB zipped).
My server needs MySQL, so I need a way to convert it. PhpMyAdmin is said to only take up to 2MB of database files.
I'm terribly inexperienced in all this. Can someone give me some pointers?

Thanks!

[vbgamer45]

I did a search on the forums we have an unofficial tool found here
http://www.simplemachines.org/community/index.php?topic=476264.0

[emanuele]

Would you have any issue (or would you need any assistance) let me know.

[PieterV]

How do I run the script? Do I need to upload it using the package manager?

[emanuele]

Upload the script in the same directory of SMF and then through your browser open it (e.g. http://www.yoursite.tld/forum/sqlite_to_mysql.php) and follow the instructions.

[PieterV]

I don't have server access. I can only administer the forum. I'll have to pull some strings to get that fixed, but it might take a while.

So, my situation:
[SMF Old - bad host - no ftp access - SQLite] >>> database migration >>> [SMF New - good host - ftp access - MySQL]

I've already asked if they could look into it, but it usually takes 2 weeks to get a reply ... good reasons to switch, as you can imagine ...
Is there an easy alternative to convert the DB? Most of the stuff I find online seem geared towards server admins and/or cost a few organs.

[emanuele]

In order to do the conversion you need both SQLite and MySQL support on the same host, so...probably your best option is to download xampp or wampserver or similar and do the conversion on your own computer.

[PieterV]

Thanks, I'll look into it.

[Oldiesmann]

This option may be useful to you as well: http://otland.net/f479/convert-sqlite-mysql-database-pictures-47742/

Note that if you do go with that option, I highly recommend using NotePad++ or a similar tool for the editing portion, as Notepad doesn't handle large files very well.