[Forum] mySQL Help

[smartikat]

I have a very Slow mySQL server from my host. I found a better server, but I am at a lost of how to switch my site to connect to this new server. Please help

Thanks

[Lynne]

I'm not sure what you are asking for help with here. You want to know how to set up to use MySQL on another server? You would edit your config.php file:

[COLOR=#000000][COLOR=#007700]    [/COLOR][COLOR=#FF8000]//    ****** MASTER DATABASE SERVER NAME AND PORT ****** 
    //    This is the hostname or IP address and port of the database server. 
    //    If you are unsure of what to put here, leave the default values. 
[/COLOR][COLOR=#0000BB]$config[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'MasterServer'[/COLOR][COLOR=#007700]][[/COLOR][COLOR=#DD0000]'servername'[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#DD0000]'localhost'[/COLOR][COLOR=#007700]; 
[/COLOR][COLOR=#0000BB]$config[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'MasterServer'[/COLOR][COLOR=#007700]][[/COLOR][COLOR=#DD0000]'port'[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#0000BB]3306[/COLOR][COLOR=#007700]; 

    [/COLOR][COLOR=#FF8000]//    ****** MASTER DATABASE USERNAME & PASSWORD ****** 
    //    This is the username and password you use to access MySQL. 
    //    These must be obtained through your webhost. 
[/COLOR][COLOR=#0000BB]$config[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'MasterServer'[/COLOR][COLOR=#007700]][[/COLOR][COLOR=#DD0000]'username'[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#DD0000]'root'[/COLOR][COLOR=#007700]; 
[/COLOR][COLOR=#0000BB]$config[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'MasterServer'[/COLOR][COLOR=#007700]][[/COLOR][COLOR=#DD0000]'password'[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#DD0000]''[/COLOR][COLOR=#007700];][/COLOR][/COLOR]

Instead of localhost, you would put the IP.