moving mybb to new host

[Kenny]

Howdy!

I have been reading the other thread on this subject submitted by tristam, and I have followed the guidance given here:

You basically need to backup your existing database, then copy over your MyBB files from the old server to the new one. Restore the database and then update inc/config.php with your new database information.

I've done the backup, copied the mybb folder and all it's contents to the new server, and imported the backup into my new database. Now, I just need to ask what is meant by "update inc/config.php with your new database information." If anyone could offer me specifics of what new database information and how to update it it would be much appreciated. I know it's probably a simple thing to you IT wizards but to us retards it's like a foreign language. Thanks in advance for any help.

[Jag100]

This might be able to help you

[Wiki: Inc/config.php]

You just change the details in that file to point towards your new mysql database on your host

[Kenny]

Alright, to the best of my knowledge I've done everything I needed to do, but I'm getting the following error when I try to open mybb at the new location:

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/content/k/e/n/kennystringer/html/myBB/inc/db_mysql.php on line 313
MySQL error:
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/content/k/e/n/kennystringer/html/myBB/inc/db_mysql.php on line 314


Query:

The new location is http://www.iwfi.org/myBB/index.php
Any help appreciated.

[Dennis Tsang]

Make sure your database login information is updated for the new host. This information can be changed in inc/config.php, see Jag100's post. To get the information, you should look in your host's control panel, or just contact them.

[Kenny]

Hello Dennis,

Yes, I've already done that. I just went and verified with my new host and I have entered the correct information to the config file. Here is the code as I've entered it:

<?php
/**
* Daatabase configuration
*/

$config['dbtype'] = 'mysql';
$config['hostname'] = 'localhost';
$config['username'] = 'iwfoc';
$config['password'] = '********';
$config['database'] = 'iwfoc';
$config['table_prefix'] = 'mybb_';

My username and the database name are both iwfoc and the password is ******** (not disclosed, but the correct password is entered at this location). Have I done something wrong? As far as I can see I've done it correctly and I just verified again that I'm using the correct information. But it is definitely NOT working! Any suggestions?[/quote]

[judel]

Are you sure the url to your new host is "localhost"? Check your settings and enter the actual url there and see if it works then!

[Kenny]

Are you sure the url to your new host is "localhost"? Check your settings and enter the actual url there and see if it works then!

Are you saying that "hostname" is the url to my host? I just contacted my new host, and they told me that the url to my new host is just my domain name, iwfi.org. I tried substituting that for "localhost" but got the same error. Anyway, the word "localhost" was what was entered here in the config file from my old host. I'm assuming that if the url were required here, it should have read "kennystringer.com" which was the urs to my old host.

Can you please clarify what it is you're suggesting I put as "hostname"? Thanks

PS. I just tried entering the url for my hosts servers, which is secureserver.net, and that resulted in IE returning a "page not available" message. I'm assuming this is telling me that the previous information I had entered was correct, cuz at least it returned the error message above. I went and changed it back to "localhost" and the "page not available" response went away, and I'm back to the original error message from post 3 of this thread. Boy these kinds of problems are frustrating!! Any possible help appreciated...

[Dennis Tsang]

Hello Dennis,

Yes, I've already done that. I just went and verified with my new host and I have entered the correct information to the config file. Here is the code as I've entered it:

<?php
/**
* Daatabase configuration
*/

$config['dbtype'] = 'mysql';
$config['hostname'] = 'localhost';
$config['username'] = 'iwfoc';
$config['password'] = '********';
$config['database'] = 'iwfoc';
$config['table_prefix'] = 'mybb_';

My username and the database name are both iwfoc and the password is ******** (not disclosed, but the correct password is entered at this location). Have I done something wrong? As far as I can see I've done it correctly and I just verified again that I'm using the correct information. But it is definitely NOT working! Any suggestions?

[/quote]
Can you verify if you can login to phpMyAdmin with that username/password?

Are you sure the url to your new host is "localhost"? Check your settings and enter the actual url there and see if it works then!

The hostname in the configuration is the hostname for the MySQL server, which 99% of the time is localhost

[MarkusK]

Hostname is the path to you mysql-server. In most cases mysql and webserver are the same so you can use "localhost". You should ask your provider for the correct path.

[Kenny]

Can you verify if you can login to phpMyAdmin with that username/password?

Yes, they are correct. Mybb is still not working however, and I am still getting the error messages as per post 3 of this thread.