Date: Fri, 29 Aug 2003 14:33:07 -0700 From: Michelle <tristan11@mindspring.com> To: freebsd-questions@freebsd.org Subject: restoring mysql databases from mysqldump was Re: upgrading mysql Message-ID: <613AB8E4-DA68-11D7-BE93-000393843210@mindspring.com> In-Reply-To: <A4196EF4-DA5B-11D7-B233-0030656DD690@foolishgames.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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) >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?613AB8E4-DA68-11D7-BE93-000393843210>