Backup Website Code、Database to Remote Server/Ftpserver Automatically

Part I backup plan and host info

A simple backup system plan

The main advantage of using FTP or NAS backup is a protection from data loss.

I am going to write about FTP backup solution here. The idea is as follows:

• Make full backup every day night
• Also we can backup only those files that has been modified since the full backup (incremental backup) as a seven-day backup cycle.

Our sample setup-this is a full backup demo

Local Server ===>>> Remote Server[ftp/nas server]

IP:192.168.1.10/192.168.1.11 ===>>> 192.168.1.12

Let us assume that your ftp details are as follows:

• FTP server IP: 192.168.1.12
• FTP Username: R_to+FTP-test
• FTP Password:Pass_$$$$
• FTP Directory: /bak (or /)

You will store data at remote server as follows:
=>> /bak/web/192.168.1.10/files mm-dd-yy - Full backup
=>> /bak/db/192.168.1.11/ files mm-dd-yy - Full backup

Local Server:Server A& Server B info

Server A :Website win2003 OS

ip:192.168.1.10

Website code path e:\website\longrujun.name

Server B :Database WIN2003+MSSQL2005

Ip:192.168.1.11

Database related info

E:\bak\Full

\Diff

\Logs

Remote Server:Server C info

Ftp server Account info win2003+Server-U

Ip:192.168.1.12

Username:R_to+FTP-test

Passwd:Pass_$$$$

Main Home Directory E:\bak

The detail architecture as the following describes

E:\bak\web:archive the ServerA’s website code

\db:archive the serverB’s database files

\logs:archive the web logs

Part II:Config

1、 backup website code to remote ftp server

A、Download the AutoRun.rar file on ServerA’s Disk F and extract

B、Open AutoRun folder and make 2 config files in run folder

web_to_remote.bat

======start====

rar a -m0 F:\Autorun\backup\10website%date:~2,2%%date:~5,2%%date:~8,2%.rar e:\website\longrujun.name

cd F:\Autorun\backup

F:

ftp -v -n -s:F:\Autorun\run\ftp10website.txt 192.168.1.12

del F:\Autorun\backup\*.rar /a /s /q /f

=======end=====

ftp10website.txt

=======start===

open 192.168.1.12

user R_to+FTP-test Pass_$$$$

cd web

cd 192.168.1.10

bin

prompt

mput *.rar

bye

========end====

Ok,now,pls add the web_to_remote.bat to scheduled task and run it a day

2、 backup database files to remote ftp server

the 2 steps as the upper ways

A、 Download the AutoRun.rar file on ServerA’s Disk F and extract

B、 Open AutoRun folder and make 2 config files in run folder

db_to_remote.bat

======start====

rar a -m0 F:\Autorun\backup\10website%date:~2,2%%date:~5,2%%date:~8,2%.rar E:\bak\Full

cd F:\Autorun\backup

F:

ftp -v -n -s:F:\Autorun\run\ftp11db.txt 192.168.1.12

del F:\Autorun\backup\*.rar /a /s /q /f

=======end=====

ftp11db.txt

=======start===

open 192.168.1.12

user R_to+FTP-test Pass_$$$$

cd db

cd 192.168.1.11

bin

prompt

mput *.rar

bye

========end====

The same as we should add the db_to_remote.bat to scheduled task and run it a day

Filed under: Windows, How to, Log, Backup, Ftp [Edit Tags]

收藏此页到365Key | 添加到Del.icio.us | Digg this