mysql backup script

Discussion in 'PHP' started by sam20e, Mar 10, 2013.

0
  1. #1
    hi guyz

    I know what im looking for is widely available when i do a google search, but all outdated and all got some sort of bug.

    1) I need a simple PHP script which will backup 1 mysql database and zip it to gz and upload that backup to a local FTP location. (important i need only php script because this is for a shared server, not for a vps or dedi to run sh or other comands)

    2) Important db backup should be zipped and should be stored according to time stamp. For ex : mysql_1_20120101_180102.zip.gz something like that.

    3) this php script i want to configure in cron (to run 2-3 times a day)

    anyone has a working script like this please let me know or link me to the script. Please do not google for me because i have already tried many scripts. I never came across 1 working without flawlessly.

    so it would be great if you can share a script which you already using/tested and working. I need only db backup php script

    Thanks
     
    sam20e, Mar 10, 2013 IP
  2. EricBruggema

    EricBruggema Well-Known Member

    Messages:
    1,740
    Likes Received:
    28
    Best Answers:
    13
    Trophy Points:
    175
    #2
    I think if you want this you need a custom build script, and that can be done! :)
     
    EricBruggema, Mar 10, 2013 IP
  3. sam20e

    sam20e Member

    Messages:
    57
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    45
    #3
    i dont need a custom made script. there are many available for free its just all are out dated to the latest tech.
     
    sam20e, Mar 10, 2013 IP
  4. sdeveloper

    sdeveloper Member

    Messages:
    17
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    31
    #4
    The best solution I know that will satisfy all your requirements - is to use such php script described for example here:
    http://forums.cpanel.net/f49/automatic-cpanel-backup-domain-mysql-cron-php-111213.html

    It works using cpanel native backups system, so you'll just need to enter ftp/cpanel/params settings into your php script and set up cron jobs. I'm using this method with all my projects under cpanel.

    The only difference I'd found these days - x3 skin needed to be used in settings.
     
    sdeveloper, Mar 11, 2013 IP