Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => PostgreSQL and SQLite Support => Topic started by: PieterV on January 11, 2013, 02:19:30 PM

Title: SQLite to MySQL migration
Post by: PieterV on January 11, 2013, 02:19:30 PM
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!
Title: Re: SQLite to MySQL migration
Post by: vbgamer45 on January 11, 2013, 02:21:51 PM
I did a search on the forums we have an unofficial tool found here
http://www.simplemachines.org/community/index.php?topic=476264.0
Title: Re: SQLite to MySQL migration
Post by: emanuele on January 11, 2013, 02:36:33 PM
Would you have any issue (or would you need any assistance) let me know. ;)
Title: Re: SQLite to MySQL migration
Post by: PieterV on January 12, 2013, 01:16:30 PM
How do I run the script? Do I need to upload it using the package manager?
Title: Re: SQLite to MySQL migration
Post by: emanuele on January 12, 2013, 03:00:08 PM
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.
Title: Re: SQLite to MySQL migration
Post by: PieterV on January 12, 2013, 07:08:21 PM
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.
Title: Re: SQLite to MySQL migration
Post by: emanuele on January 13, 2013, 04:07:30 AM
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.
Title: Re: SQLite to MySQL migration
Post by: PieterV on January 13, 2013, 08:25:31 AM
Thanks, I'll look into it.
Title: Re: SQLite to MySQL migration
Post by: Oldiesmann on January 18, 2013, 03:24:30 PM
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.