MySQL: Difference between revisions
Jump to navigation
Jump to search
(Created page with "==Check MySQL Version== <pre> mysql -V </pre> ==MySQL Dump== ===Backup All Databases=== <pre> mysqldump --all-databases > backup.sql </pre> ===Backup database using User=== <pre> mysqldump -u dbuser -p dbname > dbname.sql </pre> ===Exclude a table from MySQL Dump=== <pre> --ignore-table=dbname.tablename Syntax: mysqldump -u DBuser -p DBname --ignore-table=DBname.tablename > dbname.sql </pre> ===Export Single Table=== <pre> mysqldump -u username -p database-name t...") |
No edit summary |
||
| Line 23: | Line 23: | ||
mysqldump -u DBuser -p DBname --ignore-table=DBname.tablename > dbname.sql | mysqldump -u DBuser -p DBname --ignore-table=DBname.tablename > dbname.sql | ||
</pre> | </pre> | ||
===Export Single Table=== | ===Export Single Table=== | ||
<pre> | <pre> | ||
mysqldump -u username -p database-name table-name > backup.sql | mysqldump -u username -p database-name table-name > backup.sql | ||
</pre> | |||
===Export Table Structure Only=== | |||
<pre> | |||
mysqldump -u DBUser -p --no-data dbname > schema.sql | |||
</pre> | </pre> | ||
Revision as of 16:18, 19 June 2024
Check MySQL Version
mysql -V
MySQL Dump
Backup All Databases
mysqldump --all-databases > backup.sql
Backup database using User
mysqldump -u dbuser -p dbname > dbname.sql
Exclude a table from MySQL Dump
--ignore-table=dbname.tablename Syntax: mysqldump -u DBuser -p DBname --ignore-table=DBname.tablename > dbname.sql
Export Single Table
mysqldump -u username -p database-name table-name > backup.sql
Export Table Structure Only
mysqldump -u DBUser -p --no-data dbname > schema.sql