Thanks to all who responded to my post. I had everything but the "import process" right.
I was trying to use "mysqlimport databasename /home/Lamar/filename". but kept getting error message. I can't remember offhand what the error message was, but I used the method below and it worked. sorry for the inconvenience. I am short on time. sincerely, Lamar -----Original Message----- From: [EMAIL PROTECTED] [mailto:jurban@;urbanresearch.com] Sent: Monday, November 11, 2002 8:44 PM To: Lamar Cc: [EMAIL PROTECTED] Subject: Re: Table solution 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 --------------------------------------------------------------------- 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