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@gentoo.org mailing list