UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support Data Base backup and re-installing

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

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.

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

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.

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.

What is the advantage to using the ubb backup over other backups?

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 .

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.

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.