how to create mysql for my site.

[deadone]

hello all,
seems my domain name has been transferred to my new host , im having an issue as to get my hobbysite part of my site to work.
i have a database up file for it but it dont seem to want to connect to my site. im totally lost as to how to set this up.

my site seems fine but when i try and access the MHS part i get this message

MySQL Server Connection Failed
Sorry, MyHobbySite was unable to connect to the database server at this time. The server may be busy. Please try again later.
Error: php_network_getaddresses: getaddrinfo failed: Name or service not known

does any1 no how to reolve this issue.

regards
Mick

[sjmike]

you have to modify one of your php files to point to the new MySQL Server. Let me dig around and find out which one exactly.

[sjmike]

Found it. You need to update the config.inc.php file in the /includes directory.

[deadone]

sorry about the late reply and the help is very much needed.
ok so i have found the file in mention, what do i need to edit and were is it.
this is driving me mad.

[sjmike]

Probably need to modify your website path and your database hostname. Your hosting provider should be able to provide your the hostname in your MySQL control panel. Your website root path you can often find when you log into the FTP.

[deadone]

Probably need to modify your website path and your database hostname. Your hosting provider should be able to provide your the hostname in your MySQL control panel. Your website root path you can often find when you log into the FTP.

thanx mike, i have tried this but to no avail. i have the information needed.
i have sent you a pm so hope you dont mind me bothering you.

[deadone]

thought i should just say if i have not already done so.
big thanks to ya mike for helpomg me out, very much appreciated.
my site now runs alot faster on my new host and kudos for sorting my database issues out.