Hello, i have tried to restore backup. That i have got by 1. extracting .zst file created by DA backup system, finding .sql file and compressing it using gzip (tar -czf f.tar.gz f.sql). I have compressed it because it is large and i needed to transfer it over internet.
When i have uploaded this .tar.gz file in DA as a user, it says:
When i have extracted the file and opened it, it says it is not UTF8 and the beginning of the file is:
When i have uploaded the uncompressed .sql file without mentioned weird charcacters at the beginning and the end, restore was successful.
I have not emptied the destination database before importing the sql backup file.
When i have uploaded this .tar.gz file in DA as a user, it says:
Unable to restore database user_dbnamehere : ERROR: 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: 'user_dbnamehere.sql'.
gzip: stdout: Broken pipe
When i have extracted the file and opened it, it says it is not UTF8 and the beginning of the file is:
the file also ends with alot of space, like if someone push 400 times a spacebar key. When i have removed weird spaces and above quoted text, and again compressed the file to tar.gz and uploaded, it still complains the same.user_dbnamehere.sql many spaces here 0000644000342500034330047723600714026255674012337 0ustar -- MySQL dump 10.13 Distrib 5.7.33, for Linux (x86_64)
--
-- Host: localhost
When i have uploaded the uncompressed .sql file without mentioned weird charcacters at the beginning and the end, restore was successful.
I have not emptied the destination database before importing the sql backup file.
Last edited: