Re: Indexing question

Thanks Gavin and Joerg, that was very helpful! -- Jonas On Sun, Oct 3, 2010 at 12:44 PM, Joerg Bruehe wrote: > Hi Neil, all! > > > Tompkins Neil wrote: > > So if you have individual indexes for example field_1, field_2 and > field_3 > > etc and then perform a search

Indexing question

x27;user_id' = something and 'product_id' in (list, of, ids), ordered by 'created'. Do I need two separate indexes, one on 'created' and another on ('user_id', 'product_id', 'created'), or does having only the latter suffice the former case? -- Jonas, http://jonasgalvez.com.br

Re bug#45458

Hi, I just filed http://bugs.mysql.com/bug.php?id=51687 which is very related to your bug#45458. If you would care to look at it and provide feedback, I would appreciate it. /Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Change clock/timezone time without restart mysql

Hi, I need to change the computer clock (changing the /etc/zoneinfo) but I would not restart de MySQL service. The NOW() still returning the old time... Thanks, Jonas

Re: Alter Table - InnoDB

ands: -rw-rw 1 mysql mysql 85G 2008-12-04 12:04 ibdata1 The Ibdata file before all alter table commands: -rw-rw 1 mysql mysql 60G 2008-12-03 18:04 ibdata1 Greets, Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lis

Re: Alter Table - InnoDB

s this is an production database :( Greets, Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Alter Table - InnoDB

Hi Ananda, > Since u have cancled the job, those in-complete temp files can be > deleted from the file system. ok - but I'm using InnoDB. The IBdata file is bumped up. There are no temp files on the database directory. Greets, Jonas -- MySQL General Mailing List For li

Alter Table - InnoDB

command. How I can remove the temp tables? - I have also read at some bug reports if I now restart the database mysql performs an InnoDB recovery and restores an old temp table to the current table! Is this correct? Thanks, Jonas -- MySQL General Mailing List For list archives: http

SSL Connection and emty SSL_CIPHER

t | /etc/ssl/private/mysql-server.crt | | ssl_cipher|| | ssl_key | /etc/ssl/private/mysql-server.key | +---++ Now I limited MySQL remote connections for user 'jonas' to SSL: mysql>

memory usage in relation to open connections

sed memory. the system has 1GB ram, and according to statistics most of it is already in use. current value of max_connections for MySQL is 160. are there any algorithms to calculate the average/maximum memory usage? thanks in advance, jonas PS: i'm not subscribed to the list, please C

Grouping and summering

Customer A DB Dev DB Customer B DB 0,75 Is this possible in any way? Would be very pleased for a bit of help. Thanks in advance // Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Access Denied in Query Browser

Hello, I get an error message when I start Query Browser. Could not fetch Catalogs/Schema data. The following error occured: Access denied; you need the SHOW DATABASES priviliege for this operation. My hosting provider has started their server with --skip-show-database. Is it possible to get

Re: Where to store comments?

Martijn van den Burg wrote: On Wednesday 28 September 2005 20:47, Siegfried Heintze wrote: Other databases allow one to store comments describing each field in a table definition. These are stored in the database. In addition, one can store comments about the table. Examples include MS SQL S

mysql_store_result -> Error: 2000 (CR_UNKNOWN_ERROR) Message: Unknown MySQL error

Hello, I have searched high and low for more specifics to the problem I am having but to no avail. Hopefully someone here can help. I really appreciate any knowledge that may be imparted. On to the question! We have numerous mail servers running qmail/vpopmail with MySQL used as the backend. Pass

RE: Row level security requirements, can I still use MySQL?

arked as excluded from the "global access option". But your suggestion of removing the "root" user would solve my problem but increase administration?. /jonas -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED] Sent: den 18 november 2004 14:29 To: Jonas Ladenf

RE: Row level security requirements, can I still use MySQL?

nteresting. Here it is (not MySQL but the "mind-work" might be interesting). http://www.securityfocus.com/infocus/1743 Regards /Jonas -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: den 18 november 2004 12:48 To: Jonas Ladenfors Cc: Mysql (E-mail) Su

RE: Row level security requirements, can I still use MySQL?

might not be applicable to this solution. Regards /Jonas -Original Message- From: Luke Venediger [mailto:[EMAIL PROTECTED] Sent: den 18 november 2004 12:35 To: Jonas Ladenfors Cc: Peter Lovatt; [EMAIL PROTECTED] Subject: Re: Row level security requirements, can I still use MySQL? Hi, I

RE: Row level security requirements, can I still use MySQL?

per user level, is this possible in this solution? /Jonas Hi I use a system based on linux securuty model create groups - this will define access to the data, so you need to group the data - and encrypt data the group can access using the password belonging to that group. make users members of

RE: Row level security requirements, can I still use MySQL?

;) What I have been thinking about is some low-level way where you as an administrator can control users and groups and place restrictions on each row by tagging the row in some way? Or the user could tag his rows in someway. Is this how other RDBMS enforce access restrictions? Regards /Jonas

Row level security requirements, can I still use MySQL?

t something I do not fully understand and that I cannot guaranty that the end result will have the security I claim. Is this possible in MySQL? Does anyone know if it cab be performed with other RDBMS? Regards /Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/

RE: Importing Excel Data in MySql

I use a tool called navicat. In supports excel imports excellent. They have a shareware version on their page you can try out. www.navicat.com Regards /Jonas -Original Message- From: Bertrand Gac [mailto:[EMAIL PROTECTED] Sent: den 21 oktober 2004 09:09 To: mysql Subject: Importing

Choosing the correct my.cnf

have placed the my.cnf in the root directory of my mysql5 directory (/usr/local/mysql5/my.cnf) but I dont know how to force mysqld_safe to read that file and not the one in /etc/my.cnf. Could someone give my a solution on how to fix this? Thanks in advance /Jonas --- Jonas

Re: server is getting slower and slower

Jonas --- Aman Raheja <[EMAIL PROTECTED]> schrieb: > Is the MySQL server 4.1 - default installed? Did you > change any > parameters (variables) for it? > Have you checked the network performance otherwise? > I can't really think of anything that the MySQL > ser

Re: server is getting slower and slower

terminals. This is why it has to do something with the server. I'm running mysql 4.1 on a Suse linux distribution 8.2 Like I said before I had the response within seconds. Right now the terminal is sending the data and is waiting for a response which will take up to two minutes. Jonas ---

server is getting slower and slower

that they will receive the response of the server. How can I make the servers response faster? Thank you very much Jonas ___ Gesendet von Yahoo! Mail - Jetzt mit 100MB Speicher kostenlos - Hier anmelden

Specify which domain to connect from

Hello, Is there someway to specify which domain one would like to connect from in the mysql console. When connecting on my server I always get connected through localhost. I would like to connect through my DNS name. quasi example : mysql -u [EMAIL PROTECTED] -p regards /Jonas -- MySQL

Help needed with a select statement

much for your help. Jonas ___ Gesendet von Yahoo! Mail - Jetzt mit 100MB Speicher kostenlos - Hier anmelden: http://mail.yahoo.de -- MySQL General Mailing List For list archives: http://lists.mysql.com

SV: ER Diagrams with mysql

I have been using dbdesigner from fabforce. An excellent tool for visual design. It also has a reverse engineer feature. http://www.fabforce.net/dbdesigner4/ regards /Jonas Hi, i created a database with around 20 tables. However i created the tables by script writting all create table

Possible bug in mysqldump with 5.0.0/InnoDB & longblobs?

later use "LOAD DATA INFILE" to restore it correctly. How I use mysqldump: mysqldump --add-drop-table --force --single-transaction -u user -p password myDB > dumpfile My linux specs: MySQL 5.0.0-alpha InnoDB tables My OpenBSD specs: MySQL 5.0.0 debug binary release from mysql.com InnoDB tables /Jonas

Re: Large database with High Availability - how to do it?

ly not be finished until the end of this year. Regards, Jonas Oreland -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Large database with High Availability - how to do it?

Hi Daniel, Daniel Ek wrote: Jonas Oreland wrote: Hi Daniel, Daniel Ek wrote: I really thought that MySQL tried to produce MySQL cluster for common hardware and with the design principle; more nodes with common hardware, insted of few nodes with extreme hardware. we do. I will probably never

Re: Large database with High Availability - how to do it?

Jochem van Dieten wrote: Daniel Ek wrote: Jonas Oreland wrote: Daniel Ek wrote: I today have a database using 20GB storage, which actually means that I should have at least 30GB (40GB recommended) ram using Mysql cluster. This could be 40 boxes with 1G ram each. But doesn't that increas

mysql & blobs

ile I restore the backupFile with mysql -uxxx -pxxx < backupFile Everything is included in the restured database except the blob data. When I look in backup file I can see that all my blod data has been replaced by "-". What causes this? Regards /Jonas

Re: Select statement returning to many answers

Thank you everyone that responded, You were all correct. The query performed a cartesian product. I added a where statement and all was fine again. Thanks! /Jonas - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: M

Select statement returning to many answers

as b, cd_donor as d; Why does this happend? I thought that these two queries would return the exact same amout of rows. Is there something I have forgotten or is the debug release of 5.x.x errornous? Regards /Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

LDAP and MySQL?

Has anyone fooled around with LDAP and MySQL? Could the standard user table in mysql be replaced with a LDAP binding? Have not done any research but I think I remeber people talking about this some time ago. Or maybe I am mistaken ;). Anyone tried something like this? /Jonas

NetBSD & MySQL

Are there any NetBSD users on this list? Has anyone succesfully compiled MySQL 4.1x or 5.x on NetBSD? Why arent they in pkgsrc? Not just done yet or did something happend in the 4.1.x release that stopped MySQL from working on NetBSD? Regards /Jonas

Managing users in different OS enviroments with MySQL

our active directory? Or is that not a smart way to go? Any suggestions are welcome /Jonas

Re: Changeing a columns type with alter

Doh! dont bother I found it in the manual ALTER TABLE t1 CHANGE c1 c1 BLOB; /Jonas - Original Message - From: "Jonas Lindén" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 15, 2004 9:46 AM Subject: Changeing a columns type with alter Hello l

Changeing a columns type with alter

Hello list, Could anyone help me on how I go about if I would like to change a coulmns type from say INT to FLOAT? Should I use the ALTER command? I cant seem to find any info on it in the manual. Regards /Jonas

Re: Binlog strangeness?

Hi MySQL 5.0.0, Mandrake 9.2 and the error pointed to my alter table statement where tried to add a foreign key constraint. I have been fiddling a little bit with replication priot to this error but I commented all of that data out of the my.cnf file. Regards /Jonas - Original

Binlog strangeness?

bin log interfere with my data? Does MySQL read bin log and compare them in some way with new data? Anyone ? /Jonas

Re: Replication between different database names

Hello, Is this what you are lookin for? --replicate-rewrite-db=from_name->to_name Regards /Jonas > I have a central mysql server that is required to be a slave to many > different master databases on my customer sites. > > Is it possible to replicate many masters to one slave wh

Re: Problems replicating

Hola, I figured it out myself, The problem was that I didnt specify any tables. I thought that if you replicated a database the tables would be included. That is not the case. I added this to make it work. Replicate_Wild_Do_Table: CellDB%.% Regards /Jonas - Original Message - From

Problems replicating

Hello, I still trying to get my replication working witout success. I included show processlist and show slave status. Can anyone make out from them what I am lacking? I am running mysql 5.0.0 on a linux master trying to replicate them on a windows slave Best regards /Jonas

Re: Transaction Not supported

Sorry Mike, Joshua is absolutly correct. Dont listen to my nonses ;) What I did was trying to use something like this which to my knowledge doesnt work on MySQL servers. $dbh->commit(); $dbh->rollback(); /Jonas > - Original Message - > From: "Joshua J. Kugler&q

Re: Transaction Not supported

I dont think that transactions are supported (yet?) by the PERL DBI. /Jonas - Original Message - From: "Mike Blezien" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, March 30, 2004 9:42 PM Subject: Transaction Not supported

row level access?

Is it possible to grant access to individual rows in a table in MySQL? regards /Jonas

Re: replication in mysql5 between linux and windows

- Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 29, 2004 3:54 PM Subject: Re: replication in mysql5 between linux and windows > Jonas Lind?n <[EMAIL PROTECTED]> wrote: > > Hello list, I hav

replication in mysql5 between linux and windows

MASTER" so there is some kind of connection between the two atleast. Best regards /Jonas Lindén

Replication question

? or are just MyISM tables replicatable. I have not tried anything yet just thought I ask around abit first:) Best regards /Jonas Lindén

install issues

Hello people, I made a mistake and installed mysql5 under /usr/local :(. Now I want to remove the files installed by "make install" how can I do that? regards /Jonas

How to present query time through perl

perl:dbi to connect to my mysql db. Has anyone managed to do this? Best regards /Jonas

Re: LIKE % not including NULL values?

Thats true, but the actuall query looked more like this SELECT * FROM testdb WHERE col1 LIKE '$var%' and if I left the $var empty my plan was to get all columns. But I use the "OR col1 IS NULL" trick which solved my problem. Thanks anyway /Jonas If you want all values wh

LIKE % not including NULL values?

Hello list SELECT * FROM testdb WHERE col1 LIKE '%' The above SELECT statement doesnt return columns with NULL values. Should it? ;). Should I approce the problem in another direction? Regards /Jonas

Transfering from access to MySQL?

Hello, Could someone help me with a tip on how I can convert my old Access DBs to MySQL? Regards /Jonas

Re: Where to find ibbackup

alright, then I´ll probably go for mysqldump, thanks /Jonas > Jonas Lind?n <[EMAIL PROTECTED]> wrote: > > Hello, I am runing mysql5.x and have just started fiddeling with how I should back up my innodb databases. I started reading about ibbackup and think it suits me. But the pr

Where to find ibbackup

using it who could give me a hint? regards /Jonas

Re: SQL-HELP

Hello, you might want to try select DISTINCT ? http://www.mysqlfreaks.com/statements/18.php /Jonas - Original Message - From: "Carl Schéle, IT, Posten" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 17, 2004 3:49 PM Subject: SQL-HELP

Can mysql do DESC indexes?

Hello, can the new version of mysql 5 do reversed indexes? CREATE INDEX table ON (name(10) DESC); In manual it is described to be a fortcoming feature but and to be ignored in present version. regards /Jonas

path for my.cnf with dual mySQL installations

for where I can staticly set the path for my.cnf` for one of my MySQL installations? Regards /Jonas

Re: Referencing multiple primary keys

I solved it myself :) You need to keep the primary keys in the same order as the index, DOH! ofcourse :) In parant table PRIMARY KEY(key1,key2) In child table INDEX(key_fk1, key_fk2) Regards /Jonas - Original Message - From: "Jonas Lndén" <[EMAIL PROTECTED]> To: &

Referencing multiple primary keys

, fkey2) REFERENCES secondDB(col1, col2) ON DELETE SET NULL; Is there someone who could point me in the right direction? I have indexed the foreign keys in testDB. Regards /Jonas Lindén

cause of table crash

Hello I get the following errors/warnings on a table: Table is marked as crashed Not used space is supposed to be: 3688 but is: 3624 record delete-link-chain corrupted corrupt What can be the cause of this crash? Med vänlig hälsning/Best Regards Datatal Utveckling AB Jonas Gauffin Tel

SV: SV: SV: GRANT problem

> Use 'localhost' as the host unless you are specifying the > grant to be > for users on another machine. > '%' stands for all machines except 'localhost'. I know. And the is exactly what I want. > > Datatal AB - Gauffin, Jonas wrote: >

SV: SV: GRANT problem

I get access denied (from mysql.exe and myodbc) when specifying no host or % as host in the grant statement. > -Ursprungligt meddelande- > Från: gerald_clark [mailto:[EMAIL PROTECTED] > Skickat: den 24 oktober 2003 15:11 > Till: Datatal AB - Gauffin, Jonas > Kopia: [

SV: GRANT problem

> > GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO @'%' > IDENTIFIED BY ''; FLUSH PRIVILEGES; > yes. no diffrence. Specifying '%' or no host doesn't work for me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC

SV: GRANT problem

--Ursprungligt meddelande- > Från: Nathaniel Mallet [mailto:[EMAIL PROTECTED] > Skickat: den 24 oktober 2003 03:04 > Till: Rory McKinley; Datatal AB - Gauffin, Jonas > Kopia: [EMAIL PROTECTED] > Ämne: RE: GRANT problem > > > I was having the same problems tryi

SV: Tablecrash

yes, its gone in 4.0.16 > -Ursprungligt meddelande- > Från: Victoria Reznichenko [mailto:[EMAIL PROTECTED] > Skickat: den 23 oktober 2003 21:12 > Till: [EMAIL PROTECTED] > Ämne: Re: Tablecrash > > > "Datatal AB - Gauffin, Jonas" <[EMAIL PROTECTED

SV: GRANT problem

it works if I specify the host. Why doesn't % work as host? > -Ursprungligt meddelande- > Från: Rory McKinley [mailto:[EMAIL PROTECTED] > Skickat: den 23 oktober 2003 11:56 > Till: Datatal AB - Gauffin, Jonas > Ämne: Re: GRANT problem > > > thinking.

SV: GRANT problem

> Not sure if this will help - in your GRANT statement do you > not need to specify a host for the user e.g. GRANT.. to > datatal @ your_host_name.?. > > GRANT uses % as host if none is specified. % = all hosts. any other ideas? -- MySQL General Mailing List For list archives: http://

SV: GRANT problem

| N | N| +--++-+-+-+-+-+-+---++-+++---+--+ > -Ursprungligt meddelande- > Från: Franz, Fa. PostDirekt MA [mailto:[EMAIL PROTECTED] > Skickat: den 23 oktober 2003 11:03 > Till: Datatal AB - Gauffin, Jonas > Ämne: AW: GRANT problem > > > Hi Jonas, > > did you send

SV: GRANT problem

OR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)" please help > -Ursprungligt meddelande----- > Från: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED] > Skickat: den 23 oktober 2003 09:15 > Till: [EMAIL PROTECTED] > Ämne: GRANT problem

GRANT problem

something? Med vänlig hälsning/Best Regards Datatal Utveckling AB Jonas Gauffin Tel direct: +46 (0) 498 25 30 16 Tel Support: +46 (0) 498 25 30 30 Fax: +46 (0) 498 25 30 99 http://www.datatal.se "I try every day, but sometimes I fail" -- MySQL General Mailing List For list archive

SV: selecting table structure

"describe tablename" return columns: +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ > -Ursprungligt meddelande-

Tablecrash

Im using mysql 4.0.15a. To whom should I send the table? //Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SV: Table crashes

Hello > crashes occurs for some reasons like : > - unclean tables ( tables are closed improprely), > - hardware problems > - something goes wrong in the system > - know bugs > Check that your tables are clean, before start using them. MyODBC 3.51 is the only way that I access the database. (MyODB

Table crashes

E set-variable = myisam_sort_buffer_size=4M I need to get this going without getting crashes every week, please help. /Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: errors

Im pretty sure that the server has not been rebooted inproperly. Can there be any other reasons? The errors occur quite often. > -Ursprungligt meddelande- > Från: Victor Pendleton [mailto:[EMAIL PROTECTED] > Skickat: den 23 september 2003 14:26 > Till: Datatal AB - Ga

VB: errors

No answers? No suggestions? Surely, someone must have got these errors. > -Ursprungligt meddelande- > Från: Datatal AB - Gauffin, Jonas > Skickat: den 22 september 2003 14:16 > Till: [EMAIL PROTECTED] > Ämne: errors > > > Hello > > I often get these

errors

when creating the tables. //Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql + mingw

I'm trying to compile the mysql c++ api with mingw When I run configure I get this error what could it be ? loading cache ./config.cache checking whether to enable maintainer-specific portions of Makefiles... no checking for MySQL library directory... configure: error: Didn't find the mysql librar

Re: @@identity

Don Read wrote: On 18-Jun-2003 Jonas Geiregat wrote: I'm using php + mysql for my project I want to get the last insert ID. I could use the php function mysql_last_id(); but I could aslo use @@identity. Now some people have advised me NOT to use @@identity, cause it's not save buggy

@@identity

I'm using php + mysql for my project I want to get the last insert ID. I could use the php function mysql_last_id(); but I could aslo use @@identity. Now some people have advised me NOT to use @@identity, cause it's not save buggy sometimes slow .. is this true am I better of with the php function

probably a stupid question

Hey, Here is what I want to do I have 2tables let's say table A and B for simplicity. in table A I have column id and in table B I have column A_id I insert a new value into table A insert into a values(NULL) Since id is auto_incremenet and the primary key it will have an auto value. Now I want tha

Re: DELETE or RENAME tables?

[EMAIL PROTECTED] wrote: How do you DELETE or RENAME a table? Thanks. alter table TABLENAME rename NEWNAME; drop table TABLENAME; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

transactions with php

I'm trying to implement transaction (mysql) in my php code. Could anyone tell me if this is a good way of using them. I make an array with all the query's I loop through them. like this mysql_query($qarray[$i])or die($flag = false);. After the loop I do if($flag) commit; else rollback; Is this a

Re: transactions with php

gital www.becomingdigital.com - Original Message - From: "Jonas Geiregat" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, 17 June, 2003 13:44 Subject: transactions with php I'm trying to implement transaction (mysql) in my php code. Could anyone tell me if this is a good wa

Re: transactions with php

l.com - Original Message - From: "Jonas Geiregat" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, 17 June, 2003 13:44 Subject: transactions with php I'm trying to implement transaction (mysql) in my php code. Could anyone tell me if this is a good way of

Advanced how to's

uff ? Like joins and difficult query's ? Regards Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql design question ?

| user_id | Marks | Now I have an other table where I keep the name etc.. from each user. You will all kill me for this, but in access you could the setup a relation between user_id and the id of the user in the user table. Is something like that possible in mysql ? So that if I select some data

NOT NULL ?

I really don't get the user of NOT NULL anyone knows a good page on the manual that talks about it I can't seem to locate one. Or any good resource help to help me figure this out would be greate regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

mysql windows passwd probleme

I install mysql4.0.13 on windowsXP by using the installation wizard. Next I start mysql using NET START mysql, then I try to change my root password 'mysqladmin -u root password "foobarke". Try to login with the new root passwd I get error access denied. But I can login as root using nothing as

SV: Duplicate keys?

> > No, the last inserted id is just 1051 or something like that. > > Must be something else. > > Dunno where '2147483647' comes from. > > > > Is there a way to reset the auto_increment value or something? > > > First, check out with myisamchk if the table isn't crashed. > Then you can use SET INS

Duplicate keys?

Hello Have anyone got this error before: ERROR 1062: Duplicate entry '2147483647' for key 1 I get it when I do a simple insert query. The primary key is an auto_increment field and are not specified in the insert. Thank

Storage issue

after a year do you think? Best regards, Jonas Askås - 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 &l

Storage issue

after a year do you think? Best regards, Jonas Askås - 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 &l

Storage issue

after a year do you think? Best regards, Jonas Askås - 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 &l

My SQL

How do I download and install My SQL for Mac OS 9? Thanks, Jonas *-*-*-*-*-*-*-*-*-*-*-* Jonas Rosenbloom 1042 Shirley Drive Henderson, NC 27536 Phone: 252-492-5754 [EMAIL PROTECTED] *-*-*-*-*-*-*-*-*-*-*-* - Before posting

- in colum names

them change their tablenames? Med vänliga hälsningar Jonas Eriksson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thre

  1   2   >