ok, I got this from 1and1 and have no confidence in them. I want to be sure my site is backed up (I will be using bq and whoever the new host is to back it up also) I have done these commands and it "backs up" and then I FTP the backup to my computer but I want to be sure there is actually information in that backup. Does this sound legit?
at command, type
mysqldump --opt -Q -h localhost -databaseusername -p databasename >sitename.backup.sql
it goes to next line and is done
then FTP to my computer and I have a backup.
So first, does it sound legit? Second, what do I DO with it should my site go down. Do I just FTP it back to the server?
That is a database backup only. No files are being touched during that process. What you have is an sql dump that can be imported fairly easily should the database need to be restored. Simply ftp this to the server and import the data. You will need to have recreated the database and user/permissions first as this is only data.
well, I am using 1&1s cp. I think it is their own creation. I will be moving to a server using Plesk most likely. I did the previous commands using putty. I was hoping I could use that to backup the whole server (only 6.5GB) and then ftp it to my computer
It is a little more complicated to setup but, once it is initialized, will run incrementally with fairly low bandwidth usage and overhead. If you do end up moving to a plesk solution dirvish may or may not be the best choice based on the way plesk handles databases. I hope this helps.
Thank you, I will look into dirvish once I get the bqbackup all set up and figure out what is going funk with my sqldump
I logged onto putty and entered
mysqldump --opt -Q -h localhost -u dbusername -p dbname >domainname.backup011007.sql
it went seemed to "take" and asked for my password. I entered it, pressed enter and... nothing. The cursor just sat there blinking. Eventually, and I mean 5 minutes plus later it went back to the prompt.
I went to FTP to my server and I don't see it there. Any idea what is going on?
NEVERMIND... found the file. It was named domainname.backup011007 but I thought it would be simply backup011007. My bad!
thank you! So you said it only copied the files (posts and such) I opened one of these earlier backups I did and I could see what appeared to be posts.. all jumbled together with other stuff.
If I had to rebuild from this backup, are you saying I would just have to reinstall the vbulletin software and all my settings/changes to it (wow, big job there) but that I could somehow then import the above backup (with the post data) back into the site so the posts would "insert themselves" where they should be? Would that also mean I would need to have the exact same forums in the exact same location for them to "insert" properly. Sorry for all the questions. I just want to be really, really sure I'm covered.
Use this from the command line to restore a backup really easily without having to upload anything...
mysql -uDBUSER -hDBHOST -pDBPASS DBNAME < "domainname.backup011007.sql"
Self explanitory, replace the crap in the bold... My spacing is correct BTW, no space between the -p, the -h and the -u and their respective info. I had troubles when I had a space, it might work for you...