Alibabacloud.com offers a wide variety of articles about linux server backup best practices, easily find your linux server backup best practices information here online.
the configuration information of my_multi.cnf, which can be copied accordingly.
[Mysqld_multi]
Mysqld =/usr/local/mysql001/bin/mysqld_safe
Mysqladmin =/usr/local/mysql001/bin/mysqladmin
User = root
Password = root
[Mysqld1]
Socket =/tmp/mysql_001.sock
Port = 3301
Pid-file =/usr/local/mysql001/data_1/hostname. pid
Datadir =/usr/local/mysql001/data_1
Log =/usr/local/mysql001/data_1/hostname. log
User = mysql
# Slave setting
Server-id = 2
Master-host =
~] # Mysqldump -- databases test1 -- skip-opt -- quick -- extended-insert = false -- lock-all-tables -- master-data = 2-u root-p123456>/tmp/test1. SQL
2. view the backup file
We found that the starting position of the record at this time is exactly 1133, as shown in the following example:
Change master to MASTER_LOG_FILE = 'mysqlbin. 100', MASTER_LOG_POS = 000161;[Root @ test4 ~] # Cat/tmp/test1. SQL -- MySQL dump 10.13 Distrib 5.1.70, for unknown-
restore systems, which are largely system-neutral, and the Linux backup processes the packaging and unpacking of files. In general, the following directories need to be backed up:/etcContains all core configuration files. This includes network configuration, system name, firewall rules, users, groups, and other global system entries./varContains information that is used by the system Daemon (service), incl
This article mainly introduces the Linux batch backup server configuration file and directory methods, the need for friends can refer to the next
Function:1. Only in the backup machine, the remote server only need to allow the backup
mail notification.
5 The target path for SVN backup is/mnt/svn119, backup directory naming rule: repos+ current date, such as repos20091112. Where/mnt/svn119 is mapped to the/SVN directory of the standby machine.
6 The log information that is backed up is stored in the/svn/shell/logs directory of the host, and the corresponding log file is: current date. Log, such as 20091112.log. After the
The data on the server is so important that we have to back it up regularly! Here is a backup of MySQL and the use of rsync to synchronize files on the server, thus enabling the backup of files between multiple Linux servers.A MySQL BackupMySQL
.jpg "/>4. Upgrading the operating system1) Following the above operation, enter the privileged mode, if your previous configuration has not been saved need to save and upgrade the system, or upgrade the system after the restart will lose the configuration, then enter the copy TFTP flash, then enter the server IP 192.168.1.2, and then enter the name of the system you want to upgrade, The prerequisite is that your TFTP to have this system to upgrade, m
Startup-config in privileged mode to restore the factory settings, reboot and then complete the recovery.650) this.width=650; "title=" Capture 5. PNG "src=" http://s3.51cto.com/wyfs02/M02/5B/73/wKioL1UJaFaxPL8nAAG-oJigCxs838.jpg "alt=" Wkiol1ujafaxpl8naag-ojigcxs838.jpg "style=" padding:0px;margin:0px;vertical-align:top;border:none; "/>3. Back up the router's configuration file on TFTP1) First prepare a router and a server, with a cross-line connecti
Local single File upload script, name uf
This is done on the local test, using the Bpcs_uploader script implementation, just for simple encapsulation, automatically improve the cloud file path.
Technical Highlights: Use DirName to get the directory where the files are located, use PWD to get the full path of the file, and as a cloud file path.
#!/bin/bash
cur_dir=$ (CD "$ (dirname") "; pwd)
name=$ (basename "$")
/home/grm/bin/bpcs_uploader/bpcs_uploader.php Upload $ awin$cur_dir/$name
Local f
mode, plus the control switch passive mode to see the situation plus if the upload using passive mode Entering Passive Mode errorBinary: Binary transferCD: Server side CD LCD: Client CD put upload single mput upload multiple get download single mget download multiple Prompt Multiple Tips#========================start Shell Script ============================#!/bin/bash#定义备份数据库时使用的用户名和密码db_user = "root" db_passwd= "111111"#定义FTP服务器地址, user name, passw
Set MySQL installed in C: disk, MySQL database username is root, the password is 123456, the database name is database_name, in D: Packing directory to store the backup database, the backup database name is Backup20070713.sql ( 20070713.sql for backup date)
Back up the database:
Mysqldump is a SQL-level backup mechan
MySQL database in the format of a table with deletionBacking up a MySQL database is in the format of a table with deletion, so that the backup can overwrite existing databases without the need to manually delete the original database.
Mysqldump -- add-drop-table-uusername-ppassword databasename> backupfile. SQL
Directly compress and back up the MySQL database
Mysqldump-hhostname-uusername-ppassword databasename | gzip> backupfile. SQL .gz [it is esti
database does not exist. If the database exists, you need to overwrite it with the following command:Restore database TestDB from disk= '/opt/dbbackup/testdb.bak ' with replaceSQL Server also has two operations: detaching a database and attaching a database.First, detach the database:sp_detach_db TestDBSo, where are the separated files? In fact, do not worry at all, it is too easy to find a file under the Linux
-ppassword databasename | gzip> backupfile. SQL .gz [it is estimated that it should be in linux. I guess I did not try it]
Back up a MySQL database table
Mysqldump-hhostname-uusername-ppassword databasename specific_table1 specific_table2> backupfile. SQL
Back up multiple MySQL databases at the same time
Mysqldump-hhostname-uusername-ppassword-databases databasename1 databasename2 databasename3> multibackupfile. SQL
Back up database structures only
My
Server Load balancer principles and practices part 3 basic concepts of Server Load balancer-network Basics
SeriesArticle:
Server Load balancer: requirements of Server Load balancer
Server Load balancer details A
Build Practice lvs+keepalived Load BalancingKeepalived Overview1.keepalived is a powerful auxiliary tool specifically designed for LVS, mainly used to provide failover and health check function-to determine the LVS load Scheduler, node server availability, timely isolation and replacement of the new server, when the failed host to rejoin the cluster after recovery.Overview of the 2.keepalived hot-standby pr
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.