I fixed my gallery today after some help from a coworker and some troubleshooting. I’m going to list what I did here in case I need to do it again. But if you don’t care about details then just click on ‘My Gallery’ in the sidebar and enjoy.
- Created a Target MySQL Database and User on my BlueHost account.
- Reinstalled Gallery using the installtion utility in my existing Gallery Directory on the new server. It is important to note that I used the new user and databse name when reinstalling. Again at my BlueHost host.
- Check the permissions on the g2data directory and make sure to ‘chmod’ 775 and ‘chown’ recursively to a user that has rights to move the files.
- Tar them up.
- Using SCP copy the tarball to the BlueHost server.
- Un tar into the new g2data location
- Using MySQL Administrator Backed up the old Database from my previous host (K9)
- Went to BlueHost and made sure that MySQL connections were allowed from my current IP (Dynamic IP–need to check it all the time with Cable)
- Using MySQL Administrator, connected to the BlueHost MySQL instance and restored the DB to the new schema.
- Fire up the new gallery and login as admin
- Run all maintenance.
Bingo!