-
☆ A M B ☆
- 24,524 Posts
I frequently have to do just that when I dump the database from one server to clone a system in another server; the differences in MySQL versions causes all kinds of problems. So when I dump the originating database, I run the resulting .sql file through a text editor and remove everything after the basic table definition before uploading the file to the second database.
-
MODX Staff
- 10,725 Posts
BTW, you can have phpmyadmin handle this automatically in your dumps by selecting MYSQL323 in the SQL Export Compatability drop down that is available on the Export view of the database, a part of the Structure settings (at least in the version that comes with XAMPP, 2.6.2-pl1).
-
☆ A M B ☆
- 24,524 Posts
Never noticed that, not sure what version the remote servers have.
I also just added a new permission that allows a logged-in manager user to view unpublished documents in the frontend. This means that with the right permissions the Preview window will actually work for unpublished documents and you will be able to use QuickEdit on unpublished documents.
This should also be tested, be sure to check the "View unpublished documents in frontend" permission in the role editor.