database problem
__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: cannot create database Description: I have already set the path to c:\mysql\bin and would like to create a database. When i enter the command creta database feedback; it comes out this error 'create' is not recognized as an internal or external command, operable program or batch file How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Synopsis: Cannot create database Submitter-Id: [EMAIL PROTECTED] Originator: Diana Organization: Student from Multimedia Universuty MySQL support: licence Severity: non-critical Priority: medium | high Category: mysql client Class: sw-bug doc-bug change-request support Release:mysql-3.23.38 Exectutable: [mysqld, mysqld-shareware, mysqld-nt or mysqld-opt] Environment: machine description System:XP Compiler: VC++ 6.0 Architecture: i -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database problem
dEeZAcK SweETtY wrote: __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: cannot create database Description: I have already set the path to c:\mysql\bin and would like to create a database. When i enter the command creta database feedback; it comes out this error 'create' is not recognized as an internal or external command, operable program or batch file How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Synopsis: Cannot create database Submitter-Id: [EMAIL PROTECTED] Originator: Diana Organization: Student from Multimedia Universuty MySQL support: licence Severity: non-critical Priority: medium | high Category: mysql client Class: sw-bug doc-bug change-request support Release: mysql-3.23.38 Exectutable: [mysqld, mysqld-shareware, mysqld-nt or mysqld-opt] Environment: machine description System:XP Compiler: VC++ 6.0 Architecture: i You are trying to run mysql client commands from the Windows/Dos command line. But: 1. Delete the spam. If it looks like spam why read it? 2. Do not send attachments. Many people do not read attachments. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database problem
dEeZAcK SweETtY [EMAIL PROTECTED] wrote on 09/01/2005 10:27:28 AM: __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: cannot create database Description: I have already set the path to c:\mysql\bin and would like to create a database. When i enter the command creta database feedback; it comes out this error 'create' is not recognized as an internal or external command, operable program or batch file How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Synopsis: Cannot create database Submitter-Id: [EMAIL PROTECTED] Originator: Diana Organization: Student from Multimedia Universuty MySQL support: licence Severity: non-critical Priority: medium | high Category: mysql client Class: sw-bug doc-bug change-request support Release: mysql-3.23.38 Exectutable: [mysqld, mysqld-shareware, mysqld-nt or mysqld-opt] Environment: machine description System:XP Compiler: VC++ 6.0 Architecture: i This is not a bug but a training issue. Please, read the fine manual (RTFM). Not only does it tell you, step-by-step, how to set up a MySQL installation on XP but actually walks you step-by-step through some of the more common tasks of using it. Installation: http://dev.mysql.com/doc/mysql/en/windows-installation.html Basic tutorial: http://dev.mysql.com/doc/mysql/en/tutorial.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Safe Database Problem
Mike Miller [EMAIL PROTECTED] wrote: Hi, I believe I've done everything from the book and have been fighting with the same problem for about 6 hours thus far. I just upgraded from MySQL 3.23.56 to 4.0.17. In the old system, I prevented show databases from ordinary users using skip-show-databases. In order to upgrade I used the same data directory and ran the fix_privs script as instructed to all all of the required fields to the mysql.* tables as it did. ALl of this is successful and I can see it all there when I browse these tables. I did a flush privs, reloaded the whole daemon a few times to no avail. All users besides root have been revoked (actually they never had) show databases permission, yet all users are still able to execute show databses and receive a list of hundreds of databases. SHOW VARIABLES keeps telling me that skip show database is OFF, yet I can't seem to change it with any combo of startup parameters or set commands due to it being a 'depreciated variable' in all the docs. I don't see what I'm missing. Is there a trick with the new versions which I'm not getting? Check privileges of those users. If they have such global privileges (on all databases) as SELECT, UPDATE etc. or CREATE TEMPORARY TABLES, LOCK TABLES, they also can see databases in the output of SHOW DATABASES. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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]
Re: Safe Database Problem
Oh Jeeze- why didn't I think of removing this. When I upgraded the default is to have these two as 'Y', however, for some reason, that means that show databases shows all databases despite no permissions. That doesn't seem logical on one hand (if they don't have permissions to the database nor its tables, how could they create/lock on its tables), but on the other (they need to be able to see the databases to do a tmp table and a lock). In any case, problem fixed. I'm going to add a note to the docs to save people my troubles. Create_tmp_table_priv: Y Lock_tables_priv: Y Cheers; -M From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Safe Database Problem Date: Fri, 13 Feb 2004 13:38:50 +0200 Mike Miller [EMAIL PROTECTED] wrote: Hi, I believe I've done everything from the book and have been fighting with the same problem for about 6 hours thus far. I just upgraded from MySQL 3.23.56 to 4.0.17. In the old system, I prevented show databases from ordinary users using skip-show-databases. In order to upgrade I used the same data directory and ran the fix_privs script as instructed to all all of the required fields to the mysql.* tables as it did. ALl of this is successful and I can see it all there when I browse these tables. I did a flush privs, reloaded the whole daemon a few times to no avail. All users besides root have been revoked (actually they never had) show databases permission, yet all users are still able to execute show databses and receive a list of hundreds of databases. SHOW VARIABLES keeps telling me that skip show database is OFF, yet I can't seem to change it with any combo of startup parameters or set commands due to it being a 'depreciated variable' in all the docs. I don't see what I'm missing. Is there a trick with the new versions which I'm not getting? Check privileges of those users. If they have such global privileges (on all databases) as SELECT, UPDATE etc. or CREATE TEMPORARY TABLES, LOCK TABLES, they also can see databases in the output of SHOW DATABASES. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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] _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=dept/bcommpgmarket=en-caRU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Safe Database Problem
Hi, I believe I've done everything from the book and have been fighting with the same problem for about 6 hours thus far. I just upgraded from MySQL 3.23.56 to 4.0.17. In the old system, I prevented show databases from ordinary users using skip-show-databases. In order to upgrade I used the same data directory and ran the fix_privs script as instructed to all all of the required fields to the mysql.* tables as it did. ALl of this is successful and I can see it all there when I browse these tables. I did a flush privs, reloaded the whole daemon a few times to no avail. All users besides root have been revoked (actually they never had) show databases permission, yet all users are still able to execute show databses and receive a list of hundreds of databases. SHOW VARIABLES keeps telling me that skip show database is OFF, yet I can't seem to change it with any combo of startup parameters or set commands due to it being a 'depreciated variable' in all the docs. I don't see what I'm missing. Is there a trick with the new versions which I'm not getting? Thanks in advance, -M _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/viruspgmarket=en-caRU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database problem.
try to use the myisamchk to check/repair MyISAM tables Pablo Pragana wrote: I hope you can help me with this: Incorrect information in file: './sarara/searchindex.frm' Error consulta SQL : SHOW KEYS FROM `searchindex` MySQL ha dicho: #1033 - Incorrect information in file: './sarara/searchindex.frm' How can I fix this??? Thanks _ Consigue aquí las mejores y mas recientes ofertas de trabajo en América Latina y USA: http://latam.msn.com/empleos/ -- 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]
Database problem.
I hope you can help me with this: Incorrect information in file: './sarara/searchindex.frm' Error consulta SQL : SHOW KEYS FROM `searchindex` MySQL ha dicho: #1033 - Incorrect information in file: './sarara/searchindex.frm' How can I fix this??? Thanks _ Consigue aquí las mejores y mas recientes ofertas de trabajo en América Latina y USA: http://latam.msn.com/empleos/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Show database problem
Joris Beckers [EMAIL PROTECTED] wrote: I used the flush privileges command There are in total 6 databases But only mysql and cehdb are visible. The MySQL version is 4.1.0-max-nt There are no other hosts configured for that user other then % Because it's mysql 4, the safe-show-database option is not usefull All the users that existed function normal I tried making some other users All of them have the same problem Some show the mysql database, others show yet an other database It's strange. Can't find any reasonable explanation Really strange .. But I wasn't able to repeat it :( It worked fine for me for all users. What is the output of SELECT USER()? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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]
Re: Show database problem
When I enter : mysql\binSHOW GRANTS FOR uma; I get a response that show is not a command etc.. This is on Win32 version 4.x The same happens when I try it from mysql and also after I run mysqld Any ideas what is wrong here? Thanks Albert - Original Message - From: Joris Beckers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 01, 2003 11:19 AM Subject: Show database problem I've got a user, admFrederic He got the grants shown below. Those are correct and I configured them that way. mysql SHOW GRANTS FOR admFrederic; +--- + | Grants for [EMAIL PROTECTED] | +--- + | GRANT USAGE ON *.* TO 'admFrederic'@'%' IDENTIFIED BY PASSWORD '6ddf5e1a1cc75e8a' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER ON `cehdb`.* TO 'admFrederic'@'%' | +--- + But, when I log in using that username. That user can access the main database... mysql show databases; +--+ | Database | +--+ | cehdb| | mysql| +--+ Does anyone know how to fix this? Only cehdb should be accessable. Also, the user can run SQL commands on the mysql database. GRANT commands etc. are not possible. This is the version info. mysql status; -- mysql Ver 11.18 Distrib 3.23.53, for Win95/Win98 (i32) Connection id: 351 Current database: Current user: [EMAIL PROTECTED] Server version: 4.1.0-alpha-max-nt Protocol version: 10 Connection: nemesis via TCP/IP Client characterset:latin1 Server characterset:latin1 TCP port: Uptime: 1 hour 6 min 14 sec Thanks, Joris -- 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]
RE: Show database problem
Albert, This may sound minuscule. You're certain that 'uma' is a user account and not a database or table? Normally, you use SHOW GRANTS FOR user_account. See example: mysql SHOW GRANTS FOR test_usr; +--+ | Grants for [EMAIL PROTECTED] +--+ | GRANT USAGE ON *.* TO 'test_usr'@'% | GRANT ALL PRIVILEGES ON 'tempdb'.* TO 'test_usr'@'%' | GRANT ALL PRIVILEGES ON 'test'.* TO 'test_usr'@'%' +--+ However, if you attempt to show grants on an object with SHOW GRANTS FOR object_name you get the following error. See example: mysql SHOW GRANTS FOR tempdb; ERROR 1141: There is no such grant defined for user 'tempdb' on host '%' Albert, one suggestion. Next time provide the exact error message. It makes it easier to assist. Regards, Adam -Original Message- From: Albert [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 8:46 AM To: [EMAIL PROTECTED] Subject: Re: Show database problem When I enter : mysql\binSHOW GRANTS FOR uma; I get a response that show is not a command etc.. This is on Win32 version 4.x The same happens when I try it from mysql and also after I run mysqld Any ideas what is wrong here? Thanks Albert - Original Message - From: Joris Beckers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 01, 2003 11:19 AM Subject: Show database problem I've got a user, admFrederic He got the grants shown below. Those are correct and I configured them that way. mysql SHOW GRANTS FOR admFrederic; +--- + | Grants for [EMAIL PROTECTED] | +--- + | GRANT USAGE ON *.* TO 'admFrederic'@'%' IDENTIFIED BY PASSWORD '6ddf5e1a1cc75e8a' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER ON `cehdb`.* TO 'admFrederic'@'%' | +--- + But, when I log in using that username. That user can access the main database... mysql show databases; +--+ | Database | +--+ | cehdb| | mysql| +--+ Does anyone know how to fix this? Only cehdb should be accessable. Also, the user can run SQL commands on the mysql database. GRANT commands etc. are not possible. This is the version info. mysql status; -- mysql Ver 11.18 Distrib 3.23.53, for Win95/Win98 (i32) Connection id: 351 Current database: Current user: [EMAIL PROTECTED] Server version: 4.1.0-alpha-max-nt Protocol version: 10 Connection: nemesis via TCP/IP Client characterset:latin1 Server characterset:latin1 TCP port: Uptime: 1 hour 6 min 14 sec Thanks, Joris -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Show database problem
* Albert When I enter : mysql\binSHOW GRANTS FOR uma; I get a response that show is not a command etc.. This is on Win32 version 4.x The same happens when I try it from mysql and also after I run mysqld Any ideas what is wrong here? When you say you try it from mysql do you mean standing in the mysql directory in the command promt? In that case, that would be the explanation. When you see mysql on this list, it means the mysql SQL shell, AKA the mysql command line, AKA the mysql monitor, AKA the standard client. It is an executable in the mysql/bin directory, named mysql.exe on win32. Execute this program, and then enter your SQL commands. URL: http://www.mysql.com/doc/en/mysql.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Show database problem
This is the error I get and yes uma is a user and listed in my.ini file actually C:\mysql\binSHOW GRANTS FOR uma; 'SHOW' is not recognized as an internal or external command, operable program or batch file. C:\mysql\bin Albert - Original Message - From: Fortuno, Adam [EMAIL PROTECTED] To: 'Albert' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 9:38 AM Subject: RE: Show database problem Albert, This may sound minuscule. You're certain that 'uma' is a user account and not a database or table? Normally, you use SHOW GRANTS FOR user_account. See example: mysql SHOW GRANTS FOR test_usr; +--+ | Grants for [EMAIL PROTECTED] +--+ | GRANT USAGE ON *.* TO 'test_usr'@'% | GRANT ALL PRIVILEGES ON 'tempdb'.* TO 'test_usr'@'%' | GRANT ALL PRIVILEGES ON 'test'.* TO 'test_usr'@'%' +--+ However, if you attempt to show grants on an object with SHOW GRANTS FOR object_name you get the following error. See example: mysql SHOW GRANTS FOR tempdb; ERROR 1141: There is no such grant defined for user 'tempdb' on host '%' Albert, one suggestion. Next time provide the exact error message. It makes it easier to assist. Regards, Adam -Original Message- From: Albert [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 8:46 AM To: [EMAIL PROTECTED] Subject: Re: Show database problem When I enter : mysql\binSHOW GRANTS FOR uma; I get a response that show is not a command etc.. This is on Win32 version 4.x The same happens when I try it from mysql and also after I run mysqld Any ideas what is wrong here? Thanks Albert - Original Message - From: Joris Beckers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 01, 2003 11:19 AM Subject: Show database problem I've got a user, admFrederic He got the grants shown below. Those are correct and I configured them that way. mysql SHOW GRANTS FOR admFrederic; +--- + | Grants for [EMAIL PROTECTED] | +--- + | GRANT USAGE ON *.* TO 'admFrederic'@'%' IDENTIFIED BY PASSWORD '6ddf5e1a1cc75e8a' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER ON `cehdb`.* TO 'admFrederic'@'%' | +--- + But, when I log in using that username. That user can access the main database... mysql show databases; +--+ | Database | +--+ | cehdb| | mysql| +--+ Does anyone know how to fix this? Only cehdb should be accessable. Also, the user can run SQL commands on the mysql database. GRANT commands etc. are not possible. This is the version info. mysql status; -- mysql Ver 11.18 Distrib 3.23.53, for Win95/Win98 (i32) Connection id: 351 Current database: Current user: [EMAIL PROTECTED] Server version: 4.1.0-alpha-max-nt Protocol version: 10 Connection: nemesis via TCP/IP Client characterset:latin1 Server characterset:latin1 TCP port: Uptime: 1 hour 6 min 14 sec Thanks, Joris -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Show database problem
Stefan, Indeed, and my mistake (semantics). I meant what you explained. It is clear to me that the order in the table remains in the manner the data were entered, and that cannot be changed, unless a record is deleted and then re-entered, which would place it elsewhere (at the end). This does not really have any benefits IMHO. And yes, I understand that it is the output that is sorted based on the query. Thanks for clarifying this, and as I read my question, I should have seen the difference myself. Mea culpa! : =) I am quite familiar with SQL Server 2000, but need to use MySQL for a project for the University I am at (Devry Alpharetta, Atlanta), to capture the input from a student survey of the classes and the Faculty members. There are several fields: semester (char), course(char), courseID (int), Faculty (varchar[30] - if that is acceptable in that format - and the answers to 18 questions, all alpha characters (char) or numeric char (int), and one Boolean (yes/no or 1,0). I need to figure out how to best structure this, e.g. create tables on the fly (if that is possible using ASP/ADO and SQL with ODBC connector), or create tables with many to many relationships and store the data for each course survey in a separate table. The tables with many to many relationships would hold all the courses, courseID's, and Faculty members, and the answers to the survey would create links between those and the results from the surveys. A typical class unique identification would look like this: sum03_FBaah_CIS_349 The cols would be 1 through 18 + a calculation col for the average of questions 1 to 18 and a col for the average of all answers to question 1, question 2, etc ... Mind you I may export the answers to an excel spreadsheet and do the calculations there rather than in the DB itself. Anyway this is a long answer to your response but I wanted those who read this to get an idea of what I am working with. Any suggestions are welcomed. Albert - Original Message - From: Fortuno, Adam [EMAIL PROTECTED] To: 'Albert' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 9:38 AM Subject: RE: Show database problem .com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Show database problem
On Tue, 2 Sep 2003 08:45:42 -0400 Albert [EMAIL PROTECTED] wrote: When I enter : mysql\binSHOW GRANTS FOR uma; I get a response that show is not a command etc.. This is on Win32 version 4.x The same happens when I try it from mysql and also after I run mysqld Any ideas what is wrong here? Thanks you should enter this in mysql console, not in shell. run .../mysql/bin/mysql binary (--help option will show you all possible keys) and then enter MySQL commands. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Show database problem
OK I think I got it, in Win32 it has to be done from the mysql client screen and not from the command prompt. Either that or use another GUI client as the front end for MySQL I guess and I have had some suggestions on that one. I will try doing so. Thanks for the help Albert - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Albert [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 9:36 AM Subject: Re: Show database problem * Albert When I enter : mysql\binSHOW GRANTS FOR uma; I get a response that show is not a command etc.. This is on Win32 version 4.x The same happens when I try it from mysql and also after I run mysqld Any ideas what is wrong here? When you say you try it from mysql do you mean standing in the mysql directory in the command promt? In that case, that would be the explanation. When you see mysql on this list, it means the mysql SQL shell, AKA the mysql command line, AKA the mysql monitor, AKA the standard client. It is an executable in the mysql/bin directory, named mysql.exe on win32. Execute this program, and then enter your SQL commands. URL: http://www.mysql.com/doc/en/mysql.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Show database problem
I've got a user, admFrederic He got the grants shown below. Those are correct and I configured them that way. mysql SHOW GRANTS FOR admFrederic; +--- + | Grants for [EMAIL PROTECTED] | +--- + | GRANT USAGE ON *.* TO 'admFrederic'@'%' IDENTIFIED BY PASSWORD '6ddf5e1a1cc75e8a' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER ON `cehdb`.* TO 'admFrederic'@'%' | +--- + But, when I log in using that username. That user can access the main database... mysql show databases; +--+ | Database | +--+ | cehdb| | mysql| +--+ Does anyone know how to fix this? Only cehdb should be accessable. Also, the user can run SQL commands on the mysql database. GRANT commands etc. are not possible. This is the version info. mysql status; -- mysql Ver 11.18 Distrib 3.23.53, for Win95/Win98 (i32) Connection id: 351 Current database: Current user: [EMAIL PROTECTED] Server version: 4.1.0-alpha-max-nt Protocol version: 10 Connection: nemesis via TCP/IP Client characterset:latin1 Server characterset:latin1 TCP port: Uptime: 1 hour 6 min 14 sec Thanks, Joris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Show database problem
On Mon, 1 Sep 2003 17:19:52 +0200 Joris Beckers [EMAIL PROTECTED] wrote: I've got a user, admFrederic He got the grants shown below. Those are correct and I configured them that way. don't forget about FLUSH PRIVILEGES; --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Show database problem
On Monday, September 01, 2003 5:19 PM CEST, Joris Beckers wrote: But, when I log in using that username. That user can access the main database... snip Does anyone know how to fix this? Only cehdb should be accessable. Did you try to set the safe-show-database flag? Hm, let me see where I have put this... OK, I put it in my c:\winnt\my.ini. Here's the line: [mysqld] safe-show-database This is generally the way to hide non-rights databases to users, on MySQL 3. It's the default behaviour since MySQL 4. Also, the user can run SQL commands on the mysql database. What does that mean? The user can successfully SELECT data from mysql.* ? Then it's a granted privilege that enables him to do so. Did you look at other GRANTS for other hosts than % ? This is the version info. mysql status; -- mysql Ver 11.18 Distrib 3.23.53, for Win95/Win98 (i32) Connection id: 351 Current database: Current user: [EMAIL PROTECTED] Server version: 4.1.0-alpha-max-nt Protocol version: 10 Connection: nemesis via TCP/IP Client characterset:latin1 Server characterset:latin1 TCP port: Uptime: 1 hour 6 min 14 sec What's the MySQL server version here, please? 3.23.53 (win) or 4.1.0-max-nt? Can't interpret your information here very well... -- Yves Goergen [EMAIL PROTECTED] Please don't CC me (causes double mails) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Show database problem
I used the flush privileges command There are in total 6 databases But only mysql and cehdb are visible. The MySQL version is 4.1.0-max-nt There are no other hosts configured for that user other then % Because it's mysql 4, the safe-show-database option is not usefull All the users that existed function normal I tried making some other users All of them have the same problem Some show the mysql database, others show yet an other database It's strange. Can't find any reasonable explanation But, when I log in using that username. That user can access the main database... snip Does anyone know how to fix this? Only cehdb should be accessable. Did you try to set the safe-show-database flag? Hm, let me see where I have put this... OK, I put it in my c:\winnt\my.ini. Here's the line: [mysqld] safe-show-database This is generally the way to hide non-rights databases to users, on MySQL 3. It's the default behaviour since MySQL 4. Also, the user can run SQL commands on the mysql database. What does that mean? The user can successfully SELECT data from mysql.* ? Then it's a granted privilege that enables him to do so. Did you look at other GRANTS for other hosts than % ? This is the version info. mysql status; -- mysql Ver 11.18 Distrib 3.23.53, for Win95/Win98 (i32) Connection id: 351 Current database: Current user: [EMAIL PROTECTED] Server version: 4.1.0-alpha-max-nt Protocol version: 10 Connection: nemesis via TCP/IP Client characterset:latin1 Server characterset:latin1 TCP port: Uptime: 1 hour 6 min 14 sec What's the MySQL server version here, please? 3.23.53 (win) or 4.1.0-max-nt? Can't interpret your information here very well... -- Yves Goergen [EMAIL PROTECTED] Please don't CC me (causes double mails) http://firstknight.no-ip.com:4001/PixelBug.asp?Seed=030901210342
DATABASE PROBLEM
HI! there is a problem in mysql database.there r two tables.one table is named as transactions and the other is named as the code.the transactions table has got the 12 fields which r the following 1.clientid int 2.date date 3.isinno text 4.debit int 5.credit int 6.desc text 7.dpid1 text 8.nsdlid int 9. desc1 text 10. desc2 text 11. dpid bigint 12.transno int All these fields r by default NULL the code table has got the 8 fields which r the following 1.rd smallint 2.transno int 3.status tinyint 4.status1 tinyint 5.cdate date 6.clientid int 7. isinno text 8.description text . All these fields r by default NULL I am writing this query but its not giving the recquired results i.e i want it should pick up the all the fields of both the tables without any duplicate enteries. SELECT * from transactions,holdings,code where transactions.clientid=holdings.clientid and transactions.isinno=code.isinno and transactions.isinno=' INE561A01013' and transactions.transno='4509'AND FROM_DAYS(transactions.date) - TO_DAYS(holdings.hdate) group by transactions.credit,code.description Basically the problem with the above query is that its giving the duplicate enteries . plz. solve my problem at the earliest.its very urgent. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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
database problem
hi everybody, i have problem with storing chinese word to databaseall the chinese automatic change to code like this #31639;#30424;#12290; its not only waste the space, also i have problem to display it...sometime, some of the word not complete and also display symbols.is there anybody can help me? Please help mei am stuck here.. sql thanks in advance regards, saras _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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
Re: database problem
On Wed, 10 Apr 2002 03:59:22 + saraswathy saras [EMAIL PROTECTED] wrote: hi everybody, i have problem with storing chinese word to databaseall the chinese automatic change to code like this #31639;#30424;#12290; its not only waste the space, also i have problem to display it...sometime, some of the word not complete and also display symbols.is there anybody can help me? Please help mei am stuck here.. It's a problem of UNICODE ... you have to set your mysql with Chinese Unicode char. but still the data will be and should be remain with #31639;#30424;#12290; codes ... it's only a matter on terminal or software that will retreive / read the data ... if the terminal/software doesn't support Chinese Unicode ... so data will not be translated into proper way. -- Let's call it an accidental feature. -- Larry Wall - 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
Symbolically linked database, unknown database problem.
I've created databases on a partition without problems, now I come to create a new database on a different partition and I can't access the database at all. At this stage I have the following in the mysql data directory (among others): lrwxrwxrwx1 mysqlmysql 17 Sep 3 11:56 candi - /asp/mysql/candi/ lrwxrwxrwx1 mysqlmysql 24 Dec 7 12:40 cc - /home/fastbase/cc/mysql/ The first database (candi) is fine (along with others in the /asp/mysql path) but the cc database is not accessible. If I log-in as user mysql I can access that directory fine so I thought it may be another problem but I guess rights may still be an issue. Any ideas? What are the rules/requirements for mysql to recognise the database directory? I haven't created any tables yet (as I can't access the database). Peter Campbell http://www.fastbase.co.nz Phone NZ 04 385 2230, Fax 04 385 2224. - 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: Symbolically linked database, unknown database problem.
Hi, Try ls -Ll cc, to check that the link is valid and to see the permissions on the destination. HTH Quentin -Original Message- From: Peter Campbell [mailto:[EMAIL PROTECTED]] Sent: Friday, 7 December 2001 12:57 p.m. To: [EMAIL PROTECTED] Subject: Symbolically linked database, unknown database problem. I've created databases on a partition without problems, now I come to create a new database on a different partition and I can't access the database at all. At this stage I have the following in the mysql data directory (among others): lrwxrwxrwx1 mysqlmysql 17 Sep 3 11:56 candi - /asp/mysql/candi/ lrwxrwxrwx1 mysqlmysql 24 Dec 7 12:40 cc - /home/fastbase/cc/mysql/ The first database (candi) is fine (along with others in the /asp/mysql path) but the cc database is not accessible. If I log-in as user mysql I can access that directory fine so I thought it may be another problem but I guess rights may still be an issue. Any ideas? What are the rules/requirements for mysql to recognise the database directory? I haven't created any tables yet (as I can't access the database). Peter Campbell http://www.fastbase.co.nz Phone NZ 04 385 2230, Fax 04 385 2224. - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
create database problem
Hi !!! I'm new in this ml. I've installed MySQL on my linux box follow the instruction ... I have : create user mysql create group mysql compiled mysql exec the script install_db changed permission etc ... all this operation are doing by root user. I can connect to the db 'test' without problem, but if I want to connect the 'mysql' db (with any user, root, mysql, etc) mysql give me the error 1004 say me that the user @locahost have no the permission to do this. This error appear me if I want create a new database. In the db 'test' I can create/delete and use table. I search on line and I see more people have this problem ... but I don't find the solution. I search on the documentation but this don't solve this problem. Excuse me if this is a stupid problem Thanks in advance at all Emiliano __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.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
Re: create database problem
Show us what you type, and what error message you get. Emiliano Carlesi wrote: Hi !!! I'm new in this ml. I've installed MySQL on my linux box follow the instruction ... I have : create user mysql create group mysql compiled mysql exec the script install_db changed permission etc ... all this operation are doing by root user. I can connect to the db 'test' without problem, but if I want to connect the 'mysql' db (with any user, root, mysql, etc) mysql give me the error 1004 say me that the user @locahost have no the permission to do this. This error appear me if I want create a new database. In the db 'test' I can create/delete and use table. I search on line and I see more people have this problem ... but I don't find the solution. I search on the documentation but this don't solve this problem. Excuse me if this is a stupid problem Thanks in advance at all Emiliano __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.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 -- Gerald L. Clark [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: create database problem
Hi !!! Scuse me if before I insert few data to analize the problem :-) Now at the shell I insert the command 'mysql' then at the prompt of mysql if I insert the command 'connect test' this work and I can use sql command to work on the database. If I else insert 'connect mysql' (the other db created by the script mysql_install_db) the result is this error ERROR 1044: Access denied for user: '@localhost' to database 'mysql' If I launch mysql and when appear me the prompt 'mysql' insert the command 'CREATE DATABASE pippo;' the result is ERROR 1044: Access denied for user: '@localhost' to database 'pippo' This problem exist using all user on the system (root included). Thanks in advance for your interesting Emiliano On Thursday 06 September 2001 17:05, you wrote: Show us what you type, and what error message you get. Emiliano Carlesi wrote: Hi !!! I'm new in this ml. I've installed MySQL on my linux box follow the instruction ... I have : create user mysql create group mysql compiled mysql exec the script install_db changed permission etc ... all this operation are doing by root user. I can connect to the db 'test' without problem, but if I want to connect the 'mysql' db (with any user, root, mysql, etc) mysql give me the error 1004 say me that the user @locahost have no the permission to do this. This error appear me if I want create a new database. In the db 'test' I can create/delete and use table. I search on line and I see more people have this problem ... but I don't find the solution. I search on the documentation but this don't solve this problem. Excuse me if this is a stupid problem Thanks in advance at all Emiliano __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.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
RE: create database problem
Ok The problem are that I have checked this command but after I insert the root (unix root) and not the db root. Thanks you very much ! Emiliano --- Sheena Sidhu [EMAIL PROTECTED] wrote: emiliano , the reason you cannot use mysql to connect to use mysql database but can use test is because you do not have permissions to use mysql database. try connecting as mysql -u root -p when prompted enter the root password. after being connected, look into the users and db table of mysql database. this will give you clues why you cannot do somethings that you mentioned in ur mail. Sheena. -Original Message- From: emiliano [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 12:55 PM To: [EMAIL PROTECTED] Subject: Re: create database problem Hi !!! Scuse me if before I insert few data to analize the problem :-) Now at the shell I insert the command 'mysql' then at the prompt of mysql if I insert the command 'connect test' this work and I can use sql command to work on the database. If I else insert 'connect mysql' (the other db created by the script mysql_install_db) the result is this error ERROR 1044: Access denied for user: '@localhost' to database 'mysql' If I launch mysql and when appear me the prompt 'mysql' insert the command 'CREATE DATABASE pippo;' the result is ERROR 1044: Access denied for user: '@localhost' to database 'pippo' This problem exist using all user on the system (root included). Thanks in advance for your interesting Emiliano On Thursday 06 September 2001 17:05, you wrote: Show us what you type, and what error message you get. Emiliano Carlesi wrote: Hi !!! I'm new in this ml. I've installed MySQL on my linux box follow the instruction ... I have : create user mysql create group mysql compiled mysql exec the script install_db changed permission etc ... all this operation are doing by root user. I can connect to the db 'test' without problem, but if I want to connect the 'mysql' db (with any user, root, mysql, etc) mysql give me the error 1004 say me that the user @locahost have no the permission to do this. This error appear me if I want create a new database. In the db 'test' I can create/delete and use table. I search on line and I see more people have this problem ... but I don't find the solution. I search on the documentation but this don't solve this problem. Excuse me if this is a stupid problem Thanks in advance at all Emiliano __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.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 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.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
Unknown database problem
Hi! I having a very weird unpredictable problem. A script run from cron at 2:00am every day must conect to database 'ubex' and do some stuff with it. The script is in perl and uses DBI. It works fine pretty much all the time but sometimes (1 or 2 time per month) it gives an error: Unknown database 'ubex' Mysql is 3.23.40, OS is FreeBSD 4.4-RC, Perl is 5.005_03 DBI.pm is 1.14 (ID: v. 10.32 2000/06/14 20:04:03) MySQL DBD is 2.0409 (ID: v 1.5 1999/10/03 17:46:19) The same happens with other databases accessed from a script run from a cron. What could be wrong? Regards, Artem - 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: create database problem
mysqladmin --help will provide you with a list of switches you can use. If you add -u root to the shell command , perhaps you'll have more success. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 16:37 Subject: create database problem shellmysqladmin create trial mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'trial'' why this happened i only can use test database by default - 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
upgrade / database problem?
Am running Redhat 7.0, and had installed. 3.23.22. with php4.0. Would like to upgrade to 3.23.32. No existing tables or data. Any major problems anyone having with .32 version on 7.0 redhat? Also, any special steps to upgrade rpm and keep php4.0 intact? What add'l libraries are needed? What about existing tables / data? Will it affect exsiting database. Thanx Marc - 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 database-problem: deletion of rows
On Sun, Feb 25, 2001 at 12:16:39AM +0100, Katja Ide wrote: Hi everyone, We've got a database with 46 tables running on the server of Schlund for four months now. During these four months we've been inserting data into the database by PHP-scripts without any problem whatsoever - until two weeks ago. Then we suddenly noticed that some of the data had disappeared: it had been deleted from the database. These deletions mostly followed the same structure: I've only seen this when my data files wrapped the 4G limit in 3.22.27. Data would just be gone without an error message that the table was full or any sign that the table was corrupted (I didn't do an isamchk though). The oldest data would always disappear. What MySQL version and what type of tables (ISAM/MyISAM) do you use? Did you run an (my)isamchk on the tables? Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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
Strange database-problem: deletion of rows
Hi everyone, I've got a problem with my MySQL-Database that I've been dealing with for nearly two weeks now and I don't seem to get a clue of what it's about. My webspace-provider (Schlund Partner in Germany: http://www.schlund.de) doesn't have a solution either, nor have some of my expert-friends I asked - that's why I hope you might be able to help me. Maybe this is a known problem... We've got a database with 46 tables running on the server of Schlund for four months now. During these four months we've been inserting data into the database by PHP-scripts without any problem whatsoever - until two weeks ago. Then we suddenly noticed that some of the data had disappeared: it had been deleted from the database. These deletions mostly followed the same structure: 1.) they happened only after (or maybe during, I don't know) inserting data into the database 2.) they deleted a series of rows from a single table 3.) the number of rows and the "starting point" from which on the data was deleted was always different: sometimes the data between ID 120 and ID 248 was deleted, sometimes the rows between 96 and 168... and so on... 4.) the row before the deleted rows (e.i: in the examples noted above row 119 or row 95) was always changed: one of the values was set to "0" (only exception: the last deletion that happened today where the last row wasn't changed- strangely enough, this one was different for several reasons) 5.) the row inserted directly before (or during) the deletion stayed completely "untouched": every data was inserted correctly (only exception again: the last deletion). 6.) after the rows were deleted, the information given in the phpMyAdmin-interface (Version 2.1.0) I'm using for administration of the database (only for special cases, normally every data is inserted and changed by the php-scripts) seems to indicate that the data still is "hidden" somewhere: in the table affected today for example there were 22 rows and after inserting the 23rd row the rows from 7 up to 23 where deleted, and the "Browse"-Option of the phpMyAdmin-interface (which interprets the query: "SELECT * FROM D_Newsletter LIMIT 0, 30") says "Showing records 0 - 29 (23 total, 6 in query)" and then lists the 6 rows left after deletion. The strange thing is that today there seems to have been a "change of plans": it was the first time that a different kind of table was affected, that no row has been set to "0" and that the latest entry wasn't kept untouched but wasn't inserted at all. Well, so much for the problem, this is the most detailed description I can give you, I hope I didn't forget anything. I'm pretty sure the problem can't be in the PHP-scripts we're inserting the data with, because 1.) we've been inserting data with these scripts for four months now without any problem, and most of the scripts have been unchanged since then. 2.) it's always a different table that's affected and always a different number of rows 3.) the deletions don't happen after every insertion. Of course, I've checked all the scripts, but I couldn't find any errors that could have caused something like that. I know all this sounds pretty strange, but my last hope is that you might have heard of some problem like this before, and maybe you can even think of a solution, that would be really great - or at least some information I can give to my provider; until today they are sure it must be a problem in my scripts. Thanks a lot for your help, yours, Katja Ide Webmaster of dvd-headquarters.de http://www.dvd-headquarters.de mailto: [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
