Exporting sqlite2 database to SQL

Question

Hi I'd like to export data from a sqlite2 database into SQL to import into phpMyAdmin. Thanks.

Well, mind if you post your table structure. – Ruel Jul 12 '12 at 00:01 — Ruel, Jul 12 '12 at 00:01

score 0 · Accepted Answer · answered Jul 12 '12 at 00:44

0

After searching I found sqlite2

And to export it to SQL you do:

sqlite database.db .dump > output.txt

To stop an error in phpMyAdmin you need to delete the first line: "BEGIN TRANSACTION;"

answered Jul 12 '12 at 00:44

Luke Wenke

1 Answers1