RE: [cobalt-users] MYSQL - Moving data base problems

["mjr" <mjr@xxxxxxxxxxx>]

Found the answer to my problem....If anybody is interested
 http://list.cobalt.com/pipermail/cobalt-users/2002-March/065631.html

Regards,
Mitch



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


_____________________________________
cobalt-users mailing list
cobalt-users@xxxxxxxxxxxxxxx
To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
http://list.cobalt.com/mailman/listinfo/cobalt-users