These are the steps that I followed for data loading:
- use test;
- LOAD DATA INFILE ‘/test.csv’ INTO TABLE data FIELDS TERMINATED BY ‘|’ LINES TERMINATED BY ‘\r\n’;
- I get an error ERROR 1049 (42000): Unknown database ‘n’;’
After that, the connection to MySQL gets lost. Any further queries on that connection result in the following error:
- select * from data;
- No connection. Trying to reconnect…
ERROR 1049 (42000): Unknown database ‘n’;’
ERROR:
Can’t connect to the server
Although, it re-connects to the server after I ‘use test’ again:
- use test
- No connection. Trying to reconnect…
Connection id: 45
Current database: *** NONE ***
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
Any help in this regard will be appreciated. Thanks!
), the load worked completely fine this time! The only thing that has changed ever since I tried the last time is that the machine was rebooted.
