PDA

View Full Version : MYSQL Backup



Anonymous
09-07-2003, 12:50 PM
I've been keeping up on the forums and apparently a lot of people have been having a lot of trouble with their SQL databases being destroyed, lost or otherwise not ported over. I was wondering how one goes about backing up their MYSQL database. My database is very critical to my site, but I've never had an issue where I've had to back it up before, any help would be appreciated...

Raven - http://www.ravensrants.com

wildjokerdesign
09-07-2003, 12:56 PM
Raven, check this post here. It has details how to get your old database

http://forums.westhost.com/phpBB2/viewtopic.php?p=2897

Anonymous
09-07-2003, 01:26 PM
Thanks for the help, I searched the forums but came up empty, probably because I looked for SQl and not just database.

Anyway, I tried the instructions in the topic and I keep getting that "Mysqldump" is not a valid command. Any ideas?

Raven - http://www.ravensrants.com

ccwebb
09-07-2003, 01:33 PM
Can't you ftp to your site - locate your file - and download it to your computer?

In my ftp program I just have to drag a file to a folder(directory) on my computer.

Charlie

ajparker
09-07-2003, 01:43 PM
The system is case sensitive - it would need to be mysqldump (all lower case.)

In fact just typing mysqldump at the $ prompt should give you a list of options and usage...

Avery

Anonymous
09-07-2003, 10:11 PM
Thanks everyone for the help... I was typing the command in lower case (beautiful thing about heing a Linux user, no need to DL a special program for SSH) it just for some reason wasn't taking.

Now I know though.

Apparently, while I was trying to backup the database, Westhost was in the process of converting me. For a while, I didn't know which server I was logging into, much less which one had my databse.

The good news is that the database made it over ok. I was a bit surprised by that. i lost a few of my most recent blog entries and some other test data was lost, I've also spent the past few hours hammering out some email and sendmail issues, but other than that I seem to be golden.

Thank you again for your help! It's nice to know such a strong community is here!

ajparker
09-07-2003, 10:14 PM
Thanks, glad things worked out mostly well for you :) I suspect with my second database they would have got to it if I'd waited long enough - they seem to be overloaded though - so, since I can and hadn't been told not to.....


Avery