Re: Backing up a MySQL database on a remote server

2001-08-30 Thread dwilkers
Hi, There was allot left un-said:-) assuming you can not get access to the command line dump. select * from your_table_name into outfile "your_home_dir/your_filename"; This will create a text file. Now download these files and save them. reverse load data infile "your_home_dir/your_filename"

Backing up a MySQL database on a remote server

2001-08-30 Thread Jeff Isom
I'm new to MySQL and I'm sure this has been covered, but I can't find it so I'll ask here. What is the best way to backup a MySQL database that is hosted on a remote server. Our web site is hosted by a hosting company and they configured MySQL. I want to backup the database periodically. I've