Re: Alter table error
It might be a permissions problem. Mysql is trying to create a temporary file to do the ALTER but cannot. Check for the write permissions/ownership on the data directory. Regard, Bhavin. - Original Message - From: "Nick Stuart" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 2:15 PM Subject: Alter table error > Got another problem with 4.0.7 when trying to alter the table. > Trying to run: > ALTER TABLE `call_information` CHANGE `close_date` `close_date` > TIMESTAMP DEFAULT '' NOT NULL > and it returns a: > ERROR 7: Error on rename of '.\helpdesk\call_information.MYI' to > '.\helpdesk\#sql2-b90-81.MYI' (Errcode: 13) > > Any ideas on why I would get this?? I think it has something to do with > my case problem that I posted before because if you look it says > helpdesk instead of HelpDesk. > > -- > > -Nick Stuart > > USM Computer Science Major > Visit us at http://csforum.newtsplace.com > (run with LAMP) > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Alter table error
Thats what I thought, but wasnt the case. The directory was open to full control by everyone. I did fix the problem though. It turns out this is an issue with windows not letting anyone edit a file that is in use. And when a table is used mysql will cache and hence windows thinks it's in use and will lock it. I just had to do a mysqladmin -u root refresh and I was able to edit the table. God how I've missed windows! blah! Thanks for the pointer though. I ended up finding this solution somewhere through google, can't remember where atm though. -Nick On Wed, 2003-01-08 at 19:19, Jennifer Goodie wrote: > >ERROR 7: Error on rename of '.\helpdesk\call_information.MYI' to > >'.\helpdesk\#sql2-b90-81.MYI' (Errcode: 13) > > >Any ideas on why I would get this?? > > Errorcode 13 is permission denied or file not found. Either > .\helpdesk\#sql2-b90-81.MYI exists and your mysqld user does not have > permission to overwrite it, or the user does not have write permissions on > the data dir and everything in it. Using perror will help you decode the > errorcodes. > > > SQL,QUERY > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Alter table error
>ERROR 7: Error on rename of '.\helpdesk\call_information.MYI' to >'.\helpdesk\#sql2-b90-81.MYI' (Errcode: 13) >Any ideas on why I would get this?? Errorcode 13 is permission denied or file not found. Either .\helpdesk\#sql2-b90-81.MYI exists and your mysqld user does not have permission to overwrite it, or the user does not have write permissions on the data dir and everything in it. Using perror will help you decode the errorcodes. SQL,QUERY - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ALTER TABLE error
It means you're connecting to the server as an annonymous user. If you have a username to connect to the server, run the following query: mysql> show grants for your_user_name@localhost; and it will show you all the priveleges that you have for specific databases and tables. That's the best way to figure out what happened. If it says that you do not have ALTER privelege for 'dbname', then update the grants for yourself, or ask your ISP to do that if you dont have su access -- "The road to hell is paved with melting snowballs." -- Larry Wall in <[EMAIL PROTECTED]> Carl Troein wrote: CT: CT: Steve Osborne writes: CT: CT: > ERROR 2000: Access denied for user: '@localhost' to database 'dbname' CT: > CT: > Can anyone give me some insight as to why I cannot do this? Do I require CT: > root privileges to do this (right now I am logged in as a user, as this CT: > remote server is an ISP)? CT: CT: What unix user you are is irrelevant. However, what MySQL user CT: you are is not. You should read the chapters on privileges and CT: security, and ask your ISP to do so too. You shouldn't be able CT: to connect as the anonymous user. CT: CT: BTW, your clock is off by ~65 minutes. CT: CT: //C CT: CT: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ALTER TABLE error
Steve Osborne writes: > ERROR 2000: Access denied for user: '@localhost' to database 'dbname' > > Can anyone give me some insight as to why I cannot do this? Do I require > root privileges to do this (right now I am logged in as a user, as this > remote server is an ISP)? What unix user you are is irrelevant. However, what MySQL user you are is not. You should read the chapters on privileges and security, and ask your ISP to do so too. You shouldn't be able to connect as the anonymous user. BTW, your clock is off by ~65 minutes. //C -- Carl Troein - CĂrdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ALTER TABLE error
are you sure you don't want to UPDATE Advertisers SET PACK_KEYS=0;? Steve Osborne wrote: >Can anyone tell me why I am receiving the following error? I am connecting >to a remote server via ssh, and accessed the mysql prompt by typing: mysql > The following is the screen contents after trying to use the ALTER >TABLE command; 'dbname' has been sub'd for actual database name. > > > >Welcome to the MySQL monitor. Commands end with ; or \g. >Your MySQL connection id is 1451062 to server version: 3.23.43 > >Type 'help' for help. > >mysql> connect dbname >Connection id:1451083 >Current database: dbname > >mysql> ALTER TABLE Advertisers PACK_KEYS=0; >ERROR 2000: Access denied for user: '@localhost' to database 'dbname' > > > >Can anyone give me some insight as to why I cannot do this? Do I require >root privileges to do this (right now I am logged in as a user, as this >remote server is an ISP)? > >Steve Osborne >Database Programmer >Chinook Multimedia Inc. >[EMAIL PROTECTED] > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: alter table error
Okay, I ran "myisamchk -c message.MYI" and got back: myisamchk: error: 22 when opening MyISAM-table 'message.MYI' perror says error 22 is "Error code 22: Invalid argument" Is there a way I can regenerate the index file? I can still open mysql and do queries on the table so it does not appear to be fatal. Hmm. - Dan >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 3/26/01, 12:11:09 PM, "Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]> wrote regarding Re: alter table error: > On Mon, 26 Mar 2001, Daniel Adams wrote: > > Well, I wanted to limit the size of the index so it wouldn't take up a > > lot of space. The message table is about 500mb right now and is going to > > get a lot bigger. Well not limiting the size of the index get rid of the > > error? > > > Actually you should be able to do that, and it is quite advisable. I assume/guess that the error code returned with your error message is actually '126'. > Looking it up with perror, I get: > 126 = Index file is crashed / Wrong file format > If this is correct, it would be nice to ran a myisamchk to check on your indeces and then try again. > regards, > thalis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: alter table error
Reffer documentation about mysql version and table type where you can do that. - Original Message - From: "Daniel Adams" <[EMAIL PROTECTED]> To: "LIBASOV IOANNIS" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, March 26, 2001 7:54 PM Subject: Re: alter table error Well, I wanted to limit the size of the index so it wouldn't take up a lot of space. The message table is about 500mb right now and is going to get a lot bigger. Well not limiting the size of the index get rid of the error? >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 3/26/01, 11:35:19 AM, "LIBASOV IOANNIS" <[EMAIL PROTECTED]> wrote regarding Re: alter table error: > It's better like this: > alter table message add index subject2 (subject); > - Original Message - > From: "Daniel Adams" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, March 26, 2001 7:19 PM > Subject: alter table error > Can anyone tell me what this means and how to fix it? I ran the below > query to simple add another index and this is what i got. Thank you. > mysql> alter table message add index subject2 (subject(10)); > ERROR 1034: 126 for record at pos 176850808 > - Dan > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: alter table error
On Mon, 26 Mar 2001, Daniel Adams wrote: > Well, I wanted to limit the size of the index so it wouldn't take up a > lot of space. The message table is about 500mb right now and is going to > get a lot bigger. Well not limiting the size of the index get rid of the > error? > Actually you should be able to do that, and it is quite advisable. I assume/guess that the error code returned with your error message is actually '126'. Looking it up with perror, I get: 126 = Index file is crashed / Wrong file format If this is correct, it would be nice to ran a myisamchk to check on your indeces and then try again. regards, thalis > >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< > > On 3/26/01, 11:35:19 AM, "LIBASOV IOANNIS" <[EMAIL PROTECTED]> wrote regarding > Re: alter table error: > > > > It's better like this: > > alter table message add index subject2 (subject); > > > - Original Message - > > From: "Daniel Adams" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Monday, March 26, 2001 7:19 PM > > Subject: alter table error > > > > Can anyone tell me what this means and how to fix it? I ran the below > > query to simple add another index and this is what i got. Thank you. > > > mysql> alter table message add index subject2 (subject(10)); > > ERROR 1034: 126 for record at pos 176850808 > > > - Dan > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: alter table error
Well, I wanted to limit the size of the index so it wouldn't take up a lot of space. The message table is about 500mb right now and is going to get a lot bigger. Well not limiting the size of the index get rid of the error? >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 3/26/01, 11:35:19 AM, "LIBASOV IOANNIS" <[EMAIL PROTECTED]> wrote regarding Re: alter table error: > It's better like this: > alter table message add index subject2 (subject); > - Original Message - > From: "Daniel Adams" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, March 26, 2001 7:19 PM > Subject: alter table error > Can anyone tell me what this means and how to fix it? I ran the below > query to simple add another index and this is what i got. Thank you. > mysql> alter table message add index subject2 (subject(10)); > ERROR 1034: 126 for record at pos 176850808 > - Dan > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: alter table error
It's better like this: alter table message add index subject2 (subject); - Original Message - From: "Daniel Adams" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 26, 2001 7:19 PM Subject: alter table error Can anyone tell me what this means and how to fix it? I ran the below query to simple add another index and this is what i got. Thank you. mysql> alter table message add index subject2 (subject(10)); ERROR 1034: 126 for record at pos 176850808 - Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php