At 17:39 -0700 7/26/04, Shannon R. wrote:
hello list!
i'll be moving from a RedHat server to a Debian server very soon.
despite the different linux distributions, is it ok to transfer my
entire mysql database by just copying everything in /var/lib/mysql
of the RedHat system to the Debian system? has anyone tried this
before?
I'd expect it to work.
the reason why i don't want to do the database transfer using data
generated by mysqldump is because i want all the auto-generated
record_ids to stay the same in the new system.
I'd expect this to work, too. mysqldump will dump the values that those
auto-generated IDs currently have, and they won't change when you reload
them. AUTO_INCREMENT values aren't generated automatically unless you
store NULL or zero into them, which won't be the case with mysqldump
files. (I assume here that you didn't do something unsupported like
change the values to negative numbers or zeros after generating the IDs.)
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
