Restoring a big database

A big forum of mine recently went down and I have a backup of the MySQL database. It runs on vBulletin.

I want to install a fresh copy of vBulletin and then import the database that I have backed up.

The only way that I know how to do this is through phpmyadmin. The only problem that I have is that it's about 50mb so importing it through the browser lags out or doesn't complete.

Is there a method or way that I could use to do this more effectively and quickly?

Any help or suggestions would be greatly appreciated.Thanks!

 

Restoring The Database via SSH/Telnet

 

i use a script called "bigdump" ... it works very well for me.

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

 

And if you don't have shell access, put the backup in a folder on your server and write a simple PHP script that does a LOAD.

 

best solution : mysql -u username -psomepass database < dump.sql

 

Install mysqldumper (mysqldumper.de/en).
Upload your sql backup file to ftp.
Execute it with mysqldumper web interface.

 

Ok, I finally have access to my computer to start the restoring process.

The backup of the database is 246MB. It'll take me probably a day to upload it lol.

Is there any way to split the file and then join the files once they're uploaded onto the web host?

 

archive with volumes

 

archive with volumes? can you explain more on that?

 

Another very good script is automysqlbackup
http://sourceforge.net/projects/automysqlbackup/

This script can be put in /etc/cron.daily for example

 

Repped BIG TIME!

MySqlDumper is nothing short of brilliant, i've been using flakey BigDump for years and i almost give up on a project today when it kept locking up importing a 360MB database on to my slow host.

Thought i would give MySqlDumper a go, all i can say is wow. Lightning fast, simple, a bunch of stats on the screen keeping you informed about the import etc.

Anyone who uses BigDump, ditch it and give MySqlDumper a go.

 

I am glad you liked it. MysqlDumper is really amazing. I don't remember how I am leaving without it It is lifesaver.

 

It's brilliant, my hosts MySql is very slow.. I get alot of 404's just doing an export through phpMyAdmin on a database under 1MB.

MysqlDumper imported the 360MB database like a hot knife through butter, the whole time displaying stats on speed, table it was up to etc. I tried Bigdump probably 12 times and it failed 3/4 in to the import and was about to give up, now i got a 50k article website.

I wish i could rep you a couple more times.

 

Mysql dumper has come to my rescue a number of times.
Compelled me to making a somewhat healthy donation on their site.

 

Make sure it is highly compressed, e.g. archive it with tar.gz.

Then, upload using phpMyAdmin, hopefully that the file after archiving will be smaller.

 

i upload Today 375mb through ftp and Use BigDump Its Work Great for Me I done My Work In 5 Hours 4 hours Upload and 1 Hour to restore Look Like Bullet work for me Thax to This Topic Peace

 

Hello Clark AKA Superman, LOL

You are a star, i was having all kinds of problems with bigdump and a 380mb mysql database. installed mysqldumper and it works a treat REP++