Oct 10, 2018

Sample shell script to import files into MySQL database




After importing the files, you can create an event in MySQL to continue to process those imported data. Creating an event is a better way because if you execute those sql queries from shell, it may encounter connection timed out etc if it takes long time to process those data.
CREATE EVENT process_data_after_import_event ON SCHEDULE 
AT CURRENT_TIMESTAMP + INTERVAL 3 SECOND
DO CALL process_data_after_import();