Database backups ?

[_Chris_]

How are the others here doing mysql database backups please ?

[Catherine]

If you have cPanel control panel for the hosting plan, it is possible to take backups of MySQL databases via phpmyadmin

[duncan320]

I do mine via a scheduled cron job daily and then another script on my local PC here FTP's them from eukhost servers each night to my pc and then deletes the backups, when i get 4gb worth i then archive them to DVD just in case, i also do full site backups the same way.

[euk-samson]

To back up a database individually, look for the title "Download a MySQL Database Backup" in the Backups option in cPanel . Below that there should be a listing of every database that you have created. Simply click on the name of the database you want to backup and save it to your local machine.

[_Chris_]

Many thanks Catherine, Samson and Duncan, the input is really appreciated.

I really like the automated mode of Duncans suggestion. Duncan, would you be able to expand a little please ? What would the cron look like and the script for ftp'ing from euk to your pc please ?

[Catherine]

Hi Chris.

You are most

To take the backup of databases, you can enter the command below for backup in cron.

#/usr/bin/mysqldump -u username -ppassword dbanme > backup.sql

The other option is to select the Backups option in cPanel control panel and click on "Download or Generate a Full Backup option" and enter the details required.

Hope this helps

[_Chris_]

Thanks again Catherine, I'll try that cron, but for the automated part of ftp'ing the backup onto your pc as Duncan kindly suggested sounds good (is he still here?), I have googled, but can't seem to find anything related to backing up from the servers to your pc. Any ideas on that part at all please ?

[Catherine]

Hi Chris,

You're welcome

For this purpose, you need to search for "FTP BAT file - Windows Scheduled Task" or contact a Windows admin in order to make a script for you.

[_Chris_]

That sounds good, have googled that and it's a bit above my knowledge status at the moment, but will research more.

Who are the windows admin please ? do they charge to make that small script ?

Would have been good to have learnt the scripting that Duncan uses.

[eUKhost.com]

That sounds good, have googled that and it's a bit above my knowledge status at the moment, but will research more.

Who are the windows admin please ? do they charge to make that small script ?

Would have been good to have learnt the scripting that Duncan uses.

I Chris

Our windows system administrator's can make such scripts for you.

You are most welcome to open a ticket in windows department and they will surely help you with such requirement.

[_Chris_]

I Chris

Our windows system administrator's can make such scripts for you.

You are most welcome to open a ticket in windows department and they will surely help you with such requirement.

Thanks Mark. Do they charge ? Where is the 'windows' department please ?

[_Chris_]

Thanks Mark. Do they charge ? Where is the 'windows' department please ?

Anyone know at all ?

[Rock]

Thanks Mark. Do they charge ? Where is the 'windows' department please ?

Anyone know at all ?

Hi Chris,

We wont be charging you for such customised backup scripts.

You can open up a support ticket with our Windows Dept by following this link: https://support.eukhost.com/index.php?x=&mod_id=4&t=17

[_Chris_]

I Chris

Our windows system administrator's can make such scripts for you.

You are most welcome to open a ticket in windows department and they will surely help you with such requirement.

Well, apparently, they don't - answer just received from William Watson :

"We do not have such script which copy backup at your local PC."

Any help much appreciated.

Chris

[John_B]

Also the CMS might have a backup facility. In Drupal you can get a backup module. Just hit backup and it starts downloading the databse. If you have clients who are intimidated by cPanel this may be the 'no excuses' alternative!