Struggling to back up the site database is quite troublesome, but also to go to FTP export, so ask
Who has done what program, you can export a Web site database data,, get compressed files, download
Share to: more
------Solution--------------------
What about win? Write a bat file yourself. To deal with it. Backup compressed copy files to FTP directory
------Solution--------------------
::.........................................................................................................................................................................................................................................................
:: Version: Backdatesystem V1.0
:: function: For system platform Backup program and data
:: Features: Generate file names by current date
:: Pathback, Pathsource, pathdatabase, filename, password, letter (next down)
:: (Uplink) Baklogpath, Bakdatabase, Bakdatatime, Baktimestart respectively (next)
:: (uplink) backup path, source path, database path, backup file prefix name, password (downstream)
:: (uplink) WinRAR installation drive letter, log path, database name, SQL automatic backup time, document time
:: Bak_ftpserver, Bak_ftpusername, Bak_ftpuserpass for FTP address, user and password
::.........................................................................................................................................................................................................................................................
Set Pathback=f:\websiteback\
Set Pathsource=e:\website\gjwebsite
:: Set pathdatabase=e:\project\website_aspnet\aspnet_test008\db_2005
Set Filename=andy_website_
Set Password=wuyi
Set Letter=d:
Set baklogpath=f:\websiteback\log\
Set baktimestart=%time:~0,2%%time:~3,2%%time:~6,2%%time:~9,2%
Set bakdate=%date:~0,4%%date:~5,2%%date:~8,2%
:: Set Bakdatabase=dg_gongjiao
:: Set bakdatatime=1126
:: FTP Related parameters
:: Set bak_ftpserver=200.0.0.0
:: Set Bak_ftpusername=test
:: Set bak_ftpuserpass=test123456
:: Del%pathback%%filename%*.rar
%letter%\progra~1\winrar\winrar.exe a-inul-p%password%%pathback%%filename%%bakdate%%baktimestart%%pathSource%
echo-compression complete, generate%filename%%bakdate%%baktimestart%.rar ... [%date%%time%] >%baklogpath%log_%bakdate%.txt
:: Echo--Start uploading ... [%date%%time%] >>%baklogpath%log_%bakdate%.txt
:: Echo Open%bak_ftpserver% >ftp.andy
:: Echo%bak_ftpusername%>>ftp.andy
:: Echo%bak_ftpuserpass%>>ftp.andy
:: Echo Bin >>ftp.andy
:: Whether to create a folder in days
:: Echo mkdir%bakdate% >>ftp.andy
:: Echo CD%bakdate% >>ftp.andy
:: Echo mput%pathback%%filename%*.rar >>ftp.andy
:: Echo Bye >>ftp.andy
:: Ftp-s:ftp.andy-i >>%baklogpath%log_%bakdate%.txt
:: Del ftp.andy/q
:: REM Xcopy%bak_tmpfile%*%pathback%%filename%/y
:: Del%pathback%%filename%*.rar/q/S
:: Rd%pathback%/Q
:: Echo--Upload complete [%date%%time%]-->>%baklogpath%log_%bakdate%.txt
Four or five years ago when you backed up net bat, reference!