On Friday, August 29, 2003, at 01:01 PM, Lucas Holt wrote:
That sounds correct. I would recommend doing a binary backup as well in case something happens. (i usually tar up the mysql directory with the service off)
If you want extra security, you could use the phpMyAdmin software to backup the databases as well.. so you have an extra copy. I believe it actually runs mysqldump anyway though.
If you can eventually, I'd recommend the 4.x releases. I have had great success with them.
On Friday, August 29, 2003, at 02:56 PM, Michelle wrote:
I would like to upgrade mysql from mysql-server-3.23.54 to mysql-server-3.23.57 and understand that I will need to do a dump before upgrading since the upgrade needs to overwrite the databases. Since I have never done this before, I just want to make sure I have the correct steps after reading over the mysql site and the man >> pages.
First I will dump all of my databases:
mysqldump -A > backup-file.sql
Then I will shutdown the mysql server and upgrade the mysql port with the environment variable OVERWRITE_DB defined when running make install.
To rebuild the databases do I simply use:
mysqldump --all-databases > backup-file.sql
and then restart the mysql server using mysqld_safe
Am I missing any steps?
[EMAIL PROTECTED] mailing list
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Lucas Holt [EMAIL PROTECTED] ________________________________________________________ FoolishGames.com (Jewel Fan Site) JustJournal.com (Free blogging)
"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."
- Albert Einstein (1879-1955)
_______________________________________________ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"