Build your next data model with DeZign for Databases trial software, available for download directly from Datanamic's download section.Once the upload is complete, the bottom of the browser will indicate dump complete. Using the same cPanel program, browse to the gz file and upload it. There is no need to unzip this file to restore it. gz file will be downloaded to your local drive. Display data types in a diagram: Learn how to display data type and/or domain info in the entity boxes on your diagram. Look for ‘Download a MySQL Database Backup’ and click the name of the database.Getting started with DeZign for Databases: Start making a data model directly.DeZign for Databases: Learn more about DeZign for Databases.On the mainscreen you'll find 'View dump (schema) of database'. You can also make a dump with PHPMyAdmin.

More information can be found in MySQL's online manual:

You can get a list of the options your version of mysqldump supports by executing mysqldump -help. If you don't give any tables or use the -databases or -all-databases, the whole database(s) will be dumped. The mysqldump utility is a utility to dump a database or a collection of the database for backup or for transferring the data to another SQL server (not necessarily a MySQL server). You can use the MySQL utility 'mysqldump' or you can use PHPMyAdmin.

There are several ways to create a MySQL database structure dump. A dump will contain SQL statements to create the table and/or populate the table. You can then restore the backup with a command like mysql -u user_name -p /var/backups/'.When you want to reverse engineer an existing MySQL database into DeZign for Databases you can connect to the database directly or you can make a database structure dump and import that structure dump. The basic usage of mysqldump is mysqldump -u user_name -p name-of-database >file_to_write_to.sql I'd suggest using the mysqldump utility to back up your database. While you can execute backup commands from PHP, they don't really have anything to do with PHP.

Download phpmyadmin mysqldump