Log in

View Full Version : Switching Hosts


Napster6
08-26-2009, 08:46 PM
I am trying to switch hosts, I have all the forums folders i uploaded them via FTP

I get the standard database error page with no code on it or anything. It's been awhile since I did this much any ideas, I am assuming I am missing something.

HMBeaty
08-26-2009, 08:51 PM
Did you update your includes/config.php file? You can also right click > view source on the page you get the database error to view the error

Napster6
08-26-2009, 08:55 PM
I didn't update anything.

charset=ISO-8859-1

that the error msg?

HMBeaty
08-26-2009, 09:01 PM
No, and you might want to make sure you update you're config.php file to coincide with your new host

Napster6
08-26-2009, 09:08 PM
<!--
Database error in vBulletin :

Cannot use database

MySQL Error : No database selected
Error Number : 1046
Request Date : Wednesday, August 26th 2009 @ 10:07:35 PM
Error Date : Wednesday, August 26th 2009 @ 10:07:35 PM
Script : XXXX
Referrer :
IP Address : XXXXXXXX
Username :
Classname : vB_Database
MySQL Version :
-->



Any ideas there?

HMBeaty
08-26-2009, 09:12 PM
MySQL Error : No database selected
Again, you need to update your config.php file

Napster6
08-26-2009, 09:17 PM
Okay well background here

I already run vbulletin on my one site, I am hosting this for a friend.
The database and table prefix where do I figure that out again?

--------------- Added 1251325375 at 1251325375 ---------------

mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Access denied for user 'gf'@'XX.61.149.141' (using password: YES)
/mounted-storage/home119c/sub006/sc67362-TFJU/www/gf/forums/includes/class_core.php on line 311



THanks for the help by the way

snakes1100
08-26-2009, 09:43 PM
Update the database name, username & password in config.php, they are not the same from server to server typically unless you matched what "your friend" had set in the config file originally.

Napster6
08-26-2009, 09:59 PM
looks like im stuck on table prefix. how do I decide again how to do that?

snakes1100
08-26-2009, 10:01 PM
Use phpmyadmin to view the database, the prefixes will be at the begining of the table names.

Napster6
08-26-2009, 10:03 PM
would be nice but the database is empty. the .sql file is too large to upload i just emailed my tech support for my hosting

Marco van Herwaarden
08-28-2009, 10:32 AM
Please see the manual:Moving Servers (http://www.vbulletin.com/docs/html/moving_servers)