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
--
[email protected] mailing list
