Cool. That's what I figured, so thanks for the confirmation. However, what about the mysql system database? I'd like to keep the same users/permissions. Know of a safe and sure way to move it?
Thanks, John Hebert --- Jason DeWitt <[EMAIL PROTECTED]> wrote: > 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 > >[email protected] > >http://brlug.net/mailman/listinfo/general_brlug.net > > > > > > > > > _______________________________________________ > General mailing list > [email protected] > http://brlug.net/mailman/listinfo/general_brlug.net __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html
