Re: Can't connect error 10061 - nothing but Mascon works remotely.
Dear Daevid, [root@daevid]# mysqladmin ping -h daevid.com -uroot -p [root@daevid]# mysqladmin ping -h 192.168.1.254 -uroot -p mysqld is alive So this means a connection is possible, and it doesn't matter whether you issue a host name or an ip number. Now you have two programs that can access the MySQL server: Mascon and mysqladmin. But as I see, you tried the ping from the local host (i.e. you connected from the same machine where the MySQL server is running). What happens if you try this from the Win XP box? Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Daevid Vincent [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED] Sent: Monday, December 09, 2002 12:18 AM Subject: RE: Can't connect error 10061 - nothing but Mascon works remotely. [root@daevid]# mysqladmin ping -h daevid.com -uroot -p Enter password: mysqld is alive [root@daevid]# mysqladmin ping -h 192.168.1.254 -uroot -p Enter password: mysqld is alive -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 08, 2002 1:53 PM To: Daevid Vincent; [EMAIL PROTECTED] Cc: 'Karam Chand' Subject: Re: Can't connect error 10061 - nothing but Mascon works remotely. Can't connect to MySQL server on 'daevid.com'(10061) Try mysqladmin ping -h mysql_host_name. This is the most basic thing I can think of to connect to a MySQL server. It should report mysqld is alive. If even that doesn't work, try mysqladmin ping -h 192.168.1.1 (or whatever your server host ip is). If that fails, too, mail your Mascon connection settings to the list, so someone more savvy than me may find out what's happening. HTH! -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Daevid Vincent [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: 'Karam Chand' [EMAIL PROTECTED] Sent: Sunday, December 08, 2002 9:37 PM Subject: RE: Can't connect error 10061 - nothing but Mascon works remotely. Error No. 2003 Can't connect to MySQL server on 'daevid.com'(10061) This is the same error I get with all the other programs too... No SSH or SSL. I'm connecting from my WinXP box to my Linux server over my local LAN. -Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 8:55 PM To: Daevid Vincent Subject: RE: Can't connect error 10061 - nothing but Mascon works remotely. Can you send me some details like: - The error msg. that SQLYog is reporting. - Are you using SSH or SSL? - Are you able to connect thru mysql.exe ( console client to mysql ) --- Daevid Vincent [EMAIL PROTECTED] wrote: Yes. I've done this all before, and I am aware of the RH8 glibc issue, but I thought that the current RPMS on the mysql site fixed that. 'cept it doesn't. I don't understand why mascon works but other windows clients don't work when everything else is the same. -Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 9:02 PM To: Daevid Vincent Subject: Re: Can't connect error 10061 - nothing but Mascon works remotely. Are you trying to access Linux MySQL from a Windows machine? If yes, you can try SQLYog at http://www.webyog.com __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - 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)
Re: mysqldump error
Dear Carlos, Got error: 2013: Lost connection to MySQL server during query when retrieving data from server In your my.cnf / my.ini configuration file, set the value for the communication buffer high (maximum is 16 MB): [mysqldump] set-variable = max_allowed_packet=16M Restart the server, and the dump should work. HTH! -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Carlos A. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 3:13 PM Subject: mysqldump error Hello I have a Red Hat 7.1 server with mysql 3.23.49a installed. Recently I get an error when run mysqldump in order to backup my dbs. The error is following: /usr/local/bin/mysqldump: Got error: 2013: Lost connection to MySQL server during query when retrieving data from server I ran mysqldump with --opt or without it, the error is the same. I must say the table have many registers, almost 200.000 PD: I ran myisamchk before do the dump, and the error remains. Thanks in advance. _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx - 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: Table copy problem
Dear Olh, SELECT * INTO [temptablename] FROM [sourcetablename] WHERE id is null In MySQL, you simply do: CREATE TABLE temptable SELECT * FROM sourcetable LIMIT 0 That's even simpler, 100% reliable and FAST! :) HTH! -- Stefan Hinz [EMAIL PROTECTED] Geschftsfhrer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Olh Barnabs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 1:44 PM Subject: Table copy problem Hello! I want to copy one table's structure to another (non existing) table, but i didn't find any command or example to do that. Exactly, the situation is the following: A dynamic database structure has tables. We want to copy any of tha tables (while we don't know that table's structure) to another template table, which isn't exist. So, that looks like on MsSQL: SELECT * INTO [temptablename] FROM [sourcetablename] WHERE id is null and the SQL server creates a [temptablename] table with no records (or we hope that ;) ) But we can't do this on MySQL server, 'cause MySQL isn't know the SELECT...INTO syntax, but in the INSERT...INTO syntax, we must count the columns, which we wnat to create. (it's not good for me...) Can somebody solve this problem? Or it's willn't work for the next version? (uhh-uhh, thats the worst...) Thanx, Barnabas Olah Cegedim Hungary - 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: MySQL: Select Not In Table
Dear Henning, SELECT Table1.ID FROM Table1 WHERE Table1.ID NOT IN (SELECT Table2.ID FROM Table2); SELECT Table1.ID FROM Table1 LEFT JOIN Table2 USING (ID) WHERE Table2.ID IS NULL Hope it helps, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Henning Sittler [EMAIL PROTECTED] To: 'mysql users' [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 3:16 PM Subject: MySQL: Select Not In Table Just wondering if anyone knows of a work around for selecting rows in Table1 that have an ID column value which is not found in the ID column of Table2. I have seen a workaround for selecting similar rows IN both tables, but I want NOT IN. This would be a work around to the sql subselect query in the following statement: SELECT Table1.ID FROM Table1 WHERE Table1.ID NOT IN (SELECT Table2.ID FROM Table2); Thanks for any help! - 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: MySQL 4.0.5(a) is released
Dear Lenz, `Show_db_priv` enum('N','Y') NOT NULL default 'N' i.e. User must be granted explicitly this privilege in order to be able to use: SHOW DATABASES; Suggested way for setting this Ptivilege is ofcourse command: GRANT SHOW DATABASES; Sound it bit strange in a GRANT select, show databases, update context as it has two words, in opposite to all other privileges that have only one word. I hope you will agree that this approach provides much better flexibility and is more natural than mysqld starting option. Totally agree :) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Alexander Keremidarski [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Cc: Lenz Grimmer [EMAIL PROTECTED]; MySQL announce list [EMAIL PROTECTED]; MySQL mailing list [EMAIL PROTECTED] Sent: Friday, November 29, 2002 11:15 AM Subject: Re: MySQL 4.0.5(a) is released Dear Stefan, Stefan Hinz, iConnect (Berlin) wrote: Dear Lenz, Removed variable `safe_show_database' as it was not used anymore. What will ISPs say about this one? They use 'safe_show_database' for their MySQL setups, so their customers on virtual MySQL hosts cannot see other customers' databases. (It's more likely that you won't attack something which you cannot see.) Or am I missing out on something? Functionality is still there, but implemented at the place it belongs to. Pay attention on Privlieges tables 4.0.5 uses. You will see there is: `Show_db_priv` enum('N','Y') NOT NULL default 'N' i.e. User must be granted explicitly this privilege in order to be able to use: SHOW DATABASES; Suggested way for setting this Ptivilege is ofcourse command: GRANT SHOW DATABASES; I hope you will agree that this approach provides much better flexibility and is more natural than mysqld starting option. If you still have concerns, please don't hesitate to share them with us. -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria ___/ www.mysql.com - 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: MySQL secure access
Dear Alice, but what i meant is my customer want to have the access on their database. and i don't want them to view those databases that not belongs to the particular customer. customer only access their own database only. In MySQL 4.0.5a: Start the server with --safe-show-databases In MySQL = 4.0.5: GRANT ... ON customer1_db.* TO 'customer1'@'localhost' IDENTIFIED BY 'customer1_pw' If not explicitely granted, this command will not grant the show databases privilege, so customer1 cannot see other databases except for customer1_db. Hope it helps, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Alice Tan [EMAIL PROTECTED] To: Pae Choi [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Friday, November 29, 2002 2:54 AM Subject: Re: MySQL secure access of course i will full access on those databases in all the databases store in our server, and i able to view/update all of them. but what i meant is my customer want to have the access on their database. and i don't want them to view those databases that not belongs to the particular customer. customer only access their own database only. - Original Message - From: Pae Choi [EMAIL PROTECTED] To: Alice Tan [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Thursday, November 28, 2002 8:33 PM Subject: Re: MySQL secure access If I am your customer and the data related to my web contents and/or services stored(this is more than likely if the hosting service is used) in the database at your site, I would definitely claim that the access to data will be appropriate. Ex, You have Web services using a hosting service. And the Web services collect the customers' info. Shouldn't you need to access the database which stored all your customers' info. In addition, it's a trust-based relationship. But the hosting service should not have access to the customers' data even though the customers' databases reside at the hosting site. That's more appropriate in the business process and prevent the possible legal matter. Because the customers can simply claim that It's my data and not yours! The right practice will be to seperate your company's database and customer's databases on different hosts. And your company can provide the proper access to your customers to their databases. Otherwise, they will move on to somewhere else who can do for their needs. Pae Hi, all, I am now using MySQL with MySQL Front, where i knew that it can access ALL the databases that store remotely. My company is doing hosting services. And we are using MySQL as our database system. Currently, we have our own databases + customer's databases store in our hosting server. But our customer requested to have their own access on their databases, which i don't want them to see those databases that not belongs to them. Can i do that ? Thanx in advance for anyhelp. regards, alice /--- \ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person),you are hereby notified that any dissemination, distribution, printing or copying of this Message or any part thereof is prohibited. Please delete this Message if received in error and advise the sender by return e-mail. Opinions, conclusions and other information in this Message that do not relate to the official business of this company shall be understood as neither given nor endorsed by this company. This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) *Scanner Engine powered by Norman Virus Control \--- ---/ - 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: Is it possible to export data from access to MySQL?
Dear Steve, Is it possible to export data from MS Access into MySQL? If you don't care to export every single table manually, this is what you do: 1. Install MyODBC 3.51.04 2. Configure a system DSN for your MySQL server. 3. In Access, right-click the table to be exported. 4. Choose Export... 5. Choose Data Type ODBC. 6. Choose a name for the table (default: the Access name). 7. On Computer Data Source, choose the DSN you set up in step 2. The table will be created in the database you set up in step 2. The export will create the table definition (.frm) and import the data. Make sure _all_ your Access tables have primary keys, this makes things easier. You may run into trouble if your Access tables have strange column names (e.g., with spaces, umlauts etc.). Recently, I tried this procedure on a 500 MB Access table with 1.2 million records, and it took 4 minutes on a 2 GHz single processor Pentium machine running Win2K with Service Pack 2. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Steve Jackson [EMAIL PROTECTED] To: MySQL General Mailing list [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 3:37 PM Subject: Is it possible to export data from access to MySQL? Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 - 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: Select statement problem
Dear John, probably the problem does not derive from MySQL, but from the URL encoded search string, e.g.: Search for oneword = oneword Search for two words = two%20words If you match against two words, there will be no match, as it should match against two%20words. I am not informed which language you use for your application. If it's PHP, you can use the urldecode() function which will convert %20 into , so you can feed MySQL with the decoded string. Hope it helps, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: John Chang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 25, 2002 8:20 PM Subject: Select statement problem I am creating a search form for the TitleName. When I type in one word it finds all titles with the one word. If I use two words it doesn't work. How do I change my select statement to make it work? Thank you. SELECT * FROM Titles A, ActorTitle B, Actors C WHERE A.TitleID=B.TitleID AND B.ActorID=C.ActorID AND A.TitleName LIKE '%Title%' GROUP BY A.TitleName ASC Studios (StudioName, StudioID) Genres (GenreName, GenreID) Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID) Actors (Name, ActorID) ActorTitle (TitleID, ActorID) TitleGenres (TitleID, GenreID) MYSQL - 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: problem with replication
Dear Soenke, i wanna setup replication, everything works so far, but the slave can'tconenct to the master, access denied. but if i connect with the 'mysql' program from slave machine to master machine, it works! Before you go crazy, check if the slave (user) has sufficient privileges. Let's say the slave user is called repluser which connects from replmachine. In this case you do SHOW GRANTS FOR 'repluser'@'replmachine'; (on the master server, of course). Check for the FILE privilege. The slave user won't need anything else. It doesn't need SELECT or whatever, only FILE. On the master server, you can do the following: DELETE FROM mysql.user WHERE User = 'repluser'; DELETE FROM mysql.db WHERE User = 'repluser'; FLUSH PRIVILEGES; GRANT FILE ON *.* [or only on the database you want to replicate] TO 'repluser'@'replmachine' IDENTIFIED BY 'some-password'; Now, your slave should be able to replicate from the master. Hope it helps. Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Sönke Ruempler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 24, 2002 11:53 AM Subject: problem with replication hello, i wanna setup replication, everything works so far, but the slave can'tconenct to the master, access denied. but if i connect with the 'mysql' program from slave machine to master machine, it works! going crazy .. both mysqld's are 3.23.53 ! what is going wrong here ahh? regards, soenke. - 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: Strange Error with MySQL 4.0.4 under Win2K
Dear Egor, thanks for your great advice, finally pointing out the reason for the problem. SH mysql ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL SH PRIMARY KEY; SH ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to SH '.\trainee\#sql2-648-2.MYI' (Errcode: 13) This error can occur on Windows if you use lower_case_table_names=1. Which is turned on by default with MySQL 4.0.x. Is this a bug or a feature? ;-) Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 19, 2002 7:52 PM Subject: re: Strange Error with MySQL 4.0.4 under Win2K Stefan, Sunday, November 17, 2002, 5:12:52 PM, you wrote: SH yesterday I imported some tables from MS Access via ODBC into my brand SH new MySQL 4.0.4 server. Everything went fine, but the tables did not SH have a primary key, so I did the following: SH mysql ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL SH PRIMARY KEY; SH ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to SH '.\trainee\#sql2-648-2.MYI' (Errcode: 13) This error can occur on Windows if you use lower_case_table_names=1. SH As PERROR says, 13 is permission denied. What's that? I can do the SH following: SH mysql CREATE TABLE auftrag_2 SELECT * FROM auftrag; SH Now, I can ALTER the auftrag_2 TABLE with no problems at all. SH Trying a workaround, I switched the default-table-type to innodb. Now, SH all the Access tables I import become innoDB tables, and I can ALTER SH TABLE auftrag like above without getting error 13. SH However, innoDB tables have a MyISAM style .frm file. I get a quite SH similar error when I try the following: SH mysql ALTER TABLE auftrag ADD FOREIGN KEY (Auftraggeber) REFERENCES SH auftraggeber(Schl); SH ERROR 1005: Can't create '.\trainee\#sql-6fc_2.frm'. (Error: 150) SH Seems to be an (internal) temporary table problem. Does anyone know SH what's happening, and how to solve this prob? Nope. It's not the same error. This error means that your foreign key definition is not correctly formed. -- 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 - 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