Enter the / home / zxin10 / task directory, execute CHMOD U + X mysqlbak.sh, and grant execution permission. (3) Log in as ebaserdb user, create the directory MKDIR – P / home / ebaserdb / task, and upload the script mysqlbak.sh in ASCII mode to the MySQL deployment server / home / ebaserdb / task directory. (2) The database ensures that the binary function is turned on( (to be supplemented) Print version information to prove that the command is available. Run the command to view the version information of MySQL dump: Log in to the server as a user who can log in to the MySQL database in the background, such as ebaserdb user. (1) Check whether the MySQL dump function is available. It is suitable for the case with a large number of databases and occupies a large space. The backup result is a copy of the entire MySQL data file, which only saves the data exported on the same day. Xtrabak.sh corresponds to the environment where the official hot backup tool xtrabackup is installed and can be backed up using the innobackupex command. It is applicable to the case where the amount of database data is small and occupies less space.Ģ. The file of the current day is and the file of the previous day is. Compress the export file and save the export file of the last two days. Export all tables, stored procedures, functions, events and tablespaces of all databases. Mysqlbak.sh corresponds to the environment where the MySQL database has been installed and the mysqldump command can be used. This document describes the installation and use of MySQL backup tool.Ģ installation and operation instructions
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |