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
