L* R*
HOME FORUM DOWNLOADS
Content
  Links
     Browse SVN
     SVN Commit log
     Documentation (Wiki)
  Developers
     Taskmanager
User
Welcome, Guest. Please login or register.
Did you miss your activation email?
December 04, 2008, 05:53:53 PM

Login with username, password and session length
Search



Advanced search
Support GoPHP5.org
BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Support > BeBot 0.4 support > Topic: moving bot
Pages: [1]   Go Down
« previous next »
Print
Author Topic: moving bot  (Read 464 times)
0 Members and 1 Guest are viewing this topic.
devas
Freshman
*
Offline Offline

Posts: 2


moving bot
« on: August 01, 2008, 06:36:22 PM »

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 01, 2008, 06:38:22 PM by devas » Logged
Temar
BeBot Developer
Grandmaster
********
Online Online

Gender: Male
Posts: 888



WWW
Re: moving bot
« Reply #1 on: August 01, 2008, 07:01:37 PM »

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

MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
saik0
Freshman
*
Offline Offline

Posts: 13


Re: moving bot
« Reply #2 on: August 01, 2008, 09:30:50 PM »

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.
Logged
devas
Freshman
*
Offline Offline

Posts: 2


Re: moving bot
« Reply #3 on: August 03, 2008, 09:57:57 AM »

ok thx Smiley figured mysqldump out, all working again  Grin
Logged
Glarawyn
BeBot Developer
Champion
********
Offline Offline

Posts: 414



Re: moving bot
« Reply #4 on: August 05, 2008, 04: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
Logged
Zeephonz
Rookie
**
Offline Offline

Gender: Male
Posts: 21


Re: moving bot
« Reply #5 on: August 05, 2008, 08:05:11 PM »

The alternative is to download the GUI Tools for MySQL. Nice purdy interface for complete database management.
Logged
Pages: [1]   Go Up
Print
BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Support > BeBot 0.4 support > Topic: moving bot
« previous next »
 
Jump to:  

Recent
online not working after ...
by Temar
[Today at 05:09:48 PM]

Bot not working after tod...
by Alreadythere
[Today at 01:04:41 PM]

Tokens Calulator
by Temar
[December 03, 2008, 01:09:03 PM]

Bebot does not work with ...
by IKShadow
[December 03, 2008, 08:54:04 AM]

!items database
by Temar
[December 03, 2008, 07:27:59 AM]

massive_pvp_time_table 1
by Sudoka
[December 03, 2008, 06:49:07 AM]

Log playtime from buddys ...
by IKShadow
[December 02, 2008, 06:48:12 AM]

[request] Raid timers
by Elesar1
[December 01, 2008, 04:41:09 PM]

Shared DB online list
by Temar
[December 01, 2008, 01:55:47 AM]

relay colors
by Temar
[December 01, 2008, 01:54:56 AM]
Stats
Members
Total Members: 1246
Latest: Vingus
Stats
Total Posts: 11193
Total Topics: 1508
Online Today: 21
Online Ever: 168
(July 01, 2007, 09:30:02 PM)
Users Online
Users: 6
Guests: 15
Total: 21
clashbot
Kentarii
Raysett
Temar
vikor
upstart

Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC
TinyPortal v0.9.8 © Bloc | NewDef design by Bloc
Page created in 0.29 seconds with 29 queries. (Pretty URLs adds 0.025s, 4q)
Loading...