To add an alt to Leon's mysqldump command ...
in admin/cli of existing site, there are mysql_ php scripts that will fix issues with DB ... mysql_collation.php, mysql_compressed_rows.php, and mysql_engine.php. All have help screens if called without options. Help screens explain options. Those scripts must be run from command line so knowing or finding php-cli is necessary.
'SoS', Ken