copy a table from local to remote

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?

Thanks.

Carla
(from ITALY)

On 6 May, 16:22, Carla <carlarendine6...@tin.it> 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?
>
> Thanks.
>
> Carla
> (from ITALY)

mysqldump

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

I know that mysqldump is used for backup copies.
In my case do you suggest to make a backup file with mysqldump and
import itself by remote?
Could I do it by phpmyadmin?

Thanks

Captain Paralytic ha scritto:
> On 6 May, 16:22, Carla <carlarendine6...@tin.it> 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?
>>
>> Thanks.
>>
>> Carla
>> (from ITALY)
>
> mysqldump

Carla wrote:> Captain Paralytic ha scritto:
>> On 6 May, 16:22, Carla <carlarendine6...@tin.it> 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?
>>>
>>> Thanks.
>>>
>>> Carla
>>> (from ITALY)
>>
>> mysqldump
>I know that mysqldump is used for backup copies.
> In my case do you suggest to make a backup file with mysqldump and
> import itself by remote?
> Could I do it by phpmyadmin?
>
> Thanks
>
Please don't top post (top posting fixed).

Yes you could export the dump from PMA, which will also compress the file
for you. Then you can upload it using PMA at the remote end.

Thank you all for your tips, I'll use phpmyadmin.
I'm not an expert on using mysql and I've never used mysqldump, so I'll
use phpmyadmin that seems to be more easy to manage.
Thanks again.

Clara

On May 6, 7:11 pm, Carla <carlarendine6...@tin.it> wrote:
> I know that mysqldump is used for backup copies.
> In my case do you suggest to make a backup file with mysqldump and
> import itself by remote?
> Could I do it by phpmyadmin?
>
> Thanks
>
> Captain Paralytic ha scritto:
>
> > On 6 May, 16:22, Carla <carlarendine6...@tin.it> 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?
>
> >> Thanks.
>
> >> Carla
> >> (from ITALY)
>
> > mysqldump

Yes I use phpMyAdmin 2.11.6 and have 2 identical DBs up there. U can
select a table click export, always use transaction, select the insert
method and SQL radio button and by clicking GO it will create an
INSERT SCRIPT that you can then copy paste to notepad lets say, and
run on the database you wish. In your case I guess you should install
phpadmin locally and do an export from local db to Live.
Cheers