Question: how to extract data from mysql database?
Answer: Select your database from the list on the left. Click on "Export" from the top set of tabs. Select the tables from the list that you would like to back up. ...  Make sure both the "Structure" and "Data" boxes are selected on the right. ...  Check the "Save as file" box.