You can use mysqldump to export the data from your webserver to a file, ftp the file, and import into your local database.
There are also some tools that might help -- urSQL (http://www.urbanresearch.com/ursql), for example, can export query results directly to Excel. This means you could connect urSQL directly to your webserver database (provided it's accessible), submit a "select * from my_table", and export the results directly to an Excel file... There are other tools that provide similar functionality. If you want to do it manually: 1) mysqldump on the webserver (http://www.mysql.com/doc/en/mysqldump.html) 2) Transfer the file to your local machine 3) Import into mysql (mysql < dump-file.sql) On Mon, 11 Nov 2002, Lamar wrote: > I want to copy a table from a webserver that has MySQL database server > located on it, then, ftp to my local machine to insert into my local > database. > > any ideas on how to do this? > > my goal is to create an Excel spreadsheet from the table for distribution. I > have created the spreadsheet using the database on my local machine, but I > want the database on the webserver. --------------------------------------------------------------------- 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