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
>
>  
>

Reply via email to