Re: copy database other than mysqldump

2005-10-21 Thread Gleb Paharenko
Hello. Have a look here: http://dev.mysql.com/doc/refman/5.0/en/upgrading-to-arch.html http://dev.mysql.com/doc/mysql/en/Moving.html 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

copy database other than mysqldump

2005-10-20 Thread Luke Vanderfluit
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

Re: copy database other than mysqldump

2005-10-20 Thread Clyde Lewis
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

Re: copy database other than mysqldump

2005-10-20 Thread sheeri kritzer
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