Author Topic: moving bot (Read 12333 times)

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

Temar · « **Reply #1 on:** August 02, 2008, 02:01:37 am »

u can iver copy the database to new location too
or connection to old useing the IP
localhost = same computer

saik0 · « **Reply #2 on:** August 02, 2008, 04:30:50 am »

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.

devas · « **Reply #3 on:** August 03, 2008, 04:57:57 pm »

ok thx

figured mysqldump out, all working again

Glarawyn · « **Reply #4 on:** August 05, 2008, 11:44:16 pm »

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