how to restore big database to mysql?

My mysql database is too big, can not restore to my database, how to do?

 

What error are you getting?

 

try restoring it through ssh:

mysql -u username -ppassword new_db_name < backup_file.sql

 

try this script.

http://www.ozerov.de/bigdump.php

 

What happens when you restore database? How you are doing it?

 

Try to open the sql file with notepad, select all and copy then on you myphpadmin, open query and paste the code there. It will take some time especially if you're dealing with very huge data. If that causes an error, try using third party like sqlyog, you only need to supply the host, user and password. Use port 3306(if I'm not mistaken) as default.

 

You can do an upload of a big database in seconds, using putty.

Download putty here: http://www.chiark.greenend.org.uk/~s.../download.html

Install putty. Login with the IP of your host, your root user and password.

Upload the database you want to import in a sql file to your server using an ftp client like smartftp, cuteftp... etc

Once in the command window, type this, copy and paste:

mysql -u yourmysqlusername -p mysqldatabasename < /path/to/your/file.sql

replace yourmysqlusername with the username for MySQL

replace mysqldatabasename with the actual name of the database

replace /path/to/your/file.sql with the location and name of the database you have uploaded in a sql file to your server using ftp and the one which will be imported to the actual database

Tell me if you need more help.

 

Interesting question, I always wondered how I would do this if my hosting providers 99.9% uptime failed me again and I had to restore my backup on a new hosting service because this time they didn't pay their reseller fees and they got banned and I bought 2 years hosting but instead got 3 months.

Oh I went slightly of topic.

 

He's probably uploading a backup or a database that he bought or something similar.

 

ssh is the best way for you

 

Maybe reducing the size of the database would be a solution. Going through ssh is a good solution also.

 

see this article backup and restore large mysql database

 

Try BIGDUMP
it will import All Size of DB

.zip and SQL formats only

Thanks,
-XAK

 

sorry to hijack here.....i'm having prob on my wordpress db.....i've backup the said db, have moved to new server. now i want to upload the db to new server, how should i do it? while using the import tool at myphpadmin, after a while an error message prompted:
MySQL said: Documentation
#1044 - Access denied for user 'reuben@'localhost' to database 'reuben_wrdp2'

pls advise...tq

 

Bigdump is the way to go. Works every time, i have imported alot for big sql DB's this way. Reuben - Access denied for user sounds to me like a user info problem.. how big is your sql dump?

 

me files wasn't big, i suspect the configuration prob since i was moving from another server...maybe u can show some guide...

 

http://www.mysqldumper.de/en/

This script saved me over the weekend - very user friendly and has a progress bar - something PHPmyadmin lacks