[TriLUG] Migrating Gallery (was mysql question)

[Roy Vestal]

I want to ammend my previous email. I'm migrating a website that uses 
Gallery 2 and MySQL to a new server. I was not able to solve the problem 
below, so I archived the gallery and started a new one using gallery. I 
told it to use the existing tables. It was able to find the layout but 
the pics aren't showing up.

Anyone run into this with Gallery?

TIA


Roy Vestal wrote:
> I am migrating from an old webserver to a newone. I'm having issues with 
> migrating my data. My old db is mysql 4.1.20 to 5.0.41. I think I've 
> done a simple full db dump:
>
>     mysqldump > my_databases.sql
>
> Then on the new server I did a simple import:
>
>     mysql < my_databases.sql
>
> However, when I try to connect with the correct username and password, I 
> get told I don't have permission. Curious what did I miss?
>
> TIA,
> Roy
>