Serendipity Forums

A few weekends ago I decided that I wanted to convert my site from mySQL into SQLite. I had various reasons in mind, the main being that I am just plain insane. Besides that, the mySQL server on my VPS is fairly bogged down with two large sites and I wanted to take any burden off the mySQL server as I could. Being nuts only pushed the fact harder.

The issue is that s9y does not have a full exporter so that I can purely do an export and them import it back into the new database. I tried to repopulate the database with plugin information first -- installing all the same plugins -- and then grabbing the exported data from mySQL and importing it into the database.

I kept having issue converting the data from mySQL into SQLite. I was able to get a basic format working from phpmyadmin so that I would not get many errors while importing. There were some posts (about 1 out of 10) that would not import into the database automatically. I've tried to use all of the tools I can find on Windows, OS X, and Linux without much luck. It seems that most of the tools out there are for SQLite 3 rather than 2.

My question is: Has anyone successfully done this before? I would love to see how its been done as I am currently stumped.

If this is not a possibility I would also like to hear that as I need to hear it from someone else before completely giving up on this.

Thanks,
Zac

Hi!

I'd proceed exactly like you did: Make a MySQL Dump file, use the plainest MySQL 3.23 SQL Dump format without any special characters or instructions. And then use a SQLitemanager tool to import a SQL dump, and make manual modifictions as required.

Which error messages did you get for which SQL statements?

Best regards,
Garvin

Hey Garvin,

It seems the issue was in the extended body field in the entries table. I was also missing another plugin which caused even more issues in other places. I just started another project, so getting this up and running got put onto the back burner.

Thanks,
Zac