Results 1 to 18 of 18
-
09-24-2013, 12:24 AM #1Junior Guru Wannabe
- Join Date
- Nov 2005
- Posts
- 59
Automatically backing up a Database?
Well,
Really not sure which forum this belongs in so just starting here and hopefully someone can direct me if this is the wrong place.
My website is hosted through hostpc.com.
It has phpMyAdmin which I can use to see my DB stuff.
It has a link in the Direct Admin dashboard called Cronjobs but I don't know anything about them.
It also has a link to view Installed Perl Modules so I guess Perl is there too.
It also has some sort of Softaculous Auto Installer if that helps at all.
I'm not a programmer so really don't know much about this stuff but can usually tinker with things as long as I get pointed in the right direction...
Anyway, I'm looking for some way I can set something up to automatically backup my database(s). I've seen lots of things regarding bash scripts, cron jobs, etc but I honestly don't know if I can even do that.
I can access my site via FTP but don't know if I can access some sort of bash prompt or use Putty or something like that.
If anyone can offer any assistance, please let me know.
Thanks!!!
-
09-24-2013, 03:15 AM #2
I suppose you do not have WHM access or cpanel, right?
NetDynamics LLC - One-stop Solution for Hosting Needs
We love Backups! Backup storage for your server backups
-
09-24-2013, 07:53 AM #3Junior Guru Wannabe
- Join Date
- Nov 2005
- Posts
- 59
-
09-24-2013, 09:36 AM #4
cPanel offers a good backup option. You can download your database and your files with just one click!
NetDynamics LLC - One-stop Solution for Hosting Needs
We love Backups! Backup storage for your server backups
-
09-24-2013, 10:09 AM #5WHT Addict
- Join Date
- Apr 2005
- Location
- Holland
- Posts
- 124
DirectAdmin should also have option 'Backup' in which you can choose what should be backed-up (e-mail, website, database).
-
09-24-2013, 10:21 AM #6Junior Guru Wannabe
- Join Date
- Nov 2005
- Posts
- 59
Yes, DA has a backup option, but I have to log in and do it. I'm looking for something I can schedule somehow so I dont' have to do it every day. HostPC had an outage last week due to a HDD failure and they only back up weekly for shared accounts so I lost some stuff. I just want to make sure that doesn't happen again by making my own backups.
-
09-24-2013, 10:27 AM #7WHT Addict
- Join Date
- Apr 2005
- Location
- Holland
- Posts
- 124
Well...
DirectAdmin knows three access levels:
- Admin
- Reseller
- User
You most probably have user level. Only Admin and Resellers can automate (cronjob) backups of the users, but user level does not have this option (as you said, you have to log in and start it manually).
So, try asking your hosting provider to set this option for you ;-)
-
09-24-2013, 10:28 AM #8Junior Guru
- Join Date
- Feb 2012
- Posts
- 231
Add the following command to your CRON and you are all set to go:
Code:mysqldump ---user [user name] ---password=[password] [database name] > [dump file]
WEBUZO - Single User Control Panel for your VPS/Cloud/Server (CentOS/Ubuntu)
Install NGINX, Apache, MySQL, LAMP, LEMP, PHP, Java and 310+ popular scripts by a CLICK
Email Server, Database Management, Domain Management, FTP Management, CSF, CRON
-
09-24-2013, 10:38 AM #9Junior Guru Wannabe
- Join Date
- Nov 2005
- Posts
- 59
-
09-24-2013, 10:44 AM #10
Two more options:
1. You can ask your host if they can schedule an automatic backup for you or if they sell an extra backup option such as automatic remote backup.
2. You can buy a script such as cpremote or whmeasybackup to automate backups. But both need cpanel if I recall it right.NetDynamics LLC - One-stop Solution for Hosting Needs
We love Backups! Backup storage for your server backups
-
09-24-2013, 01:29 PM #11Junior Guru Wannabe
- Join Date
- Nov 2005
- Posts
- 59
So if I change to a host that offers cPanel, does that make it easier for me to do my own automated backups? I'm looking to possibly change hosts after all this and most of them have cPanel as their preferred setup.
-
09-24-2013, 01:34 PM #12NetDynamics LLC - One-stop Solution for Hosting Needs
We love Backups! Backup storage for your server backups
-
09-24-2013, 01:41 PM #13Web Hosting Guru
- Join Date
- May 2013
- Posts
- 294
cpanel is easier to manage
Treat your password like your toothbrush. Don't let anybody else use it, and get a new one every six months.Sancte Michael Archangele, defende nos in proelio, contra nequitiam et insidias diaboli esto praesidium. Imperet illi Deus, supplices deprecamur: tuque, Princeps militiae coelestis, Satanam aliosque spiritus malignos, qui ad perditionem animarum pervagantur in mundo, divina virtute, in infernum detrude. Amen
-
09-24-2013, 01:45 PM #14Junior Guru Wannabe
- Join Date
- Nov 2005
- Posts
- 59
I'm checking to see if they can change me over to cPanel. If not I may just look info moving to a new host.
-
09-24-2013, 03:39 PM #15Junior Guru Wannabe
- Join Date
- Nov 2005
- Posts
- 59
-
09-25-2013, 02:29 AM #16Junior Guru
- Join Date
- Feb 2012
- Posts
- 231
Did you try flushing the privileges ?
WEBUZO - Single User Control Panel for your VPS/Cloud/Server (CentOS/Ubuntu)
Install NGINX, Apache, MySQL, LAMP, LEMP, PHP, Java and 310+ popular scripts by a CLICK
Email Server, Database Management, Domain Management, FTP Management, CSF, CRON
-
09-25-2013, 09:31 AM #17Junior Guru Wannabe
- Join Date
- Nov 2005
- Posts
- 59
-
09-25-2013, 02:15 PM #18Web Hosting Master
- Join Date
- Feb 2004
- Location
- Toronto
- Posts
- 2,308
VimHost >> 30 Days Backup | cPanel + LiteSpeed + JetBackup | DMCA FREE!
20 Years in business ~ Premium Hosting in Toronto, Canada ~ 151 Front Street (Canadian owned and operated)
Similar Threads
-
I need some help backing up / restoring my database
By iulia in forum Hosting Security and TechnologyReplies: 11Last Post: 12-05-2009, 08:30 AM -
backing up database
By FreshFroot in forum Programming DiscussionReplies: 9Last Post: 10-20-2009, 03:28 AM -
Backing up database data
By pergesu in forum Hosting Security and TechnologyReplies: 2Last Post: 10-25-2005, 02:39 PM -
Backing up a MySQL Database
By GameStudioD in forum Programming DiscussionReplies: 9Last Post: 09-08-2004, 04:51 PM -
backing up a database woes
By aqi32 in forum Web Hosting LoungeReplies: 7Last Post: 04-06-2004, 05:15 PM