Topic: New database creation messes up existing databases

[edform]

I have a Mambo website in a virtual domain on my server and it seems to get broken every time I try to install any PHP/MySQL software. The same actions also break Twiggi.

I just ran through the early stages of setting up eGroupware on my server including creating a database called egroupware and a template fragment for httpd in the custom templates area. As soon as I expand the template and restart httpd the Mambo website dissapears along with Twiggi. When I look at MySQL with the Windows MYSQL Administrator tool, all the dtabases are apparently missing except egroupware and test. The databases can't actually be gone because Webmail still works, and it surely needs Horde.

Anybody know what's going on here - and how to put it right?

Ed Form

[guest22]

Ed, what does 'mysqlshow' tell you on the console?

[edform]

Ed, what does 'mysqlshow' tell you on the console?

The response is Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Ed Form

[guest22]

The response is Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Then you have a different problem, mysql is not running.

[edform]

The response is Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Then you have a different problem, mysql is not running.

But I can connect to it with MySQL Administrator and manipulate the two databases that I can see - egroupware and Test. The shocking thing is that this is possible without opening a Tunnel onto the server!!!!! It seems like the standard MySQL has been disconnected from it's external duties and a new instance started in an insecure mode, with just the standard empty Test database and the one created during the egroupware setup - the good news is that restoring last night's backup of /var/lib/mysql cured the problem completely - I now need to open a tunnel before I can connect to MySQL and whn I do all the databases are returned.

During the incident the mysql.sock file was zero length.

Is this a bugette or is it just the Howto procedure pickling the MySQL system?

The Howto is here...

http://serviceinfosg.com:8185/index.php?option=com_remository&Itemid=42&func=selectfolder&filecatid=1

Ed Form