- Create a text file update.in with two lines in it, e.g.
saved1
saved2
- Start a server on a fresh data folder, default server settings are enough
- Execute SQL
USE test;
DROP TABLE IF EXISTS t1;
CREATE TABLE t1
( word VARCHAR(255) PRIMARY KEY ) ENGINE=Aria;
LOAD DATA LOCAL INFILE 'update.in' INTO TABLE t1;
SET AUTOCOMMIT=0;
DELETE FROM t1;
LOAD DATA LOCAL INFILE 'update.in'
INTO TABLE t1 IGNORE 1 LINES;
COMMIT;
(make sure you have the right path to update.in)
- kill server with SIGKILL or alike
- try to start server on the same datadir again
To reproduce the problem manually:
- Create a text file update.in with two lines in it, e.g.
saved1
saved2
- Start a server on a fresh data folder, default server settings are enough
- Execute SQL
USE test;
DROP TABLE IF EXISTS t1;
CREATE TABLE t1
( word VARCHAR(255) PRIMARY KEY ) ENGINE=Aria;
LOAD DATA LOCAL INFILE 'update.in' INTO TABLE t1;
SET AUTOCOMMIT=0;
DELETE FROM t1;
LOAD DATA LOCAL INFILE 'update.in'
INTO TABLE t1 IGNORE 1 LINES;
COMMIT;
(make sure you have the right path to update.in)
- kill server with SIGKILL or alike
- try to start server on the same datadir again