...
1 - Log into MySQL console
You have to use mysql command with --local-info=1 to login, e.g.
| Code Block |
|---|
mysql --local-infile=1 -uroot -p dualshield |
2 - Change to "DualShield" database:
| Code Block | ||
|---|---|---|
| ||
use DualShield; |
3 - Enable local_infile
...
| language | bash |
|---|
...
4 - Execute the script below to import the database
...
* replace "FILE-PATH-TO" with the actual file path where the downloaded file is saved, e.g. "c:\downloadstemp"
* Please note that it can take hours to import the data depending on the performance of the machine, as there are nearly 5 millions of records to be imported.
...