Control Characters in backup

Hi,

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

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

Thanks,
Bryle

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

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

OK here’s a screen shot:

https://www.growing-bones.com/zdr23xSt4q/MySQLSample.png

The screenshot has cut out most of the response.

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;

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

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?

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?

Yes.

Thank you. Much appreciated.

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, 8 months ago by jdaliani.

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

Hi,

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

David