Discover Centmin Mod today
Register Now

Sysadmin Sypex dumper alternative?

Discussion in 'System Administration' started by elargento, Sep 11, 2016.

  1. elargento

    elargento Member

    293
    16
    18
    Jan 4, 2016
    Ratings:
    +39
    Local Time:
    3:59 PM
    10
    Hi,

    I see SypexDumper isn't compatible with PHP 7. Do you know any other mysql dump script which is compatible with PHP7?
     
  2. eva2000

    eva2000 Administrator Staff Member

    30,178
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,138
    Local Time:
    4:59 AM
    Nginx 1.13.x
    MariaDB 5.5
    Wouldn't know as I never trust php based mysql backup scripts for risk of timeouts and incomplete backup databases. The proper way is via ssh command line and mysql native client, mysqldump outlined at bottom of page at MariaDB MySQL - CentminMod.com LEMP Nginx web stack for CentOS

    mysqldump is what is used for Centmin Mod's premium dbbackup.sh mysql backup script outlined at MariaDB - dbbackup.sh - quick mysql database backups for Centmin Mod stack | Centmin Mod Community :)
     
    • Agree Agree x 1
  3. cloud9

    cloud9 Premium Member Premium Member

    140
    54
    28
    Oct 6, 2015
    England
    Ratings:
    +75
    Local Time:
    7:59 PM
    1.11.x
    10.x
    • Like Like x 1
  4. elargento

    elargento Member

    293
    16
    18
    Jan 4, 2016
    Ratings:
    +39
    Local Time:
    3:59 PM
    10
    Actually I'm not so good at managing servers and that's why I was looking for a script with GUI support.
     
  5. eva2000

    eva2000 Administrator Staff Member

    30,178
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,138
    Local Time:
    4:59 AM
    Nginx 1.13.x
    MariaDB 5.5
    Just needs practice :)
     
    • Like Like x 2
  6. elargento

    elargento Member

    293
    16
    18
    Jan 4, 2016
    Ratings:
    +39
    Local Time:
    3:59 PM
    10
    but what happens if I don't have root access? for example a shared hosting?
     
  7. eva2000

    eva2000 Administrator Staff Member

    30,178
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,138
    Local Time:
    4:59 AM
    Nginx 1.13.x
    MariaDB 5.5
  8. cloud9

    cloud9 Premium Member Premium Member

    140
    54
    28
    Oct 6, 2015
    England
    Ratings:
    +75
    Local Time:
    7:59 PM
    1.11.x
    10.x
    Look for a shared host who offers something like r1soft backups then, but as per above post you would be best to get a decent priced VPS.

    Mind you if your on shared hosting you wont be running centminmod so why are you here ? (confused.com)
     
  9. eva2000

    eva2000 Administrator Staff Member

    30,178
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,138
    Local Time:
    4:59 AM
    Nginx 1.13.x
    MariaDB 5.5
    true indeed !

    if on shared hosting, only way is to get web host to provide a full site + mysql backup so you can transfer to a VPS :D
     
  10. elargento

    elargento Member

    293
    16
    18
    Jan 4, 2016
    Ratings:
    +39
    Local Time:
    3:59 PM
    10
    well, there are many users that can't afford a vps so they have a shared hosting account. I understand there are better ways to back up databases like by using your script but I need a solution for shared hosting
     
  11. eva2000

    eva2000 Administrator Staff Member

    30,178
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,138
    Local Time:
    4:59 AM
    Nginx 1.13.x
    MariaDB 5.5
    Majority of shared hosts use whm/cpanel and web hosts have option to allow full site backups from being generated and downloaded from within user's cpanel account - probably a good alternative IF your site data size isn't too large. The problem is when data set size is large enough to cause timeouts and delays and interrupt the script's backup process
     
    • Like Like x 1
  12. elargento

    elargento Member

    293
    16
    18
    Jan 4, 2016
    Ratings:
    +39
    Local Time:
    3:59 PM
    10
    Is it useful if I'm running Centminmod, right? I'm using cPanel so mysqldump command will be enough, right?

    Thanks to all of you for your help.
     
  13. eva2000

    eva2000 Administrator Staff Member

    30,178
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,138
    Local Time:
    4:59 AM
    Nginx 1.13.x
    MariaDB 5.5
    dbbackup.sh is only for centmin mod lemp's structure :)
     
  14. cloud9

    cloud9 Premium Member Premium Member

    140
    54
    28
    Oct 6, 2015
    England
    Ratings:
    +75
    Local Time:
    7:59 PM
    1.11.x
    10.x
    Just run CPanels backup and make sure the MySQL box is ticked, you can back up locally, to a remote ftp site or to Amazon.

    Screen Shot 2016-09-13 at 07.15.09.png Screen Shot 2016-09-13 at 07.15.26.png
     
    • Like Like x 1
    • Agree Agree x 1