Back up database - Page 2

**MikeMann** · 01-05-2009, 10:37 PM

Quote:

Originally Posted by susannad

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?

I believe the database can be called whatever you desire (as long as it's name is not already used by someone else on the server). Then simply follow the restore directions under the database backup and restore tutorial. You're getting it pretty good there Susanna

**NexDog** · 01-06-2009, 12:29 AM

Yep, database name is merely configured in the applications config file.

**susannad** · 01-06-2009, 02:39 AM

I'm not actually restoring per se

I'm moving a database from one place to another
I'm moving a site, you see

So I am on the right tram then?

**NexDog** · 01-06-2009, 03:55 AM

Yea, pretty much. If you have to use a different database name or user just put that in the script's config file.

**MikeMann** · 01-06-2009, 04:29 PM

Quote:

Originally Posted by susannad

I'm not actually restoring per se

I'm moving a database from one place to another
I'm moving a site, you see

So I am on the right tram then?

You're still "restoring" whether it's from a backup of an existing database or moving from one place to another

**susannad** · 03-04-2009, 06:24 PM

I put this (a bump) back up near the top so I can access it myself personally

I was going backwards and forwards finding this thread as I forgot how I did this back-up last time. And now I'm moving a couple of sites again

**MikeMann** · 03-05-2009, 12:26 PM

Quote:

Originally Posted by susannad

I put this (a bump) back up near the top so I can access it myself personally

I was going backwards and forwards finding this thread as I forgot how I did this back-up last time. And now I'm moving a couple of sites again

I stuck it for you and others as its probably something most will need

**susannad** · 03-05-2009, 03:32 PM

I never thought of sticking it - thanks

I will have to read it again today, I ran into trouble on a restore last night

**susannad** · 03-05-2009, 09:38 PM

Lucky this is sticky I'm back reading it again!!! Been 1 and 1/2 days on one recalcitrant databse

**NexDog** · 03-05-2009, 10:03 PM

I backup the forum and ticket databases daily using a simple cron. I then have another cron that tars up the directory that they get dumped into. And then I schedule FTP to upload it to a remote storage location with other files. All files are backed up to 3 locations actually.