Although mysqldump is the official solution, there's a fabulous perl script "mysqlhotcopy" that simply copies the data from MySQL tables in folders and restoring the data is as simple as copying the files back to their /var/lib/mysql/data location.
I know about pg_dumpall, which creates a humongous SQL file, but is there something equivalent in the postgresql world, like a "pgsqlhotcopy" which copies data folders in a similar way as mysqlhotcopy? Thanks! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
