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... (AT) tin (DOT) it> wrote:
mysqldump

On Tue, 06 May 2008 17:22:05 +0200, Carla wrote:
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 (AT) zetachannel (DOT) com> sigged:
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:

Carla wrote:> Captain Paralytic ha scritto:

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... (AT) tin (DOT) it> wrote:
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