On Tue, 06 May 2008 17:22:05 +0200, Carla wrote:
> Hi guys, I've created a table in my local database and filled it with a
> great amount of data (too much!) and now I need to insert the same data
> on my website database. What a stressful operation! :-/
> Do you know some way to speed up the data filling? Any ideas?
> Is there a query to copy directly a table content from local db to
> remote one? Or to save-export the local table content in a file and than
> load-import this file from remote db?

If you've got command access on both systems, you can use mysqldump,
compress the resulting file which will often end up with something about
1/5th the size of the raw data), upload and decompress, and run the dump
as a mysql script.

--
Kyle J Cardoza <admin@zetachannel.com> sigged:
>Faith does not, in fact, move mountains;
Mainly because they won't let her loose with a drilling crew and enough
dynamite. -- Chris Suslowicz in the Monastery