MySQL

From Wiki
Revision as of 16:14, 19 June 2024 by Qljca (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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
Retrieved from "https://workwiki.in/index.php?title=MySQL&oldid=111"