1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Sypex Dumper, Backup and restore your database

Backup and restore your database quickly !

  1. Allan

    Allan Well-Known Member

  2. ShadyX

    ShadyX Well-Known Member

    I have been using sypex for a long time now and it is a great tool :)
    Allan likes this.
  3. Dodgeboard

    Dodgeboard Well-Known Member

    Same here. Works seamlessly and integrates into Xenforo AdminCP. I mentioned this some time back, but it's nice to see a resource written. Thanks!.


    Does anyone know how to fix this error? I am getting this in the email from the cron job I set up:

    X-Powered-By: PHP/5.2.17
    Expires: Wed, 19 Nov 2008 19:19:19 GMT
    Cache-Control: no-store, no-cache, must-revalidate
    Content-Type: text/html; charset=utf-8

    Notice: Undefined property: Sypex_Dumper::$JOB (/home/MYSITE/public_html/sxd/index.php:96)Warning: file_get_contents() [<a href=\'function.file-get-contents\'>function.file-get-contents</a>]: Filename cannot be empty (/home/MYSITE/public_html/sxd/index.php:96)

    The problem was that I didn't change job_name with my own job name.
    You can get that by clicking "save" in Sypex Dumper.

    /usr/bin/php /home/site/public_html/sxd/index.php -j=job_name
  5. Dodgeboard

    Dodgeboard Well-Known Member

    First try getting it to work by manually running it from the AdminCP.

    You did edit this line with your site specific info, right?

    /usr/bin/php /home/site/public_html/sxd/index.php -j=job_name


    It does work manually.

    I have: /usr/bin/php /home/MYSITE/public_html/sxd/index.php -j=job_name
  7. Dodgeboard

    Dodgeboard Well-Known Member



    Thanks Dodgeboard,
    I had found that as well and translated but it didn't help me much either. I'll keep messing with it...
  9. Jeremy P

    Jeremy P Well-Known Member

    Does the cron user have permissions to write to the backup folder?
  10. Adam Howard

    Adam Howard Well-Known Member

  11. Allan

    Allan Well-Known Member

    Unzip "SypexDumper_209.zip" folder and upload "sxd" folder in "forum" folder.

    For you, it's "forums" folder.
  12. Adam Howard

    Adam Howard Well-Known Member

    I had already done that. :cautious:
  13. Adam Howard

    Adam Howard Well-Known Member

    Never mind...... I re-uploaded everything again and this time it shows up. I guess something didn't upload right the last time.

    Of course just my luck... It never does finish backing up.

    Execution stopped by user

    ^^ Always seem to get that.
  14. EnragedGames

    EnragedGames Member

    Wow, amazing, thanks for the "addon"! I was wondering how hard would it be to integrate DropBox so that backup archives are sent to DropBox instead of a FTP?
    gldtn likes this.
  15. Claudio

    Claudio Well-Known Member

    if I add a cron, which database will be saved?
    the command doesn´t specify a phpmyadmin username/password or even a database name..


    It will be the same database that your xenforo installation uses. You don't have to specify the username/password anywhere. The command asks for a job name, see my edited post above - post #4. Hope that helps. If you need anything else just ask.
  17. Claudio

    Claudio Well-Known Member

    my idea is to use the same cron but for make a backup of a selected database of any kind, not only xenforo


    I got this from their documentation. http://sypex.net/en/products/dumper/docs/
    Hopefully this helps.

    SypexDumperstarting from version 2.0.5 supports the work from the command line (console/cron).
    The following arguments:
    • -h=localhost - MySQL-host
    • -o=3306 - port
    • -u=root - username
    • -p=password - password
    • -j=my_job - name of the saved job
    Only argument -j with the name of the saved job required, all the rest must be specified in the event that they differ from the data stored in the config file.
  19. Claudio

    Claudio Well-Known Member

    thank you very much!
  20. RoldanLT

    RoldanLT Well-Known Member

    I'm using the standalone pack :)

Share This Page