BlueShepherdSoftware

Members
  • Posts

    1
  • Joined

  • Last visited

BlueShepherdSoftware's Achievements

Newbie

Newbie (1/4)

0

Reputation

  1. My Hawkhost hosted website is slowly coming together, it is good. I'm working on a PHP script with customer data stored in mySQL as well as some custom logs files ... and I'm looking to do backups. I've developed the site on my own local box and transferred to hawkhost so I'm not worried about the HTML, PHP, etc ... but data (mysql and log files) is the issue. I know that hawkhost does the R1Soft backups (nightly?) for the last 7 days but I really want the data on my own machine. I am looking for suggestions on how to do an automated off site backup: remote login to my hawkhost account, sqldump the database then download to my machine OR cron job to sqldump the database then ??? to ??? (dropbox or ???) OR something else? A downside to #2 is that if somebody hacks my account/website then they may be able to hack my backup location and destroy my data .. not good. I would really like it so I can drop the data into mysql on my local machine and peruse the live data offline (just in case) ... aka; not have the backup file in some "proprietary" compressed format that requires me to upload back to hawkhost, etc to restore the data Any suggestions on which item above (or others) and the next level of details (my "work" machines are Windows based) ... would be greatly appreciated. Thanks, Scott