Xenical prescription diet pill

Recently, I was asked to xenical prescription diet pill setup an automatic database backup process for some cloud sites.  Not having much experience with database backup, let alone setting up an xenical prescription diet pill automatic process.  I plowed ahead on the project.

I was directed to this link for the MS SQL Databases: http://cloudsites.rackspacecloud.com/index.php/How_can_I_create_a_cron_job_to_backup_my_MSSQL_database%3F

Following the above link was more than helpful.  Although, I still ran into an error after running through the directions.  “curl: (6) Couldn’t resolve host ‘backupdb.asp’ ”  My first mistake was, I was using the xenical prescription diet pill linux path instead of the windows unc path in the backup.asp file.  My second mistake was I didn’t enter a full url for the command to run in the cron job setup.  After fixing those simple mishaps, I now have xenical prescription diet pill an automatic backup running for my sites.

For MySQL Databases, I was directed to this site: http://cloudsites.rackspacecloud.com/index.php/How_do_I_create_a_cron_job_to_backup_my_MySQL_database%3F generic cialis rating

I can’t say that I’m at all familiar with shell scripting or xenical prescription diet pill that I even know what the code is really doing.  For the xenical prescription diet pill MySQL Database process I did wonder off the directed path and xenical prescription diet pill had found another backup tool, phpMyBackupPro (http://www.phpmybackuppro.net/).  This tool can xenical prescription diet pill be easily installed on your site and will create an xenical prescription diet pill automatic backup for you.  Using this tool for multiple sites isn’t what xenical prescription diet pill it was designed for, unless you want to install this tool on each site.  No thank you.

After that little adventure, I got back on my directed path.  The error I found this time was “No such file or directory”.  After reviewing the shell script multiple times, I couldn’t find anything wrong.  I did some searching and found this:

#!/bin/bash
Backupdir= *******.com/backups
backupfile=`date +backup-%d-%m-%y_%H.sql`
tarfile=mysqlbackup.tar
cd $backupdir
mysqldump –opt -A -h ******** –password=****** -u ******* > $backupfile
gunzip “$tarfile”.gz
tar rf $tarfile $backupfile &> /dev/null
gzip $tarfile
rm $backupfile

*replace the “*” with actual information

I plugged in the xenical prescription diet pill information for the script then continued setting up the cron job per the xenical prescription diet pill original directions in the above link.  The first time this script runs, you will get a “File Not Found”.  Run the script a second time and the error is gone.  I’m now getting automatic backups of my MySQL Databases.

Filed under: SQL Server,Tips   Tags: Database, MS SQL cheap cialis generic capsules, MySQL, Rackspace Cloud zoloft vs paxil, scripts,
 No Comments » buy cialis yahoo