I've 7Gb .sql backupfile. I've to import it to my working database(mysql).
$ mysql -u <username> -p
mysql> use database <databasename>
It almost took 3-4 hrs and gave an error
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.
So, I've tried
$ mysql -u <username> -p --binary-mode
mysql> use database <dbname>
mysql> source <pathtofile>
Again, after 3hrs, it ended with an so many errors with some of them being
unkown character \n'. I think the error was repetitive. Initially I've tried opening the file to save it in
UTF-8 encoding but It's taking more than 3 hrs to open completely.