Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Aiheen aloitti: AbuGosok - tammikuu 22, 2009, 01:26:07 AP

Otsikko: Tools to Converting SQLite to MySQL
Kirjoitti: AbuGosok - tammikuu 22, 2009, 01:26:07 AP
Is there any tools to converts SQLite to MySQL?

I Installed my SMF 2.0 beta forum with SQLite as database engine.

Now I need to convert it to MySQL. Is there any way to do this?

I already tried "backup database" in Admin >> Maintenance >> Forum Maintenance >> Common Tasks

But it gives me SQLite *.db files. (In MySQL Mode, it gives *.sql files.)

Is there any tool?


Thanks for your attention :)
Otsikko: Re: Tools to Converting SQLite to MySQL
Kirjoitti: karlbenson - tammikuu 22, 2009, 05:08:10 AP
Theres no way to do it inside SMF.
AFAIk smf has not/is not providing any tools to convert it.

You would probably need to find third party tools/scripts to do it (using google or other SE)
Otsikko: Re: Tools to Converting SQLite to MySQL
Kirjoitti: greyknight17 - tammikuu 29, 2009, 11:02:55 IP
Don't know of a way to do this either. Did a search and not much about it. Closest I found was this site (http://forum.teamspeak.com/showthread.php?t=12184). I'm not sure if it only applies to their product there or overall for all conversions from SQLite to MySQL. Guess you can backup your database and give it a try.
Otsikko: Re: Tools to Converting SQLite to MySQL
Kirjoitti: dmsoft - helmikuu 13, 2009, 07:42:51 IP
Hello !

You can take a look at http://dbconvert.com/convert-sqlite-to-mysql-pro.php?DB=10

Otsikko: Re: Tools to Converting SQLite to MySQL
Kirjoitti: greyknight17 - maaliskuu 01, 2009, 06:39:38 IP
AbuGosok, if you just started using SMF 2.0, you might want to just start from the beginning again and create it using MySQL.

You can try the coversion tool posted above to see if it helps, but it looks like you will have to fork over around $80 just to do this conversion.

Topic locked.