[TriLUG] Migrating Gallery (was mysql question)

[David McDowell]

I also had the same problem trying to migrate Gallery2.  Only in my
last server change, from physical to virtual did it work exactly as it
should have.  The reason, Gallery2 and mysql-server were *exactly* the
same versions on both physical and virtual machines.  I'm glad the
distro I'm using has a LONG life before I need to change it.  From the
first failure, I still haven't finished re-uploading all my photos
into Gallery2.  :(  It's been so long since I went down this road, by
the time I decide to do anything with a new version, maybe I'll have
given in to iPhoto... LOL!  :)

David


On 8/19/07, Allen Freeman <knieveltech at yahoo.com> wrote:
> I ran into exactly the same problem when I tried migrating a gallery2 site between harddrives, unfortunately I wasn't able to come up with a resolution in a timely manner. I assume part of the problem revolves around copying the picture directories that gallery2 creates when it does photo processing/archiving, however that's just a hunch on my part. Sorry I don't have any hard information to offer.
>
> -Allen Freeman
>
> Roy Vestal <rvestal at trilug.org> wrote: 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
> >
>
> --
> TriLUG mailing list        : http://www.trilug.org/mailman/listinfo/trilug
> TriLUG Organizational FAQ  : http://trilug.org/faq/
> TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
>
>
>
> ---------------------------------
> Got a little couch potato?
> Check out fun summer activities for kids.
> --
> TriLUG mailing list        : http://www.trilug.org/mailman/listinfo/trilug
> TriLUG Organizational FAQ  : http://trilug.org/faq/
> TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
>