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.