RE: More information from mysqld_safe

2005-07-21 Thread michael watson \(IAH-C\)
OK, I have more information - I am getting the error message: Fatal error: Can't open privilege tables: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2) WTF???! -Original Message- From: michael watson (IAH-C) Sent: 21 July 2005 14:39 To: mysql@

More information from mysqld_safe

2005-07-21 Thread michael watson \(IAH-C\)
Hi Now I'm having trouble getting the server started! Again, suse linux, mysql 4.1.12-Max. My MySQL server was running before, now it's not. I don't remember changing anything apart installing DBD::mysql from source... Anyway, data dir is /var/lib/mysql and all the ownerships are correct (owne

mysql_config doesn't exist

2005-07-21 Thread michael watson \(IAH-C\)
Hi I'm trying to install something on SuSe Linux that requires mysql_config (DBD::mysql to be precise). I have mysql installed but nowhere is there anything called mysql_config. The server version is something called 4.1.12-Max, a version of MySQL I've never used before. Does this version not c

Getting warnings from mysqlimport with MySQL v4.0.15-standard-log

2005-06-10 Thread michael watson \(IAH-C\)
Hi The subject says it all! My mysqlimport command reports 43 warnings, but I have no idea how to access them. "SHOW WARNINGS" was only implemented after MySQL version 4.1, and I have 4.0.15-standard-log. Any help? Many thanks Mick -- MySQL General Mailing List For list archives: http://lists

Problems with DBI

2004-08-16 Thread michael watson (IAH-C)
Hi Not sure if I should be posting to the DBI list really, but I will try this one too. I'm running suse linux enterprise server 8.2, MySQL 4.0.15-standard-log, DBI 1.32 I get the following error message: DBD::mysql::db rollback failed: ROLLBACK failed at dbirollbacktest.cgi line 49 DBD::mysql:

Can't drop database

2004-06-21 Thread michael watson (IAH-C)
Hi I am running Suse Linux 8.2 and MySQL 3.23.55 A funny thing happens: %> mysqladmin drop base Database "base" dropped %> mysqladmin create base Can't create database 'base'. Database exists. And if I log in to MySQL, there it is - undropped! So why is mysqladmin telling me the database is dr

Different users try to access different mysql.sock

2003-09-16 Thread michael watson (IAH-C)
Here is an interesting one! I have changed datadir in my.cnf to point to /data/mysql. I also have the socket file as /data/mysql/mysql.sock This is all fine and works. My server starts up with no complaints, /data/mysql/mysql.sock springs into existence and everyone is happy. Except my users

Problem with mysql.sock

2003-09-15 Thread michael watson (IAH-C)
Hi I need to know how and where to tell mysql to look for mysql.sock. I am using mysql version 3.23.55 and SUSE Linux 8.2. My problem is that i have a mysql daemon working very well and using /var/lib/mysql/mysql.sock as the correct socket. No problems. My problems come when I try and inst

Problems POST-installation

2003-07-01 Thread michael watson (IAH-C)
Hi I am having problems POST-installation with MySQL. A bit about my setup: SUSE Linux 8.1 MySQL 4.0.13 (installed from tar ball) MySQL installed in /usr/local/mysql Everything on the installation worked fine. I then ran mysql_install_db I then changed ownership of everything in /usr/local/my