Domain Registration from
$12.50/year
Domain Registration from
$12.50/year

FAQs

VBulletin Board

How to Configure the mySQL Database for VBulletin?

Go to CPanel and click on mySQL databases. Once inside,
1. CREATE the database naming it whatever you wish (most use 'Forums'). Once the database is created, refresh the cpanel to show your changes (Each time you refresh, you need to click the mySQL button gain...it's a pain, but this is how it is). 2. THIS STEP IS IMPORTANT!!! Create yourself as a user with a password (for this use admin). Refresh. 3. You will see your database looking like this in CPanel:
yourdomain_yourdatabasename
your username will look like this: yourdomain_yourusername
4. ADD your username to the database. Refresh.
5. If it is successful, you will see something that looks like this:
Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:username_customers:localhost","username_admin","");
PHP $dbh=mysql_connect ("localhost", "username_admin", "") or die ('I cannot connect to the database.');
mysql_select_db ("username_customers");
JDBC (may not be avalible) Connection C = DriverManager.getConnection( "jdbc:mysql://localhost/username_customers?user=realweb_admin&password=");

Moving the boards from your old server to realwebhost.net's servers...??

Step One - Backup current database
[*]telnet into your system
[*]from the root directory, type mysqldump -uUSERNAME -pPASSWORD databasename > /path/to/dump.txt;
[*]this should only take no more than 30 seconds
[*]when it is completed, it will bring you back to the prompt
[*]verify that you have a dump.txt in the /path/to area you specified

Step Two - Transfer to new server
[*]telnet into machine1, and from the command prompt do the following:
[*]machine1$ cd /path/to/yourbackupdirectory
[*]machine1$ ftp machine2 (IP or host) - this should open a connection and ask for your username/password
[*]ftp> bin
[*]ftp> cd /path/to/newdirectory
[*]ftp> put dump.txt (should take no more than 30 seconds)
[*]ftp> close
[*]ftp> quit
[*]verify dump.txt is in the /path/to/new area on the new server

Step Three - Install Vb on new server creating a dummy database (won't be used - you can delete later)

Step Four - Restore to new server
[*]telnet into machine
[*]create new database on the mysql (either via phpMyAdmin or telnet)
[*]from the root, type mysql -uUSERNAME -pPASSWORD newdbname < /path/to/dump.txt
[*]this takes a couple of minutes, but you can track the progress either by FTP (checking the /mysql/data/newdbname and see the files appearing) or by phpMyAdmin (you should see the files appearing there)
[*]when it is completed, it will bring you back to the prompt

Step Five - Bringing it back online
[*]Go into your config.php and change the database name to the database name you created in Step 4.
[*]upload config.php
[*]Go into your admin/index.php and then click on "options" and change the URLs and verify the options and click "submit"

That's it!

The Config.php File. The contents!

Below is the code directly from config.php...replace what is capitalized with YOUR info.
the very last thing before the last ?> is $usepconnect = ...PLEASE set this to 0 so your
board will not use unecessary persitent connections. It is set to 1 by default in the config.php file.


/////////////////////////////////////////////////////////////
// Please note that if you get any errors when connecting, //
// that you will need to email your host as we cannot tell //
// you what your specific values are supposed to be //
/////////////////////////////////////////////////////////////

// type of database running
// (only mysql is supported at the moment)
$dbservertype="mysql";

// hostname or ip of server
$servername="localhost";

// username and password to log onto db server
$dbusername="YOUR_DBUSERNAME";
$dbpassword="YOUR PASSWORD";

// name of database
$dbname="YOUR_DATABASENAME";

// allow password viewing / editing in control panel
// 0 = not visible or editable
// 1 = not visible, but can be edited
// 2 = visible and can be edited
$pwdincp=1;

// technical email address - any error messages will be emailed here
$technicalemail = "dbmaster@selfemployed.org";

// use persistant connections to the database
// 0 = don't use
// 1 = use
$usepconnect = 0;

?>

Categories: 28 | Questions: 909

Categories: 30 | Questions: 183

HELPDESK

WEB HOSTING SOFTWARE VERSIONS

  • 4.4.9, 5.2.28

  • 4.1.22. 5.0.67

  • 11

  • 2.11

  • 4.4.9, 5.2.28

  • 4.1.22. 5.0.67

  • 11

  • 2.11

top


SecurityMetrics Credit Card Safe

Developed by