Restore my DB Vbulltin

Status
Not open for further replies.

tio2012

Active Member
219
2012
35
0
Hello,

Could give me advice how to restore my DB? i was trying with msqldumper but doesn't work and via phpadmin doesn't work as well [:|]

Thanks
 
7 comments
phpmyadmin is the ultimate tool , if you cant restore through it there is probably no other way.

If you have root access then you can easily increase the upload size and restore the SQL backup in one go.

If you dont, then just cut and paste the queries to execute in phpmyadmin, the sql backup is nothing but just the sql commands that needs to be executed.
 
phpmyadmin is the ultimate tool , if you cant restore through it there is probably no other way.

If you have root access then you can easily increase the upload size and restore the SQL backup in one go.

If you dont, then just cut and paste the queries to execute in phpmyadmin, the sql backup is nothing but just the sql commands that needs to be executed.

, if you cant restore through it there is probably no other way.
You are 100% wrong,


Do you have root access ? upload the sql db your homedir then run

mysql -u username -p database_name < yoursql.sql

"You may need to edit the dir depending on which Linux Distro your on"


Alternatively, You will to use Bigdump http://www.ozerov.de/bigdump.php

Once imported.

You have to go into your public_html folder and find the location of your configuration file and update your new mysql database, username and password details.
 
Last edited:
What is the size of your DB Backup?

Some of the options which i have tried in the past and my results are:


  1. BigDump is Good but can be a big hassle. I could never do successful restore with it.
  2. MySQLDumper is very good. It needs a powerful CPU if you are gonna restore a big size database. I sucessfully restored over 2 GB database on ServeDome in the past. Best one for me.
  3. PHPMyAdmin is the basic but a powerful one.
  4. SSH Restore is probably the best one if you have access to it.
 
phpmyadmin is the ultimate tool , if you cant restore through it there is probably no other way.

If you have root access then you can easily increase the upload size and restore the SQL backup in one go.

If you dont, then just cut and paste the queries to execute in phpmyadmin, the sql backup is nothing but just the sql commands that needs to be executed.

being an SQL guy, i completely disagree with you
DB has data in it and quires are the way to access it!!

@OP:
if you have root access then fallow DLow instructions, else
upload it to any directory(via FTP Client) and let your host guy the db name and ask him to restore
 
Status
Not open for further replies.
Back
Top