I run a cron job that runs a web based cgi script each night. It backs up my MySQL database to a directory on my server. I then offload that file along with others nightly with another cronjob backup script to tape. Or at the very least you could download the *.sql file that is created by the cgi script each night. Here is the cgi script I use. Save and upload it as YOUR_DB_NAME.cgi to your web server's cgi-bin directory

#!/bin/sh # uncomment to run as UNIX script. File must be executable.

Edit this file and put correct string for following items

MYSQLUSERNAME1&2 MYSQLPASSWORD1&2 mysqlXX1&2 DATABASE_NAME1&2

Don't forget to set permission of 755 to this script.

You can do that with WebFTP, SiteTools, most FTP software, other utilities.

echo # Send text/plain Content-type header.
exec 2>&1 # Senf error output (stderr) to the browser

filename=/path/where/you/save/database_file/DATABASE_NAME1.sql # ex.: dbbackup_2006-03-07.sql --add after name for date--> _`date "+%Y-%m-%d"`

Dump DB

mysqldump --opt --no-create-db --user=MYSQLUSERNAME1 --password=MYSQLPASSWORD1 --host=localhost DATABASE_NAME1 > $filename
#echo "Database DATABASE_NAME1 saved in $filename."

You can actually run that script from your web browser. e.g. http://www.yoursite.com/cgi-bin/YOUR\_DATABASE\_NAME.cgi

Perhaps you have phpMyAdmin not setup correctly. You need to rename the file config-inc.sample.pfp to config.inc.php open in editor: Edit these lines to look $cfg['blowfish_secret'] = 'Put something here you will remember'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ $cfg['Servers'][$i]['host'] = 'localhost'; <<leave as localhost here Save that file, then re-upload it to your phpMyAdmin directory of your webserver. Then type in your browser, http://IPADDRESS_OF_YOUR_SERVER/pathtophpMyAdmin e.g. http://192.168.0.222/phpMyAdmin You should then get a logon. The default logon will be username>root with no password for a fresh install of MySQL. Once logged in I recommend going direct to the Priviledges link and make a password for root, also, then add another MySQL default user and use it for your scripts to connect to MySQL.