Re: After upgrade to 5.03beta, mysqld won't start [SOLVED]
On 4/12/2005 9:31 PM John Swartzentruber wrote: On 4/12/2005 8:43 PM Petr Chardin wrote: Hi Jonh, As I said, I couldn't find any error logs that seemed to relate (i.e, had information newer than the upgrade and start failures). I looked into the /etc/init.d/mysql script and tried running mysqlmanager directly. It would not run because of errors. From another message in this newsgroup, I saw that someone else was having similar problems and that removing the items from the [mysql] section of my.conf took care of them. That's what I did, and then the server started. From what I can tell, this appears to be a bug because the [mysql] section should have no affect on the server process and should not prevent mysqlmanager from running. Yes, it is a bug in mysqlmanager and it is fixed in the source repository. Please upgrade to 5.0.4 when it is released. Petr I just wanted to confirm that 5.0.4 does fix the problem as promised. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: After upgrade to 5.03beta, mysqld won't start
On 4/12/2005 8:43 PM Petr Chardin wrote: Hi Jonh, As I said, I couldn't find any error logs that seemed to relate (i.e, had information newer than the upgrade and start failures). I looked into the /etc/init.d/mysql script and tried running mysqlmanager directly. It would not run because of errors. From another message in this newsgroup, I saw that someone else was having similar problems and that removing the items from the [mysql] section of my.conf took care of them. That's what I did, and then the server started. From what I can tell, this appears to be a bug because the [mysql] section should have no affect on the server process and should not prevent mysqlmanager from running. Yes, it is a bug in mysqlmanager and it is fixed in the source repository. Please upgrade to 5.0.4 when it is released. Petr Thanks for the confirmation. I'll upgrade when it is released. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: After upgrade to 5.03beta, mysqld won't start
On 4/10/2005 10:57 AM Gleb Paharenko wrote: Hello. What is in error log? See: http://dev.mysql.com/doc/mysql/en/starting-server.html As I said, I couldn't find any error logs that seemed to relate (i.e, had information newer than the upgrade and start failures). I looked into the /etc/init.d/mysql script and tried running mysqlmanager directly. It would not run because of errors. From another message in this newsgroup, I saw that someone else was having similar problems and that removing the items from the [mysql] section of my.conf took care of them. That's what I did, and then the server started. From what I can tell, this appears to be a bug because the [mysql] section should have no affect on the server process and should not prevent mysqlmanager from running. John Swartzentruber <[EMAIL PROTECTED]> wrote: I was rash and decided to try to upgrade from 4.1 to 5.03 on my home server. This isn't a critical system, but I am working on a class project on it. Yup, I'm a newbie. I'm running Fedora Core3. I did an "rpm -ivh" for each of the appropriate RPMs (server, client, devel, bench, shared). For the "shared" I did a --force because there is no shared-compat for 5.03. Anyway, it looks like everything installed, but now, when I do /etc/init.d/mysqld start, it tries for awhile, then fails. I'm not sure where to look to figure out this problem. I don't see any log files, and there are no error messages. Can anyone please get me pointed in the right direction? If I can't figure this out soon, I'll need to try to get 4.1 working again. Thanks for your help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5.0.3 --no-auto-rehash
On 3/28/2005 3:50 PM Alejandro D. Burne wrote: OK, I confuse a little, this is the message: [EMAIL PROTECTED] init.d]# /etc/rc.d/init.d/mysql start Starting MySQL/usr/sbin/mysqlmanager: unknown option '--no-auto-rehash' in my.cnf exists "no-auto-rehash", if I comment this line mysqld starts up without errors. maybe my.cnf came from 5.0.2 and this option it's not supported on 5.0.3? Alejandro. I'm seeing this exact problem. I just upgraded today from 4.1 to 5.0.3. When I tried to start the program, it failed (I didn't even get the error message). Thanks to Alejandro's message, I tried commenting out the two entries in my [mysql] section, and now the server starts. Having "safe-updates" in the [mysql] section also causes a problem and prevents mysqlmanager from running. If mysqld or mysqlmanager don't care about what's in the [mysql] section, there appears to be a bug. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
After upgrade to 5.03beta, mysqld won't start
I was rash and decided to try to upgrade from 4.1 to 5.03 on my home server. This isn't a critical system, but I am working on a class project on it. Yup, I'm a newbie. I'm running Fedora Core3. I did an "rpm -ivh" for each of the appropriate RPMs (server, client, devel, bench, shared). For the "shared" I did a --force because there is no shared-compat for 5.03. Anyway, it looks like everything installed, but now, when I do /etc/init.d/mysqld start, it tries for awhile, then fails. I'm not sure where to look to figure out this problem. I don't see any log files, and there are no error messages. Can anyone please get me pointed in the right direction? If I can't figure this out soon, I'll need to try to get 4.1 working again. Thanks for your help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Assertions
I'm taking a database course and am curious about the support for assertions in MySQL. It appears that they were added to SQL92, but I don't see any information about them in the MySQL documentation (either to say they are supported or to say they are not). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with LOAD DATA INFILE
On 2/21/2005 4:21 AM Heikki Tuuri wrote: John, please print a detailed description of the latest foreign key error with SHOW INNODB STATUS and post it here. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL Network from http://www.mysql.com/network/ Thank you! I won't bother to post the results because the command showed me the problem. The problem appears to be that the parser doesn't skip whitespace after separators as I assumed it did. The result is that my key was "Administrator", but it was looking for " Administrator". Removing all whitespace allowed it to work correctly. To me, this parsing is either a bug or a "feature" that should be documented in red letters. But it isn't a InnoDB issue. Thanks again for your help by pointing out this very useful command. - Original Message - From: "John Swartzentruber" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Sunday, February 20, 2005 11:54 PM Subject: Problems with LOAD DATA INFILE I am new to SQL and to MySQL, but am working with it on a project for a graduate Database system course. I'm running MySQL 4.1.10 under Windows 2000. I am trying to load a table from a text file. The table in question has a foreign key. The table that it references contains data. The problem is that when I load the data using LOAD DATA LOCAL INFILE, I get this error: ERROR 1216 (23000): Cannot add or update a child row: a foreign key constraint fails That seems clear enough except that the foreign key constraint should *not* fail. I've verified that the value exists in the other table. What is really strange is that when I tried inserting the data directly using "INSERT INTO", it works. In this particular case, I only need to load a handful of records, so using INSERT INTO is an option, but I would really like to figure out what isn't working. Here is my table definition: create table Subscriber ( UserIDint auto_increment, Name varchar(50) not null, Password varchar(8) not null, EmailAddress varchar(50), SGroupNamevarchar(50), primary key (UserId), foreign key (SGroupName) references AccessGroup(GroupName) on update cascade ) ENGINE=INNODB; Here is how I am attempting to load it: LOAD DATA LOCAL INFILE 'c:/Documents and Settings/john/My Documents/Grad School/Project/LoadData/Subscriber.csv' REPLACE INTO TABLE Subscriber FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (Name, Password, EmailAddress, SGroupName); Here are the first two lines of my data file: Name, Password, EmailAddress, SGroupName "John Swartzentruber", "8490JTTT", "[EMAIL PROTECTED]", Administrator And here is what *does* work: insert into Subscriber (Name, Password, EmailAddress, SGroupName) values ("John Swartzentruber", "8490JTTT", "[EMAIL PROTECTED]", "Administrator"); Can anyone see what my problem is? I really appreciate any assistance you can provide. I hope this is the appropriate group for newbie questions. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems with LOAD DATA INFILE
I am new to SQL and to MySQL, but am working with it on a project for a graduate Database system course. I'm running MySQL 4.1.10 under Windows 2000. I am trying to load a table from a text file. The table in question has a foreign key. The table that it references contains data. The problem is that when I load the data using LOAD DATA LOCAL INFILE, I get this error: ERROR 1216 (23000): Cannot add or update a child row: a foreign key constraint fails That seems clear enough except that the foreign key constraint should *not* fail. I've verified that the value exists in the other table. What is really strange is that when I tried inserting the data directly using "INSERT INTO", it works. In this particular case, I only need to load a handful of records, so using INSERT INTO is an option, but I would really like to figure out what isn't working. Here is my table definition: create table Subscriber ( UserIDint auto_increment, Name varchar(50) not null, Password varchar(8) not null, EmailAddress varchar(50), SGroupNamevarchar(50), primary key (UserId), foreign key (SGroupName) references AccessGroup(GroupName) on update cascade ) ENGINE=INNODB; Here is how I am attempting to load it: LOAD DATA LOCAL INFILE 'c:/Documents and Settings/john/My Documents/Grad School/Project/LoadData/Subscriber.csv' REPLACE INTO TABLE Subscriber FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (Name, Password, EmailAddress, SGroupName); Here are the first two lines of my data file: Name, Password, EmailAddress, SGroupName "John Swartzentruber", "8490JTTT", "[EMAIL PROTECTED]", Administrator And here is what *does* work: insert into Subscriber (Name, Password, EmailAddress, SGroupName) values ("John Swartzentruber", "8490JTTT", "[EMAIL PROTECTED]", "Administrator"); Can anyone see what my problem is? I really appreciate any assistance you can provide. I hope this is the appropriate group for newbie questions. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]