error when backing up DB

Discussion in 'Troubleshooting' started by yatesf, Apr 8, 2004.

  1. yatesf

    yatesf Guest

    I get the following error when clicking on the backup link:

    "An Error has occured

    --------------------------------------------------------------------------------
    MYSQL ERROR:
    You have an error in your SQL syntax near 'CREATE TABLE amember_access_log' at line 1
    in query:
    SHOW CREATE TABLE amember_access_log "

    Any ideas what's causing this?

    -Fred
  2. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    MySQL version on your webhosting is outdated and doesn't support this command. You can use your hosting control panel backup tools to get a copy of MySQL database to your local harddrive.
  3. yatesf

    yatesf Guest

    Here is my server's s/w version info as listed from my aMember admin CP:
    Software version info
    aMember 2.1.1PRO
    PHP 4.0.6 (apache)
    OS Linux dev62 2.2.19-6.2.16 #1...
    MySQL 3.22.32

    I thought aMember required MySQL version 3.22+ according to this source:
    http://www.cgi-central.net/scripts/amember/docs/html/

    -Fred
  4. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    I will fix manual. In fact, aMember works with 3.22, but backup operation requires 3.23. You can use hosting tools to backup database.

Share This Page