Dear Ronald, > Due to some application compatibility issues, I may have to backrev > mysql-3.23.53a-1 to 3.23.52-3. I have only a few weeks' experience > with mysql -- can I do this and retain the current tables and data > contained therein?
Backup your databases and tables first. I would suggest you use mysqldump -uusername -ppassword --all-databases --add-drop-table > mysql_db.sql (you can use any name you want, and any other location) for this. (In most cases, a mere file copy action of DATADIR (c:\mysql\data or /var/lib/mysql) will do, but mysqldump makes sure your data are compatible with all table handlers MySQL can use, etc.) Uninstall MySQL 3.23.53a-1 (sure it's -1?). Install MySQL 3.23.52-3 (sure it's -3?). In case you copied DATADIR, make sure the server is not running, then copy the DATADIR backup back to the appropriate location (DATADIR, see above), overwriting the DATADIR data of the new installation. Start the server. If you used the method I suggested, start the server first. The installation procedure will have installed the default grant tables as well, which means, you will have the default MySQL users set up (instead of the users you set up with your old installation). Import your own backuped data as follows: shell> mysql -uroot < mysql_db.sql This will install your old grant tables, too, overwriting the newly installed mysql database. Now, everything should be in the same state as it was before you downgraded. HTH! -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Ronald O. Christian" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 09, 2002 7:32 PM Subject: backrev mysql while retaining data? Due to some application compatibility issues, I may have to backrev mysql-3.23.53a-1 to 3.23.52-3. I have only a few weeks' experience with mysql -- can I do this and retain the current tables and data contained therein? Ron - "I do not love the bright sword for its sharpness, nor the arrow for its swiftness, nor the warrior for his glory. I love only that which they defend." http://roc85.home.attbi.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 --------------------------------------------------------------------- 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