Re: Help with ALTER TABLE error
John Stile [EMAIL PROTECTED] wrote: I have Mysql Cluster (version 4.1.16-gama) running, and now I need to convert database tables from engine MyISAM to NDBCLUSTER, but ALTER TABLE fails on some tables. Does anyone know what the error means or how to get around it? mysql use database1; mysql alter table attr engine=NDB; ERROR 1005: Can't create table './database1/#sql-4627_3a.frm' (errno: 4009) Seems weird. Can you check permissions in datadir/database1 and/or create a testcase for us? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help with ALTER TABLE error
I have Mysql Cluster (version 4.1.16-gama) running, and now I need to convert database tables from engine MyISAM to NDBCLUSTER, but ALTER TABLE fails on some tables. Does anyone know what the error means or how to get around it? mysql use database1; mysql alter table attr engine=NDB; ERROR 1005: Can't create table './database1/#sql-4627_3a.frm' (errno: 4009) -- ._. | \0/John Stile | | UniX Administration | | / \ 510-305-3800 | | [EMAIL PROTECTED] | .-. signature.asc Description: This is a digitally signed message part
Re: Help with ALTER TABLE error
On Tue, 2004-10-19 at 21:42, John Stile wrote: I have Mysql Cluster (version 4.1.16-gama) running, and now I need to Sorry, I meant version mysql-max-4.1.6-gamma-pc-linux-i686. signature.asc Description: This is a digitally signed message part
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
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
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
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
Sql Alter Table error handling
HI, I would like to know how can i resume errors in a Alter Table sentence. I am doing a script that uses alter table to drop some columns of some tables in my converted access to mysql database. The problem is that if a column doesn´t exists in a certain table, the script stops with a column/key doesn´t exist error. How can i execute this script non stop? Is there a resume error sentence for that? Is there a handling error way to do that? Thanks, Leonardo Porto - 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: Sql Alter Table error handling
In the last episode (Jun 12), leonardo klarmann porto said: HI, I would like to know how can i resume errors in a Alter Table sentence. I am doing a script that uses alter table to drop some columns of some tables in my converted access to mysql database. The problem is that if a column doesn´t exists in a certain table, the script stops with a column/key doesn´t exist error. How can i execute this script non stop? Is there a resume error sentence for that? Is there a handling error way to do that? $ mysql --help | grep error -f, --force Continue even if we get an sql error. $ -- Dan Nelson [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
ALTER TABLE error
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. screen contents start 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' screen contents end 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
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. screen contents start 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' screen contents end 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
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
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
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
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
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