mySql Database dump question.

I have a sql file of over 300MB on my server. How exactly do I get these tables to my mysql database. I cannot manually do it through phpmyadmin as it times out every time I try.

Thank You.

 

If you have SSH or telnet access to your server you can try this:

$ mysql -u username -D dbname -p < sqlfile.sql

 

No Access to telnet or ssh

 

You can try the script here: http://www.ozerov.de/bigdump.php
Another (laborious) method would be to split your SQL file into several smaller files and then import each one of them using phpmyadmin.

 

Do you have cpanel??

If so simply click on the "backups" button and download your mysql database in a tar file. If you have cpanel on the new server you can use it to upload that same backup file.

 

I just tried the BigDump and it says it cannot read the file size.

 

Anybod know of another dump script?

 

Big dump is your best bet just upload the sql file to ur server then config big dump and run it! Pm me if you need any help

 

If you can access the mysql server remotely (ask your host) you can run mysql from your pc with $ mysql -h <myhost> -u username -D dbname -p < sqlfile.sql

 

Go to: http://dev.mysql.com/downloads/gui-tools/5.0.html
and download: MySQL Administrator

You can make backups and restore your sql files.
If you need some help, just let me know

Thanks...
Mike30