Sample shell script to import files into MySQL database
After importing 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_eventSCHEDULE
AT INTERVAL SECOND
DO CALL process_data_after_import();