sqlite to mysql

sqlite to mysql

Posted by: yurman
Posted on: 2009-02-22 17:49:00

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

Re: sqlite to mysql

Posted by: sdayman
Posted on: 2009-02-22 20:33:00

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

Re: sqlite to mysql

Posted by: sXi
Posted on: 2009-02-23 04:06:00

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




How To Install PHP.INI / ionCube on DreamHost

Tags: smf forumsimple machinescluesqlitesuggestion