MySQL database not working?

[nycitylove]

It seems that my MySQL database for my gallery doesn't seem to be correct. I've installed it onto another gallery for transferring, and it shows up very differently.

Original: http://taylorlautner.info/gallery

New: http://alist-production.com/taylorlautner.info/gallery

Someone told me that it could be the structure of the gallery is stored in the database itself? (Database issue)

[Joachim Müller]

Different look is caused by different themes, not by differences in the database.

[nycitylove]

No, I'm not talking about themes. The albums, and categories are in the incorrect locations. Files are also not showing up when I added all the files correctly in my FTP.

[formulx]

All I see are user galleries at the moment on the new website.

[nycitylove]

Exactly, it doesn't seem to have the same structure as the old gallery. Perhaps it is a problem in the database of the old gallery?

[Nibbler]

It looks like you have no categories, all your albums are in no category, and you have no pictures. Check in phpMyAdmin for anything that looks wrong. There should be 13 categories in the categories table, each album in the albums table should have a value for 'category' and your pictures table should be full of entries. Perhaps you didn't restore an SQL dump properly.

[nycitylove]

I compared both databases in phpMyAdmin and they are awfully different.

[Edit GauGau] Replaced hotlinked image with attachment origup9.jpg [/Edit] - Orig

[Edit GauGau] Replaced hotlinked image with attachment newnm6.jpg [/Edit] - New

[Nibbler]

You must be looking at the wrong thing. The screenshot shows no albums, yet there are albums at http://alist-production.com/taylorlautner.info/gallery

[nycitylove]

I apologize, here's the correct screen shot:

[Edit GauGau] Replaced hotlinked image with attachment [/Edit]

[Joachim Müller]

Don't hotlink! Hotlinks go down at some stage, rendering the entire thread useless. Attach your screenshots instead. I did this for you now.