Re: unexpected create table as lock issue

Hi! - Original Message - From: "Sasha Pachev" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, May 13, 2004 3:01 AM Subject: Re: unexpected create table as lock issue > [EMAIL PROTECTED] wrote: > > I have a table called web_master

Re:Re: Problems compiling NDB-Cluster mysql-4.1.2

Hello, thanks for your response. The zlib-Library was already installed on the machine. The command "find / | grep zlib" showed my the file zlib.h at /usr/include/linux/zlib.h I've update from zlib 1.1.4-105 to 1.1.4-232 and installed the zlib-devel package too. I've tried to compile with differe

Re: GUID storage

Hi! On May 12, Larry Lowry wrote: > A uniqueidentifier in MS SQL is basically a guid. I am generating > them via System.Guid.NewGuid().ToString(N") in the Dot Net > framework which now returns me a string of 32 characters (hex). > Internally I understand it is a 128-bit integer. As an option I

Re: ORDER BY Question

Hi Dirk, from the excellent on-line manual: http://dev.mysql.com/doc/mysql/en/SELECT.html Columns selected for output can be referred to in ORDER BY and GROUP BY clauses using column names, column aliases, or column positions. Column positions are integers and begin with 1: mysql> SELECT colleg

Changing Table Row Order

I just switched my primary key from a numerical column to abbreviations, primarily because the latter are more distinctive and easier for me to work with. The flip side is that my row order has been turned upside down. I made my database in a spreadsheet, with North America (#1) at the top and Ant

Re: From the top! (primary/foreign keys)

One more thing, though... I don't understand this restrict and cascade function. I looked for it when I created my table, but didn't see any mention of it. If I understand MySQL's documentation, I don't need to worry about it, because it's created by default every time you create a foreign key. Is

Re: From the top! (primary/foreign keys)

BINGO! About the same time I got your message, I figured out how to create foreign keys with SQLyog. I followed your instructions in creating two brand new tables in phpMyAdmin, then linked the foreign key and primary key in SQLyog. I haven't tested it yet - there isn't even any data in the tables

InnodB Hot Backup Questions

I'm hoping someone on the list has some experience with the tool (specifically, restoring a backup), as I'm stumped. First, "--apply-log" seems to only work on the host that ibbackup is lode-locked to. This doesn't make sense. Running the tool dumpes out some text, and part of that text is, "(--r

Re: ESRI GIS products support lacking in MySQL???

Wow. I'd stop listening to whomever it is that's telling you these stories. Really. The difference between the MyISAM and InnoDB storage engines centers on InnoDB's excellent support for transactions (MyISAM has none), InnoDB's row versus full table locking with MyISAM, and general ACID complia

Re: From the top! (primary/foreign keys)

CREATE TABLE Continent ( CCODE VARCHAR(6) NOT NULL UNIQUE, CGROUP VARCHAR(255), TYPE VARCHAR(255), NAME VARCHAR(255), NUM_ID INT(4) NOT NULL UNIQUE, PRIMARY KEY (CCODE), TYPE = InnoDB); CREATE TABLE Nations ( NAME VARCHAR(255) NOT NULL UNIQUE, TYPE VARCHAR(255), NCODE VARCHAR(6),

RE: ESRI GIS products support lacking in MySQL???

It says, "Currently, these features are available for MyISAM tables only." Does that mean you can't join MySQL tables that use these features? I haven't even learned how to make a join yet, but I was told that it can only be done with InnoDB tables.

RE: ESRI GIS products support lacking in MySQL???

Look at some of the features of 4.1.1 http://dev.mysql.com/doc/mysql/en/Spatial_extensions_in_MySQL.html > -Original Message- > From: Douglas Phillipson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 12, 2004 1:41 PM > To: [EMAIL PROTECTED] > Subject: ESRI GIS products support lacking

Re: fastest filesystem for MySQL

Jacob, I'd go with Reiser on SuSE. Like Sasha mentioned though, the filesystem component may have little overall effect, depending on your set-up. I'd stay away from XFS when working with databases, as its performance gains are achieved via extended write delays while the queue sits in main

Re: HELP mysql.sock is missing in Mac OS X

iH doesn't look as tho mysqld is running --> mysqld ended did you install the standard database files? what about the permissions? can mysqld read those files check the error log in the data directory - hcir On May 12, 2004, at 6:53 PM, Jose Manuel Islas Romero wrote: I start MySQL and it seem

Re: HELP mysql.sock is missing in Mac OS X

Jose Manuel Islas Romero wrote: >I start MySQL and it seems to start the server normally > > >TrentCioran:/usr/local/mysql TrentCioran$ sudo ./bin/mysqld_safe > >Starting mysqld daemon with databases from /usr/local/mysql/data > >040512 21:27:05 mysqld ended It's not starting normally. It's sta

HELP mysql.sock is missing in Mac OS X

I start MySQL and it seems to start the server normally >TrentCioran:/usr/local/mysql TrentCioran$ sudo ./bin/mysqld_safe >Starting mysqld daemon with databases from /usr/local/mysql/data >040512 21:27:05 mysqld ended but when i try to open the mysql console it sends me the message: >TrentCior

Re: urban myth?

Boyd E. Hemphill wrote: To all who answered thank you. This answer below is the one that I can use to convince him what he proposes is not necessarily safe. I almost always have a timestamp column immediately after my auto_increment'ed primary key column which I use for ordering by insert/

From the top! (primary/foreign keys)

OK, I've made some changes, and I'm still trying to figure out this foreign key stuff. This time, I'll focus on just two tables, named "continents" and "nations." I put screen shots of their structure and some sample rows online at http://www.geoworld.org/try.gif It sounds like non-repeating nume

Re: GUID storage

In the last episode (May 12), Larry Lowry said: > A uniqueidentifier in MS SQL is basically a guid. I am generating > them via System.Guid.NewGuid().ToString(N") in the Dot Net > framework which now returns me a string of 32 characters (hex). > Internally I understand it is a 128-bit integer. As

Re: Restore 20 gigabytes of binary logfiles

JFL wrote: I need to restore 20 gigabytes of binary logfiles. What should I do in order to get the job done as quickly as possible? I am considering this: mysqlbinlog --database=mydb logfiles | mysql -f There is a faster way, but it is rather tricky. 4.0 slave can be tricked into thinking that tho

Re: security and extended ascii characters

Chris W wrote: In an effort to make sure no binary data is maliciously submitted via a form I have code the makes sure all characters in any input field are with in the range of a space to a "~". However now that I am getting some users of my site from Europe, that are having problems submittin

Re: Saving PDF's as Blobs

Lou Olsten wrote: I tried this and it DOES work with my PDFs. However, I didn't fully understand how LOAD_FILE would handle all different kinds of binary data, so I tried the same thing with a JPG. It ended up dropping over half of the data. So although LOAD_FILE does work for my PDFs, how can I

Matching Jurisidictions & EcoRegions

Randy Clamons wrote, "Add a column to your states table that references the ECode of the EcoRegion. That will allow you to classify the smallest jurisdiction to an eco-region and limit the number of rows you need to maintain in the EcoRegions table. Create a unique index on ECode in the EcoRegions

Re: unexpected create table as lock issue

[EMAIL PROTECTED] wrote: I have a table called web_master which has as a primary key column called web_id. When I try to create another table as a select, I get the following error message [note, that group_id is indexed]: mysql> create table sort_test as select * from web_master where group_id = 6

Re: Thread safeness

Marcelo Criscuolo wrote: Hello folks, I'm looking for some information about MySQL thread-safeness, but I'm not understanding well the manual (http://dev.mysql.com/doc/mysql/en/Threaded_clients.html). It says "If you don't need interrupts or timeouts, you can just compile a thread-safe cli

RE: Importing Fixed Length Text Files

Thanks for the response, it was timely and right on the money. Allen -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 6:22 PM To: Allen Weeks; MySQL List Subject: Re: Importing Fixed Length Text Files Allen Weeks wrote: Hello All,

Re: GUID storage

A uniqueidentifier in MS SQL is basically a guid. I am generating them via System.Guid.NewGuid().ToString(N") in the Dot Net framework which now returns me a string of 32 characters (hex). Internally I understand it is a 128-bit integer. As an option I could store that in MySql. What data type

Re: ESRI GIS products support lacking in MySQL???

Funny, I contacted ESRI with a similar question just today. I want to download a huge file of ArcView/GIS data for use in a MySQL database, but I wasn't sure if there's a way to extract data from those files. Someone replied that it can indeed be done, but I haven't yet learned any particulars. I

Re: Sorting Varchar

That didn't do it. I got 0,0,1050,1168,1195, 1975, 150,155,16500,170,178. . . The non-numerics came out last (which I want). There are two zeros but no negative numbers. Any alternatives? Ken ** On Wed, 12 May 2004 07:47:11 -0400, Bill Easton <[EMAIL PROTECTED]> wrote: You could also

Re: GUID storage

In the last episode (May 12), Larry Lowry said: > Well I'm trying to move to MySQL from the MS SQL Server world. Most > data elements are easy except for the uniqueidentifier. > > In the MySQL world what is the preferred/best way to store a > uniqueidentifier? The easiest would just be a char(36

Re: GUID storage

On Wed, May 12, 2004 at 02:50:55PM -0700, Larry Lowry wrote: > Well I'm trying to move to MySQL from the MS SQL Server > world. Most data elements are easy except for the uniqueidentifier. > > In the MySQL world what is the preferred/best way to store a > uniqueidentifier? The easiest would just

Re: GUID storage

Larry Lowry wrote: Well I'm trying to move to MySQL from the MS SQL Server world. Most data elements are easy except for the uniqueidentifier. In the MySQL world what is the preferred/best way to store a uniqueidentifier? The easiest would just be a char(36). Thanks. Larry Lowry In this case I

Re: ESRI GIS products support lacking in MySQL???

Cynically, MySQL is probably not prohibitively expensive enough to hide the prohibitive expense of their add-on product. :) In any event, MySQL is up-front with its features and drawbacks as can be seen here: http://dev.mysql.com/doc/mysql/en/Compatibility.html (Especially scroll down to the sub

myphp problem

I have redhat 9.0 i have install rpms of apache 2.04, php-4.2.2-17 php-mysql-4.2.2.17 i download the latesest phpmyadmin-2.5.6 but when i try http://coopunit.forestry.uga.edu:8080/phpMyAdmin/ i got error cannot load MySQL extension, please check PHP Configuration. How can i fix this problem? Than

GUID storage

Well I'm trying to move to MySQL from the MS SQL Server world. Most data elements are easy except for the uniqueidentifier. In the MySQL world what is the preferred/best way to store a uniqueidentifier? The easiest would just be a char(36). Thanks. Larry Lowry

Re: InnoDB replication to MYISAM

On Wed, May 12, 2004 at 01:38:04PM -0400, Shayne Paddock wrote: > In section 16.7.5 in the mysql manual it says that you can setup > replication with InnoDB tables on the master to MYISAM tables on the > slave. While I have proven this to be true, it does not warn you that > if in your Master's co

Re: --read-only startup

On Wed, May 12, 2004 at 04:11:41PM -0400, Tucker, Gabriel wrote: > Sorry for the second post, I realized that my first post might not be clear... > > I want the failover and the switch from "read-only" to "non > read-only" to be dynamic, no downtime. You can't do that. The read-only setting cann

ESRI GIS products support lacking in MySQL???

I hope this isn't an inappropriate list for this... I have been trying to get ESRI (ww.esri.com) to consider supporting MySQL as a backend Database. They informed me that MySQL doesn't have all the features required to support ESRI's products. Since the alternatives are Oracle and SQL Server,

Re: Database design.. Asking again

* Brian Reichert [...] > I don't know if there's a limit at to how many tables can be handled > by a single MySQL query. This limit is actually hardware architecture dependant: You can join 31 tables on a 32-bit server and 63 tables on a 64-bit server. -- Roger -- MySQL General Mailing List Fo

Re: startup problems with linux

Why use root? How about creating a dummy database (CREATE DATABASE dummy) and a dummy user that only has rights to access that database and have your init.d script connect as the user dummy to db dummy? Much better than leaving MySQL root passwords around in easy to find places. (I know, I know...

RE: --read-only startup

Sorry for the second post, I realized that my first post might not be clear... I want the failover and the switch from "read-only" to "non read-only" to be dynamic, no downtime. Thanks -Original Message- From: [EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 4:07 PM To: Mysql General (E

--read-only startup

Hello all: I am trying to setup a multi-master environment that looks like a master-slave. Let me explain. My system will have all the clients talk to one server. If that server goes down, then it will fail to another. I want the setup to be multi-master so that upon fail-over, the other se

Re: fastest filesystem for MySQL

On Wed, May 12, 2004 at 12:39:59PM -0500, Chris W wrote: > I thouught I read somewhere a while back that MySQL was working on an > option to create a MySQL partition so as to avoide all OS filesystem > overhead to speed things up and I think to save a small bit of over > head. Is this true? Th

Re: How to dump data in db.table syntax?

Hi! On May 12, Nico Sabbi wrote: > Alle Wednesday 12 May 2004 14:12, hai scritto: > > Hi! > > > > On May 12, Nico Sabbi wrote: > > > Alle Wednesday 12 May 2004 11:19, Sergei Golubchik ha scritto: > > > > Hi! > > > > > > > > > sorry for replying to myself, but I verified that adding > > > > > repli

RE: DSNless connection under DAO

I am not sure if this will work in VBA but an you try this? connectionString = "Driver={MySQL ODBC 3.51 Driver};server=localhost;DB=redpath-lims;UID=;PWD=" Dim mysqlRS As New ADODB.Recordset Set mysqlRS = New ADODB.Recordset mysqlRS.ActiveConnection = connectionString mysqlRS.Open "SELECT * FROM i

Re: ORDER BY Question

> > select job_coop as 'Job/Coop', count(*) as Count from queue group by > > job_coop order by Count; > > > The other alternative is to omit the 'as Count' and use this query: > > select job_coop as 'Job/Coop', count(*) > from queue > group by job_coop > order by 2; > > where the '2' in the 'order

Re: startup problems with linux

TK Banks wrote: The startup script provided with Fedora linux uses the mysqladmin ping command to verify that the server is up after the safe_mysqld command has been issued; however, once I changed the password for the root account, this no longer works: it sits there and tries this command 10

Re: DSNless connection under DAO

Yes - the problem occurs inside the OpenDatabase call, which unfortunately is a native VBA function, so I can't debug it. Calling OpenConnection also prompts this dialog to come up. EE Victor Pendleton wrote: Have you tried stepping through this code to see why the application is prompting yo

startup problems with linux

The startup script provided with Fedora linux uses the mysqladmin ping command to verify that the server is up after the safe_mysqld command has been issued; however, once I changed the password for the root account, this no longer works: it sits there and tries this command 10 times on one sec

Re: Database design.. Asking again

On Mon, May 10, 2004 at 09:49:31PM -0700, Scott Haneda wrote: > Sorry for the post again, I hijacked a thread and wanted to get this on the > correct track. > > I can not seem to find the section in the manual that talks about the max > number of tables MySql can use, can someone point me please?

unexpected create table as lock issue

I have a table called web_master which has as a primary key column called web_id. When I try to create another table as a select, I get the following error message [note, that group_id is indexed]: mysql> create table sort_test as select * from web_master where group_id = 69; ERROR 1205: Lock w

RE: DSNless connection under DAO

Have you tried stepping through this code to see why the application is prompting you with the ODBC dialog box? -Original Message- From: Eric Ellsworth To: [EMAIL PROTECTED] Sent: 5/12/04 11:29 AM Subject: DSNless connection under DAO Hi, I am using Microsoft Access to connect to My

RE: Changing Type value of column in an existing table

ALTER TABLE table_name MODIFY col -Original Message- From: Bartis, Robert M (Bob) To: '[EMAIL PROTECTED]' Sent: 5/12/04 12:51 PM Subject: Changing Type value of column in an existing table How does one go about change the data type of a column in an existing table? Robert M. Bartis Lu

Changing Type value of column in an existing table

How does one go about change the data type of a column in an existing table? Robert M. Bartis Lucent Technologies ¢ Room HO 1C-413A (HO) / 1B-304 (WH) ( 732.949.4565 (HO) / 973.386.7426 (WH) * [EMAIL PROTECTED]

InnoDB replication to MYISAM

In section 16.7.5 in the mysql manual it says that you can setup replication with InnoDB tables on the master to MYISAM tables on the slave. While I have proven this to be true, it does not warn you that if in your Master's contstraints you have ON DELETE or ON UPDATE clauses those clauses will no

Re: fastest filesystem for MySQL

I thouught I read somewhere a while back that MySQL was working on an option to create a MySQL partition so as to avoide all OS filesystem overhead to speed things up and I think to save a small bit of over head. Is this true? Chris W. -- Bring Back the HP 15C http://hp15c.org:8080 If you don'

security and extended ascii characters

In an effort to make sure no binary data is maliciously submitted via a form I have code the makes sure all characters in any input field are with in the range of a space to a "~". However now that I am getting some users of my site from Europe, that are having problems submitting some extende

Re: Saving PDF's as Blobs

I tried this and it DOES work with my PDFs. However, I didn't fully understand how LOAD_FILE would handle all different kinds of binary data, so I tried the same thing with a JPG. It ended up dropping over half of the data. So although LOAD_FILE does work for my PDFs, how can I go about getting

DSNless connection under DAO

Hi, I am using Microsoft Access to connect to MySQL 4.0.13-nt on my local machine. I want to use a DSNless connection make sure users don't connect with more privileges than they should have. When I run the code below, I always get the ODBC data source dialog box. How can I suppress this dial

Innodb - next key locking

I have a perl script which fork()'s many children and each child is updating a table, and each child is inserting/updating DIFFERENT rows - I split up the work so that no two children try to update the same row so that no child has to wait for any locks to be released. The problem is, I am getting

RE: MySQL does not automatically start at BOOT time??

Hello List: Few days ago I posted "MySQL does not automatically start at BOOT time??" on this list. Several people responded but the problem was not resolved. I did a fresh install of RH9 & MySQL 4.0.18 (Binary) on a DUAL CPU 1.5 GB Mem server. After reading the MySQL documentation & MySQL book b

Re: Filling column

If I understand you, you've created a new INT column which is empty, and you want to fill it. If so, you could SET @i = 0; UPDATE yourtable SET your_int_col = (@i:= @i + 1); I would imagine that there is an order you want for the resulting sequence. In that case, you should add an ORDER BY

missing manual.ps

Hello, I have just dowloaded mySQL 4.0 onto my PC with Microsoft XP OS on it. After unzipping the file I couldn't find the manual.ps postcript file in the Docs directory. It is not essential for me; I was just curious about it and I thought I give you a shout about it not being there. Th

RE: Case Sensitive

you can add `lower_case_table_names = 1` to the my.cnf to ignore table name sensitivity. -Original Message- From: Andre MATOS To: [EMAIL PROTECTED] Sent: 5/12/04 9:53 AM Subject: Case Sensitive Hi List, I have three MySQL servers. One is running on Windows XP, another on MacOS X, and

Re: Case Sensitive

But this issue can be handled by MySQL. Take a look at the lower_case_table_names system variable. With lower_case_table_names=1 on the Linux/Unix server, table names will be stored as lower case. See the manual for the details,

Re: ORDER BY Question

> select job_coop as 'Job/Coop', count(*) as Count from queue group by > job_coop order by Count; The other alternative is to omit the 'as Count' and use this query: select job_coop as 'Job/Coop', count(*) from queue group by job_coop order by 2; where the '2' in the 'order by' is the number of

RE: Case Sensitive

This isn't caused by MySQL. It's an OS issue. Linux and Unix are case sensitive operating systems so any program you run, unless it is specifically written to be NON-case sensitive, is case sensitive as well. Jack -Original Message- From: Andre MATOS [mailto:[EMAIL PROTECTED] Sent: Wedn

Case Sensitive

Hi List, I have three MySQL servers. One is running on Windows XP, another on MacOS X, and finally one on Linux. All servers have the same version: 4.0.18. Every time when I create tables on the servers Windows XP and MacOS, MySQl creates the database without creating problems with the tabl

Thread safeness

Hello folks, I'm looking for some information about MySQL thread-safeness, but I'm not understanding well the manual (http://dev.mysql.com/doc/mysql/en/Threaded_clients.html). It says "If you don't need interrupts or timeouts, you can just compile a thread-safe client library (mysqlclient

Re: How to dump data in db.table syntax?

Alle Wednesday 12 May 2004 16:14, Egor Egorov ha scritto: > Nico Sabbi <[EMAIL PROTECTED]> wrote: > > Alle Wednesday 12 May 2004 14:12, hai scritto: > >> > > > sorry for replying to myself, but I verified that adding > >> > > > replicate-do-db=db to my.cnf doesn't work as I expected > >> > > > >> >

Re: Filling column

Hi, Is there a function to fill an integer column in incremental order (1,2,..,n). Cannot use Auto_Increment as the table has another primary key. regards Hello A Z, You can declare a column as AUTO_INCREMENT without designating it as a primary key. However, having more than 1 auto_incremen

Re: Filling column

A Z <[EMAIL PROTECTED]> wrote: > > Is there a function to fill an integer column in > incremental order (1,2,..,n). > Cannot use Auto_Increment as the table has another > primary key. > Auto_increment column isn't necessarily to be primary key, it must be indexed. -- For technical support co

Re: How to dump data in db.table syntax?

Nico Sabbi <[EMAIL PROTECTED]> wrote: > Alle Wednesday 12 May 2004 14:12, hai scritto: >> > > >> > > > sorry for replying to myself, but I verified that adding >> > > > replicate-do-db=db to my.cnf doesn't work as I expected >> > > >> > > What do you mean - it doesn't work ? >> > > Or, rather, how

Filling column

Hi, Is there a function to fill an integer column in incremental order (1,2,..,n). Cannot use Auto_Increment as the table has another primary key. regards Yahoo! Messenger - Communicate instantly..

Re: Simple questions!!

Kirti S. Bajwa wrote: Hello List: RH 9 MySQL 4.0.18 Just did a fresh Binary install of MySQL. Also installed support for Perl/DBI/DBD: Question: (1) I am going to setup a MySQL Client machine on a different Server. I notice I can't install a Client MySQL from Binary MySQL distro. Is it correct?

Re: ORDER BY Question

Hi Dirk, you should be able to just add on "ORDER BY Count" after your groub clause. /Johan Dirk Bremer (NISC) wrote: The following query produces the following results: select job_coop as 'Job/Coop', count(*) as Count from queue group by job_coop; -- snip Is there a way to use the ORDER BY clau

Re: ORDER BY Question

Dirk Bremer (NISC) wrote: The following query produces the following results: select job_coop as 'Job/Coop', count(*) as Count from queue group by job_coop; +--+---+ | Job/Coop | Count | +--+---+ | B03013 |19 | | B05044 | 9 | | B07037 | 6 | | B15037 |

Restore 20 gigabytes of binary logfiles

I need to restore 20 gigabytes of binary logfiles. What should I do in order to get the job done as quickly as possible? I am considering this: mysqlbinlog --database=mydb logfiles | mysql -f Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

ORDER BY Question

The following query produces the following results: select job_coop as 'Job/Coop', count(*) as Count from queue group by job_coop; +--+---+ | Job/Coop | Count | +--+---+ | B03013 |19 | | B05044 | 9 | | B07037 | 6 | | B15037 | 4 | | B16032 | 6

Re: Foreign Key Renaming Problem

"Deepak Vishwanathan" <[EMAIL PROTECTED]> wrote: > I have a table named t1 with a column x1 which is the primary key for > that table. There are some other tables that reference this table t1 on > x1 with foreign key constraints. > > > > I wanted to rename the column x1 for some reason, so, I went

replication of temporary tables

Hi, In short: what is the standard MySQL handling of temporary tables, *especially* when you've got a slave filter on to only replicate certain tables? My replication stopped over the weekend, because a query was executed which created temporary tables, then used that table to update one of t

Re: Simple questions!!

Kirti, > (1) I am going to setup a MySQL Client machine on a different Server. I > notice I can't install > a Client MySQL from Binary MySQL distro. Is it correct? I´m not sure, but I think you´ll have to install altmost the complet MySQL package on the client machine. Perhaps because the librari

Simple questions!!

Hello List: RH 9 MySQL 4.0.18 Just did a fresh Binary install of MySQL. Also installed support for Perl/DBI/DBD: Question: (1) I am going to setup a MySQL Client machine on a different Server. I notice I can't install a Client MySQL from Binary MySQL distro. Is it correct? (2) On a Client MyS

Re: mysql on redhat9

"Stephen Camilleri" <[EMAIL PROTECTED]> wrote: > Egor, > > That is what I meant.. I had even tried the -p option but same probs. > > Anyway thanks for interest. I am building up a new installation and will > try whole setup afresh ! :( You can reset password for root user following step by step

Fwd: Re: New Prepared Statements !!!!!

Note: forwarded message attached. Yahoo! India Matrimony: Find your partner online. http://yahoo.shaadi.com/india-matrimony/--- Begin Message --- At 13:08 + 3/12/04, Arunachalam wrote: Sorry to all, I found that these

Re: How to dump data in db.table syntax?

Alle Wednesday 12 May 2004 14:12, hai scritto: > Hi! > > On May 12, Nico Sabbi wrote: > > Alle Wednesday 12 May 2004 11:19, Sergei Golubchik ha scritto: > > > Hi! > > > > > > > sorry for replying to myself, but I verified that adding > > > > replicate-do-db=db to my.cnf doesn't work as I expected >

RE: Two problems with prepared statements in ver 5.0.0

Hello, I have found this trouble between documentation and real API library and quote to MySQL Team and report the BUG last 2 months back. They replied me that it's under development and it would be available to the developers from its next release on Aug 2004. The main changes happens in Prepa

RE: mysql on redhat9

Egor, That is what I meant.. I had even tried the -p option but same probs. Anyway thanks for interest. I am building up a new installation and will try whole setup afresh ! :( Stephen -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: 11 May 2004 17:49 To: [EMAIL PR

Re: How to dump data in db.table syntax?

Hi! On May 12, Nico Sabbi wrote: > Alle Wednesday 12 May 2004 11:19, Sergei Golubchik ha scritto: > > Hi! > > > > > sorry for replying to myself, but I verified that adding > > > replicate-do-db=db to my.cnf doesn't work as I expected > > > > What do you mean - it doesn't work ? > > Or, rather, ho

Fw: Sorting Varchar

> You could also use "order by cost+0,cost". This puts the non-numerics > first, then the numerics in numerical order. (You'd need to get fancier > if there are non-numerics starting with a digit or numerics <= 0.) > > > From: Sasha Pachev <[EMAIL PROTECTED]> > > > > [EMAIL PROTECTED] wrote: >

innodb: is it OK to use many (thousands) tables?

Hi. We have quite a buzy MySQL/InnoDB server. There is a lot activity on the servers and the tables get quite fragmented. In order to fight this we use the "alter table foo type=innodb"-trick. Today, ~100 tables are active. I was thinking of hashing the data out to approx 1100 tables. This will r

Re: fastest filesystem for MySQL

Sasha Pachev wrote: Based on what I've seen so far, JFS and XFS do not yet have a solid track record of stability with MySQL. This does not mean they could not be good - I just do not trust them yet. I do vaguely remember a support case when a very strange corruption happened on either one of

Re: timestamps and timezones

"joe collins" <[EMAIL PROTECTED]> wrote: > I see that > LOCALTIMESTAMP and LOCALTIMESTAMP() are synonyms for NOW() > when I use now() I get the database time but > I have a webhost based in US (Pacific Time), however most database events > will be generated from BST and this is the time zone I

Re: How to dump data in db.table syntax?

Alle Wednesday 12 May 2004 11:19, Sergei Golubchik ha scritto: > Hi! > > On May 11, Nico Sabbi wrote: > > Alle Tuesday 11 May 2004 15:33, Nico Sabbi ha scritto: > > > Alle Tuesday 11 May 2004 15:00, Egor Egorov ha scritto: > > > > Nico Sabbi <[EMAIL PROTECTED]> wrote: > > > > > Hi, > > > > > as the

Re: How to dump data in db.table syntax?

Hi! On May 11, Nico Sabbi wrote: > Alle Tuesday 11 May 2004 15:33, Nico Sabbi ha scritto: > > Alle Tuesday 11 May 2004 15:00, Egor Egorov ha scritto: > > > Nico Sabbi <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > as the title says mysqldump 4.0.18 (and previous versions) doesn't want > > > > to d

Re: Max

Just a minor correction... select YourField from YourTable order by YourField DESC limit 1; ('DESC' in order to return the greatest value first) On Tue, 11 May 2004 17:28:05 +0200, Mikhail Entaltsev <[EMAIL PROTECTED]> wrote: > > Hi, > > select YourField from YourTable order by YourField limit

Re: Error on Start Up: Threadstack not what mysqld wants

- Original Message - From: "Sasha Pachev" <[EMAIL PROTECTED]> To: "Daniel R. Anderson" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, March 04, 2004 7:22 AM Subject: Re: Error on Start Up: Threadstack not what mysqld wants > Daniel R. Anderson wrote: > > Whenever I start up