We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

my backup from within MODx Manager does not back up all of the records

    • 27210
    • 158 Posts
    signcarver Reply #1, 16 years ago
    I noticed that my database backup that i made from the MODx tools menu, which was formerly a 2.1 mb is now only 150k.

    when i try to import the suspicious small backup i get the following error:
    Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 5
STR: />
SQL: <br />
<b>Fatal error</b>:  Allowed memory size of 33554432 bytes exhausted (tried to allocate 1572878 bytes) in <b>/home3/signcarv/public_html/ezdacc/manager/actions/bkmanager.static.php</b> on line <b>305</b><br />


SQL query:

<br /> <b>Fatal error</b>: Allowed memory size of 33554432 bytes exhausted (tried to allocate 1572878 bytes) in <b>/home3/signcarv/public_html/ezdacc/manager/actions/bkmanager.static.php</b> on line <b>305</b><br />

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<br />
<b>Fatal error</b>:  Allowed memory size of 33554432 bytes exhausted (tri' at line 1


    If i use the phpMyAdmin panel to do the backup, it works fine.

    Any help would be appreciated.



      • 27210
      • 158 Posts
      signcarver Reply #2, 16 years ago
      found the problem. the manager log table was apparently too large. once i cleaned it out the MODx Manager works.

      However i had no indication from MODx that there was an issue with the backup which is kinda scary...
        • 8609
        • 607 Posts
        einsteinsboi Reply #3, 16 years ago
        I’ve found that it’s generally a good idea to clean out the site cache and manager logs before backing up your MODx site database. phpMyAdmin is notoriously bad when it comes to importing/exporting large databases in my experience.
          The Coding Pad - MODx        MODx Beginner Tutorials     
          MODx Video Tutorials 
          MODx Development
          • 27210
          • 158 Posts
          signcarver Reply #4, 16 years ago
          good suggestion - however i shouldn’t have to remember to do these kinds of things - that’s what software should do - and certainly it should catch errors and report when a procedure isn’t completed properly.