mysql database dump

Question

PHP

There are 2 functions in php that do the following:
1. Creates a database schema.
2. Creates a data dump to this database

mysqldump -uUSER -pPASSWORD -hlocalhost -d --default-character-set=utf8 --quote-names --allow-keywords --add-drop-table --set-charset --result file=/path/to/file/schema.mysql

mysqldump -uUSER -pPASSWORD -hlocalhost --ignore-table=PROJECT.schema_info-t --default-character-set=utf8 --add-drop-table --create-options --quick --allow-keywords --max_allowed_packet=16M --quote-names --complete-insert --set-charset --result-file=/path/to/file/data.mysql

When creating schema.mysql, it is necessary to take data from the schema_info table and put it in schema.mysql. And when creating data.mysql, take all the data except the data in schema_info and push it into data.mysql

Answer 1

mysqldump -uUSER -pPASSWORD -hlocalhost -d --default-character-set=utf8 --quote-names --allow-keywords --add-drop-table --set-charset schema_info > /path/to/file/schema.mysql

man mysqldump