backup subroutine

Hello,

(Sorry if this message is duplicated)
 
Please, which way to create mysql table backup is the
most painless?

I used to do that as described below until my ISP
disabled the script because it
ate all system resource when I managed to create a
backup of 80MB table:

1. prepare and execute "SELECT * FROM `$table`"
2. fetch rows one by one and store queries "INSERT
INTO $table VALUES..." into a
variable.
3. When the cycle is finished, print this variable
into a file

It works fine on relatively small tables. But 80MB one
caused both mysql and
Apache have gone away.

Any suggestion?

Thanks,
Alex G.


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org