Re: [gentoo-user] MySQL Upgrade

[kashani]

C. Beamer wrote:
> This works and is not a big deal.  As I said, I'm just curious if there
> is a way to fix things so that my database will be backed up properly
> with the mysqldump process that is run when upgrading.  As I also
> stated, I haven't had the chance to try dumping the existing database
> alone using mysqldump.

	If the data is available within Mysql, then it can be dumped. I'd start 
looking at which options you used on the dump and even at the dump 
itself as the source of your problems. How you got the data into Mysql 
in the first place should not matter. If you look at the dump itself I'd 
pay special attention to the create lines. The usual mistake is not to 
have specified the create statements which means everything gets created 
as a table in a single database assuming you don't have any name space 
collisions.

Normally I do the following for a new install.

on the old server or install
mysqldump -u root -p --opt -Q > mysql-20051102.txt
	Not a super fancy dump, but if you're all text this should work fine.

on the new server or install
emerge mysql
/usr/bin/mysql_install_db
/etc/init.d/mysql start
/usr/bin/mysqladmin -u root password 'temppass'
mysql -u root -p
drop database test;
drop database mysql;
exit
mysql -u root -p < mysql-20051102.txt
mysql -u root -p
flush privileges;
exit

kashani
-- 
gentoo-user@g.o mailing list