Announcement

Collapse
No announcement yet.

Database backups ?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database backups ?

    How are the others here doing mysql database backups please ?
    http://www.eUKhost.com

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

    Comment


    • #3
      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.
      www.systemtek.co.uk - Computers, Electronics and Telecoms news and technical information.

      Comment


      • #4
        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.

        Comment


        • #5
          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 ?
          http://www.eUKhost.com

          Comment


          • #6
            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

            Comment


            • #7
              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 ?
              http://www.eUKhost.com

              Comment


              • #8
                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.

                Comment


                • #9
                  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.
                  http://www.eUKhost.com

                  Comment


                  • #10
                    Originally posted by _Chris_ View Post
                    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.
                    eUKhost - eNlight Cloud Hosting || eUKhost Knowledgebase
                    Toll Free : 0808 262 0255 || Skype : mark_ducadi

                    Comment


                    • #11
                      Originally posted by eUKhost.com View Post
                      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 ?
                      http://www.eUKhost.com

                      Comment


                      • #12
                        Originally posted by _Chris_ View Post
                        Thanks Mark. Do they charge ? Where is the 'windows' department please ?
                        Anyone know at all ?
                        http://www.eUKhost.com

                        Comment


                        • #13
                          Originally posted by _Chris_ View Post
                          Thanks Mark. Do they charge ? Where is the 'windows' department please ?
                          Originally posted by _Chris_ View Post
                          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
                          Rock _a.k.a._ Jack Daniel

                          Follow eUKhost on Twitter || Join eUKhost Community on Facebook

                          Comment


                          • #14
                            Originally posted by eUKhost.com View Post
                            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
                            http://www.eUKhost.com

                            Comment


                            • #15
                              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!

                              Comment

                              Working...
                              X