Back up database

**susannad** · 04-19-2008, 06:56 PM

I know we can (and should) back up our database/s
Could some kindly person direct me to the relevant spot in our plesk panel where I can export a db? I have looked around in there, but fail to see where I can do this

**MikeMann** · 04-19-2008, 11:27 PM

I believe this tutorial is still relevant:

http://www.hostnexus.com/support/tutorials/phpmyadmin/

Edit: Had to update the tutorial to bring it up to date for the version of Plesk and PhpMyAdmin.

Edit: Updated this to reflect the correct updated location for these tutorials.

**susannad** · 04-21-2008, 08:50 AM

ah .. great. Not too hard to follow. And now I'm

probably safe

**MikeMann** · 04-21-2008, 06:35 PM

Well when is anything I write hard to follow? Gotta make it easy so I can follow it you know

Pinsprings · 04-23-2008, 08:14 AM

Thanks for updating that, Mike!

Pinsprings · 04-23-2008, 08:42 AM

Has the database restoration tutorial been updated as well?

**MikeMann** · 04-23-2008, 04:08 PM

Quote:

Originally Posted by Pinsprings

Has the database restoration tutorial been updated as well?

Haven't done any other updating yet. That'll begin either tonight or tomorrow. I'll be updating old ones and adding new ones

Edit: Restore tutorial updated. Had to correct an error on the backup that would cause an error on restore. The "Add drop table" needed to be checked otherwise it would not restore if the tables were still there. The tables need to be dropped and created again to restore properly.

Edit: All phpmyadmin tutorials updated

mydog8it · 10-11-2008, 02:06 PM

Is this still the correct tutorial to follow for backing up? It seemed to work since my file has

Quote:

-- phpMyAdmin SQL Dump

on the first line, but I wanted to double check since this is a pretty old post.

**MikeMann** · 10-11-2008, 08:24 PM

Quote:

Originally Posted by mydog8it

Is this still the correct tutorial to follow for backing up? It seemed to work since my file has

on the first line, but I wanted to double check since this is a pretty old post.

Noticed I left a few unnecessary items near the top of the tutorial so they have now been removed. Otherwise, the tutorial is still current. Glad you were able to use it

**susannad** · 01-05-2009, 07:52 PM

Now ... another step (one giant step for me and a small step for the rest of you)

Oke Doke. I have backed up all my dbs regularly but now .. I want to put a databse that I have downloaded into another place.

Do I make a database in the new place and then upload? (well of course I do but..)

The database has a name, so I make a new database in the new place and call it by that name ?

Then I upload via webadmin, the db that I downloaded from elsewhere, into the new place?

Am I right so far?