Difference between revisions of "Mysqldump"
Jump to navigation
Jump to search
↑ https://linux.die.net/man/1/mysqldump
(→Usage) |
|||
| Line 6: | Line 6: | ||
** Compressing from <code>[[stdin]]</code> | ** Compressing from <code>[[stdin]]</code> | ||
*** <code>mysqldump DB_name | [[gzip]] > DB_name.sql.gz</code> | *** <code>mysqldump DB_name | [[gzip]] > DB_name.sql.gz</code> | ||
| − | *** <code>mysqldump DB_name | [[xz -T0]] > DB_name.sql.xz</code> | + | *** <code>mysqldump DB_name | [[xz -T0]] > DB_name.sql.xz</code> |
| + | |||
| + | * <code>mysqldump -u root -p –all-databases</code> | ||
== Related commands == | == Related commands == | ||
Revision as of 17:00, 28 July 2021
mysqldump[1] a backup program.
Usage
mysqldump DB_name > DB_name.sql
mysqldump -u root -p –all-databases
Related commands
mongodumpmariabackup(since 2017)mysqlmysqldumpslow
See also
- MariaDB:
mariadbcheck,mariabackup,mysqldump, MyRocks,show (MariaDB)MariaDB Changelog,50-server.cnf, MariaDB engines, .ibd, .myd, .myi,/var/log/mysql/error.log, MariaDB files:.frm,.ibd,/etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries,show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306 - MySQL,
mysqldump, mysqladmin, XtraBackup, MySQL Enterprise Backup, MyISAM,/var/log/mysql/, MySQL Workbench, Adminer,ib_logfile0, mysqld --help --verbose, MySQL versions - XtraBackup and MyDumper
- MongoDB:
mongodump, PostgreSQL:pg_dump, MariaDB: mysqldump
Advertising:
