MySQL DB Backup

**harner** · 09-29-2006

I'm not sure what database administration tool is on one of our servers that went down, but I have to back up the MySQL server since it went down. I can SSH to it, and I'm transferring files to my workstation right now. However, I get errors that say some files cannot be found for whatever reason.

The server was a POS, and hosted Nagios and a bunch of other cool stuff. So, how would I go about backuping up the databases? Can I do it manually or should I risk throwing something like phpMyAdmin on the webserver and pray for the best?

**muha** · 09-29-2006

Bit stupid to do it like this but ...
login with ssh

Code:

mysqldump -u <username> -p <databasename> > <outputfile>

It will ask for your password. You can also specify that behind -p
Export a database from mysql to a local file (on that server).
Logout ssh.

Then copy it to your local location:

Code:

scp username@ssh.domain.com:./tmp/file.gz .

Transferring a file from a remote machine to a local machine.

Be sure to delete the remote copy, so it's not open to the internet afterwards

**mitto** · 10-03-2006

Please check the below mentioned related URLs for it

http://forums.linuxwebadmin.info/ind...opic,28.0.html

http://forums.linuxwebadmin.info/ind...opic,70.0.html

http://forums.linuxwebadmin.info/ind...opic,24.0.html

Thanks,

**harner** · 10-03-2006

Thanks, guys.

**muha** · 10-04-2006

@mitto: nice forum!
In short it comes down to:

mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]

I forgot about the username-part before .... corrected it.

**harner** · 10-04-2006

I was prompted for the username/password anyway. That looks easier for the next time, though!

**mitto** · 10-18-2006

Thanks muha

**ram_88** · 12-08-2006

Hi! I have the same problem. When i'm googled the net i found this:www.phpmybackuppro.net.
Try it!

**muha** · 12-11-2006

Hi ram_88, thanks for the link but always try to add some info when you post links. I thought you were a spambot

Also, if we all only post links, the forum would become nothing more than links instead of useful information.

**weknowtheworld** · 12-15-2006

gr8 info but I think sometimes it's imp. to give urls for getting more information..

Thread Tools

Display

MySQL DB Backup

Posting Permissions