Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
None
-
None
-
uname -r
3.10.0-957.12.2.el7.x86_64
Mysql Server version: 10.2.25-MariaDB MariaDB Server
Description
On this page:
These two lines may not work on some linux systems:
gunzip < NAME_OF-FILE.GZ | mysql -u USERNAME -p PASSWORD --default-character-set=utf8 DATABASE_NAME
and
mysql -u USERNAME -p PASSWORD --default-character-set=utf8 DATABASE_NAME < NAME_OF-FILE
In many cases you will want to leave the PASSWORD out and then enter it at the prompt. Some hosts have disabled it due to security implications of having the password in the command, so the commands should be:
gunzip < NAME_OF-FILE.GZ | mysql -u USERNAME -p --default-character-set=utf8 DATABASE_NAME
<then enter password at the prompt>
and
mysql -u USERNAME -p --default-character-set=utf8 DATABASE_NAME < NAME_OF-FILE
<then enter password at the prompt>