Cannot properly export a table via phpMyAdmin: columns containing comments are not included

Created:

2016-11-16 13:07:03 UTC

Modified:

2017-08-08 13:35:52 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Cannot properly export a table via phpMyAdmin: columns containing comments are not included

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

Exporting database table via phpMyAdmin is incorrect: columns containing comments are not included.

Export via mysqldump utility is working correctly.

Cause

This is Plesk internal issue with ID #PPPM-4241 . The fix is planned to be released in future Plesk updates.

Resolution

  • Export via mysqldump utility.
    mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` <databasename> <tablename> > <outputfile>

or:

  • Delete comments from row manually.
Have more questions? Submit a request
Please sign in to leave a comment.