Database backup file won’t import into MySQL 8

[Mark SmithParticipant]

Hi Dee,

Yes, that’s done it.

Would that be available in an upcoming update?

Many thanks for your assistance in this.

Mark

[Dee NutbourneModerator]

Hi Mark,

Yes, we will be improving the method to disable strict requirements.
I have added this to our development list.

Best Wishes,
Dee

[Mark SmithParticipant]

Hi,

I have done some further experiments and narrowed it down to the CREATE TABLE command.

I have attached both an Updraft backup file (which fails against MySQL 8) and a MySQL 8 export (no data). Both the actual CREATE TABLE commands are identical which makes me think the metadata or comments within the file have an impact.

https://pastebin.com/jkC59TqK – Updraft Backup file (data deleted)
https://pastebin.com/w8yYU8tF – MySQL Export file (data deleted)

To replicate (not a complete example – the key is to place one of the files in a standalone directory and map to /docker-entrypoint-initdb.d):
docker run -d \
–name DB \
-P \
-v /path/to/one-of-the/export-files-directory:/docker-entrypoint-initdb.d \
-e MYSQL_USER_FILE=/var/run/secrets/mysql-user \
-e MYSQL_PASSWORD=”” \
-e MYSQL_ROOT_PASSWORD=”” \
-e MYSQL_DATABASE_FILE=”” \
mysql:8

[Mark SmithParticipant]

Hi,

I have done some further experiments and narrowed it down to the CREATE TABLE command.

I have attached both an Updraft backup file (which fails against MySQL 8) and a MySQL 8 export (no data). Both the actual CREATE TABLE commands are identical which makes me think the metadata or comments within the file have an impact.

https://pastebin.com/jkC59TqK – Updraft Backup file (data deleted)
https://pastebin.com/w8yYU8tF – MySQL Export file (data deleted)

To replicate (not a complete example – the key is to place one of the files in a standalone directory and map to /docker-entrypoint-initdb.d):
docker run -d \
–name DB \
-P \
-v /path/to/one-of-the/export-files-directory:/docker-entrypoint-initdb.d \
mysql:8

[Mark SmithParticipant]

Hi,

I have done some further experiments and narrowed it down to the CREATE TABLE command.

I have attached both an Updraft backup file (which fails against MySQL 8) and a MySQL 8 export (no data). Both the actual CREATE TABLE commands are identical which makes me think the metadata or comments within the file have an impact.

https://pastebin.com/jkC59TqK – Updraft Backup file (data deleted)
https://pastebin.com/w8yYU8tF – MySQL Export file (data deleted)

To replicate (not a complete example – the key is to place one of the files in a standalone directory and map to /docker-entrypoint-initdb.d):
docker run -d –name DB -P -v /path/to/one-of-the/export-files-directory:/docker-entrypoint-initdb.d -e MYSQL_USER_FILE=/var/run/secrets/mysql-user -e MYSQL_PASSWORD=”” -e MYSQL_ROOT_PASSWORD=”” -e MYSQL_DATABASE_FILE=”” mysql:8

[Mark SmithParticipant]

Hi,

I have done some further experiments and narrowed it down to the CREATE TABLE command.

I have attached both an Updraft backup file (which fails against MySQL 8) and a MySQL 8 export (no data). Both the actual CREATE TABLE commands are identical which makes me think the metadata or comments within the file have an impact.

https://pastebin.com/jkC59TqK – Updraft Backup file (data deleted)
https://pastebin.com/w8yYU8tF – MySQL Export file (data deleted)

To replicate (unable to provide an example due to errors with the duplicate answer check – the key is to place one of the files in a standalone directory and map to /docker-entrypoint-initdb.d)

[Mark SmithParticipant]

Hi,

I have done some further experiments and narrowed it down to the CREATE TABLE command.

I have attached both an Updraft backup file (which fails against MySQL 8) and a MySQL 8 export (no data). Both the actual CREATE TABLE commands are identical which makes me think the metadata or comments within the file have an impact.

https://pastebin.com/jkC59TqK – Updraft Backup file (data deleted)
https://pastebin.com/w8yYU8tF – MySQL Export file (data deleted)

[Mark SmithParticipant]

Hi,

I have done some further experiments and narrowed it down to the CREATE TABLE command.

I have attached both an Updraft backup file (which fails against MySQL 8) and a MySQL 8 export (no data). Both the actual CREATE TABLE commands are identical which makes me think the metadata or comments within the file have an impact.

https://pastebin.com/jkC59TqK – Updraft Backup file (data deleted)
https://pastebin.com/w8yYU8tF – MySQL Export file (data deleted)

To replicate (not a complete example – the key is to place one of the files in a standalone directory and map to /docker-entrypoint-initdb.d):
docker run -d \
–name DB \
-P \
-v /path/to/one-of-the/export-files-directory:/docker-entrypoint-initdb.d \
-e MYSQL_USER_FILE=/var/run/secrets/mysql-user \
-e MYSQL_PASSWORD=”” \
-e MYSQL_ROOT_PASSWORD=”” \
-e MYSQL_DATABASE_FILE=”” \
mysql:8

[Mark SmithParticipant]

Hi,

Ignore my previous comment – I have spent quite a few attempts to reply.

I have done some further experiments and narrowed it down to the CREATE TABLE command.

I have attached both an Updraft backup file (which fails against MySQL 8) and a MySQL 8 export (no data). Both the actual CREATE TABLE commands are identical which makes me think the metadata or comments within the file have an impact.

https://pastebin.com/jkC59TqK – Updraft Backup file (data deleted)
https://pastebin.com/w8yYU8tF – MySQL Export file (data deleted)

To replicate (not a complete example – the key is to place one of the files in a standalone directory and map to /docker-entrypoint-initdb.d):
docker run -d \
–name DB \
-P \
-v /path/to/one-of-the/export-files-directory:/docker-entrypoint-initdb.d \
-e MYSQL_USER_FILE=/var/run/secrets/mysql-user \
-e MYSQL_PASSWORD=”” \
-e MYSQL_ROOT_PASSWORD=”” \
-e MYSQL_DATABASE_FILE=”” \
mysql:8

[Mark SmithParticipant]

https://pastebin.com/jkC59TqK – Updraft Backup file (data deleted)
https://pastebin.com/w8yYU8tF – MySQL Export file (data deleted)

[Author]

Posts