• Resolved jdaliani

    (@jdaliani)


    Updraft database backup to Google Drive is converting some data to weird characters. For example, in the database backup file, the value 0x828e0013b8f3bc1bb22b4f57172b019d is being saved as Çé\0∏Ûº≤+OW+ù, and the value 0x00000000000000000000000000000000 is being saved as \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0. Any insight into this that anyone could share would be greatly appreciated. The hosting company is dreamhost.

Viewing 14 replies - 1 through 14 (of 14 total)
  • Plugin Contributor bcrodua

    (@bcrodua)

    Hi,

    I will ask one of our colleague to check on this.

    We’ll be back to you as soon as possible.

    Thanks,
    Bryle

    Thread Starter jdaliani

    (@jdaliani)

    Hello: Here are some samples of the problem:

    1. This is taken from a PHPMyAdmin export of the database, and is CORRECT:

    INSERT INTO wp_wffilemods (filenameMD5, filename, knownFile, oldMD5, newMD5, SHAC, stoppedOnSignature, stoppedOnPosition, isSafeFile) VALUES
    (0x153bf0017bcfd7e16bfcafe10773b78e, ‘wp-content/themes/twentytwenty/404.php’, 1, 0x00000000000000000000000000000000, 0x6ae36b4bd66078c9781a642c6d014169, 0x99613ef89062475f1164f245682970884671100237f566332152a8dd2859704f, ”, 0, ‘?’),

    2. This is the same line from that same MySQL datatable and is taken from the UpDraft backup to Google Drive:

    INSERT INTO wp_wffilemods VALUES
    (‘;{œ◊·k¸Ø·s∑é’, ‘wp-content/themes/twentytwenty/404.php’, 1, ‘\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0’, ‘j„kK÷`x…x\Zd,mAi’, ‘ôa>¯êbG_dÚEh)pàFq7ıf3!R®›(YpO’, ”, 0, ‘?’),

    Thank You for your assistance

    Plugin Author David Anderson

    (@davidanderson)

    Please can you tell us the results of running the SQL command SHOW CREATE TABLE wp_wffilemods; ?

    Thread Starter jdaliani

    (@jdaliani)

    Plugin Author David Anderson

    (@davidanderson)

    The screenshot has cut out most of the response.

    Thread Starter jdaliani

    (@jdaliani)

    OK so you mean this, right? Thanks …

    CREATE TABLE wp_wffilemods (
    filenameMD5 binary(16) NOT NULL,
    filename varchar(1000) NOT NULL,
    knownFile tinyint(3) UNSIGNED NOT NULL,
    oldMD5 binary(16) NOT NULL,
    newMD5 binary(16) NOT NULL,
    SHAC binary(32) NOT NULL DEFAULT ‘\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0’,
    stoppedOnSignature varchar(255) NOT NULL DEFAULT ”,
    stoppedOnPosition int(10) UNSIGNED NOT NULL DEFAULT ‘0’,
    isSafeFile varchar(1) NOT NULL DEFAULT ‘?’
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    Thread Starter jdaliani

    (@jdaliani)

    It seems to export fine from PHPMyAdmin, but the Updraft backup to Google drive had that weird character conversion …

    Plugin Author David Anderson

    (@davidanderson)

    In a BINARY column type, those two different expressions you’re seeing are actually entirely equivalent. i.e. Two different ways of expressing the same thing. Are you experiencing a problem (i.e. something doesn’t work), or is it just the variation that is troubling you?

    Thread Starter jdaliani

    (@jdaliani)

    So in laymen’s terms, what you’re saying is that it’s not incorrect, but simply in a different format, and a format that can be reimported, yes?

    Plugin Author David Anderson

    (@davidanderson)

    Yes.

    Thread Starter jdaliani

    (@jdaliani)

    Thank you. Much appreciated.

    Thread Starter jdaliani

    (@jdaliani)

    OK here’s my problem though. In that format, I can’t re-import the database – or any individual data table thereof – through PHPMyAdmin, and attempting to do so CRASHES PHPMyAdmin – after creating a corrupted table that CAN’T be deleted! Is there any way to get it to export the database in a normal format – which is to say, like PHPMyAdmin exports databases/data tables. Because if not, it’s pretty much useless to me personally …

    • This reply was modified 4 years, 7 months ago by jdaliani.
    Thread Starter jdaliani

    (@jdaliani)

    … and now attempting to import a table from this file appears to have corrupted my entire database. This is quite upsetting.

    Plugin Author David Anderson

    (@davidanderson)

    Hi,

    Sorry about this. We have someone working on the problem and a resolution to output in a different format.

    David

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘Control Characters in backup’ is closed to new replies.