> 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
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.
Stefan Hinz <hinz@stripped>
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" <ronc@stripped>
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
"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."
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 <mysql-thread127024@stripped>
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php