How to export schema of MYSQL Database?

If you need schema of your MYSQL database for backup or any copy database to another server, then you must need schema with or without data.

GUI tools like SQLYog, WebYog or PHPmyAdmin will best example for that. But if you need any command or utility then MYSQLDUMP has most important role.

For using mysqldump you can export schema as well as data with it.

mysqldump -u root -p –no-data [mydatabase] > myschema.sql






Leave a Reply

Your email address will not be published. Required fields are marked *