Author Topic: backing up the bot? and transferring it to another comp (Read 5644 times)

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

Kentarii · « **Reply #1 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

dragonjr · « **Reply #2 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 .

Tyrence · « **Reply #3 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

Kentarii · « **Reply #4 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.

dragonjr · « **Reply #5 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?

dragonjr · « **Reply #6 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

Kentarii · « **Reply #7 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.

dragonjr · « **Reply #8 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?

Shendar · « **Reply #9 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.

dragonjr · « **Reply #10 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 ?

dragonjr · « **Reply #11 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?

Kentarii · « **Reply #12 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

dragonjr · « **Reply #13 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?

dragonjr · « **Reply #14 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.

Author Topic: backing up the bot? and transferring it to another comp (Read 5644 times)

dragonjr

backing up the bot? and transferring it to another comp

Kentarii

Re: backing up the bot? and transferring it to another comp

dragonjr

Re: backing up the bot? and transferring it to another comp

Tyrence

Re: backing up the bot? and transferring it to another comp

Kentarii

Re: backing up the bot? and transferring it to another comp

dragonjr

Re: backing up the bot? and transferring it to another comp

dragonjr

Re: backing up the bot? and transferring it to another comp

Kentarii

Re: backing up the bot? and transferring it to another comp

dragonjr

Re: backing up the bot? and transferring it to another comp

Shendar

Re: backing up the bot? and transferring it to another comp

dragonjr

Re: backing up the bot? and transferring it to another comp

dragonjr

Re: backing up the bot? and transferring it to another comp

Kentarii

Re: backing up the bot? and transferring it to another comp

dragonjr

Re: backing up the bot? and transferring it to another comp

dragonjr

Re: backing up the bot? and transferring it to another comp