ok thank you for all the help

i just saw a buddlylist clear will that effect anything else on the mmeber part for like there alts and info that they ahve put in ?

Buddylist is another word for friends list.
This is stored on the chat-server, so you can't back up your buddylist.

So, you don't need to backup your database to run !buddylist clear.
This will just empty the bot's friends list. When clear is done, you can run rosterupdate to add the bots members again.
But if the member list contains people who have changed servers etc, you will get those buddy add -1 messages.

As for backup up your database, are you running your bot on windows or linux? Do you have SSH access if it's linux?
If that's the case it's just a matter of running this command:
mysqldump -u<username> -p <databasename> > bebot_backup.sqlOr if you want to archive it.
mysqldump -u<username> -p <databasename> | nice bzip2 > bebot_backup.sql.bz2You will be prompted for your password, so if my mysql username is bebot and the database is called bebot as well, you have this command:

mysqldump -ubebot -p bebot | nice bzip2 > bebot_backup.sql.bz2
Later when you want to restore your backup you can run:
bunzip2 bebot_backup.sql.bz2and
mysql -ubebot -p bebot < bebot_backup.sql

The commands are the same, you just have to locate the path to the mysql bin directory if you didn't add them during install time to your path environment.

C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump -u<username> -p <databasename> > bebot_backup.sql

If you're running the command above in a command prompt, you can select where you want to store the files by changing dirs.
Otherwise, it will just end up in your c:\users\<username> directory I guess.
Windows 7 doesn't have bzip2/bunzip2, so use the command without the archive compression and just save it to .sql

The answer lies within
more conf/MySQL.conf

C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump -u<dragon> -p <bebot> > bebot_backup.sql

tried and it says this was a unexspectied time thats it
then i tried what you just posted MySQL.conf in not recognized an internal or external command operable program or batch file
and am i able do this while the bot is running or should i be shuuting it off?

Try this:
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump -udragon -p bebot > bebot_backup.sql

ok i copied and pasted in where i would put cmd then i had to put in a password i did and then some words poped ur realy quick and the black box disappeard what am i doing wrong