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_event ON SCHEDULE 
AT CURRENT_TIMESTAMP + INTERVAL 3 SECOND
DO CALL process_data_after_import();

Comments

Popular posts from this blog