2016-06-18, 02:27 PM
Hello everyone,
I have an untouched compressed MyBB MySQL backup stored on my pc, it was obtained through the Admin CP with the database backup tool (downloaded it directly to my desktop). However when I try to extract it on Linux using:
I get the following error message: "not in gzip format". I then did basic research on the file and discovered something odd. The supposedly compressed file contains a plain MySQL query at the very top of it; whereas the rest seems to be actual compressed data.
The plain text part:
Everything underneath these 8 lines is most likely compressed data.
When I try importing this file into MySQL it gives me the following error:
Is it still possible to retrieve the data from this backup file?
Any sort of help would be appreciated, thanks in advance.
I have solved the issue myself, I have simply removed the plain text from the file and then attempted to decompress it again with success! (MyBB version 1.8.7)
I have an untouched compressed MyBB MySQL backup stored on my pc, it was obtained through the Admin CP with the database backup tool (downloaded it directly to my desktop). However when I try to extract it on Linux using:
gunzip -c mybbdump.sql.gz
I get the following error message: "not in gzip format". I then did basic research on the file and discovered something odd. The supposedly compressed file contains a plain MySQL query at the very top of it; whereas the rest seems to be actual compressed data.
The plain text part:
-- MyBB Database Backup
-- Generated: 18th June 2016 at 14:12
-- -------------------------------------
CREATE TABLE `emails` (
`username` varchar(120) CHARACTER SET utf8 NOT NULL DEFAULT '',
`email` varchar(220) CHARACTER SET utf8 NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Everything underneath these 8 lines is most likely compressed data.
When I try importing this file into MySQL it gives me the following error:
Quote:ERROR at line 5: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected. Query: ''.
Is it still possible to retrieve the data from this backup file?
Any sort of help would be appreciated, thanks in advance.
I have solved the issue myself, I have simply removed the plain text from the file and then attempted to decompress it again with success! (MyBB version 1.8.7)