in reply to Re^2: Speed of MySQL DBs
in thread Speed of MySQL DBs

That may be. But I had been given to understand that restoring such data to a new installation of pg would create issues related to the oid's. Consequently I have stuck to the dump and restore methods, which recreate the oid's when the data is re-inserted into the database tables.

But I have been able to restore an installation and preserve the existing passwords without requiring a reset, by copying the /var/lib/mysql/mysql directory and dropping it into a new instance (of the same version). /var/lib/mysql being the datapath for the server and the mysql directory inside it storing the user, password and privilege data for the installation.

-- Hugh

Replies are listed 'Best First'.
Re^4: Speed of MySQL DBs
by john_oshea (Priest) on Feb 06, 2006 at 18:58 UTC

    I think the oid issue only bites if you have something dependent on oids remaining unchanged. As a (very) small data-point, I've moved databases between installations successfully and had no problems. I am, however, fortunate enough to have come across PostgreSQL around the time that the developers started talking about deprecating oids at some point (v7.2 onwards, I think), so I've just avoided them from the outset.

    And having just re-read the last paragraph, I think the phrase "Just my 2 cents worth" would probably be overstating it ;-)

[reply]

In Section Seekers of Perl Wisdom