[cobalt-users] MYSQL - Moving data base problems

["mjr" <mjr@xxxxxxxxxxx>]

Having problems with a MYSQL database that I moved.....

I had a database on ns.domainname.net and moved it to ns1.domainname.net
I used this on ns.domainname.net
mysqldump -uroot -p database | gzip > database.gz

Then on ns1 I created the data base uploaded the gz file and used this
command
gunzip < database.gz | mysql -uroot -p database

The database on ns1 is talking a long time to get its information...
I tracked it down and it looks like the new data base on ns1 is still going
to the (old) ns machine for information.

When I take a look at the pid on ns1.domainname.com....
24617 ?        SN     0:00 /usr/sbin/mysqld --basedir=/
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/ns.domainname.net.pid --skip-locking
This is using ns.domanname.net when it should be ns1.domainname.net

I have the same database on ns2.domainname.net that wasn't moved..I
installed fresh and the pid looks like

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/ns2.domainname.net.pid --skip-lockin
It has the correct machine ns2.domainname.net

How can I change it that ns1 uses the database on ns1 instead of going to
ns?
Any ideas would be greatly appreciated.

Regards,
Mitch