BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Age of Conan Archive => AoC 0.6 support => Topic started by: dragonjr on March 02, 2011, 05:32:35 pm

Title: backing up the bot? and transferring it to another comp
Post by: dragonjr on March 02, 2011, 05:32:35 pm

ok guys youve helped me tons of times and i managed to get everything to work butwhen it comes to backing this thing up and moveing it i just cant get it to work.
ive tried all the commands that ive seen in the forums and ive tried just grabing the folder and putting it to a flash and that didnt work but i tried that with the bot and the php file dont work but i think thats because i dont have the back up but is there a place where i can find a step by step on how to back it it i have a database namd and a user name but i just cant figure out what i doing wrong any help would be great thanks again for all the help

Title: Re: backing up the bot? and transferring it to another comp
Post by: Kentarii on March 02, 2011, 10:40:25 pm

Google is your friend...
http://www.noupe.com/how-tos/10-ways-to-automatically-manually-backup-mysql-database.html

Title: Re: backing up the bot? and transferring it to another comp
Post by: dragonjr on March 03, 2011, 02:36:09 am

i realy suck at this i mananged to get everything else to work but to back this dam thing up ive read the site you sent me and ive read

Code: [Select]

http://dev.mysql.com/doc/refman/5.1/en/copying-databases.htmlbut either im typeing everything wrong or im just not understanding this type of info
the other thing is i go to
mysql/mysql 5.1/bin and i dont even see the dump.sql. i know this is a simple process why am i not understanding this .

Title: Re: backing up the bot? and transferring it to another comp
Post by: Tyrence on March 03, 2011, 08:41:19 am

if you post what you are typing it'll be easier for us to help you fix it.

anyway, here is an example of how to back up a database named 'test' to a file named 'test.sql' in the root of C: using username 'tyrence' and password 'froobpower'

C:\> mysqldump -utyrence -pfroobpower test > C:\test.sql

command is identical in linux except of course your file path would be different

Title: Re: backing up the bot? and transferring it to another comp
Post by: Kentarii on March 03, 2011, 10:11:41 am

mysql.exe and mysqldump.exe isn't always added to the PATH environment variable depending on your installation, so then you have to provide the full path to those exe files.

Title: Re: backing up the bot? and transferring it to another comp
Post by: dragonjr on March 05, 2011, 02:24:29 pm

i see the mysql.exe and i see the mysqldump.exe is that where i need to get the back up to if so how wouldi write the command for it?

Title: Re: backing up the bot? and transferring it to another comp
Post by: dragonjr on March 05, 2011, 02:59:20 pm

Code: [Select]

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Chris>mysqldump ---user [user name] ---password=[password]
mysqldump: unknown option '---user'

C:\Users\Chris>[database name] > [dump file];
'[database' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Chris> ---user dragon ---password=atalntic
'---user' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Chris> ---user dragon ---password=atalntic bebot > dumpfile
'---user' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Chris> --user dragon --password=atalntic bebot > dumpfile
'--user' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Chris>mkdir dumpdir

C:\Users\Chris>shell
'shell' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Chris>mkdir DUMPDIR
A subdirectory or file DUMPDIR already exists.

C:\Users\Chris>mysqldump --tab=DUMPDIR_db_name
Usage: mysqldump [OPTIONS] database [tables]
OR     mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR     mysqldump [OPTIONS] --all-databases [OPTIONS]
For more options, use mysqldump --help

C:\Users\Chris> mysqldump --all-databases
mysqldump: Got error: 1045: Access denied for user 'ODBC'@'localhost' (using pas
sword: NO) when trying to connect

C:\Users\Chris>thats one that i tried

Code: [Select]

C:\Users\Chris> mysqldump --all-databases
mysqldump: Got error: 1045: Access denied for user 'ODBC'@'localhost' (using pas
sword: NO) when trying to connect

C:\Users\Chris>
C:\Users\Chris>mysqldump -udragon -p databases > bebot_backup.sql
Enter password: ********
mysqldump: Got error: 1044: Access denied for user 'dragon'@'127.0.0.1' to datab
ase 'databases' when selecting the database

C:\Users\Chris>mysqldump -udragon -p databases > bebot_backup.sql
Enter password: *********
mysqldump: Got error: 1045: Access denied for user 'dragon'@'localhost' (using p
assword: YES) when trying to connect

C:\Users\Chris>so what am i doing wrong? the first one i got from the another site and the second one  you have posted before but thats what im doing.
and thanks for taking the time and helping this noob on the simple thing like backing this thing up

Title: Re: backing up the bot? and transferring it to another comp
Post by: Kentarii on March 05, 2011, 03:19:14 pm

You're almost there, just doublecheck that you have the correct credentials and database name.
Check your Bebot/conf/MySQL.conf file for the correct values.

Title: Re: backing up the bot? and transferring it to another comp
Post by: dragonjr on March 05, 2011, 05:11:11 pm

Code: [Select]

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| bebot              |
| dragon             |
| dragonbot          |
| mysql              |
| test               |
+--------------------+
6 rows in set (0.02 sec)

mysql>
correct credentials?

Title: Re: backing up the bot? and transferring it to another comp
Post by: Shendar on March 05, 2011, 06:06:48 pm

Quote from: dragonjr on March 05, 2011, 05:11:11 pm

Code: [Select]

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| bebot              |
| dragon             |
| dragonbot          |
| mysql              |
| test               |
+--------------------+
6 rows in set (0.02 sec)

mysql>
correct credentials?

http://library.linode.com/databases/mysql/backup-options

This is excellent guide for MySQL backup/restore process. Check your spelling, database names, passwords, logins, etc. and try again.

Title: Re: backing up the bot? and transferring it to another comp
Post by: dragonjr on March 05, 2011, 08:04:00 pm

if i where to do this one

Code: [Select]

mysqldump -u root -p -h localhost --all-databases > 1266863089-mysqlFullBackup.sql

would i write it like this
mysqldump -u root -p -h 127.0.0.1 --all-databases > 1266863089-mysqlFullBackup.sql
 but i dont know what he last pasrt is
1266863089-mysqlFullBackup.sql
and how do i make it or find it ?

Title: Re: backing up the bot? and transferring it to another comp
Post by: dragonjr on March 05, 2011, 08:15:29 pm

Code: [Select]


C:\Users\Chris>mysqldump -u root -p -h localhost --all-databases > 1266863089-my
sqlFullBackup.sql
Enter password: *********

C:\Users\Chris>mysqldump -u root -p -h 127.0.0.1 --all-databases > 1266863089-my
sqlFullBackup.sql
Enter password: *********

C:\Users\Chris>mysqldump -u root -p -h 127.0.0.1 --all-databases > backup1-mysql
FullBackup.sql
Enter password: *********

C:\Users\Chris>
it would pause after i did password for a sec or two but nothing happends  how do i know if im going in the right direction or im just makeing matters worse?

Title: Re: backing up the bot? and transferring it to another comp
Post by: Kentarii on March 05, 2011, 11:42:11 pm

Have you tried looking in that folder "C:\Users\Chris" and see if you got your .sql files?
And why do you need --all-databases? Why not just specify the one you want?

Code: [Select]

mysqldump -uroot -p dragonbot > dragonbot.sqlor

Code: [Select]

mysqldump -uroot -p bebot > bebot.sql

Title: Re: backing up the bot? and transferring it to another comp
Post by: dragonjr on March 06, 2011, 01:58:44 am

omg im such a idiot they where all the ones that i did th ecodeing right i cant believe i didnt think to loko there thank you....


now i should be able to take the file and put it ona flash drive and then just put it back where i got this one right?

Title: Re: backing up the bot? and transferring it to another comp
Post by: dragonjr on March 08, 2011, 02:25:39 am

Code: [Select]

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Chris>mysql -u root -p < 1266863089-backup-all.sql
The system cannot find the file specified.

C:\Users\Chris>
ok im trying to get the back up into the other come and this is the error im getting the file is there i put it there from the flash exactly where it was on the other comp.

Title: Re: backing up the bot? and transferring it to another comp
Post by: Kentarii on March 08, 2011, 09:54:58 am

Have you installed mysql on the new PC?
If yes, then the location of mysql.exe is not in your PATH environment.

Title: Re: backing up the bot? and transferring it to another comp
Post by: dragonjr on March 09, 2011, 01:52:00 pm

well i think i set it the same way as the comp that has the bot and everything went to the user like i found out where the the sql files where so how whould i write it to take it from there every comand i use it says it find it