Re: Moving a MySQL database

2003-08-22 Thread Roberto Sanchez
--- Yves Goergen <[EMAIL PROTECTED]> escribió: Actually, I am moving from 3.23.56 (RH9) to 3.23.49 (Debian Woody). Will this pose a problem? Will I need to 'update'? -Roberto > providing you're using the same or a newer mysql server on your new system, > you just need to copy the whole data

Re: Moving a MySQL database

2003-08-22 Thread Kirk Strauser
At 2003-08-22T15:03:33Z, Roberto Sanchez <[EMAIL PROTECTED]> writes: > I have a MySQL database residing on a RH9 server. I have started building > a Debian server running woody to replace it. Is there an easy way to grab > the whole database and move it over as is? 1. Type: `mysqldump -u root -

Re: Moving a MySQL database

2003-08-22 Thread Yves Goergen
providing you're using the same or a newer mysql server on your new system, you just need to copy the whole data directory of your mysql installation. copying the files is sufficient, but do not change the filenames nor directory structure in itself. in case you're switching from 3.x to 4.0.x, yo