REM COYING IBD FILES FROM ONE VERSION TO THE NEXT
REM You will need to know the exact structure of the table (the CREATE TABLE statement).
REM 
REM     Create the table with the same structure.
REM     Run ALTER TABLE table_name DISCARD TABLESPACE;
REM     Copy the ibd file to table_name.ibd in the target location
REM     Run ALTER TABLE table_name IMPORT TABLESPACE;
REM 
REM This may not work if you didn't FLUSH TABLES table_name FOR EXPORT; before you backed it up.

mysqldump -p -d --host=localhost --port=3306 --user=root --password=dbas --routines --triggers --events  market_data> market_data_schema.dat
mysqldump -p -d --host=localhost --port=3306 --user=root --password=dbas --routines --triggers --events  portfolio_data> portfolio_data_schema.dat
