Tools to Converting SQLite to MySQL

[AbuGosok]

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

[karlbenson]

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)

[greyknight17]

Don't know of a way to do this either. Did a search and not much about it. Closest I found was this site. 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.

[dmsoft]

Hello !

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

[greyknight17]

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.