kjarrett Posted December 13, 2005 Share Posted December 13, 2005 Hi all, Is it daily, every other, or something else? Thanks! -kj- Quote Link to comment Share on other sites More sharing options...
TCH-Thomas Posted December 13, 2005 Share Posted December 13, 2005 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. Quote Link to comment Share on other sites More sharing options...
kjarrett Posted December 13, 2005 Author Share Posted December 13, 2005 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- Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted December 13, 2005 Share Posted December 13, 2005 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. Quote Link to comment Share on other sites More sharing options...
kjarrett Posted December 13, 2005 Author Share Posted December 13, 2005 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- Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted December 13, 2005 Share Posted December 13, 2005 Well you can start by reading this forum thread and the threads it references. Quote Link to comment Share on other sites More sharing options...
abinidi Posted December 13, 2005 Share Posted December 13, 2005 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... Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted December 13, 2005 Share Posted December 13, 2005 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. Create a folder at the same level as your public_html folder in your web space - call it what ever you like Change the permissions of the folder you just created 770 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 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 Quote Link to comment Share on other sites More sharing options...
curtis Posted December 14, 2005 Share Posted December 14, 2005 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. Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted December 14, 2005 Share Posted December 14, 2005 Thanks Curtis Quote Link to comment Share on other sites More sharing options...
abinidi Posted December 14, 2005 Share Posted December 14, 2005 Those instructions *do* make it look easier. Maybe I'll try it tomorrow when I get a little more time. Thanks Bruce!! Quote Link to comment Share on other sites More sharing options...
rnmcd Posted March 20, 2006 Share Posted March 20, 2006 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. Quote Link to comment Share on other sites More sharing options...
stevevan Posted March 20, 2006 Share Posted March 20, 2006 depending upon the size of your site, that could be a rather large email! Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted March 20, 2006 Share Posted March 20, 2006 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.