Sqlite to mysql


#1

Hi,
I’ve set up a website with forum for my wife and am already in over my head. I installed the forum Simple Machines(SMF) and it set itself up with sqlite.
We’ve had a few problems since, and one suggestion from the SMF forum was to move from sqlite to mysql.(It does support both)
I barely know what they are, and have no clue how to make the move. The site is new, but we’d rather not lose the posts that have already been made.
Is there an(easy) way to make the move and save the data? Do I even need to?
the site is www.flowercityparents.org
thanks
Will


#2

I’m not an SMF user, so if nobody jumps in here, do a database dump from SMF. Then create a new MySQL database and import the data:
http://wiki.dreamhost.com/MySQL
http://wiki.dreamhost.com/Restore_SQL_backup

These two steps can be done without interfering with your current setup.

-Scott


#3

SQLite -> MySQL conversion:

  • Dump each table from the SQLite database

  • Convert tables into MySQL-importable format

Reinstall SMF:

  • Create a new MySQL database

  • Rename /forum to /forum.old

  • Create new /forum directory

  • Install SMF into /forum using MySQL details

  • Import converted table data into new database

Maximum Cash Discount on any plan with MAXCASH

How To Install PHP.INI / ionCube on DreamHost