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" into table your_table_name;
But, if you really did have to recover from a crash, you
might want to also get the table info.
explain your_table_name;
Best Regards
On Thu, 30 Aug 2001, Jeff Isom wrote:
> 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 tried using PhPMyAdmin to
> get data dumps, but the databases are quite large and the browser times out
> before the file download begins. How can I connect to the MySQL server from
> my Win2000 machine and perform a dump to my hard drive? Also, what is the
> best way to reverse the process and restore the dump from my hard drive to
> the remote server.
>
> I apologize if this question is obvious. I've looked in the documentation,
> but haven't been able to figure it out. Thanks in advance for the help.
>
> Jeff
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
