My server (RedHat) crashed today requiring a new master drive be initialized and a full operating system reloaded on it. My old master is attached as a slave.

What is the best way to recover the ubbthreads 7 system from the old master? I do have an sql backup that is a few days old. A full sql dump is on my local PC. The ubbthreads control panel dump is on a second drive that was on my server and will be mounted as a third drive once it comes up. I'd rather recover it from the old master if possible to be up to date.

If this is more than a medium difficulty task, is there someone I can contract to do that for me?

It isn't very difficult. You could just move the files over and just run the upgrade script pointing to the existing database... or you could do a full install and import your DB backup in after the process completes. Either way is fairly easy to do (especially following Gizmo's post on installing/upgrading 7.5.6p2). The instructions in the member's area will explain what files need what permissions and Gizmo's post talks about how to import your database easily enough. I figured it out using those and I am about as dumb as anyone can be figuring out SQL and linux, and I had no issues doing it myself.




Dunny

When this happened on my server a while back I copied the data from the old /var/lib/mysql to the new /var/lib/mysql and then checked that the databases weren't corrupt; in my case, they where fine, and completely up to date. Then I just moved over my flat files for the site.

Thanks for the suggestion. I just got my server back online. As soon as I get some other things reloaded I'll give it a try.

I found the old ubbthreads on the old /var/lib/mysql drive and copied them all to the same location on the operational drive.

Is there another step I have to do to make them visible to SQL? When I use phpMyAdmin to look at my databases, the ubbthreads database does not show up.

Do I have to stop and restart sql?

Thanks.

You'll need to ensure the chmods (folder 700, 660 for files) and owners are correct (mysql:mysql) and you'll need to make sure that you restart mysql (and run a repair on the tables). Note that I hope you understand what you're doing going this route, you can cause quite the mess...

Thanks. Yes, I follow your instructions. I had looked at the old folders and files and changed the permissions/groups/owners on the new copy of the folders and files to match the old ones.

It will be a while before get to a point where I can start/stop mysql. Once I do and once I copy the flat files and repair the tables, I'll give it a try. If it doesn't work, I will reinstall ubbthreads and rebuild my databases from a backup that is just a couple of days old.

Thanks again.

I restarted mysql successfully and before I ran a repair I ran theubbthreads.php and got:



Does that error mean anything to you?

So I decided that I should run a mysql repair like you suggested. I started with just one table to try my syntax in mysql. I did

repair ubbt_ADDRESS_BOOK.frm; in mysql and got a table does not exist statement. I guess I'm not sure of the syntax of the repair statement. How do you tell mysql what database the table is in?

As a side note, after I restarted mysql, the ubbthreads does appear in the phpMyAdmin database list. I can open tables and browse them with no errors. What's the best way to run a repair?

I appreciate your suggestions.

I wouldn't run any mysql steps through the UBB; I'd instead do it through PHPMyAdmin or the MySQL command line.

As for your error, it tells you what the problem is:


It's unable to read the smarty files that SHOULD be in the libs/smarty folder.

I am doing the SQL repair commands through the mysql console command interface and phpMyAdmin.

I got rid of the prior errors. The owner and group needed to be changed. I did that on all the files and directories. Now I get

If it helps, I discovered that they restored a slightly higher version of Plesk on the server. This version renamed the admin userid for mysql. When I login to mysql I have to use a different userid than I used to use. Is that id stored somplace in the ubbthreads files that I need to change?

I want to repair the tables. But still get the errors listed in my prior posting. Can I find the sql error that is referred to in the error message stored someplace?

Thanks.