shell> myloader --directory=/backups --user=<user> --password=<password> --queries-per-transaction=5000 --threads=8 --compress-protocol --overwrite-tables
The options are explained as follows:
- --overwrite-tables: This option drops the tables if they already exist
- --compress-protocol : This option uses compression on the MySQL connection
- --threads : This option specifies the number of threads to use; the default is 4
- --queries-per-transaction : This specifies the number of queries per transaction; the default is 1000
- --directory: This specifies the directory of the dump to import