Question: how to export mysql database schema with data?
Answer: Connect to your MySQL database. Click Server on the main tool bar. Select Data Export. Select the tables you want to back up. Under Export Options, select where you want your dump saved. ...  Click Start Export. ...  You now have a backup version of your site.