tailieunhanh - MySQL Administrator's Bible- P11

MySQL Administrator's Bible- P11: Với tập trung đặc biệt vào việc phát hành lớn tiếp theo của MySQL, nguồn tài nguyên này cung cấp một khuôn khổ vững chắc cho bất cứ ai mới vào MySQL hoặc chuyển từ một nền tảng cơ sở dữ liệu, cũng như các quản trị MySQL kinh nghiệm. Các bộ đôi tác giả cao hồ sơ cung cấp bảo hiểm thiết yếu của các nguyên tắc cơ bản của phạm vi bảo hiểm cơ sở dữ liệu quản lý, bao gồm cả cách tiếp cận độc đáo MySQL của các tính năng cơ sở. | Backups and Recovery 13 RISoft is that it provides what it calls near-Continuous Online Backups. It does this by performing backups very frequently every 15 minutes or less . This provides for a very small window of time that data can be lost. In addition the RISoft software also provides for complete bare-metal restore for MySQL servers. The homepage of RISoft is . Copying Databases to Another Machine You can copy the .frm .MYI and .MYD files for MylSAM tables and the .frm and data files .ibd or i bdata for InnoDB between different hardware architectures that support the same floating-point format Endianness . This means that you can transfer InnoDB and MylSAM tables from Windows to Linux without doing a logical export and import. Simply shut down the database or lock the tables involved and use scp to copy the database. Or restore a physical backup to a different machine. In cases where you need to transfer databases between different architectures you can use mysqldump to create a file containing SQL statements. You can then transfer the dump file to the second machine the destination host and feed it as input to the mysql client. To move a database from one machine to another run the following from the machine currently holding the database the target host shell mysqldump --databases sakila mysql -h destination_host sakila For large tables exporting a tab-delimited file and using mysqlimport is much faster than using mysqldump to export INSERT statements and restoring with source or the redirection operator . The --tab path to backup option to mysqldump creates a tab-delimited ASCII data file .txt and schema file .sql for each table when mysqldump is run locally. First create the backup directory and dump the database shell mkdir path to backup shell mysqldump --tab path to backup --databases sakila Then copy the files in path to backup directory to the destination machine and load the files into mysqld there shell cat path to backup .sql mysql .