restoring mysql databases from mysqldump was Re: upgrading mysql
Michelle
tristan11 at mindspring.com
Fri Aug 29 14:50:05 PDT 2003
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 at freebsd.org mailing list
>>> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
>>> To unsubscribe, send any mail to
>>> "freebsd-questions-unsubscribe at freebsd.org"
>>>
>>>
>>
>> Lucas Holt
>> Luke at 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 at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to
> "freebsd-questions-unsubscribe at freebsd.org"
>
More information about the freebsd-questions
mailing list