restoring mysql databases from mysqldump was Re: upgrading mysql

Michelle tristan11 at
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 mailing list
>>> To unsubscribe, send any mail to 
>>> "freebsd-questions-unsubscribe at"
>> Lucas Holt
>> Luke at
>> ________________________________________________________
>>  (Jewel Fan Site)
>> (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 mailing list
> To unsubscribe, send any mail to 
> "freebsd-questions-unsubscribe at"

More information about the freebsd-questions mailing list