The recent work often need to back up the MySQL database on the remote server to the local computer, a direct backup of the MySQL data directory, but because of different coding reasons often arise. Later, my friend recommended me to use a very handy and compact PHP program--mydb. Contains three files altogether:
1. mydb.php//db class
Copy Code code as follows:
?
Class db{
var $linkid;
var $sqlid;
var $record;
function db ($
From the virtual host over to the VPS, the general webmaster may feel the operation of the time cost is relatively large, although sometimes cheap vps compared to the virtual host a little cheaper, but the VPS in the operation of the dimension is more than the virtual host worry about some. For example, in the VPS maintenance,
When you have installed the "extraterrestrial virtual host management platform" Software, for special reasons, you need
To reinstall the 2003 operating system, you can follow these steps:
------------------------------------------------------------------------------------------------------------
1. Backup data:
1) Back up SQL 2000 data. Please back up the Data directory for SQL 2000 (default C:\Program
Fi
However, after VPS is involved, it is not just about backing up MySQL, but also about backing up some independent site data.
If there is a reliable third-party Linux host or cloud storage like Amazon, it is much simpler, and Linux-Linux backup is very convenient.
However, I want to run a backup every day or every week in my Windows 7 environment.
The general ide
However, after VPS is involved, it is not just about backing up MySQL, but also about backing up some independent site data.If there is a reliable third-party Linux host or cloud storage like Amazon, it is much simpler, and Linux-Linux backup is very convenient.However, I want to run a backup every day or every week in my Windows 7 environment.The general idea is
Monitoring # tail-f/var/log/message to turn off the main service # killall-9 keepalived, you can see the backup service log output: mar 13 23:00:27 linux-backup Keepalived_vrrp: VRRP_Instance (VI_1) Transition to MASTER STATEMar 13 23:00:28 linux-backup Keepalived_vrrp: VRRP_Instance (VI_1) entering MASTER STATEMar 13 23:00:28 linux-
Article Title: Nginx + PHP + MySQL dual-host mutual backup and automatic switch solution. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source.
In production applications, a data server with the "Nginx + PHP + MySQL" interface plays a very important role. If the server hardwar
My rotten girl blog moved to godaddy's free Linux host a few days ago. Migration is smooth and easy to use. Some problems have also been found. There are several main types.
1. publishing an article cannot be switched to the visual editing mode.
2. Images cannot be uploaded in the background. I am now using external link images to solve this problem.
3. You cannot enter the document tag.
4. coshtmlcache cannot be used for static blogs.
5. You cannot u
Dual-machine Hot Standby is designed for server faults.Server faults may be caused by various causes, such as equipment faults, operating system faults, and software system faults. Generally, it may take 10 minutes, several hours, or even a few days for technicians to restore the server to a normal state. From the actual experience, it usually takes more than a few hours to restart the server unless the server is simply restarted. If the technicians are not on site, the service will be restored
The previous gitlab dual-host mutual backup environment (refer to the previous blog post) still has a problem: the backend database is a single server and there is a risk of spof. In the past few days, we have investigated relevant materials, mysql-proxy can be used to solve this problem.
Environment required:
Build a master-slave environment with two MySQL servers: Master-Master
Build mysql-proxy on one se
Since we started learning to build stations, whether we are using a free virtual host, or scraping the pay of the purchase of the host, and our larger projects need to turn to VPS or server storage; whether we are technical trained or old left, See netizens have their own site so enthusiastic also set up a play; whether our site is large or small, there is profit or no profit, we must learn basic self maint
Previously introduced a small MySQL backup php script program, but it is not for MySQL shell permissions of the virtual host users, here want to talk about more common backup and restore methods, suitable for their own host friends.
1, about Backup: We use MySQL in the gene
Mysql real-time synchronization-dual-host mutual standby (dual master) bitsCN.com
Mysql real-time synchronization-dual-host mutual backup (dual master)
Setting method:
Step 1
On server A (192.168.1.43), the user is backup, 123456, and the synchronized database is test;
The user on server B (192.168.1.23) is root, 123
.
Set script permissions and scheduled backups
We upload to the VPS host root directory, and then set permissions
The code is as follows
Copy Code
chmod +x/root/backup.sh
Open CRONTAB-E
The code is as follows
Copy Code
0 3 * * */root/backup.sh
Add the timed script above to perform a
I. Overview:
When listening to the course of yeslab QIN Ke's SecV3 SNF (ASA), the windows host will send a DNS request to the primary DNS and the standby DNS at the same time, so the building environment is ready for verification.
Ii. Basic test ideas and conclusions:
A. Basic Ideas:
① Configure primary DNS and backup DNS in the operating system
② When both the primary and
Backup and recovery are important technologies for data storage. This is only a single machine learning record operation.MongoDB supports backup and recovery. The backup format is bson and the backup format is JSON and CSV.
A) export bson formatIt is mainly used for backup a
MySQL regular backup Windows host bitsCN.com
For Windows hosts
====================
Hypothetical environment:
MySQL installation path: C: MySQL
Forum database name: bbs
MySQL root password 123456
Database backup destination: D: db_backup
Program code
@ Echo off
C: MySQLinmysqladmin-u root -- password = 123456 shutdown
C: MySQLinmysqldump -- opt-u root -- password
How to configure dual-machine hot backup for MySQL database 1. there is no incremental backup mechanism for mysql database. backup is a big problem when the data volume is too large. Fortunately, the mysql database provides a master-slave backup mechanism, which is to write all the data of the master database to the
Mysql real-time synchronization-Dual-host mutual standby (dual master) Setting Method: Step 1 sets the user on server A (192.168.1.43) as backup, 123456, And the synchronized database as test; B Service Server (192.168.1.23) the user is root, 123456, And the synchronized database is test. Step 2 configure mysql. ini: server A # Replication master server-id = 10 log-bin = "E: /MySQL/logs/mysql_binary_log "bi
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.