You could also try the mysqlhotcopy binary, if it exists in your bin/ directory. I don't remember when that came out, but you might have it. You don't have to stop the instance for that.
-Sheeri On 10/20/05, Clyde Lewis <[EMAIL PROTECTED]> wrote: > You could copy the entire mysql directory structure to an isolated area > on disk. This will involve stopping the instance though. > > Luke Vanderfluit wrote: > > > Hi. > > > > I'm using 4.0.18 and for legacy reasons I can't upgrade that. > > > > However I'm upgrading the database to a new schema. > > I want to copy the database before I make changes to the schema, so > > that if anything goes wrong, I can revert back. > > > > I have a dump file of the database but that is around 5GIG, so takes > > around an hour to restore. > > Is there a quicker way to copy a database other than to do a dump. > > > > Thanks. > > Kind regards. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
