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

SQL syntax error

Discussion in 'General PHP and MySQL Discussions' started by sweetpotato, Sep 12, 2014.

  1. sweetpotato

    sweetpotato Active Member

    Hello,

    I am moving my site to another host but when backup and restore by Sympex Dumper I have this error:
    Please anyone instruct me to solve this. Now my site down.
    Thanks,
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Several people have reported issues with using Sympex Dumper.

    Try using mysqldump instead.
     
  3. sweetpotato

    sweetpotato Active Member

    Could you have quick instruction how to use mysqldump please. This is the first time I 've heard it's name. :D
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    This is what I use via SSH (using PuTTY).

    Code:
    mysqldump -udatabase_user -p --single-transaction --skip-lock-tables database_name > /path/to/backup/database_name_$(date +%d.%m.%y).sql

    Then to zip it.

    Code:
    tar -czf database_name_$(date +%d.%m.%y).tar.gz /path/to/backup/database_name_$(date +%d.%m.%y).sql
     
    sweetpotato and RoldanLT like this.
  5. RoldanLT

    RoldanLT Well-Known Member

    Yeah exactly, including me :)
    When I started using MariaDB 10.
     
  6. sweetpotato

    sweetpotato Active Member

    Thanks Brogan but I am on shared hosting so there is no SSH.
     
  7. Brogan

    Brogan XenForo Moderator Staff Member

    Have you asked your host if they will take the backup for you?
     
    sweetpotato likes this.
  8. sweetpotato

    sweetpotato Active Member

    Thanks for your help,
    I found the way by exporting database through phpAdmin and still import by Sympex dump. Database was restored successfully.
     

Share This Page