[thelist] MYSQL DB Backup
David Kaufman
david at gigawatt.com
Tue Jul 30 17:09:01 CDT 2002
SELECT * INTO OUTFILE creates files on the db server, and your dbserver is
probably not the same machine as your login/web account, so mysql is
configured to allow you to run it (since you wouldn't have access to that
machines filesystem anyway)
<tip>
To backup a mysql database on a remote server in a virtual hosting
environment
where SELECT * INTO OUTFILE complains:
Access denied for user: 'you at yer.ip.add.ress' (Using password: YES)
try the command:
mysqldump --help
</tip>
-dave
----- Original Message -----
From: "Kevin" <lists at irubin.com>
To: "Thelist" <thelist at lists.evolt.org>
Sent: Tuesday, July 30, 2002 4:56 PM
Subject: [thelist] MYSQL DB Backup
> 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
>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !
>
More information about the thelist
mailing list