Hi John: This is what I normally do: on the old server mysqldump -A -h the_host_if_not_local -u root -p > backup.sql
on the new server mysql < backup.sql The database should be stopped with this procedure or data will be lost for the time that it would take to do this. I used to do about 56GBs in under 5 minutes. You may want to tar.bz that file. If you have foreign keys you will get errors with the mysql < backup.sql. There is a command to disable this check temporarily; however, what I do is list the tables considering the dependencies. I feel reassured that everything is ok. take care, Alvaro Zuniga On Wed, 2004-03-24 at 15:07, Jason DeWitt 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. This will only move the mysql table, which is where permissions are stored. > 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
