collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18363
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: moving bot  (Read 5563 times)

0 Members and 1 Guest are viewing this topic.

Offline devas

  • BeBot Rookie
  • *
  • Posts: 2
  • Karma: +0/-0
moving bot
« 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
« Last Edit: August 02, 2008, 01:38:22 am by devas »

Offline Temar

  • Contributor
  • *******
  • Posts: 1140
  • Karma: +0/-0
    • AoFiles
Re: moving bot
« 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

Offline saik0

  • BeBot Rookie
  • *
  • Posts: 13
  • Karma: +0/-0
Re: moving bot
« 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.

Offline devas

  • BeBot Rookie
  • *
  • Posts: 2
  • Karma: +0/-0
Re: moving bot
« Reply #3 on: August 03, 2008, 04:57:57 pm »
ok thx :) figured mysqldump out, all working again  ;D

Offline Glarawyn

  • BeBot Hero
  • ******
  • Posts: 521
  • Karma: +0/-0
Re: moving bot
« 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

Offline Zeephonz

  • BeBot User
  • **
  • Posts: 43
  • Karma: +0/-0
Re: moving bot
« Reply #5 on: August 06, 2008, 03:05:11 am »
The alternative is to download the GUI Tools for MySQL. Nice purdy interface for complete database management.

 

* Recent Posts
[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm]


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 469
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal