It is quite troublesome to back up the website database, but you still need to export it through ftp.

It is quite troublesome to back up the website database and to export data through ftp, so I would like to ask who has done what program, who can export the data of the database of a website with one click, convert it into a compressed file, and download it.

Reply to discussion (solution)

Win? Write a bat file by yourself to process. back up and compress the copied file to the FTP directory.

How to write ???

:: ........................................................................................................................ ........................................................................................................................ .........
: Version: BACKDATESYSTEM V1.0
: Function: used to back up programs and data on the system platform
: Feature: generate a file name based on the current date
: Pathback, pathSource, pathdatabase, filename, password, and letter (next line)
: (Connected line) baklogPath, bakdatabase, bakdatatime, baktimeStart are (next line)
: Backup Path, source path, database path, backup file prefix name, and password (next line)
: (Connected) WinRAR installation drive letter, log path, database name, SQL automatic backup time, document time
: Bak_ftpServer, bak_ftpUserName, and bak_ftpUserPass are FTP addresses, users, and passwords.
:: ........................................................................................................................ ........................................................................................................................ .........
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 -- compress and generate %filename=%bakdate%%baktimestart%.rar ...... [% Date % time %]> baibaklogpath‑log_?bakdate=.txt

: Echo -- Start Upload ...... [% 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 folders 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 -- uploaded [% date % time %] --> % baklogpath1_log_1_bakdate1_.txt


Back up the bat at net before January 1, year 45. for details, refer!

So profound .. Can it be too simple...

I have never done it. isn't ftp a built-in download? Why?