Date: Fri, 29 Aug 2003 14:50:01 -0700 From: Michelle <tristan11@mindspring.com> To: freebsd-questions@freebsd.org Subject: Re: restoring mysql databases from mysqldump was Re: upgrading mysql Message-ID: <BDAE8222-DA6A-11D7-BE93-000393843210@mindspring.com> In-Reply-To: <613AB8E4-DA68-11D7-BE93-000393843210@mindspring.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 >>> _______________________________________________ >>> freebsd-questions@freebsd.org mailing list >>> http://lists.freebsd.org/mailman/listinfo/freebsd-questions >>> To unsubscribe, send any mail to >>> "freebsd-questions-unsubscribe@freebsd.org" >>> >>> >> >> Lucas Holt >> Luke@FoolishGames.com >> ________________________________________________________ >> 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) >> > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?BDAE8222-DA6A-11D7-BE93-000393843210>