UBB.threads PHP Forum Software Community Forums UBB.threads 7 Installation and Upgrade Support Lost everything on upgrade

I have no idea where to even post this but I have lost all my custom fields information and pretty much all my settings for my board. I'm actually glad I had done this on a test server or I would have totally lost my entire community.

I don't even know where to begin or what to say.

What steps did you do when preforming this upgrade?

Exactly as the Upgrading your UBB.threads™ 7.0+ blah blah blah stated to the letter.

The bad part is I can't even restore what I had backed up as the one file is to large to put back in using PHPMyAdmin as some PHP setting is not large enough type deal.

Did you happen to overwrite your includes/config.inc.php file during the upgrade?

No.

here is the error I'm getting in PHPMyAdmin: "No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16."

I need to know what file to change and to what to restore my old database. I think it may be /etc/php.ini

I have changed the php.ini settings and still unable to import the file.

I did a command line in mysql through telnet and got all the files in there, I just can not post on the board. It acts like it is posting but nothing new is showing.

Anyone have any ideas?

looks like I will have to use the source command in the database to pull the entire sql files back in to do it properly. Oh well, Live and Learn, LOL.

"LOL" is a good attitude... I'm not doing my update for another 12 hours or so, so we'll see if I'll be LOL'ing or @$%*#%'ing myself

you can try this: http://www.ozerov.de/bigdump.php

Yes tried big dump, it did not work for some reason. I'm manually restoring the mysql database using the source and pulling off a preloaded location on the hdd from the message board backups of the mysql database.

I think in the future I will just use Gizmo's routine to backup the database that way it will be one dump and done and easier.

Once I get it all working again I can take another stab at upgrading, lol. I had to have uploaded a wrong file at some point or other or something.

I am really busy today at the office but will get right on this later today sometime and will keep you all posted on if it all works or not. Wish me luck, lol.

Well, I re-uploaded everything and checked it all out, I can nor write to the database and all that. This brings up a real problem as if i was to even move to a newer server and such I will have to start totally from scratch or something.

How would I get a site to work again under these problems? nay Ideas?

I'm seriously looking at not upgrading now as I have a very active site and do not wish to loose everything without the possibility of every being able to recover it on the live site.

It's really hard to say what's going on. At what point during the upgrade did things go haywire? Do you recall what step you were on, and what, if any, error message you received?

Went straight through and when I went into the board it was all messed up and nothing was right. When I went into the CP it looked like it was trying to run 7.22 and 7.3 at the same time.

I think I will totally re-install 7.2.2 from scratch then get everything working then put the old database back in and see what happens from there. Other then that I am at a total loss.

Back in classic if you had to totally restore from scratch or move from one machine to another you could rebuild the database and all and it would fix it self, not with threads.

The first threads ver I have ever run was 7.2.2 and changing from classic to threads was not bad at all and had very little problems. Upgrading threads just blew me away, unfortunately we get hundreds of post's a day and have gained about 150 new members since then. It would be devastating to loose everything and have to go back to classic or loose my current database. Would not be a good thing.

Dumb question; you did run the upgrade script?

Yes. I have no clue what happened though Gizmo.

I just finished totally restoring the test site and going to try it again most likely tomorrow.

Kind of funny though, I learned allot about restoring one of these babies, LOL.

Ok, I tried it again today and it worked this time. Fixed the sub forum blank bug but my Who's Online is not working for some reason.

The no input file specified error is because php.ini has a default setting of 8M post max. Your sql file is clearly larger than 8 megs.

post_max_size = 8M

Also check upload_max_filesize but that shouldn't be your issue here.

Hi Dave. I entered all the .sql files by command line in telnet and it put them in perfectly. Yes the default is 8M and I had changed it to 100M.

I have learned tons by putting this on from scratch and the knowledge out weighs the inconvenience, LOL.

Looking to do the upgrade on my public side this week end. I will make a total and complete backup before hand for sure, It it can go wrong I will find a way, hehehehe.