[thelist] MYSQL DB Backup

[Kevin]

Hello,

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 249.68.21.215'
(Using password: YES) at ../public_html/cgi-bin/parse.pl line 24.

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

TIA.

--Kevin