Free SQLite to MySql Converter – Super Easy!

Heres how to copy my a development SQLite Database into a MySQL Production Database in 5 Easy Steps. Here’s the easiest way to do it. Seriously:

1. Install the SQLite Manager Firefox Addon

2. After the Addon is installed, in Firefox, go up to Tools > SQLite Manager (Opens the SQLite Manager Addon Window)

3. Click on the “Connect Database” Icon, looks like the Folder Open icon in any other program. Locate your SQLite Database file.

In a Ruby on Rails project you can find it in your rails_project > db > development.sqlite3

4. Back in the SQLite Manager Firefox Addon Window, go up to Database > Export Database (It will automatically export it as a SQL file just about ready to import into MySQL after the next step

5. Open that .sql file that was just exported in any basic text or code editor (ex: Notepad, TextEdit, TextMate, etc…). All you have to do now is do some find and replace SQLite specific syntax to MySQL syntax (easy):

find: AUTOINCREMENT   –   replace: AUTO_INCREMENT

find: ”   –   replace: [blank space - nothing - delete them all!!!]

Delete any line with this in it: “sqlite_sequence”, like the whole row. Example, you would delete both these rows:

CREATE TABLE sqlite_sequence(name,seq);
INSERT INTO sqlite_sequence VALUES(‘teams’,4);

Now it should be ready to import into your MySQL database. I used phpmyadmin by just going to yourhostingdomain.com/phpmyadmin, then clicked on the import link on the phpmyadmin front page, and browsed for our file we just finished modifying. You should be ready to rock.

Extra Reading

Here’s another article that explains only what is going on, but a good read nonetheless: Quick Easy Way to Migrate SQLite 3 to MySQL?

63 thoughts on “Free SQLite to MySql Converter – Super Easy!

  1. ???????????????????????????????????1?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
    ??????

  2. ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
    ?????

  3. Good Morning. I have not been there since july. It was because I was driving a vehicle to Washington because of my role at CIGNA Corporation. It takes a great deal of time from me, but I still think about your write up. I remember our days at Charles R. Drew University of Medicine & Science (CA) in Florida. So thrilled that we had a chance to play around the park. Please send my respect to Margaret as well as mack. Salut

  4. Ⅰ dοn’t know wһether іt’ѕ ϳust mе օr if ᥱverybody еlse encountering ⲣroblems
    աith ylur blog. Ιt ⅼooks
    like ѕome of tһе text οn yߋur posts aге running ߋff tһе screen.
    Cаn ѕomeone ᥱlse ρlease comment
    ɑnd lеt me қnoѡ if tҺіs іs
    happening tⲟ tһеm too?

    Тһіѕ could be a
    issue ᴡith mmy browser because ӏ’ᴠе һad tɦis ɦappen Ƅefore.
    Ꭺppreciate іt

    mʏ web ρage download nulled scripts

  5. I must say it was hard to find your site in google.
    You write interesting content but you should rank your website higher in search engines.

    If you don’t know how to do it search on youtube: how
    to rank a website Marcel’s way

  6. I intended to create you this little word to be able to thank you so much over again with your extraordinary principles you’ve featured in this case. This has been quite extremely open-handed of you to provide publicly just what a lot of folks would’ve sold as an electronic book to help make some dough for themselves, most importantly seeing that you could have tried it in the event you considered necessary. Those thoughts also acted as a fantastic way to fully grasp other individuals have the same desire just like mine to figure out very much more on the subject of this matter. I think there are numerous more fun moments up front for many who look over your website.

  7. Thanks for all your valuable efforts on this website. Betty loves working on internet research and it’s easy to understand why. My spouse and i learn all about the lively way you present precious secrets by means of this website and in addition increase contribution from some other people about this subject while our favorite girl is now learning so much. Take advantage of the remaining portion of the new year. You are doing a great job.

  8. Hello to all, it’s truly a pleasant for me to go to see this web page, it includes important
    Information.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>