From: Paul Lutus Date: 2006-12-05T04:45:05+09:00 Subject: Re: MySQL and SQLite question nephish wrote: > > Paul Lutus wrote: >> nephish wrote: >> >> > Lo there all. >> > >> > I have been giving some thought to moving to SQLite from MySQL. We are >> > moving our site from php to rails for what we call "the big rewrite" >> > and since these changes are going on. I really like that SQLite is >> > stored in flat files that can easily be moved around, like from one >> > computer to a backup computer. >> >> FWIW, MySQL also can create portable flat files, if that is how you have >> set up your database. I have a rather large set of databases for various >> purposes, and I can easily export them all into a convenient, plain-text, >> flat file format. This depends on what sort of database you have, whether >> it exploits advanced database features. >> >> Also, MySQL's native database format is also quite portable, without >> taking any conversion steps. >> >> This is only one observation, it doesn't address any of your other >> discussion points. >> >> -- >> Paul Lutus >> http://www.arachnoid.com > > i have used the export feature to create some portable files, but they > take so long to import into another db. One of my tables is 1.5 gig > i had also had some trouble moving the three files per table in one > database to another computer and having it recognized as a ligit table. Were you transferring the database from one MySQL server to another, or were you changing database engine types? If the former, you could have transferred the original database files without taking any export actions. > Maybe i was doing something wrong. I don't know of another way for > mysql to create a flat file that i could transfer to another computer, > or backup or whatever. Ordinarily you save the MySQL database files in their original form, without trying to export them to a plain-text form. This is always true unless you intend to change database engines. If you are changing database engines, then yes, you need to create plain-text tables for export, and this can take some time to export, move and import. Normally, you only have to go through this exporting procedure once, not as onerous as a daily procedure would be. -- Paul Lutus http://www.arachnoid.com