Tags: Windows Server server database virtual machineBackup and restore of Windows Server 2012R2 databasesExperimental Simulation : Beijing has a uec.com main server, need to create an additional domain controller in Shanghai, but Shanghai and Beijing network latency is large, normal replication is unsuccessful. Ideas: Create an ad database media file in Beijing, store the data in the AD database, copy the
Description1, to back up the file in the D-packing directory, named after the time (generally we through the security of God's good backup software to achieve backup) for exampleD:\data_db_201112130001.BAKD:\data_db_201112140002.BAKD:\data_db_201112150003.BAKA new file is automatically generated every day, such as December 16, 2011, which automatically generates Data_db_201112160004.bak2, to the d:\ of the
, restore the MVC databaseThe command executed is mysql-u root-p MVC Backup, the syntax is as follows:Backing up multiple tables in a databaseMysqldump-u root-p dbname table1 table2 ... > Bakname.sqlBackup multiple databases with--DATABASES option, followed by multiple databasesMysqldump-u root-p--databases dbname1 dbname2 ... > Bakname.sqlBack up all databasesMysqldump-u root-p-all-databases > Bakname.sqlexample, only one database MVC is backed up,
MySQL, and stop the two node database separately.
1.3 Configure Data synchronization options
1.3.1 A host operation
When a version of Ikey Server Windows is installed, a MY_MASTER.CNF profile is generated under the Ikey\mysql\backup folder under the installation directory, and the my_master.cnf files are copied to the installation directory under the host a. Ikey \mysql\bin folder, rename to My.cnf, befor
MySQL supports command line import Export data file, format is *.sql
1) Import:
Mysql-u User name-p password database name
2) Export:
Mysqldump-u User name-p password Database name > file path \ filename
3) Real case
I am on the Windows 2003 Development Server, the implementation of a timed automatic backup
Generic filename, used by date and time. sql. Here's my *.bat batch file
A total of 3 lines:
Windows 7x64 sp1 Simics 3.0.31 install solaris-10-sparc Note 0. Copy the sol-10-u2-ga-sparc-v (1, 2, 3, 4, 5). iso to the workspace directory. Do not use sol-10-u10-ga2-sparc-dvd.iso, This is not fully installed on 1. modify the configuration parameters (peanut-sol10-cd-install1.simics) $ disk_size = 17027891200 # modify, hard disk size, it is best to give larger, after all, you have to do some of your own work, 8 GB hard disk is not enough $ memory_m
Creating images is more flexible than ghost
Creating a system image in Win 7 has become very handy, and you can open the Create System mirroring window by simply "All programs → maintenance → backup and restore" in the Start menu, where you see "Create a System image" on the left. and the entire creation process, the user needs to do is based on the prompts to choose, and "next", it is not exaggerated to say, as long as the understanding of Chinese,
synchronizing the files:
After that, we can go to the client F disk corresponding to the current view of the synchronization over the file, hehe.
Of course Cwrsync is the incremental and modified synchronization, if you modify the corresponding files on the server side, the synchronization will only synchronize the modified files or new files.
Here's how to create a timed task by using Task Scheduler in Windows to perform a timed synchronization.
Tags: backup batch for MySQL under WindowsREM *******************************code start*****************************@echo offSet "ymd=%date:~,4%%date:~5,2%%date:~8,2%"MD D:\xl\%Ymd%D:\xampp\mysql\bin\mysqldump.exe-u yunwei-p123456-h 192.168.10.176 Zentao--default-character-set=utf8--opt-q-R- -skip-lock-tables > D:\xl\%Ymd%\zentao_%Ymd%.sql@echo onREM *******************************code end*******************************This article is from the "System
Label:Creating a BAT file You need to put 7z.dll and 7z.exe in the bat's sibling directory and Mysqldump.exe these 3 files Echo off
CLS
CD/D%~dp0REM===========configure (start) ==============
Sethost=127.0.0.1
SetUser=AdminSetpass=Configure your MySQL passwordSetDbname=the name of the database to be backed upREM===========configure (end) ==============REMSet-date-and-time-toymd-and-his
Set"ymd=%date:~,4%%date:~5,2%%date:~8,2%"Seth=% Time: ~0,2%
SetH=%h: =0%
Set"his=%h%%time:~3,2%%time:~6,2%"Echo
First, backup1, according to the user name, IP, database name to make corresponding changes, need to note is, do not need to login to MySQL, in the cmd command line execution, take my machine as an example,--cannot log on to MySQL client-- MySQL Export data - - export moy_test database data in Bak.sql file with path D --> d:/bak.sql- ----- bak.sql file of D drive is imported into Moy_test database - - D:/Bak.sqlSecond, the right to assign users-Need to log in to MySQL client-- new MySQL user, u
MySQL import garbled, usually encountered in the command line. The following is the case of the command line that solves the garbled problem:Method One: Solve garbled problem by adding parameter –default-character-set = UTF8Mysql-uroot-p Linuxsight --default-character-set=utf8 #只要保证数据库的库表字符集正确, Just use this parameter to log in.Method Two:1.mysql>use xz;2.mysql> Set Names Utf8;3.mysql>source Example.sqlMethod Three:Mysql-u root-p--default-character-set=utf8use Dbnamesource/root/newsdata.sql
oracle|window| Backup | data | Database FIRST step:
In the D-Packing directory to create a new folder backup, this directory can be arbitrary, copy exp.exe files to this directory, the directory under the new file Expbkup.bat
Exp test/test@test file=d:\backup\%date:~0,10%.dmp log=d:\backup\%date:~0,10%.log compress=n b
1. In the computer we click on the lower left corner of the "Start"-"Control Panel" button, as shown in the following figure;
2. Then click on "System and security" in the Control Panel dialog box as shown in the picture;
3. Our system and security will see a "Backup and restore";
4. Into the backup restore we click "Set up Backup" as shown in the follow
System Self Backup
1. Create a restore point
We go back to the desktop and then right-click on "Properties" in the pop-up menu and then see a "System protection" option in the Open Properties dialog box;
Now we switch to system protection and then in the pop-up window we click on "System Protection"
Because we are backup system, so we select the Local system disk C, and then put this prot
1: Our company to do a "daily statistics offline film" application, I first put this function into a WinForm program to generate an EXE file
2: "Start-> program-> attachment-> System Tool" find it, open the Scheduled Tasks window
3: Double-click the Add Scheduled Tasks item to start the Scheduled Task wizard
4: Select the application to execute, here we choose to have the "statistics every day offline movie" function exe file
5: Enter the task name, you can use the default name or take a
echo Off setlocal enableextensions::----------Configuration Items----------:: Backup placement path, plusSet Backup_path=d:\backup:: Database name to back up, multiple spaces separatedSet databases=1688 ABC Ceshi:: MySQL User NameSet Username=root:: MySQL PasswordSet Password=root:: MySQL Bin directory, plus:: If you can use dump directly (add the MySQL Bin directory to the environment variable at installa
One, mysqldump+bat processing files in MySQL
Script to perform MySQL database backup (BAT file contents)
The code is as follows
Copy Code
@echo offSet Host=localhostSet Username=rootSet Passward=ansureSet Database=weiheSet Backup_path=d:\db_backup\echo "Mysql Backup, please waitting"mysqldump-h%host%-u%username%-p%passward%--skip-lock-tables%database% >%backup_path%\%database%_
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.