Database Issues when Upgrading - Pease Help!

[sammirah]

Ok so I had my live store running and set up the separate demo and test sites, and things seemed to be going well then I went to upload my database back up to the new file and all of a sudden the live site stopped working. What am I doing wrong?! Is it because the new database is a copy of the live site database? Should I rename the backup copy before uploading it to the blank database?!

[cvhainb]

You need to check your error logs.

[sammirah]

No longer have them. I uploaded the back-ups which did not work.

[mc12345678]

Couple of things. From what version are you upgrading?

How was the database backup loaded to the new database? Did you use something like mysql backup that does the restoration from your admin?

Is the DB_PREFIX between the two sites the same?
Are the database's referenced by the two filesets different?

When you say that the live site stopped working, can you elaborate? Error messages received? Maintenance mode? Blank screen?

Which backups were loaded? Database? Files?

To be able to understand what was done wrong need to have detail of what was done, but really just want to get these two locations back to where they were so that sales can continue while further development is done on the new files.

[sammirah]

I am attempting to upgrade from 1.5.5f to 1.5.6, to up load the db back up I have to import it into the new db via phpmyadmin. The prefix for both sites were the same. The live site went blank although, I was not working on it at all. I don't have a picture of how the site looked before, but this is how it looks now without all of the sideboxes and enhancements: http://atmospherebooks.com I used Filezilla to upload the back up files, after I reloaded all of the files I used the restore feature of my cpanel to upload the db download, but it still did not work so I deleted it and tried again.

[dbltoe]

You have managed to get a glitch in the code that creates the Useful Links option in the Information Menu.

All is rocking along until the browser tries to draw that UL. The code MIGHT be in the database. Not familiar with that menu system.