I have to load data in mysql table from text file | delimited.
Please find following details:
WE have two tables (1) transaction_details and transaction_details_history
(2) we use after insert trigger on transaction_details table to insert records in history table
I am using following command to load data from text file:
LOAD DATA INFILE '/home/pradeep.tiwari/upload/transaction_details_insert_data_new.txt'
IGNORE INTO TABLE domain_details_insert_test FIELDS TERMINATED BY '|';
got following error:
ERROR 1205 (HY000) at line 1: Lock wait timeout exceeded; try restarting transaction
number of rows in txt file is around 2,00,000 at once.
As per mysql manual its not need ti increase inoodb_wait_time+out variable, vale in my server set to 200.
Please advice me to sorted out the issue.