I believe I succesfully restored the databases by running simply mysql > backup-file.sql. However, I believe the permissions are not working properly. Apache is unable to connect the sql server and I cannot shutdown the sql server with the user name and password I normally use.

On Friday, August 29, 2003, at 02:33 PM, Michelle wrote:

I ran mysqldump -A > backup-file.sql and then upgraded the mysql port, but now when I try to restore the backups using mysql "database name" < backup-file.sql, It states unknown database. I also have a mysqlhotcopy backup of all my databases. Am I doing something wrong when trying to recover multiple databases? How can I recover them from the mysqlhotcopy rather then the dump if something went wrong with the dump?

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?

Thank you,
Michelle
_______________________________________________
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
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]"



_______________________________________________ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to