[Sopano]

Hi, i need to know how to transfere my sb web to new website as i changed hosting company of server and website.

[Cruckes]

Backup MySQL Database, and then install Sbans to your new webhost and when installed, restore your backuped db's info to your new db.

[SanKen]

But remember if you have a different theme than the default, change it to the default and then backup mysql

[Sopano]

hi, i exported the sb db from old web using quick option ... so on new web i uploaded the mysql db and when i try to continue on install page i get this:

Warning: mysqli_real_connect(): (28000/1045): Access denied for user 'c1144113_web531'@'localhost' (using password: YES) in /home/c1144113/public_html/bans/includes/adodb/drivers/adodb-mysqli.inc.php on line 113

Fatal error: mysqli error: [1045: Access denied for user 'c1144113_web531'@'localhost' (using password: YES)] in CONNECT(localhost, '****', '****', c1144113_web531) in /home/c1144113/public_html/bans/includes/adodb/adodb-errorhandler.inc.php on line 77

[Phaiz]

Originally Posted by Sopano hi, i exported the sb db from old web using quick option ... so on new web i uploaded the mysql db and when i try to continue on install page i get this: Warning: mysqli_real_connect(): (28000/1045): Access denied for user 'c1144113_web531'@'localhost' (using password: YES) in /home/c1144113/public_html/bans/includes/adodb/drivers/adodb-mysqli.inc.php on line 113 Fatal error: mysqli error: [1045: Access denied for user 'c1144113_web531'@'localhost' (using password: YES)] in CONNECT(localhost, '****', '****', c1144113_web531) in /home/c1144113/public_html/bans/includes/adodb/adodb-errorhandler.inc.php on line 77

My normal preface - I'm not much in terms of support but I'll try.

The login you are using may have insufficient privileges

[Sopano]

ok i did it but have another problem now. i get this in sourcebans.log

L 08/16/2014 - 19:58:41: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20
L 08/16/2014 - 19:58:42: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20
L 08/16/2014 - 19:58:42: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20
L 08/16/2014 - 19:58:42: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20
L 08/16/2014 - 20:50:22: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20
L 08/16/2014 - 20:50:22: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20
L 08/16/2014 - 20:50:22: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20
L 08/16/2014 - 21:22:59: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20
L 08/16/2014 - 21:22:59: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20
L 08/16/2014 - 21:22:59: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20
L 08/16/2014 - 21:48:49: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20
L 08/16/2014 - 21:48:49: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20
L 08/16/2014 - 21:48:49: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20

error log file for sourcemod:

L 08/16/2014 - 19:58:41: SourceMod error session started
L 08/16/2014 - 19:58:41: Info (map "de_dust2") (file "errors_20140816.log")
L 08/16/2014 - 19:58:41: [SM] Unable to load extension "dbi.mysql.ext": libz.so.1: cannot open shared object file: No such file or directory
L 08/16/2014 - 20:50:22: Error log file session closed.

[Phaiz]

Originally Posted by Sopano ok i did it but have another problem now. i get this in sourcebans.log L 08/16/2014 - 19:58:41: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20 L 08/16/2014 - 19:58:42: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20 L 08/16/2014 - 19:58:42: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20 L 08/16/2014 - 19:58:42: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20 L 08/16/2014 - 20:50:22: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20 L 08/16/2014 - 20:50:22: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20 L 08/16/2014 - 20:50:22: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20 L 08/16/2014 - 21:22:59: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20 L 08/16/2014 - 21:22:59: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20 L 08/16/2014 - 21:22:59: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20 L 08/16/2014 - 21:48:49: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20 L 08/16/2014 - 21:48:49: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20 L 08/16/2014 - 21:48:49: [sourcebans.smx] Database failure: Could not find driver "mysql". See FAQ: http://www.sourcebans.net/node/20 error log file for sourcemod: L 08/16/2014 - 19:58:41: SourceMod error session started L 08/16/2014 - 19:58:41: Info (map "de_dust2") (file "errors_20140816.log") L 08/16/2014 - 19:58:41: [SM] Unable to load extension "dbi.mysql.ext": libz.so.1: cannot open shared object file: No such file or directory L 08/16/2014 - 20:50:22: Error log file session closed.

The first one means sb isn't connecting to the database, probably per your "access denied" errors.

The second one, I believe, might mean your server doesn't even have mysql installed. Someone please correct me if I'm wrong.

Who is your new host? Is this dedicated? If so you have to install mysql yourself, which is fairly easy.

[Sopano]

it is gameservers.com, i currently have localhost in database.cfg i think i have to do web ip ?

[WildCard65]

Originally Posted by Sopano it is gameservers.com, i currently have localhost in database.cfg i think i have to do web ip ?

The error about dbi.mysql extension means that a required library is not installed

[Phaiz]

Originally Posted by Sopano it is gameservers.com, i currently have localhost in database.cfg i think i have to do web ip ?

Sorry I meant who is your new web host?

One of my servers is through them so I know it works there, but your web host could be an issue.

I have a VPS so my cfg has "server.mywebsite.com"
Chances are if you rented one of these, you were given the chance to name it. I named mine server.mywebsite.com

If you don't have a VPS.. well I'm already stretching myself on how much I can actually help with these things. Someone else will have to help.