PDA

View Full Version : Blank page after SQL restore?


preemz10314
08-04-2011, 03:13 AM
Today, my forum had a database error message. So as usual I restored the sql that I made earlier in the day (This happens enough) so I am use to restoring mySQL. Still get a database error.

I figured that sql was bad, so I uploaded the one from the previous day (this one works for a fact), uploaded it and same thing database error. I rebooted my server after each SQL restore.

This has never happened before and I have restored my SQL enough times to know what I'm doing.

I have a feeling a may need to do a fresh install of vbulletin and restore the database.

How/ what is the best way to do a fresh install and restore the database.

Brandon Sheley
08-04-2011, 03:23 AM
Do you see the data in the database?
also..
(This happens enough)
why? this isn't common..

Lynne
08-04-2011, 03:26 AM
What is the exact database error you are getting?

preemz10314
08-04-2011, 03:32 PM
Sometimes it would show the database error sometimes not... I do not know if this is the original error, but it seems there is a problem with my database credentials, listed below.


<!--

Database error in vBulletin :

mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Access denied for user 'xxxxxxx'@'localhost' (using password: YES)

/home/xxxxx/public_html/includes/class_core.php on line 313

MySQL Error :
Error Number :
Request Date : Thursday, August 4th 2011 @ 09:26:23 PM
Error Date : Thursday, August 4th 2011 @ 09:26:23 PM
Script : http://www.xxxxx.com/forum.php
Referrer :
IP Address : xx.xx.xx.xx
Username :
Classname : vB_Database
MySQL Version :

-->

By often enough I mean, I errors have been made when installing mods, things have went wrong before so I am familiar with restoring the database via SSH..it is 75MB.

Lynne
08-04-2011, 05:23 PM
That error means the information in your config.php file is incorrect or the mysql user was not granted all permissions to the database.