Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Cpanel crontab backup help issue

[ithica]

Hi!
I have shellhost account with well know cpanel. I wish to use crontab button for emailing mySQL (forum) batabases but I dont know what to write in this cpanel form as "Command to run:". It's very clear how to set up crontab time/days/weeks... etc... but this Command to run a little bit confuse me.

Let's say that I have phpBB_forum database. I could set in that damn cpanel time and mail where to send ouput - but i dont know "command to run" for that output.
Maybe this silly question sound a little bit annoying for more skilled people, but for us - newbies - even this could be problem.

I will appreciate every helpful answer.
thanx, guys

Ithica

[exquisihost]

Hi,

Do you want to actually email the actual table files (as an attachment) or a mysql dump (text-output)? You could also tar-up the databases into one-file.

Let us know and we can assist.

Thanks,

Keith
Exquisihost

[ithica]

Ahaaa... sorry for not enough detailed question. I wish email the actual table files (as an attachment) - let's say every 4th day. So that I will have in mail full mySQL (forum and CMS portal) dabase backup if somethings wrong goes with my web hosting or something. I think that this is very appropriate since I haven't possabilityes to be online that often and manually download backups.
If this isn't possibly through cpanel console I have also ssh access to shell but again I dont know exactly command.

[exquisihost]

Hi Ithica,

Let's create a little bash/shell script

Something like this should work. You do this through file manager or through SSH. Let's call it mysqlbackup.sh

-------------------------------------------------------------------------------
#! /bin/bash

mysqldump -p<yourmysqlpassword> <DatabaseName> > db.backup.sql
# Note. This is all one-line
# You can tar this up if you wish
tar cvzpf db.backup.sql.tgz db.backup.sql
#Now let's send it
uuencode -m db.backup.sql.tgz db.backup.sql.tgz|mail -s MysqlBackup <youremail-address>
#Or you could also try it this way. I'll leave this commented out
mail -s MysqlBackup <youremailaddress> < db.backup.sql.tgz
---------------------------------------------------------------------------------

Make sure the permissions are 755 and you should be ok

To run this every 4 days, you can do something like this

* * */4 * * <yourdirectorypath>/mysqlbackup.sh

I haven't tested this but it should work

Hope this helps

Thanks,

Keith
Exquisihost

[ithica]

Thank you for your time - I will try and give you feedback in few days. Really thanx!


So this cPanel crontab form is usefull in this case just for mysql dump (text-output) and not for sending backup as attachment?