Re: How hard is it to move from on server to another?

2008-04-22 Thread Sebastian Mendel
B. Keith Murphy schrieb: A simple rsync should do the trick. How long will depend on how much data you have. I would just shut down the server, copy over the data directory and start the new server up. Should be a piece of cake. Keith David Ruggles wrote: I have a MySQL 5.x box and I am t

Re: How hard is it to move from on server to another?

2008-04-21 Thread B. Keith Murphy
A simple rsync should do the trick. How long will depend on how much data you have. I would just shut down the server, copy over the data directory and start the new server up. Should be a piece of cake. Keith David Ruggles wrote: I have a MySQL 5.x box and I am thinking about moving it to

How hard is it to move from on server to another?

2008-04-21 Thread David Ruggles
I have a MySQL 5.x box and I am thinking about moving it to another more powerful server. I would be able to schedule some downtime so that's not an issue. How complicated a process would this be? I don't want to upgrade the software or anything, just move the existing tables, users and permissions