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