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

  • 27210
    139

    signcarver Reply #1, 1 year, 7 months ago

    Reply
    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
    139

    signcarver Reply #2, 1 year, 7 months ago

    Reply
    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
    596
    The Coding Pad - MODx        MODx Beginner Tutorials     
    MODx Video Tutorials 
    MODx Development

    einsteinsboi Reply #3, 1 year, 7 months ago

    Reply
    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.


  • 27210
    139

    signcarver Reply #4, 1 year, 7 months ago

    Reply
    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.