BeBot - An Anarchy Online and Age Of Conan chat automaton
Archive => Anarchy Online Archive => BeBot 0.4 support => Topic started by: devas on August 02, 2008, 01:36:22 am
-
hi, im trying to move the bot to another computer and preserve settings ect.... but i fail badly at finding out how to make the connect to the databse again... only getting access denied, and ive tried everything... dont know much about mysql ect so... How can u move the bot to another computer and use the same mysql database? :/ get this msg when i just copy the files into database folder: PHP Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10061)
PHP Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10061) in C:\Documents and Settings\Remote\Desktop\relaybot bebot\Sources\MySQL.php on line 96
Cant find any posts helping about this either, so is there a right way to do this? =P
-
u can iver copy the database to new location too
or connection to old useing the IP
localhost = same computer
-
Just follow the same steps for setting up mySQL on your new machine, and use mysql dump to backup your database, move it to the new machine, and import it.
-
ok thx :) figured mysqldump out, all working again ;D
-
I see you've gotten it figured out, but for those searching the forums trying to accomplish the same thing:
Backup a MySQL database:
mysqldump databasename -u username -p password > database-backup.sql
Copy database-backup.sql to your new computer.
Restore SQL file:
mysql -u username -p databasename < database-backup.sql
-
The alternative is to download the GUI Tools for MySQL. Nice purdy interface for complete database management.