Backup Schedule?

[kjarrett]

Hi all,

 

Is it daily, every other, or something else?

 

Thanks!

 

-kj-

[TCH-Thomas]

Hi KJ,

 

From the Help site page:

 

Each server is backed up weekly by the datacenter. We also perform remote off-site backups of each server every other day.

 

But remember, these backups are for emergencies, it is always each and everyones responsibility to make our own backups.

[kjarrett]

Hi KJ,

 

From the Help site page:

But remember, these backups are for emergencies, it is always each and everyones responsibility to make our own backups.

 

Thanks Tom. I was asked by our network admin if there was a way to automate the process on our end using FTP. Any thoughts on that? Possible? Or not worth the trouble?

 

TIA,

 

-kj-

[TCH-Bruce]

What are you wanting to back up? The entire site? Databases?

 

You can backup your databases using a script called dbsender and have them emailed or FTP'd to you.

[kjarrett]

What are you wanting to back up? The entire site? Databases?

 

You can backup your databases using a script called dbsender and have them emailed or FTP'd to you.

 

Sorry for being unclear, thought I'd specified that, clearly didn't - that's EXACTLY what I need ... how do we make this happen? Thanks a ton!

 

-kj-

[TCH-Bruce]

Well you can start by reading this forum thread and the threads it references.

[abinidi]

Can I just say that those forum threads make it sound really complicated and difficult. (I haven't done this yet because it just sounds so hard.)

 

I'd love it if somebody wanted to write a tutorial on this. I imagine it would be widely used.

 

I'd be willing to lend a hand. But I'm not exactly sure how to get started...

[TCH-Bruce]

The dbsender script is documented on what needs to be changed. If you have problems start a thread and ask for help. I backup 4 databases every night and have them emailed to a special address.

 

Here is a quick rundown of what you need to do.

1. Create a folder at the same level as your public_html folder in your web space - call it what ever you like
   
2. Change the permissions of the folder you just created 770
   
3. Edit the dbsender script (see details below) and place it in this folder - if more than one file is to be backed up rename the script file - one script file required per file
   
4. Set up a cron job to run the script
   

Edit this section of the dbsender script for your use I've bolded what you need to edit for email:

// configure your database variables below:

$dbhost = 'localhost'; // Server address of your MySQL Server

$dbuser = 'your-cPanel-name_database-user'; // Username to access MySQL database

$dbpass = 'password-for-database'; // Password to access MySQL database

$dbname = 'your-cPanel-name_database-name'; // Database Name

 

// Optional Options You May Optionally Configure

 

$use_gzip = "yes"; // Set to No if you don't want the files sent in .gz format

$remove_sql_file = "yes"; // Set this to yes if you want to remove the .sql file after gzipping. Yes is recommended.

$remove_gzip_file = "no"; // Set this to yes if you want to delete the gzip file also. I recommend leaving it to "no"

 

// Configure the path that this script resides on your server.

 

$savepath = "/home/your-cPanel-name/folder-you-create"; // Full path to this directory. Do not use trailing slash!

 

$send_email = "yes"; // Do you want this database backup sent to your email? Fill out the next 2 lines

$to = "who-to-email@yourTCHdomain.com"; // Who to send the emails to

$from = "backup@yourTCHdomain.com"; // Who should the emails be sent from?

 

$senddate = date("j F Y");

 

$subject = "Your message subject - $senddate"; // Subject in the email to be sent.

$message = "Your MySQL database has been backed up and is attached to this email"; // Brief Message.

 

 

$use_ftp = "no"; // Do you want this database backup uploaded to an ftp server? Fill out the next 4 lines

$ftp_server = "localhost"; // FTP hostname

$ftp_user_name = "ftp_username"; // FTP username

$ftp_user_pass = "ftp_password"; // FTP password

$ftp_path = "/"; // This is the path to upload on your ftp server!

 

A sample cron job entry would look like this:

>/usr/bin/php -q /home/your-cPanel-name/folder-you-created/script-name-to run

[curtis]

Thanks Bruce. Very concise instructions. I followed your instructions and it worked perfectly.

I was using a script called Backup2Mail, a good script but I think I will use this one for now.

[TCH-Bruce]

Thanks Curtis

[abinidi]

Those instructions *do* make it look easier.

 

Maybe I'll try it tomorrow when I get a little more time.

 

Thanks Bruce!!

[rnmcd]

What are you wanting to back up? The entire site? Databases?

 

You can backup your databases using a script called dbsender and have them emailed or FTP'd to you.

Does anyone know of scripts/programs that will backup the entire site and have it emailed or FTP'd to you?

Thanks.

[stevevan]

depending upon the size of your site, that could be a rather large email!

[TCH-Bruce]

Does anyone know of scripts/programs that will backup the entire site and have it emailed or FTP'd to you?

Thanks.

There is a thread on the forums that covers this.