[thelist] MYSQL DB Backup

Kevin lists at irubin.com
Tue Jul 30 16:21:00 CDT 2002


I am hosted on a shared/virtual hosting plan and would like to backup the
one of the mysql tables on a daily basis.

I attempted to run the query - SELECT * INTO OUTFILE
'/path/to/my/file/file.sql' FROM items and got the folowing error:

DBD::mysql::st execute failed: Access denied for user:
'dbuser at'
(Using password: YES) at ../public_html/cgi-bin/parse.pl line 24.

What is the best way to back up a mysql db table?



More information about the thelist mailing list