Re: copy DB data from FreeBSD to Redhat9.0

Gleb Paharenko wrote: Hello. I also want to copy the user accounts in MySQL5.0 db over to MySQL4.1 in Redhat as well. All user accounts and rights are stored in the tables of mysql database. And fields of grant tables in 4.1.x version just a subset of fields in 5.0.x. You should set

Transparent schema update for replicated installs

(Did I send this off to the list already? It doesn't seem to be updated! ) I've been thinking recently about supporting transparent schema update of production systems in order to deliver zero downtime. What I'm thinking of is a scenario where you use a load balancer to take one of the slaves, al

RE: MySQL and triggers

On Monday, February 28, 2005 18:35, [EMAIL PROTECTED] wrote: > Hey. > We are two girls who are new to using MySQL. We are using MySQL 4.1, > and we wonder if this version supports the use of triggers? We have > tried to find the answer ourself, but with no luck - can anyone help > us? Not in 4.

MySQL and triggers

Hey. We are two girls who are new to using MySQL. We are using MySQL 4.1, and we wonder if this version supports the use of triggers? We have tried to find the answer ourself, but with no luck - can anyone help us? Best regards Marianne -- MySQL General Mailing List For list archives: http:

Fetching tables

Dears ,I have following code segment: MYSQL_ROW row; ptrm.tblres=mysql_list_tables(ptrm.connection2db,"%"); cout << mysql_num_rows(ptrm.tblres); while (row=mysql_fetch_row(ptrm.tblres)) for (i=0;ihttp://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Geologic Time

Peter Brawley wrote, "The earliest possible MySQL date is around 1000CE, so you could not store geologic dates in MySQL date cols. "Million years before present" is the geologic time unit that would most likely cohere with other geo databases, isn't it? Then the Cambrian would show up around 580 m

RE: insert data

Hi Gerald, There are some good tutorials on the web for DBI access via perl to mysql. http://www.wbluhm.com/MySQLTut.html http://perl.about.com/od/installandusemysql/l/aa090803b.htm http://dev.mysql.com/doc/mysql/en/perl.html and also http://search.cpan.org/~timb/DBI-1.47/DBI.pm You should be

Re: insert data

Hi Gerald my last try... i'm not very lucky in helping in this list... > This is the actual code except for the "": > > [...] > my $sth = $dbh->prepare( $sql ) or die $dbh->errstr if $dbh->err; Maybe this expression is the reason (combination of 'or' and 'if'). Example code: === my $no_e

RE: insert data

William, I tried " GRANT ALL ON *.* " and got error " 1064 <4200>: You have an error in your SQL syntax " ?? Jerry -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED] Sent: Monday, February 28, 2005 3:25 PM To: mysql@lists.mysql.com Subject: RE: insert data Gerald Pr

EBCDIC collation sequence

Hi There doesn't appear to be any info. on the archives regarding this, so does anyone know what character set/collation sequence to use for EBCDIC rather than ASCII collation? Cheers Bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lis

Query Help

I have a table that tracks events by month and year. The field names are (you guessed it) 'month' and 'year'. I need to do queries over some date range from variables , to , . How can I do this? SELECT state, SUM(borks) AS borkcount FROM borkstats WHERE GROUP BY state ORDE

Re: ODD COUNT(*) Results on Self-Join (Bug?)

Tom: The second file_details.FileName NOT LIKE '%_ds.php3' Was the culprit. Not a horrible explanation at all. Thanks for the extra pair of eyes! Regards, Van = http://www.dedserius.com/-Linux rocks!!! ==

Re: Geologic Time

David, The earliest possible MySQL date is around 1000CE, so you could not store geologic dates in MySQL date cols. "Million years before present" is the geologic time unit that would most likely cohere with other geo databases, isn't it? Then the Cambrian would show up around 580 mya, the begi

RE: ODD COUNT(*) Results on Self-Join (Bug?)

On Monday, February 28, 2005 14:54, Van wrote: > Tom: > > I see your point, but the group by is necessary so I can walk through > all Song Title groups and get the total number of unique versions of > that song. If I do this: > SELECT DISTINCT file_details.Title, > file_details_1.CD, >

mysqldump specific tables from multiple databases?

all, is it possible to mysqldump specific tables from multiple databases in a single run? what I am trying to do is get replication slaves to a starting point but am somewhat challenged by the nature of our architecture. specifically, we have a large number of relatively-static (updated only a f

Re: Geologic Time

If you want to represent 290 million years as an integer (290,000,000): - An UNSIGNED INT can store 4,294,967,295 - A UNSIGNED BIGINT can store 18,446,744,073,709,551,615 In your schema, I'd use a start_period and end_period instead of a varchar. It's easier to sort and do math on. You could fac

Re: SQL help

In article <[EMAIL PROTECTED]>, "Rob Brooks" <[EMAIL PROTECTED]> writes: > The only difference in the 2 statements is the 'where items_online.ID = > NULL' part. > Clearly in the first set, items_online.ID = NULL in record 7047 ... Nope. items_online.ID IS NULL for that record, but comparing anyt

Innodb and Linux 2.6 Async I/O ??

Just found and read this study: http://www.distlab.dk/badger/Publications/report0403.ps and was curious to see if anyone has any additional thoughts as to the contents? Greg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

Re: insert data

Are you sure that the parameters in the execute are all properly defined? Try this: my $dbh = DBI->connect( 'DBI:mysql:database=club', '', '', { PrintError => 0 } ) or die $DBI::errstr; my $sql = "insert into bar( group_name, me, daily, item, unit, qty, amount, tax, total ) val

Re: SQL help

NULL is an unknown value. Consequently, you cannot compare NULLs the way you expect. Effectively, = NULL is always false. Instead of items_online.ID = NULL you have to use items_online.ID IS NULL Michael Rob Brooks wrote: in question below, the problem is not in record '7047' but in the

Re: mysql open connections question

On Mon, 2005-02-28 at 14:42, Scott Purcell wrote: Hi! you haven't mentioned your OS so some of these items will be a guess at how _you_ would actually do it.. I'm basing this on Linux or any modern *nix OS. > Hello, > > I am writing a web-based application and incorporated a roll-your-own >

RE: SQL help

Properly, NULL values should be matched with 'foo IS NULL', as opposed to 'foo = NULL' which, by standard definition, always returns false regardless of the value of foo - michael dykman On Mon, 2005-02-28 at 16:02, Rob Brooks wrote: > in question below, the problem is not in record '7047' but

RE: insert data

Gerald Preston said: > Michael, > > This is the actual code except for the "": > > my $dbh = DBI->connect( 'DBI:mysql:database=club', '', '', { > PrintError => 0 } ) or die $DBI::errstr; > my $sql = "insert into wolfies( group_name, me, daily, item, unit, > qty, > amount, tax, total

RE: insert data

Michael, This is the actual code except for the "": my $dbh = DBI->connect( 'DBI:mysql:database=club', '', '', { PrintError => 0 } ) or die $DBI::errstr; my $sql = "insert into wolfies( group_name, me, daily, item, unit, qty, amount, tax, total ) values(

RE: SQL help

in question below, the problem is not in record '7047' but in the record which starts with the name 'Triad' also ... I'm using 4.0.20-standard-log -Original Message- From: Rob Brooks [mailto:[EMAIL PROTECTED] Sent: Monday, February 28, 2005 2:56 PM To: mysql@lists.mysql.com Subject: SQ

SQL help

Can someone help me with this? this statement: select Items.Name, Items.Detail, Items.ID, items_online.ID from Items left join items_online on items_online.ItemKey = Items.ID where (Name regexp 'ad') and AccountKey = 108 and Items.Active = 1; gives this: +---+--

Re: ODD COUNT(*) Results on Self-Join (Bug?)

Tom: I see your point, but the group by is necessary so I can walk through all Song Title groups and get the total number of unique versions of that song. If I do this: SELECT DISTINCT file_details.Title, file_details_1.CD, file_details_1.mp3Name, COUNT(*) AS cnt FROM file

mysql open connections question

Hello, I am writing a web-based application and incorporated a roll-your-own database pool into it. So far I am running well, but I have seen a couple of issues I would like to present. After being up for a couple of days, I noticed a "Error cannot connect, too many connections" error coming

Geologic Time

I'm working on a geologic time database and want to ask a question about geologic time. Can/should you apply MySQL's date function to geologic time? In other words, if I create a field for the number of years ago a certain geologic period began or ended - say 260 million years ago - could I design

Re: [GENERAL] Reading from Mysql & writting in PGsql

On Sun, Feb 27, 2005 at 03:27:48PM -0800, Mohsen Pahlevanzadeh wrote: > Dears,I need to read 1 field with select command from mysql. Then > Write it to pgsql. Please guide me. If you need to do this directly, look into dbi-link. http://pgfoundry.org/projects/dbi-link/ There are conversion

[Fwd: Re: Strange Issues]

Original Message Subject: Re: Strange Issues Date: Mon, 28 Feb 2005 20:47:37 +0200 From: Rob Cochrane <[EMAIL PROTECTED]> Organization: By Rob.com To: Rob Cochrane <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTE

Re: Fwd: how can I do instead of using subselects?

Joppe, Another question is how do I do when I want to compare two tables, normally is it no problem to get a list with rows that exist i both tables, but how do I do if I want to to have the diffrence listed instead, the rows that only appears in one of the tables? SELECT * FROM tblA LEFT JOIN t

Re: how can I do instead of using subselects?

Joppe, >I have a problem with a few sql-queries because I have written the questions >with subselect statements and then will they not work on older MySQL DB:s. >Can any one help me to say haw to solve it without subselect! >Today looks the questions like this: >SELECT > (SELECT count(SUB.S_ID)

Re: insert data

From perldoc DBD::mysql use DBI; $dsn = "DBI:mysql:database=$database;host=$hostname;port=$port"; $dbh = DBI->connect($dsn, $user, $password); So it's not a syntax problem. Even if it were, we should detect the error long before calling prepare or execute. Perl is quite clearly telling you

Edwin Limachi está ausente de la oficina.

Estaré ausente de la oficina desde el 28/02/2005 y no volveré hasta el 04/03/2005. Podré atender sus mensajes únicamente al final de la tarde. Para emergencias envie un mensaje a mi teléfono celular. Agradezco su comprensión. Exito para el Nuevo Año. -- MySQL General Mailing List For list arch

Re: insert data

I sent this earlier, but it doesn't seem to have gone through. Apologies to anyone who gets it twice. = From perldoc DBD::mysql use DBI; $dsn = "DBI:mysql:database=$database;host=$hostname;port=$port"; $dbh = DBI->connect($dsn, $user, $password); So it's not a syntax problem. Even

Re: problem with adding timestamp as a column

Hi, Joerg, Thank you very much for your clear reply. Now I completely understand what is going on behind the screen. Also a big thanks to all the people who gave me kind reply. Regards, Zhe Joerg Bruehe wrote: Hi! Am Mo, den 28.02.2005 schrieb Hank um 17:09: [top-posting reordered!] > On Mon

Re: Automatic server-id generation for slaves?

"Kevin A. Burton" <[EMAIL PROTECTED]> wrote on 28/02/2005 17:41:07: > Right now one of the only reasons we can't put our entire config for our > slaves in CVSup is that the config *requires* the ability to set a > server-id for each machine. > > Seems like it would be pretty trivial to support

Re: two-way replication

- Original Message - From: <[EMAIL PROTECTED]> To: "Chris Knipe" <[EMAIL PROTECTED]> Cc: Sent: Monday, February 28, 2005 7:11 PM Subject: Re: two-way replication "Chris Knipe" <[EMAIL PROTECTED]> wrote on 02/28/2005 11:53:14 AM: Hi, Is two-way replication possible with MySQL 5.x? Any g

Automatic server-id generation for slaves?

Right now one of the only reasons we can't put our entire config for our slaves in CVSup is that the config *requires* the ability to set a server-id for each machine. Seems like it would be pretty trivial to support a hostname based policy for this. You could simply look at the IP/hostname a

Re: problem with adding timestamp as a column

Hi! Am Mo, den 28.02.2005 schrieb Hank um 17:09: [top-posting reordered!] > On Mon, 28 Feb 2005 10:05:32 -0500, Zhe Wang <[EMAIL PROTECTED]> wrote: > > Hi, there, > > > > I have MySQL 4.1.10. I need to add a timestamp column to an existing > > table. I am having a problem of setting the newly ad

Re: two-way replication

"Chris Knipe" <[EMAIL PROTECTED]> wrote on 02/28/2005 11:53:14 AM: > Hi, > > Is two-way replication possible with MySQL 5.x? Any good sites / docs > describing this type of setup? > > -- > Chris. > > By "two-way" replication, do you mean "changes to either database are synchronized to the

Re: Strange Issues

Hi Gleb, Ok here is the command line info which also answers the version question. Enter password: ** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.9-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show

two-way replication

Hi, Is two-way replication possible with MySQL 5.x? Any good sites / docs describing this type of setup? -- Chris. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: alter table return error

Michael Stassen wrote: Did you try perror? ~: perror 150 Error code 150: Unknown error: 150 150 = Foreign key constraint is incorrectly formed Right, I forgot to alter one table that had a FK on this table. Thanks ;) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For l

innodb_buffer_pool_size - max_connections?

Can I assume that that with a innodb_buffer_pool_size of 1G I can accept only 500 max_connections (stack size 2M*500 connections). Also, I noticed that I can't set a innodb_buffer_pool_size > 1G. Ideas? Max -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubsc

Re: problem with adding timestamp as a column

I'd suggest not using the keyword "timestamp" as a column name. I'd suggest using "ts" or "tstamp" or something like that. To update the records to the current timestamp: update try set tstamp=null; should do it. I don't know why the default isn't working, though. On Mon, 28 Feb 2005 1

Re: alter table return error

Did you try perror? ~: perror 150 Error code 150: Unknown error: 150 150 = Foreign key constraint is incorrectly formed Michael Philippe Poelvoorde wrote: Hi, I'm trying to add an 'unsigned' attribute to one column : > alter table markets modify Id integer unsigned not null auto_increment;

alter table return error

Hi, I'm trying to add an 'unsigned' attribute to one column : > alter table markets modify Id integer unsigned not null auto_increment; ERROR 1025: Error on rename of './eurex_dax/#sql-1d2c_2f' to './eurex_dax/markets' (errno: 150) The query runs without any problems on any others tables (all are

problem with adding timestamp as a column

Hi, there, I have MySQL 4.1.10. I need to add a timestamp column to an existing table. I am having a problem of setting the newly added column to be the current time. This is what I did: CREATE TABLE try (id INTEGER); INSERT INTO try VALUES(1), (2), (3); ALTER TABLE try ADD timestamp TIMESTAMP

RE: mysql index cardinality

Nobody to explain me that? From: "mel list_php" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: mysql index cardinality Date: Fri, 25 Feb 2005 16:47:12 + Hi, A strange thing with index, I thought the cardinality was automatically updated (like for a primary key for exemple). When I use

mysqld got signal 11

Hi, I have a problem with some of my servers running 4.1.10. It is running on linux 2.6.10, Fedora Core 3 default installation. The mysql I use is from RPM package that mysql.com provides. About once a day, the servers will crash and I find mysqld got signal 11 error on the log file. These machi

field varchar and char truncate the ended blank characters

I got this problem: I need to save in a varchar field a string wich can have the ended part filled with blank character, and I need to restore the string in the same way it was saved, ie. with the right number of ended blank characters. Mysql truncate tha last blank characaters of a field for exa

Fwd: how can I do instead of using subselects?

Please help, this must be easy for experinced MySQL users but for me as a newbie isn't it. I have tried to find the answer on the things below in older MySQL manuals but without any success... I have a problem with a few sql-queries because I have written the questions with subselect statement

Re: Strange Issues (UTF-8)

To me it should be a simple task. Insert <65k of text in Unicode or even simple ASCII format into a column of type 'text' by using a GUI client like SQLyog or MySQLCC and then extract it when needed by my web page without loosing everything I put in after a certain character or character sequen

Re: Strange Issues

Hello. At first, we should check that there is nothing wrong with the character_set_xxx variables. Please send us the output of the following statement: show variables like '%char%'; Does the problem remain if you are making the query using a mysql command line client? Do you use the

Re: User that can create another user - which privileges must be granted

Hello. GRANT OPTION for adding user, and UPDATE on the mysql database to set the passwords for them. See: http://dev.mysql.com/doc/mysql/en/grant.html http://dev.mysql.com/doc/mysql/en/set-password.html "Peter PeterDresden" <[EMAIL PROTECTED]> wrote: > ...to that user, that he

my.cnf and InnoDB

Can you help me figure out the max connections # for a 2GB ram (2GB swap mem) server running myslq 4.0.16-Max-log and fedora core1. [mysqld] max_connections= ? innodb_buffer_pool_size=1G The database size is approx 100 Mb with 1,700++ tables, increasing daily.. ulimit -a core file size

Re: log-warnings

On 18 Feb 2005, at 16:05, Gleb Paharenko wrote: There is no direct way to load warnings into log files. Just for the archives, I reported this as a bug and it's in the MySQL bug db as having been verified, so I guess now we just hope/wait for a fix in a later version: http://bugs.mysql.com/bug.p

Re: FULLTEXT Exact phrase search including quotes

Hello. >and I want to search for this exact phrase, including double quotes, You can't do this, because fulltext search operates with "words", and double quotes not a "word". Also an order of the sequence of words doesn't have a sence for a fulltext search. CheHax <[EMAIL PROTECT

Re: Problem with system tables

Hello. > /usr/sbin/mysqld: File '/var/mysql-bin.03' not found (Errcode: 13) [EMAIL PROTECTED] mysql-debug-4.1.10-pc-linux-gnu-i686]$ perror 13 Error code 13: Permission denied I suggest you to check the permissions on your directories. Leo <[EMAIL PROTECTED]> wrote: > [-- te

Re: Access Denied For User

Hello. I successufully connected to MySQL server using your parameters in odbc.ini and odbcinst.ini files from php. > [unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user: > '[EMAIL PROTECTED]' (Using password: NO) You have specified the user and the password in the ODBC configurat

Re: Linking problems

Hello. >g++ -o sqltest sqltest.o -L/usr/lib/mysql -R/usr/lib/mysql -lmysqlclient -lm >-lz You should specify the location of libmysqlpp.a and add -lmysqlpp to the list of libraries. Remove -R flag. Look into the mysql++-1.7.28/examples directory. Arthur <[EMAIL PROTECTED]> wrote: >

Re: Fedora Core 2: upgrade mysql 3 to mysql 4

Hello. > I want to upgrade mysql 3 to mysql 4. At first, you should read: http://dev.mysql.com/doc/mysql/en/upgrade.html Search the MySQL lists archives about possible problems which you can expect. It is strongly recommended to make a backup. > How to remove mysql3 and install mys

Re: Strange Issues

Hi, After spending about a week researching the use of hex [string] values I am still as lost as I was before. What is the point of placing Unicode data into a column if I have to convert it when going both in and out? All the documentation I read on MySQL indicates it supports Unicode I cannot

User that can create another user - which privileges must be granted

...to that user, that he can create new users, e.g. which administrative privileges must be granted to that user. Thanx. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql tuning - server Crash 1

I have increased innodb buffer pull size to 1G (50% of my 2G ram) What do you suggest (size) for innodb_data_file_path I'm note sure about this variable usage in mysql performance. Thanks. On Mon, 28 Feb 2005 11:47:27 +0200, Heikki Tuuri <[EMAIL PROTECTED]> wrote: > Max, > > - Original Messag

how can I do instead of using subselects?

Hello everyone, I have a problem with a few sql-queries because I have written the questions with subselect statements and then will they not work on older MySQL DB:s. Can any one help me to say haw to solve it without subselect! Today looks the questions like this: SELECT (SELECT count(SUB.S

Re: Mysql tuning - server Crash 1

Max, - Original Message - From: "Deluxe Web" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, February 28, 2005 11:44 AM Subject: Re: Mysql tuning - server Crash 1 Hi I understand.. I should switch to debian :) but in the meantime what about the innodb buffer pull si

Re: Mysql tuning - server Crash 1

Hi I understand.. I should switch to debian :) but in the meantime what about the innodb buffer pull size Have you seen my variables. I had 8M? Can this be the bottle neck? On Mon, 28 Feb 2005 11:34:31 +0200, Heikki Tuuri <[EMAIL PROTECTED]> wrote: > Max, > > maybe the 640 connection piled up b

Re: Mysql tuning - server Crash 1

Max, maybe the 640 connection piled up because mysqld was hung? It is not very likely that all those threads would have taken > 3 MB of memory. Usually they take much less. The best advice is to upgrade to a recent 4.0.xx or 4.1.xx version of MySQL, which may print more info in a hang. An upgra

Re: FULLTEXT Exact phrase search including quotes

Alright, my example phrase wasn't a good one. Let's try this now: We have a table with company activities. On of them is : "Plastique ou carton" and some others are in "Plastic, carton" Plastique <> Plastic (different language) What we want, is to find exactly "Plastique ou carton" and not the o

Re: Mysql tuning - server Crash 1

Donny, - Original Message - From: ""Donny Simonton"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, February 28, 2005 2:00 AM Subject: RE: Mysql tuning - server Crash 1 Heikki, I sent this to a few friends of mine who work on fedora quite a bit. As a general note,

Re: LOAD INDEX INTO CACHE problem

Hi! The change of key_buffer_size worked like a charm. Thank you ! CheHax -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]