Converting from mySQL to SQLite

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
chickens
Regular
Posts: 192
Joined: Wed Dec 06, 2006 12:15 am
Location: Vegas
Contact:
Contact chickens

Converting from mySQL to SQLite

Post by chickens »

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
Top
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:
Contact garvinhicking

Re: Converting from mySQL to SQLite

Post by garvinhicking »

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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Top
chickens
Regular
Posts: 192
Joined: Wed Dec 06, 2006 12:15 am
Location: Vegas
Contact:
Contact chickens

Post by chickens »

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
Top
Post Reply

Return to “General discussions”