Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
9 registered (mcasado, Mike L, Gizmo, SD, Bjab, driv, SteveS, nims2, Ruben), 23 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 04/22/10
Posts: 5
Top Posters (30 Days)
Ruben 63
SD 54
Gizmo 48
gliderdad 33
Dunny 21
driv 18
Iann128 16
dbremer 16
Stan 15
Mark S 13
Latest Photos
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Gizzo Marx
Topic Options
#237515 - 06/17/10 01:03 PM Data Base backup and re-installing
capnbob Offline
stranger
Registered: 03/06/10
Posts: 5
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 Online   cat

Registered: 06/05/06
Posts: 14904
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: 5
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 Online   cat

Registered: 06/05/06
Posts: 14904
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 Online   hyper

Registered: 12/20/03
Posts: 4268
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 Online   content

enthusiast
Registered: 03/22/07
Posts: 392
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 Online   hyper

Registered: 12/20/03
Posts: 4268
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: 1438
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
Edit Post
by Bert
Today at 01:19 PM
A positive note
by SteveS
Yesterday at 09:36 PM
How to locate links to particular site if they are only used in images?
by Conrad
02/10/12 09:41 PM
Pictures not displaying
by Marker23
02/09/12 10:04 PM
Issue with logging out constantly
by Flanuva
02/09/12 07:05 PM
Forum Stats
10213 Members
36 Forums
33667 Topics
180917 Posts

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