I would just grab a dump file of the mysql database and then move it to the new server and import it.
"mysqldump mysql > mysql.sql" I believe that will move it all. John Hebert wrote: >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 > >_______________________________________________ >General mailing list >General@brlug.net >http://brlug.net/mailman/listinfo/general_brlug.net > > >
