We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 1553
    • 17 Posts
    Hi all,

    Since last week I noticed that backups I try to create from the manager fail. In the SQL file I see that the backup runs up to and including table modx_keyword_xref, then it stops. When I make a backup through phpmyadmin I get a complete SQL backup as usual.
    According to the hosting company no changes in versions of MySQL and PHP have taken place. Has anyone had similar experiences or have a hint as to where I can look?

    Thanks in advance,
    Andres
      • 1553
      • 17 Posts
      Hi,

      I could solve the problem by exporting the database with phpmyadmin using the same parameters that modxcms uses. The standard sql file that phpmyadmin creates, contains different characters for special characters such as ë and is therefore not properly imported into my testing modx installation and probably also not on the production version.
      Can anyone tell me where to find the export parameters that modx uses when exporting an sql file?

      Thanks,

      Andres
        • 4041
        • 788 Posts
        Have a look at "manager/actions/bkmanager.static.php", down near the bottom of the file. smiley
          xforum
          http://frsbuilders.net (under construction) forum for evolution
          • 1553
          • 17 Posts
          Thanks!
            • 1553
            • 17 Posts
            I looked at the bkmanager.static.php file but soon realised that would not be useful as I already know that the database parameters can’t be the cause of this problem. Backup of the database starts correctly but halts after table modx_keyword_xref. No error message, nothing except the fact that I see that my backup file is much shorter than it used to be.
            On my local version (in an XAMPP environment) backup proceeds as usual and I get the complete file. I asked my hosting provider if MySQL or PHP version or something else have changed; they say nothing changed but their PHP version went from 5.2.9 to 5.2.10. My local PHP is at version 5.2.6
            This has me looking at bkmanager.static.php again: does this file contain functionality that could have problems with PHP 5.2.10?

            Could an upgrade to a newer modx version solve my problem? Now I use 0.9.6.2 to my full satisfaction, but if necessary I will upgrade to 0.9.6.3

            thanks for your answers,
            Andres
              • 1553
              • 17 Posts
              Hi,

              Last weekend I upgraded to Evo succesfully! Then I tried to backup and I had the same problem...But I decided to empty the log after I saw that the modx_manager_log table was over 1 MB. And guess what: the backup works again!

              My salutations to the modx developers by the way for making the upgrade such an easy and reliable process!

              cheers,

              Andres
                • 28042 ☆ A M B ☆
                • 24,524 Posts
                It’s always a good idea to clear the manager actions log and the system events log, as well as clear the site cache, before doing a backup.
                  Studying MODX in the desert - http://sottwell.com
                  Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
                  Join the Slack Community - http://modx.org
                  • 1553
                  • 17 Posts
                  Of course; I should have read that somewhere, my fault embarrassed
                  Is there an explanation how the backup with phpmyadmin proceeds even with tables over 1 mB? I’m just curious even though I prefer to make a backup with the Modxcms Manager because backups with phpmyadmin on my hosting company’s server have specials characters in them and the backup resulting from that can’t be imported correctly in my local version of the website.

                  cheers,
                  Andres
                    • 28042 ☆ A M B ☆
                    • 24,524 Posts
                    probably something to do with memory limits or timeouts; phpMyAdmin is a lot more complex.
                      Studying MODX in the desert - http://sottwell.com
                      Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
                      Join the Slack Community - http://modx.org