download exporting database from phpmyadmin

If you are in the welcome screen, click on the restore icon.

It uses the binaries of the database for the job, and it’s compatible with the latest version of MySQL.

Your database will now be updated. Click the Refresh button (Cmd + R) if needed.

This will bring up a dialog box, select the file on your file system that you would like to import, then click Import.

Choose Import > From SQL Dump… from the File menu.

Careful: Importing a *.sql file may overwrite your existing data!.

You have to update the app to the latest version to make sure the app runs properly.

Now TablePlus has already supported Import SQL Dump. It works just fine for the small sized file, but for a huge file, it gives the app a hard time executing it. Previously, you can import and *.sql file to use with your database in TablePlus by dragging the file into the query editor and execute it. Not only it generates much better looking and interactive HTML but also allows you to visualize schema with ER diagrams, split large database into modules, describe each data element and document table relationships.How do I import an SQL Dump file into MySQL database? If you want more from the data dictionary export, have a look at Dataedo. This option generates the documentation in an HTML page. To print data dictionary first select your database, then click the Structure tab and click on the Data dictionary option below the list of tables. This tutorial will show you how to export data dictionary for an existing MySQL and MariaDB database using phpMyAdmin 4.8.1. It enables option to print database schema to a html page.

PhpMyAdmin is a popular web-based MySQL and MariaDB administration tool.

Download exporting database from phpmyadmin