Mass Import .tar.gz SQL Files
Hello,
As our server InnoDB has been corrupted i had copied the MySQL data directory and taken all the database backups as separate file
The backups files are like username_dbname.sql.gz
is there any command for bulk import from root end ?
I tried to do the following thing but got the error
mysql user_website < user_website.sql.gz
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: ''.
Please sign in to leave a comment.
Comments
0 comments