Need Help Importing Database

E

Error 404

New Member
Hello ;(
I am having so much troubles importing database.
I havent slept for 2 days straight, just because of trying to restore my database to my new Hosting (and new domain), from my old hosting (and old domain)... I followed some instructions, that i should upload all the files on new host from the old one, but now i am up to database, and i tried so many ways to get it to work. I did imported it on my new hosting, i edited config.php for new db info, even searched for my old domain name in that database, and changed all old domain names to my new ones, and i am getting error message - Database Error. altho, if i type http://xxxxxxxxx.xxx/admincp/ and hit enter, it pops up the AdminCP Login Prompt, and when i put my info in, and hit Login, it just gives me - Database Error ....

I was thinking if it could be difference in databases, since my old host have MySQL version 4.1.22-standard, and my new host got MySQL version 5.0.51a-community... I was thinking that they are incompatible, so my new host cant read the DB that was made by older versions of MySQL...

Any Ideas or Advices or Tips ?
I really need to get this forum up ;(

thanks,
Much love..
 
What is the database error when you try to login to the admincp? View the page source of the error screen, its in a comment near the bottom of the page.
 
<!--
Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT userid, usergroupid, membergroupids, infractiongroupids, username, password, salt FROM vb_user WHERE username = 'xxxxxx';

MySQL Error : Table 'dbname_forum.vb_user' doesn't exist
Error Number : 1146
Request Date : Saturday, April 4th 2009 @ 01:58:38 AM
Error Date : Saturday, April 4th 2009 @ 01:58:39 AM
Script : vBTEAM Underground - Free vBulletin Hacks, Skins and Support
Referrer : http://x-xxxxxx.xxx/admincp/
IP Address : xxx.x.xxx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :
-->
 
Ummm so thats the bloody reason why i am getting the error if i am going on my homepage.. it says vb_user doesnt exist, i just checked phpMyAdmin, and indeed, its missing.. WTF, as if backup doesnt include vb_user and stuff in them when backups are made... what the hell...
 
ya, i made it "vb_"

EDIT: btw, its not prefix error, about 50 tables are missing in the backup.sql, tables like vb_user, vb_usergroup and etc..
I made another backup on old FTP host, and now downloading it, i hope this one will have vb_user, etc.. because that previous backup, was downloaded from vBulletin AdminCP, thats why maybe it was corrupt... anyways, after i try to import this .sql from the FTP, i will report here, it worked or not... :)
love you bluescropion,, LOL ( not the gay way ;) )
 
At best the vbulletin database backup is "unpredictable" and a major hazard as when it fails it doesn't error out or tell you that a problem occurs, it add that error message to the backup and terminates so you think every thing is correctamundo! NOT!

Use a cpanel backup or export from phpMyAdmin to get the dump.
 
Wooooooooooooooo, i moved Successfully...

:)

thanks bluescorpion ;)
I had no errors while importing 14 parts of sql file..
Had to split it to 5mb each part, cuz phpMyAdmin wouldnt take 70mb in less then 30 seconds (Thats timeout time i think)

thankyaaaaaaaaaaaaaaaaaaaaaaaaall ;)
 
You must log in or register to reply here.
Back
Top