Export MySql Database in Linux Command Line

I will show you how to export MySql Database in Linux Command Line

mysqldump -u root databasename –ignore-table=databasename.accesslogs  > filename.sql

Zip it using 7zip
7za a -t7z filename.7z filename.sql

The –ignore-table is pretty straightforward, it simply means do not include this table when exporting.