diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-07-01 18:15:00 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-07-01 18:15:00 +0000 |
commit | a2a2e32c02643a0cec111511220227703fda1cd5 (patch) | |
tree | 69cc2b631234c2a8e026b9cd4d72676c61c594df /man/mysqlhotcopy.1 | |
parent | Releasing progress-linux version 1:10.11.8-1~progress7.99u1. (diff) | |
download | mariadb-a2a2e32c02643a0cec111511220227703fda1cd5.tar.xz mariadb-a2a2e32c02643a0cec111511220227703fda1cd5.zip |
Merging upstream version 1:11.4.2.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'man/mysqlhotcopy.1')
-rw-r--r-- | man/mysqlhotcopy.1 | 534 |
1 files changed, 0 insertions, 534 deletions
diff --git a/man/mysqlhotcopy.1 b/man/mysqlhotcopy.1 deleted file mode 100644 index 01f26c15..00000000 --- a/man/mysqlhotcopy.1 +++ /dev/null @@ -1,534 +0,0 @@ -'\" t -.\" -.TH "\fBMARIADB-HOTCOPY\fR" "1" "15 May 2020" "MariaDB 10.11" "MariaDB Database System" -.\" ----------------------------------------------------------------- -.\" * set default formatting -.\" ----------------------------------------------------------------- -.\" disable hyphenation -.nh -.\" disable justification (adjust text to left margin only) -.ad l -.\" ----------------------------------------------------------------- -.\" * MAIN CONTENT STARTS HERE * -.\" ----------------------------------------------------------------- -.\" mysqlhotcopy -.\" dumping: databases and tables -.\" backups: databases and tables -.\" databases: dumping -.\" tables: dumping -.SH "NAME" -mariadb-hotcopy \- a database backup program (mysqlhotcopy is now a symlink to mariadb-hotcopy) -.SH "SYNOPSIS" -.HP \w'\fBmysqlhotcopy\ \fR\fB\fIarguments\fR\fR\ 'u -\fBmysqlhotcopy \fR\fB\fIarguments\fR\fR -.SH "DESCRIPTION" -.PP -\fBmysqlhotcopy\fR -is a Perl script that was originally written and contributed by Tim Bunce\&. It uses -FLUSH TABLES, -LOCK TABLES, and -cp -or -scp -to make a database backup\&. It is a fast way to make a backup of the database or single tables, but it can be run only on the same machine where the database directories are located\&. -\fBmysqlhotcopy\fR -works only for backing up -MyISAM -and -ARCHIVE -tables\&. It runs on Unix and NetWare\&. -.PP -To use -\fBmysqlhotcopy\fR, you must have read access to the files for the tables that you are backing up, the -SELECT -privilege for those tables, the -RELOAD -privilege (to be able to execute -FLUSH TABLES), and the -LOCK TABLES -privilege (to be able to lock the tables)\&. -.sp -.if n \{\ -.RS 4 -.\} -.nf -shell> \fBmysqlhotcopy \fR\fB\fIdb_name\fR\fR\fB [\fR\fB\fI/path/to/new_directory\fR\fR\fB]\fR -.fi -.if n \{\ -.RE -.\} -.sp -.if n \{\ -.RS 4 -.\} -.nf -shell> \fBmysqlhotcopy \fR\fB\fIdb_name_1\fR\fR\fB \&.\&.\&. \fR\fB\fIdb_name_n\fR\fR\fB \fR\fB\fI/path/to/new_directory\fR\fR -.fi -.if n \{\ -.RE -.\} -.PP -Back up tables in the given database that match a regular expression: -.sp -.if n \{\ -.RS 4 -.\} -.nf -shell> \fBmysqlhotcopy \fR\fB\fIdb_name\fR\fR\fB\&./\fR\fB\fIregex\fR\fR\fB/\fR -.fi -.if n \{\ -.RE -.\} -.PP -The regular expression for the table name can be negated by prefixing it with a tilde (\(lq~\(rq): -.sp -.if n \{\ -.RS 4 -.\} -.nf -shell> \fBmysqlhotcopy \fR\fB\fIdb_name\fR\fR\fB\&./~\fR\fB\fIregex\fR\fR\fB/\fR -.fi -.if n \{\ -.RE -.\} -.PP -\fBmysqlhotcopy\fR -supports the following options, which can be specified on the command line or in the -[mysqlhotcopy] -and -[client] -option file groups\&. -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: help option -.\" help option: mysqlhotcopy -\fB\-\-help\fR, -\fB\-?\fR -.sp -Display a help message and exit\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: addtodest option -.\" addtodest option: mysqlhotcopy -\fB\-\-addtodest\fR -.sp -Do not rename target directory (if it exists); merely add files to it\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: allowold option -.\" allowold option: mysqlhotcopy -\fB\-\-allowold\fR -.sp -Do not abort if a target exists; rename it by adding an -_old -suffix\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: checkpoint option -.\" checkpoint option: mysqlhotcopy -\fB\-\-checkpoint=\fR\fB\fIdb_name\fR\fR\fB\&.\fR\fB\fItbl_name\fR\fR -.sp -Insert checkpoint entries into the specified database -\fIdb_name\fR -and table -\fItbl_name\fR\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: chroot option -.\" chroot option: mysqlhotcopy -\fB\-\-chroot=\fR\fB\fIpath\fR\fR -.sp -Base directory of the -\fBchroot\fR -jail in which -\fBmysqld\fR -operates\&. The -\fIpath\fR -value should match that of the -\fB\-\-chroot\fR -option given to -\fBmysqld\fR\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: debug option -.\" debug option: mysqlhotcopy -\fB\-\-debug\fR -.sp -Enable debug output\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: dryrun option -.\" dryrun option: mysqlhotcopy -\fB\-\-dryrun\fR, -\fB\-n\fR -.sp -Report actions without performing them\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: flushlog option -.\" flushlog option: mysqlhotcopy -\fB\-\-flushlog\fR -.sp -Flush logs after all tables are locked\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: host option -.\" host option: mysqlhotcopy -\fB\-\-host=\fR\fB\fIhost_name\fR\fR, -\fB\-h \fR\fB\fIhost_name\fR\fR -.sp -The host name of the local host to use for making a TCP/IP connection to the local server\&. By default, the connection is made to -localhost -using a Unix socket file\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: keepold option -.\" keepold option: mysqlhotcopy -\fB\-\-keepold\fR -.sp -Do not delete previous (renamed) target when done\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: method option -.\" method option: mysqlhotcopy -\fB\-\-method=\fR\fB\fIcommand\fR\fR -.sp -The method for copying files (cp -or -scp)\&. The default is -cp\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: noindices option -.\" noindices option: mysqlhotcopy -\fB\-\-noindices\fR -.sp -Do not include full index files for -MyISAM -tables in the backup\&. This makes the backup smaller and faster\&. The indexes for reloaded tables can be reconstructed later with -\fBmyisamchk \-rq\fR\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: old-server option -.\" old-server option: mysqlhotcopy -\fB\-\-old\-server\fR -.sp -Connect to old MySQL-server (before v5.5) which doesn't have FLUSH TABLES WITH READ LOCK fully implemented.\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: password option -.\" password option: mysqlhotcopy -\fB\-\-password=\fR\fB\fIpassword\fR\fR, -\fB\-p\fR\fB\fIpassword\fR\fR -.sp -The password to use when connecting to the server\&. The password value is not optional for this option, unlike for other MariaDB programs\&. -.sp -Specifying a password on the command line should be considered insecure\&. You can use an option file to avoid giving the password on the command line\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: port option -.\" port option: mysqlhotcopy -\fB\-\-port=\fR\fB\fIport_num\fR\fR, -\fB\-P \fR\fB\fIport_num\fR\fR -.sp -The TCP/IP port number to use when connecting to the local server\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: quiet option -.\" quiet option: mysqlhotcopy -\fB\-\-quiet\fR, -\fB\-q\fR -.sp -Be silent except for errors\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: record_log_pos option -.\" record_log_pos option: mysqlhotcopy -\fB\-\-record_log_pos=\fR\fB\fIdb_name\fR\fR\fB\&.\fR\fB\fItbl_name\fR\fR -.sp -Record master and slave status in the specified database -\fIdb_name\fR -and table -\fItbl_name\fR\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: regexp option -.\" regexp option: mysqlhotcopy -\fB\-\-regexp=\fR\fB\fIexpr\fR\fR -.sp -Copy all databases with names that match the given regular expression\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: resetmaster option -.\" resetmaster option: mysqlhotcopy -\fB\-\-resetmaster\fR -.sp -Reset the binary log after locking all the tables\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: resetslave option -.\" resetslave option: mysqlhotcopy -\fB\-\-resetslave\fR -.sp -Reset the -master\&.info -file after locking all the tables\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: socket option -.\" socket option: mysqlhotcopy -\fB\-\-socket=\fR\fB\fIpath\fR\fR, -\fB\-S \fR\fB\fIpath\fR\fR -.sp -The Unix socket file to use for connections to -localhost\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: suffix option -.\" suffix option: mysqlhotcopy -\fB\-\-suffix=\fR\fB\fIstr\fR\fR -.sp -The suffix to use for names of copied databases\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: tmpdir option -.\" tmpdir option: mysqlhotcopy -\fB\-\-tmpdir=\fR\fB\fIpath\fR\fR -.sp -The temporary directory\&. The default is -/tmp\&. -.RE -.sp -.RS 4 -.ie n \{\ -\h'-04'\(bu\h'+03'\c -.\} -.el \{\ -.sp -1 -.IP \(bu 2.3 -.\} -.\" mysqlhotcopy: user option -.\" user option: mysqlhotcopy -\fB\-\-user=\fR\fB\fIuser_name\fR\fR, -\fB\-u \fR\fB\fIuser_name\fR\fR -.sp -The MariaDB user name to use when connecting to the server\&. -.RE -.PP -Use -perldoc -for additional -\fBmysqlhotcopy\fR -documentation, including information about the structure of the tables needed for the -\fB\-\-checkpoint\fR -and -\fB\-\-record_log_pos\fR -options: -.sp -.if n \{\ -.RS 4 -.\} -.nf -shell> \fBperldoc mysqlhotcopy\fR -.fi -.if n \{\ -.RE -.\} -.SH "COPYRIGHT" -.br -.PP -Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc., 2010-2020 MariaDB Foundation -.PP -This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. -.PP -This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. -.PP -You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA or see http://www.gnu.org/licenses/. -.sp -.SH "SEE ALSO" -For more information, please refer to the MariaDB Knowledge Base, available online at https://mariadb.com/kb/ -.SH AUTHOR -MariaDB Foundation (http://www.mariadb.org/). |