--trace Trace level of messages by mysqlbackup. --uncompress Uncompress a backup during an operation. --use-tts Enable selective backup of InnoDB tables using transportable tablespaces (TTS). --user Database se
mysqlpump --all-databases To dump a single database, or certain tables within that database, name the database on the command line, optionally followed by table names: mysqlpump db_name mysqlpump db_name tbl_name1 tbl_name2 ... ...
Restore to a Separate Location Move database files on restore, create clones for fast replication Familiar command-line behavior Consistent MySQL parameters and interaction Direct restore Restore in a single step. Simplifys recovery and saves space Selective TTS restore and table rename Great for trans...
The first command line above makes a hot backup of a MySQL database. By default it creates a backup directory (named by the current date and time) in the given backup root directory. With the --no-timestamp option it does not create a time-stamped backup directory, but it puts the ba...
--trace Trace level of messages by mysqlbackup. --uncompress Uncompress a backup during an operation. --use-tts Enable selective backup of InnoDB tables using transportable tablespaces (TTS). --user Database server user name to connect. --verbose Print more verbose information. --version Display...
This command gives me an error saying no such Database S33qual$$. If I leave the -p and password option out and hit enter it prompts me for the password, if i then enter S33qual$$ and hit enter it does the backup. Is it just me or am I missing something here? I am beginning ...
This manual describes the procedures to back up and restore MySQL databases. It covers techniques for minimizing time and storage overhead during backups, and to keep the database available during backup operations. It illustrates the features and syntax of the mysqlbackup command, for example, ...
1. mysqlhotcopy command: 1 [local-host]# /usr/bin/mysqlhotcopy -u root -p My2Secure$Password sugarcrm /home/backup/database --allowold --keepold The above example, performs a backup of sugarcrm, a MySQL database to the /home/backup/database directory. –allowold: This options renames...
修改配置文件/etc/my.cnf,保证[mysqld]模块存在参数datadir=/var/lib/mysql(指向数据目录),因为xtrbackup是根据/etc/my.cnf配置文件来获取需要备份的文件。然后重启mysqld。 (2).xtrbackup的使用 一般使用的是innobackupex脚本,因为innobackupex是perl脚本对xtrbackup的封装和功能扩展。
The following sections describe the command-line options for the different modes of operation of