Upload database - help

[shariq27]

I was downgrading from vb4 to vb3.
but then i got a problem -
how to import backed up databases in phpmyadmin

Waitng for replies.
Reply below or pm me

 

[Royal King]

Use bigdump instead (y)

 

[Veer]

Try bigdump if your db size is more than 50 MB, if it is not then upload using phpMyAdmin.

 

[Sponge Bob]

If you have a VPS then use SSH which is the best

 

[Royal King]

yeap, SSH is the fastest (y)

 

[Veer]

If you have a VPS then use SSH which is the best

yeap, SSH is the fastest (y)

If any of you can tell the procedure would be good, rather going for google.

 

[shariq27]

Thanks Esotorisk

I'm not done even now.
Coz i don't know how to use them..

Please Explain the procedure

 

[Veer]

I would suggest you for using bigdump as it is user friendly.

1. First you will have to download your old mySQL database to your local computer. This can be done via phpMyAdmin using the Export function.
2. Download the dumper from BigDump website, and unzip it to your local computer, using Winzip or any other unzip tool.
3. Create a new folder named e.g. “dump” on your new web server, and change its permissions to chmod 777.
4. Open the unzipped file bigdump.php in a text editor like notepad, and adjust the database setting, i.e. database name, username, password.
5. Upload bigdump.php along with the dump file (downloaded from old server) to the new server under the directory we just created named “dump”
6. Now open the bigdump.php file by using a browser, i.e. Firefox, Internet Explorer, using address something like http://www.yourwebsite.com/dump/bigdump.php
7. Select the appropriate options and start the process, then wait for the process to finish, do not close your browser, if you do so, then you will have incomplete database on your new server. As the dump file is present on the server it will take less than a minute to complete the process, if the dump file is, consider 40 MB.
8. You must remove your dump (MySQL) file and the bigdump.php file from your server, also delete the dump folder, or change its permissions back to default.

For further help contact me through PM and get my msn, I would guide you further.

 

[raj11]

use SSH Client, such as PuTTy to login to ur vps/dedi & use this command to restore database

mysql -u dbusername -p databasename < /path/to/backupname.sql

 

[shariq27]

Thanks for the Complete procedure.
Was very helpful.Computer using Xampp webserver.
It worked finee.
Now everything is done.
just having a small problem.

Now how to import my new database into web server.
Should i need to install the vb on net server and then import again..

 

[Veer]

Yes now when the database has been restored using Bigdump.

Upload the vbulletin files over the root directory and edit the config file with the database name, username and password located at :

/includes/config.php

And then point your website.

 

[shariq27]

Thanks for the help..

 

[Veer]

Well, make sure if you had vbseo installed in the previous databse. Then don't forget to upload that too in the root directory, also inferno shoutbox (If it was there earlier).

 

[shariq27]

okay..
Thanks for the update