My dump does not work

Hello, I face a problem in transfering a mysql db from 1 machine to another. I used the mysqldump command to take the dump of a db from machine A running linux. I put the same on to a machine B running on linux. Then I used the mysqldump command to create the database. In all 15 tables should b

[OT] LDAP and Mysql

Hi, Our intranet system is using mysql. At the moment authentication is done using a password and login kept in mysql. Our webmail system authenticates using ldap. We are also going to use ldap to authenticate for our intranet. Advantage for the user will be only to having to remember one passwor

Replication Problems with Adding New Records

I am using MySQL version 4.0.10 on both Slave and Master. I am running a Visual Basic front end connected to MySQL via MySQL ODBC v3.51.04. When using MySQLCC, adding records to the master database will work fine, the server shows the additional record added. When using our app in VB, a record w

Simple left outer join not working for me :(

Probably a simple error here, been a few years since i last did SQL work... I've got 2 tables (actually just one aliased nevermind just typing this much allowed me to figure it out :) Love the way you can spend a whole day trying to figure something out, and then as soon as you try to explain

OT - Of interest to Mac OSX users.

Hi all, Of interest to Mac OSX users. http://www.aaronfaby.com/mysql.php Contains everything you'll need to get MySQL installed and working on OSX. He also has installers for Apache and PHP (http://www.aaronfaby.com/). Goodness, I wasted days getting MySQL installed originally but using his p

Replication problem

Hello, I just setup replication on mysql 3.23.55 and seem to be having some problems. The slave machine does not seem to want to copy all the data on start. I have a table with 54,000 rows on the master, and after I load up the slave there are only 54,850 on that machine. I can drop the table

Re: MySQL Feature

On Thu, Feb 13, 2003 at 02:10:18PM -0500, Luc Foisy wrote: > BUT > > SELECT Data, CASE WHEN 0 != 0 THEN 'Something' END FROM table > > will return two columns, "Data" and "CASE WHEN 0 != 0 THEN 'Something' END". It >would be better if I could do.. > > SELECT Data, CASE WHEN 0 != 0 THEN 'Somethi

Re: Starting MySQL RPM

On Fri, Feb 14, 2003 at 12:52:49AM +0100, Stefan Hinz wrote: > Have you tried > mysqld --console > already? This will not solve your problem, but at least it will > display quite some output to help you find the cause of the prob. [joliver@joliver-lnx joliver]$ sudo /usr/sbin/mysqld --console /us

Re: Formatting SQL in Access

Daniel Kasak wrote: Hi all. Hi spam filter. SQL. Query. I'm writing some code in Access 2002 which builds an sql string and then saves it as a pass-through query. I would like to be able to build in some new-line characters or something so that the query is nicely formatted so that when I (or

Formatting SQL in Access

Hi all. Hi spam filter. SQL. Query. I'm writing some code in Access 2002 which builds an sql string and then saves it as a pass-through query. I would like to be able to build in some new-line characters or something so that the query is nicely formatted so that when I (or my boss) goes back la

RE: Row numbers

At 12:31 PM 2/13/03 , Luc Foisy wrote: > > I still don't understand do you mean the "actual" row > number or just a > > display number. > > > There is no relevant data or use to this number. > > > It is the row number of the returned result set, purely > > > for display. That means no field exis

Re: Starting MySQL RPM

John, > [joliver@joliver-lnx joliver]$ sudo /etc/rc.d/init.d/mysql start > [joliver@joliver-lnx joliver]$ Starting mysqld-max daemon with databases > from /var/lib/mysql > 030213 15:01:06 mysqld ended Have you tried mysqld --console already? This will not solve your problem, but at least it wil

Starting MySQL RPM

I removed the Red Hat MySQL RPMs (which worked fine, other than not supporting InnoDB) and installed the 3.23.55-1 RPMs from mysql.com When I try to start it: [joliver@joliver-lnx joliver]$ sudo /etc/rc.d/init.d/mysql start [joliver@joliver-lnx joliver]$ Starting mysqld-max daemon with databases

Re: Re: Strange sorting in table

At 0:01 +0100 2/14/03, Viktor Vasiliou wrote: Ok, I guess you're right. It's just that it has never happend to me before. Thanks for your help. In general, when you simply insert rows into a table, that's the order in which they're returned. That's just happy coincidence, and not to be relied o

Re: Re: Strange sorting in table

Ok, I guess you're right. It's just that it has never happend to me before. Thanks for your help. Regards, Viktor - Original Message - From: Paul DuBois To: [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 11:48 PM Subject: Re: Re: Strange sorting in table >Stefan and Paul, > >W

Re: Re: Strange sorting in table

Stefan and Paul, When adding ORDER BY counterid, all rows are sorted correctly, but it should not be needed. All the other tables are sorted correctly at the start, and has always been. I'm not sure where you got that idea. There is NO guarantee about the order in which rows are returned unless

Re: Enable InnoDB in RPM install?

On Thu, Feb 13, 2003 at 04:39:44PM -0600, Mark Matthews wrote: > Trust me. You most likely do not want to run the RedHat RPMs. They tend > to have a lot of stability issues. > > Head on over to http://www.mysql.com/ and download the RPMs we provide. > Your life will be easier. Okey-dokey, I'll

Re: Strange sorting in table

Stefan and Paul, When adding ORDER BY counterid, all rows are sorted correctly, but it should not be needed. All the other tables are sorted correctly at the start, and has always been. This is the structure of the ID field in the second and third table: FieldType

Re: Enable InnoDB in RPM install?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John Oliver wrote: On Thu, Feb 13, 2003 at 03:33:31PM -0600, Paul DuBois wrote: At 12:43 -0800 2/13/03, John Oliver wrote: I've got MySQL installed via RPM on a Red Hat 8.0 machine. How do I enable InnoDB? If it's < MySQL 4, install the -Max RP

Re: Enable InnoDB in RPM install?

On Thu, Feb 13, 2003 at 03:33:31PM -0600, Paul DuBois wrote: At 12:43 -0800 2/13/03, John Oliver wrote: >I've got MySQL installed via RPM on a Red Hat 8.0 machine. How do I >enable InnoDB? If it's < MySQL 4, install the -Max RPM on top of your existing installation to get a server with Inno

Re: Enable InnoDB in RPM install?

On Thu, Feb 13, 2003 at 03:33:31PM -0600, Paul DuBois wrote: > At 12:43 -0800 2/13/03, John Oliver wrote: > >I've got MySQL installed via RPM on a Red Hat 8.0 machine. How do I > >enable InnoDB? > > If it's < MySQL 4, install the -Max RPM on top of your existing installation > to get a server wit

mysql and BDB tables

Hi, I've got a problem: I'm using Berkeley DB tables in my database, but mysql fails to restart after dropping such database. Mysql claims that it can't restore some of database tables on start and fails to do it, because tables' files do not physically exists after database dropping... I can r

RE: RE: Auto-completion

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 February 2003 11:03 a.m. To: Defryn, Guy Subject: Re: RE: Auto-completion Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter yo

Re: Auto-completion

At 10:50 +1300 2/14/03, Defryn, Guy wrote: Is auto completion a feature that only works in Mysql4? No. However, I have never noticed it to work on Windows. Are you using Windows? Cheers Sql,query - Before posting, please

RE: Bug with innodb multi-table delete and foreign keys.

Hi sinisa, I tried this patch. It came up with undefined symbol for ER_MULTI_TABLE_UPDATE_DELETE_WITH_INNODB on compile so i went ahead and added to include/mysqld_error.h for testing. i'm not sure if it's the right place or the right error code but it made mysql compile *** 256a257

Auto-completion

Is auto completion a feature that only works in Mysql4? Cheers Sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request t

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

Hi Mark, Good call. The way we understand the SQL log it looks like all of the SQL commands we had expected to be part of the transaction are on connection 7, while the counter incrementation which is done outside of the transaction was done on connection 12. At one point we though

RE: Row numbers (I thought of a new feature)

I thought of a new feature... XSLT's "position()"-like functionality in the new releases of MySQL. position(), in XSLT, returns position of the node in the document tree. In MySQL it would return position of the record in the returned result set (from SELECT query): Example: SELECT POSIT

Re: Enable InnoDB in RPM install?

At 12:43 -0800 2/13/03, John Oliver wrote: I've got MySQL installed via RPM on a Red Hat 8.0 machine. How do I enable InnoDB? If it's < MySQL 4, install the -Max RPM on top of your existing installation to get a server with InnoDB enabled. If it's MySQL >= 4, InnoDB is included already; you do

mysql control centre compile errors

platform: os: freebsd-4.5 qt: 3.1.1 (no threads, no opengl, no xft) mysqlcc source version: 0.8.9 (mysqlcc.pro.in modified to remove thread from CONFIG). compile error: > gmake -v GNU Make version 3.79.1, by Richard Stallman and Roland McGrath. Built for i386--freebsd4.3 > gcc -v gcc version 2

Re: 4.1 Self Compiled Problems

Giorgos Gaganis wrote: Hello I have downloaded 4.1 source and successfully compiled it. When i use the mysql client as a root it works without problems. If i use the client as a different user when i try to use the 'use DATABASE' command i get a segmentation fault. Here is a backtrace of the s

Re: Strange sorting in table

At 19:55 +0100 2/13/03, Viktor Vasiliou wrote: Hi Stefan, Thanks for your reply! The table has just been created, and has therefore no deleted entries. ID 1-1000 was created by myself, ID 1002 was created when a new user registered at the website. ID 1001, 1003, 1004, etc is sorted correctly.

4.1 Self Compiled Problems

Hello I have downloaded 4.1 source and successfully compiled it. When i use the mysql client as a root it works without problems. If i use the client as a different user when i try to use the 'use DATABASE' command i get a segmentation fault. Here is a backtrace of the stack when the program cra

RE: Row numbers

On 13 Feb 2003, at 15:31, Luc Foisy wrote: > Using variables is the best response to my question. I just dislike > using them cause they are ugly to work with because of the session > persistance and because I have to issue multiple queries to do the > job. Using variables seems to be the way to

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: Heikki, The application which is having this problem is used to read an XML document and update a database. The application is part of a website, so there are always other interactions with the database while the "loa

Enable InnoDB in RPM install?

I've got MySQL installed via RPM on a Red Hat 8.0 machine. How do I enable InnoDB? -- John Oliver, CCNAhttp://www.john-oliver.net/ Linux/UNIX/network consulting http://www.john-oliver.net/resume/ *** sendmail, Apache, ftp, DNS, spam filtering

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

Heikki, The application which is having this problem is used to read an XML document and update a database. The application is part of a website, so there are always other interactions with the database while the "loader" is running. The log below was created at a time when no one was usi

load data infile command not allowed problem - revised

I access a msyql server (apache/mysql/php) from my w2k workstation using phpMyAdmin. I do not have command line access. When I use the link to load a local data file it responds that it is not allowed. I read the mysql docs and see it is now disabled by default. In 4.2.4 one paragraph says "If you

Re: AW: NullPointerException in the Java Connector

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Martin Rösch wrote: -Ursprüngliche Nachricht- Von: Martin Rösch [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 13. Februar 2003 13:20 An: [EMAIL PROTECTED] Betreff: NullPointerException in the Java Connector Hi, attached is my report. T

RE: Row numbers

> > I still don't understand do you mean the "actual" row > number or just a > > display number. > > > There is no relevant data or use to this number. > > > It is the row number of the returned result set, purely > > > for display. That means no field exists or should exist in the database. I

AW: NullPointerException in the Java Connector

-Ursprüngliche Nachricht- Von: Martin Rösch [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 13. Februar 2003 13:20 An: [EMAIL PROTECTED] Betreff: NullPointerException in the Java Connector Hi, attached is my report. Thank you for your good work. Kind regards Martin Rösch ==

Re: I can't make user from the MySQL Control center

The control center doesn't have a command to flush the tables or reload the user tables. So the new user won't have access until you do: mysqladmin -u -p -h reload Curtis Stefan Hinz said: > Karáth, > >> I just have installed the MySQL on a Suse linux. >> I would like to administrate it from

Re[2]: Strange sorting in table

Viktor, >> I have a couple of tables in a MySQL database. In one of the tables, >> PhpMyAdmin sorts very strange. ID 1002 is places between ID 21 and >> ID 22. Any idea why? > The table has just been created, and has therefore no deleted entries. ID 1-1000 was >created by myself, ID 1002 was cre

Re: I can't make user from the MySQL Control center

Karáth, > I just have installed the MySQL on a Suse linux. > I would like to administrate it from Win2k with MySQL Control Center 0.8.9 > beta. But I can't make new user in the control center. Obviously, you're logged in to the MySQL server as a user who doesn't have the privileges to create new

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

Steff, a note on terminology: every query inside InnoDB always happens inside a transaction. In the AUTOCOMMIT=1 case there just is an automatic commit done at the end of each SQL statement. In your log below I cannot see how connection 7 could ever receive the error "Table 'productsprovided' wa

Re: Row numbers

Auto-inc column would be the obvious answer, but that's and intrusive answer. Jerry - Original Message - From: "Jerry" <[EMAIL PROTECTED]> To: "Luc Foisy" <[EMAIL PROTECTED]> Cc: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 7:10 PM Subject: Re: Row numbers

Re: Bug with innodb multi-table delete and foreign keys.

Scott Wong writes: > Version: Mysql 4.0.10-gamma > > > Description: ERROR 1105: Unknown error after issuing a multi-table delete on >parent/child table. > if there's no foreign keys .. works ok. > > How to Repeat : > > drop table parent; > drop table child; > > CREATE TABLE parent(id INT NOT

RE: Row numbers

You can use user variables; example: mysql> describe library_master; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | _i

RE: Row numbers

I think I know what you are asking for. Create an int field with auto_increment set. Make that field the first field in your table. i.e. CREATE TABLE my_table ( id int(11) auto_increment NOT NULL, other_data ... PRIMARY KEY (id) ); Then, when you want rowid for something

mysql 4.0.10-gamma Duplicate Entry on Key 1 Error

Hi. I'm new to the list, just installed mysql 4.0.10-gamma on Unix, BSDI 4.x to take advantage of the new Union command. I've run across an error & have narrowed it down. I don't know if this is correct behavior documented somewhere I can't find, or if it's a bug. It's an odd error, so, I will tr

Re: Row numbers

I still don't understand do you mean the "actual" row number or just a display number. - Original Message - From: "Luc Foisy" <[EMAIL PROTECTED]> To: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 6:59 PM Subject: RE: Row numbers > There is no relevant data

RE: MySQL Feature

> -Original Message- > From: Zak Greant [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 10:38 AM > To: [EMAIL PROTECTED] > Subject: Re: MySQL Feature > > > On Thu, Feb 13, 2003 at 09:57:06AM -0500, Luc Foisy wrote: > > > > I don't think it is possible at the moment, and

AW: Row numbers

I stated to implement something like Oracle's ROWNUM ... but noone's listening ... therefore I build an UDF ... > -Ursprüngliche Nachricht- > Von: Luc Foisy [mailto:[EMAIL PROTECTED]] > Gesendet: Donnerstag, 13. Februar 2003 20:00 > An: MYSQL-List (E-mail) > Betreff: RE: Row numbers > > >

RE: Row numbers

There is no relevant data or use to this number. It is the row number of the returned result set, purely for display. I was hoping there was some kind of function just to drop a number in there, regarless of any data that is stored in the table or regardless of the order the resultset appears.

Re: replication "Error updateing slave list" in mysql 4.0.10

> Check the user 'repl' has REPLICATION SLAVE privilege. Ah. that fixed it. Actually, the real reason was that I had not yet updated the mysql tables and the new privileges did not take effect as a result. mysql_fix_privilege_tables , followed by the 'GRANT' command and 'flush privileges' fixed

Re: Strange sorting in table

Hi Stefan, Thanks for your reply! The table has just been created, and has therefore no deleted entries. ID 1-1000 was created by myself, ID 1002 was created when a new user registered at the website. ID 1001, 1003, 1004, etc is sorted correctly. There is three tables in the database which all

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

Heikki, I wish I could reproduce this outside of production. To this point the only place we have seen this is in production. I did turn the logging on for MySql and the connection number assigned for all the SQL which we would have expected to be within a transaction did not change. Wit

RE: Row numbers

: Is there a way to get a row number returned with any select query? Row number is not available for some queries (ex.DELETE FROM table_name) for efficiency. You can disable it with a dummy WHERE clause: DELETE FROM table_name WHERE 1 > 0; It will be slower, but you'll get the desire

Re: remote login

Thanks to all. Now it works! Branko On Thu, 13 Feb 2003, Martin Hudec wrote: > Hmmm, what about GRANTs on user 'username@machine_name'? > > On Thu February 13 2003 18:44, Branko Kaucic wrote: > > Hi all, > > > > I have similar problems as Kris posted on 12/17/2002. I didn't find any > > solutio

I can't make user from the MySQL Control center

Hi, I just have installed the MySQL on a Suse linux. I would like to administrate it from Win2k with MySQL Control Center 0.8.9 beta. But I can't make new user in the control center. I think, I have to enable at the linux consol that the root (SQL root) could be administrate the SQL server on my

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

Steff, - Original Message - From: <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 7:21 PM Subject: Re: Transaction problems using InnoDB, "not locked with LOCKTABLES" > Heikki, >Thanks for the reply. > > My conf

Re: remote login

At 18:44 +0100 2/13/03, Branko Kaucic wrote: Hi all, I have similar problems as Kris posted on 12/17/2002. I didn't find any solution, so I write this e-mail. If I connect to mysql in console with: mysql -u username -p then everything works fine. MySQL is 3.23.53-max-nt running on WinXP and on t

Re: remote login

Hmmm, what about GRANTs on user 'username@machine_name'? On Thu February 13 2003 18:44, Branko Kaucic wrote: > Hi all, > > I have similar problems as Kris posted on 12/17/2002. I didn't find any > solution, so I write this e-mail. > If I connect to mysql in console with: > mysql -u username -p > >

Row numbers

Is there a way to get a row number returned with any select query? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread

Stuck (unkillable) queries

Hello, I'm having an odd problem with my MySQL server that I thought someone might have some ideas on. Setup: MySQL 4.0.10-max Mac OS X Server 10.2.3 DP G4 1.25 GHz 1G RAM MySQL data and temp files on 400G striped RAID array (off an Acard hardware controller) that is 90% empty Clients accessing

remote login

Hi all, I have similar problems as Kris posted on 12/17/2002. I didn't find any solution, so I write this e-mail. If I connect to mysql in console with: mysql -u username -p then everything works fine. MySQL is 3.23.53-max-nt running on WinXP and on the same machine I am trying to connect to dat

Re: open_files_limit bug in 4.0.10

At 16:56 + 2/13/03, [EMAIL PROTECTED] wrote: Dear All, It would appear that setting: set-variable= open_files_limit = 200 Within the [mysqld] stanza in a data/my.cnf does not appear to work as mysqld exits with: ERROR: unknown variable 'open_files_limit = 200' That's odd. What happe

re: 3.23.41: auto_increment bug with TRIPLE primary key? (reallystrange)

At 18:45 +0200 2/13/03, Victoria Reznichenko wrote: On Tuesday 11 February 2003 19:53, The Mindflayer wrote: mysql -V: mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) (Upgrading may not be an option.) Not subscribed to the list, so please CC me on any responses. I'd submit th

RE: Error 7 - Errorcode 13

Are you tring to create a fulltext index on a blob field? If so - it won't work - fulltext can use only text fields. Cheers, Andrew -Original Message- From: Sauer - brfree [mailto:[EMAIL PROTECTED]] Sent: 13 February 2003 16:36 To: Lista Mysql 1 Subject: Error 7 - Errorcode 13 I'm tr

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

Heikki, Thanks for the reply. My confusion is that we are only using 1 table within our lock area of the code. The error is coming back on the connection which is not doing any table locks. The error comes when we are in the middle of a transaction block. Is there some reason

RE: Create database via ODBC

At 16:40 + 2/13/03, [EMAIL PROTECTED] wrote: If that is done with the engine already running, will the DB be recognized without a restart? Yes. Also - do you happen to know if I am able to determine where the mysql/data directory resides from a given DB connection? It will not always be

open_files_limit bug in 4.0.10

Dear All, It would appear that setting: set-variable= open_files_limit = 200 Within the [mysqld] stanza in a data/my.cnf does not appear to work as mysqld exits with: ERROR: unknown variable 'open_files_limit = 200' Yet a bin/mysqladmin variables has: open_files_limit 0 I cannot fi

Re: MYSQL problem

Ellen, > Error is : can't connect to mysql on localhost <10061).. > I also try another method to solve this problem by typing > mysqld-nt --install > error prompts saying that the service already exists. > The current server installed is : c:\Apache\mysql\bin\mysqld-nt.exe Start c:\Apache\mysql\b

Re: MYSQL problem

At 23:47 +0800 2/13/03, [EMAIL PROTECTED] wrote: Hello Sir, I have problem connecting to mysql in dos-prompt.. Error is : can't connect to mysql on localhost <10061).. What does it mean? I also try another method to solve this problem by typing mysqld-nt --install error prompts saying that the

re: 3.23.41: auto_increment bug with TRIPLE primary key? (really strange)

On Tuesday 11 February 2003 19:53, The Mindflayer wrote: > mysql -V: > mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) > (Upgrading may not be an option.) > > Not subscribed to the list, so please CC me on any responses. > > I'd submit this to bugs@, but my MySQL version is way out of

Re[2]: MySQL Feature

Luc, Zak, >> SELECT aField, COLUMN_IF( some_expression, 'afield2' AS 'aColumn' ) FROM aTable > You can use a WHERE clause to get an effect like this. > SELECT CASE expression > WHEN 'value' > THEN column > ... > ELSE 'default result' > END > FROM Tabl

Re: Problem Editing mysql Text field

This is weird, all of a sudden it starts working, if it happens again though I will try another front end. Thank you for your advice Thank you, --- -Daniel Negron // \\**

RE: Create database via ODBC

If that is done with the engine already running, will the DB be recognized without a restart? Also - do you happen to know if I am able to determine where the mysql/data directory resides from a given DB connection? It will not always be the same location for the different installs that are

Re: Error 7 - Errorcode 13

Sauer, > I'm trying to add a new column into a table, but I have received the folow > message: > [Des057] ERROR 7: Error on rename of '.\vendas\pedidos.MYI' to > '.\vendas\#sql2-6f0-15.MYI' (Errcode: 13) Which MySQL version? Guess you're running MySQL under Win2K or WinXP. I had the same kind of

re: [ sub select in 4.0.9-gamma? ]

On Thursday 13 February 2003 15:03, Elby Vaz wrote: > The MySQL-4.0.9-gamma to windows supports sub select? Nope. > Ex.: select ... from ... where ... in (select.) > > If not, has some version that supports it? Subselects will come in 4.1 -- For technical support contracts, goto http

re: mySQL q.

On Thursday 13 February 2003 10:00, eliran wrote: > My name is Eliran and I'm working at Rimed company in Israel. > We consider to use MySql as a database for our application. > I installed MySql 3.23 on window XP. > I want to know what I must do in order to be able to run the C++ example it > giv

re: Has somebody got an example of Foreign Keys

On Wednesday 12 February 2003 18:26, Ben Clewett wrote: > I am using 4.0.10-gamma-max-nt, with 100% innodb, and cannot get Foreign > Keys to create. > > The help files give this example: > > CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), > FOREIGN KEY (parent_id

re: replication "Error updateing slave list" in mysql 4.0.10

On Thursday 13 February 2003 16:43, Johannes Ullrich wrote: > I am having problems setting up replication between two 4.0.10 > servers. > > What I did so far: > > - generate a dump of the current state of the server using > 'mysqldump' (its a mix of mostly innodb tables and some MyISAM > tab

re: RE: RE:mysql Innodb: Create different db on separate disks

On Sunday 09 February 2003 13:10, Dmitry Kosoy wrote: > It is good for MyISAM tables. > For Innodb it puts on separate disk frm files only. > And what about Innodb tables of the specific database? You can put different ibdata files on separate disks. > > Regards, > Dmitry > > > Is there any way

Re: Problem Editing mysql Text field

Hello There is a bug in both MySQL-Front and NaviCat where updating a field before retrieving all the record in the data result hangs up the thread as they use mysql_use_result() feature. Try using some other Front Ends. Insane - Original Message - From: "Daniel Negron/KBE" <[EMAIL PROT

Re: A bug with innodb and non innodb multi-table delete.

Scott Wong writes: > Version: Mysql 4.0.10-gamma > > Description: Mysql client loses connection when doing a multi-table delete if one >table is innodb and the other is myISAM. > > How to Repeat : > > > drop table parent; > drop table child; > > CREATE TABLE parent(id INT NOT NULL, >

Re: Error 7 - Errorcode 13

On Thu, 13 Feb 2003 13:35:33 -0300 Sauer - brfree <[EMAIL PROTECTED]> wrote: > I'm trying to add a new column into a table, but I have received the folow > message: > > [Des057] ERROR 7: Error on rename of '.\vendas\pedidos.MYI' to > '.\vendas\#sql2-6f0-15.MYI' (Errcode: 13) > There is somethin

MYSQL problem

Hello Sir, I have problem connecting to mysql in dos-prompt.. Error is : can't connect to mysql on localhost <10061).. What does it mean? I also try another method to solve this problem by typing mysqld-nt --install error prompts saying that the service already exists. The current server insta

Re: Managing replication logs

Here's another way to do it which works well with multiple slaves: http://mtop.sourceforge.net/utils/purge_replication_log This script is run on the slave and the master. When run on the slave it updates a table in the master which keeps track of the log position for each slave. When run on the

Re: MySQL Feature

On Thu, Feb 13, 2003 at 09:57:06AM -0500, Luc Foisy wrote: > > I don't think it is possible at the moment, and pretty sure its not standard SQL but >it would still be neat to have > > SELECT aField, COLUMN_IF( some_expression, 'afield2' AS 'aColumn' ) FROM aTable > > So in this example, if the

Error 7 - Errorcode 13

I'm trying to add a new column into a table, but I have received the folow message: [Des057] ERROR 7: Error on rename of '.\vendas\pedidos.MYI' to '.\vendas\#sql2-6f0-15.MYI' (Errcode: 13) Please, help me. - Before posting, ple

Re: Are temporary tables more effective than joins?

On Thu, Feb 13, 2003 at 05:57:54PM +0300, Artem Koutchine wrote: > > > The effect is you limit the possible rows to a small amount really > quick > > with a simple join. The details of the search are handled bij a like > which > > can get as complicated as you like using OR`s, NOT`s etc; it won`t

very slow imports on Solaris 8 mysql

Hi - this is a repost [sorry] We have installed MYSQL Ver 8.23 Distrib 3.23.54, for sun-solaris2.8 on sparc from a binary onto a 6 processor server with 6 gig of ram but we are seeing very slow imports. A 16M export takes 7 minutes, a 60M export takes over an hour. I have tuned my.cnf but perfo

RE: Finding functions in manual (was RE: formatting query output)

:Putting : links for each : function under the categories might help with that. The : links could go to : the specific place on the big page (there would be no : need for a separate : page for each one). Of course, this is probably OT at this point. Try http://www.

RE: Create database via ODBC

It's dead simple to create a MySQL database -- it's just a directory under mysql\data. If you want to do it from Access, just determine where the mysql\data directory is and then create the subdirectory. Hth, Arthur -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sen

RE: Licence Free Import/Export for Access?

I believe the same is true of urSQL. However, you do need to set up an ODBC data source and this requires the MS Access driver. The easiest way to get the driver is to install MS Access, but I think it is possible to install the driver without MS Access... On Thu, 13 Feb 2003, Arthur Fuller wrot

Finding functions in manual (was RE: formatting query output)

Yes, it is sometimes hard to find functions because they tend to be lumped into general categories with each page having a fair bit of functions listed (e.g. http://www.mysql.com/doc/en/String_functions.html). The categories are pretty good for separating them, but sometimes it's hard to tell whic

MySQL Feature

I don't think it is possible at the moment, and pretty sure its not standard SQL but it would still be neat to have SELECT aField, COLUMN_IF( some_expression, 'afield2' AS 'aColumn' ) FROM aTable So in this example, if the expression was true, include that column in the result set, otherwise d

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

Mark, Steff, - Original Message - From: "Mark Matthews" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, February 12, 2003 3:09 AM Subject: Re: Transaction problems using InnoDB, "not locked with LOCKTABLES" > -BEGIN PGP SIGNED

Re: formatting query output

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Duncan & Rob, et al -- ...and then Salada, Duncan said... % % Why 2 CONCATs? Why not simply: % % mysql -Be "select CONCAT(host,'.',domain) from easyadmin.vsites where % adminuser="davidtg" Hey, cool! That's *exactly* what I needed. Works perfect

  1   2   >