What would be the quickest way to move some MySQL databases from one Debian box to another upgraded Debian box? I'd like to keep the same users/permissions, so I'll need to move the mysql DB as well.
I've read through the instructions at: http://www.mysql.com/doc/en/Upgrading-to-arch.html but I don't quite understand this section: ---------- Also, don't forget to copy the mysql database because that's where the grant tables (user, db, host) are stored. You may have to run commands as the MySQL root user on the new machine until you have the mysql database in place. After you import the mysql database on the new machine, execute mysqladmin flush-privileges so that the server reloads the grant table information. ---------- Do they actually mean a FS copy? If so, I assume the mysqld should be stopped, do the copy, and then restart mysqld and then do the 'mysqladmin flush-privileges'? Or, should the mysqld just be running through the FS copy? Thanks, John Hebert __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html
