Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
  #1  
Old 26 Mar 2008, 02:56
TheMayhem's Avatar
TheMayhem TheMayhem is offline
 
Join Date: Oct 2002
Real name: Brad
Server Upgrade Gone Bad

So I've just learned the harsh realities of how a simple server upgrade can go so badly that its not even funny. Long story short, my server had to be completely restored, which left me in a wonderful predicament where I had no backup and thousands of angry users wondering what happened to their site.

So the line below should be familiar to anyone who has done mysql dump's before
mysqldump --opt -u nqforum_dab -p nqforum_user > /home/nqforum/current.sql

This is my normal line I'd use for a mysqldump. I changed the actual names of the user and database for privacy, but still you get what I'm saying. So my question if its even possible if I have my old hard drive mounted to my new one. The directory would be let's say

/mnt/olddrive/

And I have all the files I'd ever need in there. What kind of SSH command can I do to retrieve that mysql database that I'm searching for just so I can back it up somewhere on the server, download it, upload it, and then run the mysql ssh command to restore it. The big problem I'm having right now is when running any kind of mysql command, the mysql I have right now is reading from my new server not the slave hard drive I'm having. Any help would be appreciated.
__________________
Currently in Production:
vB 4: Point Market System Version 3.1.2 (A Point Donate/Store System)
Point Market Support: Support Trouble Ticket System
Reply With Quote
Comments
  #2  
Old 26 Mar 2008, 09:50
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
whats the old drive mounted as, whats mount say?
Reply With Quote
  #3  
Old 26 Mar 2008, 16:10
alphadeity alphadeity is offline
 
Join Date: Mar 2008
Try this line


mysqldump --opt -Q -u dbusername -p databasename > /path/to/backupname.sql
Reply With Quote
  #4  
Old 26 Mar 2008, 16:58
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
To locate the backup file on the old drive (think this i the question inside your long story) you can use the following command (assuming you are on Linux):

find /mnt/olddrive/ -name current.sql
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 00:25.

Layout Options | Width: Wide Color: