large SQL transfer

I need to transfer a large 2.3gig database table to a new host ( hostgator ) what options are a available, I know copy&paste would work but that would probable take me a week , so I'm looking for advice on how I could accomplish this task. ?

Regards
Marty

 

I don't think the phpMyAdmin tool at most hosts will allow importing of a database that size, so instead you could try a script that automatically does say 1000 lines at a time, sleeps for ten seconds, then does the next 1000 lines - it might take a while to run but it will avoid you having to manually do the copying as pasting.

 

you can download your table to your computer. (Export by phpmyadmin or cpanel...) Then you can compress it to these formats : gz,tar,zip
and upload by ftp to your host. Then you can import by command line.
But you need shell access.

(after successful shell login)

You can try this:

$ mysql -u username -p -h hostname databasename < data.zip


if not work you can try:
$ mysql -u username -p -h hostname databasename < data.sql

 

You may use mysqldumper (mysqldumper.de). Works fine with big databases.

 

Thanks for the replies...

I figured out how I could do this, my site's internal admin panel allows database backups from text files, so I'm currently downloading the table as a cvs file, and I'll upload that and see how it goes...

 

How do you get these massive databases?

 

Its a web directory with just under 5 million links...