i need a bat script to backup a MYSQL database to a remote FTP server, the local server is window server 2008, and local MYSQL is within the XAMPP environment, the MYSQL dump file need to be named as "file-year-month-day",
No actual FTP server and local mysql database name will be provided, so Please write all variables at beginning of the script for later modification.
this script needs to be as a working alone script, preferably it does not require external application to be installed to make this script work.
cheers and happy coding
forgot to mention, we are a IT consultation firm, we normally sub-contract out the simple coding Macro- project, by our team estimation, this project should take no longer than one hour for experienced programmer, so total fixed price of USD 15 or less is rewarded for this project
basic format of the coding, variable define, obtain date information from system, mysql database dump and file save based on date information, ftp upload to remote server.
long term contract is available based on the performance and service level of the micro project