Thanks, Michael.

Now can you tell me why selecting data from a few tables in a mysql database (being used daily by tellers posting payments and new bills getting posted by the thousands daily) usually takes 20 minutes but takes only 4 minutes when the mysql service has been restarted less than one (1) day prior to the query?

Michael Tinsay wrote:
man mysqldump

----- Original Message ----
Oh, to be on topic, may I ask for suggestions on how BEST (fastest and
safest) to migrate mysql data from version 4.0 to 5.0?

_________________________________________________
Philippine Linux Users' Group (PLUG) Mailing List
plug@lists.linux.org.ph (#PLUG @ irc.free.net.ph)
Read the Guidelines: http://linux.org.ph/lists
Searchable Archives: http://archives.free.net.ph

Reply via email to