Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (57-Vette), 51 Guests and 13 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 04/09/11
Posts: 140
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 23
Dunny 15
SteveS 13
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#237515 - 06/17/10 01:03 PM Data Base backup and re-installing
capnbob Offline
stranger
Registered: 03/06/10
Posts: 14
Loc: MA
I am still trying to understand the MASTER DATABASE. The directory that is in my website Backup Storage Directory Field is as follows: /home/08/39/2913908/web/forum'. This tests OK and I am confused as to numbers in this directory label. I assume the /home/08/39/2913908/ refers to a number assigned to our TARPA.com website on your server. Now when I go to the Tarpa.com/web/forum directory, I find a list of sql files which I believe are the files created when backing up our database. If this is so then I understand where those backup files are located and they are a series of individual tables and NOT just one large database file. Assuming the location of our backup database files are in the .../web/forum directory, then how do I restore these to the database directory? Is it possible to backup up my database to my own computer by typing that path into the Backup Storage Directory Field?

Here is the content of my "Forum Includes File"



'FULL_URL' => 'http://www.tarpa.com/forum',
'BASE_URL' => '/forum',
'FULL_PATH' => '/home/08/39/2913908/web/forum',
'SESSION_PATH' => '/home/08/39/2913908/web/forum/sessions',
'REFERERS' => 'http://www.tarpa.com',
'ATTACHMENTS_PATH' => '/home/08/39/2913908/web/forum/uploads',
'ATTACHMENTS_URL' => 'http://www.tarpa.com/forum/uploads',
'MULTI_URL' => '',

[/color]

I am having difficulty seeing the process here.

Thanks to anyone who can help a simple mind.

Bob
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#237516 - 06/17/10 01:32 PM Re: Data Base backup and re-installing [Re: capnbob]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
Well, it's just how the backup system works that's built into the ubb, many small files vs one huge.

As for the random numbers in your paths, those are assigned by your server when your site was setup.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#237521 - 06/17/10 03:31 PM Re: Data Base backup and re-installing [Re: Gizmo]
capnbob Offline
stranger
Registered: 03/06/10
Posts: 14
Loc: MA
Thanks Gizmo,

Now I need an answer to the last question...how do I re-install the backup files into the system? Where would these files go?

I published the backup files from the website back to my computer's website, so I do have a copy in my computer.

Thanks
Bob
Top
#237522 - 06/17/10 03:40 PM Re: Data Base backup and re-installing [Re: capnbob]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
I'm pretty sure you'd use a tool such as phpmyadmin to import the backup to the live database as I don't think there is a "restore" option in the ubb's backup utility.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#237524 - 06/17/10 03:50 PM Re: Data Base backup and re-installing [Re: Gizmo]
Ruben Offline

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
The only problem with the built in backup is just that, the restore.
There is not a restore utility.
So you would need to use some tool like phpmyadmin and that means restoring one table at a time. Which is slow.

I use the built in back up in addition to others. just for a backup to the backup. But restoring from the ubb backup for me would be the last resort option.
_________________________
Blue Man Group
Top
#237525 - 06/17/10 04:07 PM Re: Data Base backup and re-installing [Re: Ruben]
SteveS Offline

addict
Registered: 03/22/07
Posts: 416
Loc: Massachusetts
What is the advantage to using the ubb backup over other backups?
_________________________
Steve
crownvic.net
UBB.classic from 2000-2003
UBB.threads from 2003-present!
Top
#237526 - 06/17/10 04:20 PM Re: Data Base backup and re-installing [Re: SteveS]
Ruben Offline

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
Really none.
It is a utility that is there in the control panel.
Like I stated.
The restore is the big item which is not present in ubb.
When you consider you have what 64 tables probably will be more in version 8. And you would need to restore each table one at a time because ubb backs up one table at a time each in a separate file.
Where other tools allow you to backup the whole database and restore in one step.

I personally use phpmyadmin for backups in addition to using a backup utility in cpanel as well as the built in backup in ubb.

Alternating all three just so I have a redundant backup .
_________________________
Blue Man Group
Top
#237527 - 06/17/10 04:22 PM Re: Data Base backup and re-installing [Re: Ruben]
Chosen Offline
member
Registered: 01/26/05
Posts: 194
Loc: Cincinnati, OH
I think the only advantage is that it is there without having to go anywhere else. With access to phpmyadmin or the command line I've never used the ubb backup. I know that I can run SQL commands in there, but I still generally go into phpmyadmin so that I can look at the data afterward to make sure. It is just there as an option for people that need quick access I think.
Top
#237528 - 06/17/10 04:34 PM Re: Data Base backup and re-installing [Re: Chosen]
gliderdad Offline
Registered: 06/08/06
Posts: 1466
Loc: NY
I thinks its there for comfort as well as stated above, one place to go. Many dont feel comfortable doing things in phpmyadmmin as you can do more damage in there. I do a lot in phpmyadmin, but wana get more comfortable doing the same things via command line.
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image