Everyone is discussing cloud based server, database, apps, and servers nowadays, but is the so-called cloud server really fully support for the cloud system available from the market?
As announcement from Salesforce.com Database.com, the enterprise database built for cloud based on 7 December 2010, enterprise database is now working standalone from cloud system.
To get more information with the cloud-based databases with legacy apps, refer to Software Advice blog below.
Database is the most important file other than web file, hence the backup is very important for the web developer and web owner.
By referring to the current post, you may backup your database automatically from your Linux box.
# Specify the temporary backup directory
# Database Name
# store the current date
# Specify Ftp details
# Dump the mysql database with the current date and compress it.
/usr/bin/mysqldump -u$dbuser -p$dbpasswd $dbname | gzip > $BKUPDIR/$date.$dbname.sql.gz
# Change directory to the backup directory
# Upload the backup
ftp -n $ftpserver <<!EOF!
user $ftpuser $ftppass
# Remove the local backup file
/bin/rm -f /$BKUPDIR/$date.$dbname.sql.gz
With the above script, you may save it as file.sh and just schedule a cronjob to run it as your needed time.