On Friday 13 December 2002 19:48, Ewan \\"MEB\\" Oughton wrote: > I just became the database admin on this server, my first job was to > upgrade the mysql install, it was running 3.22.30, I upgraded it to > 3.23.54 > > Seemed to go OK, just want to check... I moved all the databases from var > in the old install to data in the new install... all the databases seem to > be there and user logins would appear to work fine... has there been any > cases of loss of data? >I have a full dump of all the data if it turns out > i have to propogate the data that way instead...
In general, usage of mysqldump is more recommended than direct coping of table files. And of course you better use mysqldump if upgrading since 3.22 as the table files format is changed. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
