preferred way to backup a 20GB MySQL database

Hi, What is the preferred way to backup a 20GB database daily, without taking offline ? MySQL 4.1 MyISAM - (will be updated to MySQL 5) 133 table(s)  Sum 115,416,561  latin1_swedish_ci  20.1 GB Thanks, Andras -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

simpe select count question

order_status, COUNT( * ) AS count FROM orders GROUP BY order_status But sometimes all orders set to shipped and only returning 1 row, but need all 3 rows with null values... Thanks, Andras Kende -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: spatial extensions - SRID

inside of some kind of xml structure? Thanks, Andras Kende http://www.kende.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 0.0.338 / Virus Database: 267.10.8/71 - Release Date: 8/12/2005 -- MySQL General Mailing List For list archives: http

Re: data directory for mysql

/data/ and create a symbolic link to it from /var/mysql/data Best regards, Andras Kende http://www.kende.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]