On Mon, Feb 06, 2006 at 05:30:39PM +0100, Laurent Goussard wrote: > Hi there, > > I use SQLite on my website for 2 years now. I do like SQLite a lot and > will use it for a lot of new web projects but, because I got more and > more traffic, I consider to move this one to MySQL in order to reduce > the over load of my computer (I host it @ home). > > Do you know if there is a way to convert easily an SQLite database > into a MySQL one ? > (I'm especially thinking about the escapestring and other "create > table [myTable] {" issues...)
FWIW, I believe SQLite's syntax is closer to PostgreSQL's than it is to MySQL, so it might me easier to migrate that direction... -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461