Data-base too large to import with phpmyadmin

[mikesco762]

I have intalled wamp on a local machine for the purpose of testing new data before uploading it to our site. The data-base that I need to import is 791mb. Can anyone tell me how to work around the size limit?

[physics]

On linux this is easy to do on the command line like

mysql -uUNAME -pPASS dbname < dbname.sql

Where dbname is the name of your database and dbname.sql is a mysql dump file.

Not sure what the equivalent is on windows, but you should be able to install Cygwin and run the command I mentioned.
[cygwin.com...]

Also you may be able to use MySQL administrator which runs as a GUI on windows:
[mysql.com...]

[Jaunty Edward]

Hi,

I had a tough time uploading my 600+ MB DB, then I found a nice way.

1. Export DB from phpmyadmin into a zip or gz file
2. upload the file to the server with FTP
3. search google for big dump
4. put DB settings in big dump php script and it will break the queries into 3000 and insert into mysql server. And you do not need any ssh access or stuff.

It works well, I have moved my DB many times. If you need anymore help PM me.
thanks
bye