(FOUO) RE: data-warehouse ETL with MySQL

CLASSIFICATION: UNCLASSIFIED SECURITY CONTROL MARKING: FOR OFFICIAL USE ONLY Perhaps Oracle will do a better job for you in this area. -Original Message- From: Tom Cunningham [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 3:16 AM To: mysql@lists.mysql.com Subject: data-warehouse

Strip off leading and trailing spaces once in db?

Is it possible to remove all trailing and leading spaces for selected fields once the data has already been loaded? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to specify start-up options when it's running as service?

At 16:47 -0700 1/14/05, Michael Loftis wrote: --On Friday, January 14, 2005 14:59 -0800 "Homam S.A." <[EMAIL PROTECTED]> wrote: I know about my.ini, but I'm not sure how to specify these mysqld start-up options to it: --shared-memory --shared-memory-base-name=MYSQL I tried adding entries like: sh

Best Query Question

This has to be so simple, but my solution runs much slower than I would expect it to. I'm wondering if there is a more efficient way to do this type of query. I have a table of email messages, I have another table containing all of the email addresses linked to each email message I want to sea

Re: ???: Symbol `sql_protocol_typelib' has different size in shared object, consider re-linking

Jacob Friis debpro.webcom.dk> writes: > /usr/bin/mysqladmin: Symbol `sql_protocol_typelib' has different size in > shared object, consider re-linking > /etc/cron.daily/mysql-server: > mysqladmin: Symbol `sql_protocol_typelib' has different size in shared > object, consider re-linking > mysql:

Re: How to specify start-up options when it's running as service?

--On Friday, January 14, 2005 14:59 -0800 "Homam S.A." <[EMAIL PROTECTED]> wrote: I know about my.ini, but I'm not sure how to specify these mysqld start-up options to it: --shared-memory --shared-memory-base-name=MYSQL I tried adding entries like: shared-memory=true shared-memory-base-name=MYSQL

Re: MySQL 4.1.8 & InnoDB: data unavailability among different connections

I'm doing the Commit so probably is the extra settings in the SQL. Could you please elaborate a bit more on that? Thank you in advance, Jose. Jeff Mathis escribió: simple answer is transactions. until you issue a commit, or otherwise specify extra settings in your SQL syntax, other connections d

Re: Upgrade correpted InnoDB tables

Mattias, - Original Message - From: "Mattias J" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, January 14, 2005 8:50 PM Subject: Re: Upgrade correpted InnoDB tables At 2005-01-14 18:09, you wrote: this is very strange. Have you used MySQL-5.0.x to create those tabl

How to specify start-up options when it's running as service?

I know about my.ini, but I'm not sure how to specify these mysqld start-up options to it: --shared-memory --shared-memory-base-name=MYSQL I tried adding entries like: shared-memory=true shared-memory-base-name=MYSQL But it didn't work. So my question is, How do I specify the above mysqld start

Re: Limit of 1000 rows?

Steve Grosz wrote: I had tried to load a group of records from a Excel spreadsheet, and for the most part it seems to have worked. The problem is that I know there were more than 1000 rows of data to be input, and it stopped at 1000 exactly. I'm not 100% sure but this is what I think happened.

Re: MySQL/InnoDB-4.1.9 is released

Nick, - Original Message - From: "Nick Arnett" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, January 14, 2005 9:28 PM Subject: Re: MySQL/InnoDB-4.1.9 is released Heikki Tuuri wrote: http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html " The correct way to use LOCK T

Re: Limit of 1000 rows?

It sound like you are exporting from Mysql Command Center which limit records to 1000 by default You can export the data from command line or increase the limit. On Fri, 2005-01-14 at 16:49, Michael Loftis wrote: > --On Friday, January 14, 2005 14:39 -0700 Steve Grosz > <[EMAIL PROTECTED]> wrote

Re: Limit of 1000 rows?

--On Friday, January 14, 2005 14:39 -0700 Steve Grosz <[EMAIL PROTECTED]> wrote: I had tried to load a group of records from a Excel spreadsheet, and for the most part it seems to have worked. The problem is that I know there were more than 1000 rows of data to be input, and it stopped at 1000 e

Limit of 1000 rows?

I had tried to load a group of records from a Excel spreadsheet, and for the most part it seems to have worked. The problem is that I know there were more than 1000 rows of data to be input, and it stopped at 1000 exactly. Am I missing something to allow more than 1000 rows to be input? Steve -

Getting 4.0.18 to log connects, connect errors, and NOT queries...

IS there any way to get the 4.0.18/4.0 series to log client connects (disconnects maybe too, but that's optional) connect errors (IE password/auth failures) WITHOUT logging every query? Like every time a client gets say ERROR 1045: Access denied for user: [EMAIL PROTECTED]' (Using password: YE

what permissions are necessary in 4.1.x to allow a user to change their own password

In 4.0.x and 3.23.x a user with these permissions: GRANT USAGE ON *.* TO 'bogus'@'%' IDENTIFIED BY PASSWORD '7f8933111c70fb1d' could still change their own password with: set password for bogus = password('bogus'); After upgrading to 4.1.7 my users are getting this error: ER

Re: actual size of a innodb tablespace

if you issue a "show table status" command from the mysql prompt, you'll get an estimate of how much free space exists in the files. Duhaime Johanne wrote: Hello Context: innodb per table. Is it possible to know the actual size of my innodb file? What part of the initial size (10M: autoexten

actual size of a innodb tablespace

Hello Context: innodb per table. Is it possible to know the actual size of my innodb file? What part of the initial size (10M: autoextend) is actually used? I would like to have an idea of the data space progression? Per database (I have 3). Thank you in advance Johanne Duhaime IRCM courr

Re: simple concurrency problem - any advice ??

Tim Wood wrote: > a-- select test_id from tests where status=1 and priority < 11 order by priority b-- update tests set status=2 where test_id = What's the best way to ensure that a single client executes both a and b atomically so that no other client can show up and execute an 'a' between ano

Re: MySQL 4.1.8 & InnoDB: data unavailability among different connections

simple answer is transactions. until you issue a commit, or otherwise specify extra settings in your SQL syntax, other connections do not see your data. Jose Antonio wrote: Hi! I am experiencing something weird using MySQL 4.1.8 with InnoDB tables. I have an application, let's call it A, that is

Recovering from a drop table with the Innodb per table setting

Hello I look throught the documentation but could not find what I was looking for (at least I could read between lines). I have mysql 4.1.7 on solaris and I have 3 differents databanks (let-s D1, D2, D3). Each of those databases are a mix of innob and MyIsam. If by mistake a table is dropped

MySQL 4.1.8 & InnoDB: data unavailability among different connections

Hi! I am experiencing something weird using MySQL 4.1.8 with InnoDB tables. I have an application, let's call it A, that is monitoring the data that is available in the database. The data is inserted in the database by a different application, let's call it B. The problem is the following: A star

Re: counting records in 2 tables using 1 query

OK, then you were on the right track with your JOINS because you wanted to know how many of each type of item (gift or event) each user had. Off the top of my head, I think you need to perform an OUTER JOIN (not the implicit INNER JOIN you create by listing table names separated by commas) and

Re: MySQL/InnoDB-4.1.9 is released

Heikki Tuuri wrote: http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html " The correct way to use LOCK TABLES with transactional tables, like InnoDB, is to set AUTOCOMMIT = 0 and not to call UNLOCK TABLES until you commit the transaction explicitly. When you call LOCK TABLES, InnoDB internally tak

Re: Perl Script to transform a MySql insert into an update

On Fri, 14 Jan 2005 18:42:41 +, wrote: >Hi, >Does anyone have a Perl Script (or other) to transform a MySql insert into an >update (or >vice-versa)??? Just wrote a QAD (Quick and dirty) script see below, has no error handling #!perl # sedit.pl # description : Transform a mysql insert into

Re: Upgrade correpted InnoDB tables

At 2005-01-14 18:09, you wrote: this is very strange. Have you used MySQL-5.0.x to create those tables? Or which MySQL version did you use when you created those tables? ... was it so that you RECREATED those tables with 4.0.21, and you STILL got the error in 4.1.8? We have never used MySQL 5. Wh

Perl Script to transform a MySql insert into an update

Hi, Does anyone have a Perl Script (or other) to transform a MySql insert into an update (or vice-versa)??? zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL

Re: counting records in 2 tables using 1 query

[EMAIL PROTECTED] wrote: There may be other ways to get at the information you want. What is the purpose of your query? Ok here are the details. I have a wish list/gift registry site (thewishzone.com). I have a table listing all the data on my users. I also have a table listing all the gifts

Error message on Solaris server - help

Getting the following runtime error messages on a Solaris server, Mysql 4.1.7 PHP 5.0.1: I try to search and: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data/labweb/htdocs/getit/search010.php on line 123 Warning: mysql_num_rows(): supplied argument i

Re: MySQL/InnoDB-4.1.9 is released

Nick, - Original Message - From: "Nick Arnett" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, January 14, 2005 7:39 PM Subject: Re: MySQL/InnoDB-4.1.9 is released Heikki Tuuri wrote: * Do not acquire an internal InnoDB table lock in LOCK TABLES if AUTOCOMMIT=1. This

Re: Selecting a random record from more than 1 table

I'm putting this discussion back on the list so that others can learn from it and/or contribute to it. So, have I got this right? You have two completely independent and unrelated tables, one containing Phones and one containing Other products and you want to choose a single one at random from the

Re: MySQL/InnoDB-4.1.9 is released

Heikki Tuuri wrote: * Do not acquire an internal InnoDB table lock in LOCK TABLES if AUTOCOMMIT=1. This helps in porting old MyISAM applications to InnoDB. InnoDB table locks in that case caused very easily deadlocks. Could you explain a bit more about how this relates to MyISAM? Is it just tha

Re: Getting started (using a mac)

Yes, you can deliver commands from the "terminal", kind of. But you have to be in the mysql command line client program. PHP works through Apache and has commands to access MySQL and many other databases. You need to enable the PHP module in the Apache configuration file. But you should get at

Re: Generic graphing tool?

And my personal favorite perl gd http://stein.cshl.org/WWW/software/GD/ At Fri, 14 Jan 2005 12:18:58 -0500, Li Qin wrote: > > Hi, > > We are using gnuplot. It is not as simple as a select statement and some > options, but needs a couple of lines of Perl (or whatever other scripting > langu

RE: Generic graphing tool?

Hi, We are using gnuplot. It is not as simple as a select statement and some options, but needs a couple of lines of Perl (or whatever other scripting language). It is very easy to use. Li -Original Message- From: Curtis Maurand [mailto:[EMAIL PROTECTED] Sent: Friday, January 14,

Re: Upgrade correpted InnoDB tables

Mattias, was it so that you RECREATED those tables with 4.0.21, and you STILL got the error in 4.1.8? Regards, Heikki - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: Sent: Friday, January 14, 2005 7:02 PM Subject: Re: Upgrade correpted InnoDB tables Mattias, this is

Re: Upgrade correpted InnoDB tables

Mattias, this is very strange. Have you used MySQL-5.0.x to create those tables? Or which MySQL version did you use when you created those tables? Regards, Heikki - Original Message - From: "Mattias J" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, January 14, 2005

Re: Getting started (using a mac)

Google is your friend...there are TONS of great sites and code snippets out there. I bought several books and found that the web and google always had better info/articles/etc. --s Scott Franks On Jan 14, 2005, at 11:21 AM, Peter O'Brien wrote: Hi I'm just getting started with PHP and MySQL. I'

Re: Getting started (using a mac)

Hi I'm just getting started with PHP and MySQL. I'm confused about from where I can deliver commands etc. I'm working from a mac OS X, can I do it from the 'Terminal' utility? Or do I need to install something else, like PuTTY? I've a fair idea on how to use PHP but it's combination with MySQL I

Re: subquery, returns more than one filed?

Hello. Starting with MySQL 4.1, all subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. You use subquery in a wrong way. See: http://dev.mysql.com/doc/mysql/en/Subquery_errors.html Jerry Swanson <[EMAIL PROTEC

Re: Memory tables much slower in 4.1.7 ?

Hello. > But now this takes forever... May be you have some locks or your system is heavy-loaded. Use 4.1.9 instead of 4.1.7. "Kevin A. Burton" <[EMAIL PROTECTED]> wrote: > Under 4.0.18 we were loading about 800M of data into a memory table to > get better performance from some of our

Re: Generic graphing tool?

There are several PHP scripts that develop graphs. You'll have do some work to feed the data to them, but I found them at: http://www.hotscripts.com/PHP/Scripts_and Programs/Graphs_and_Charts/ Curtis Jim wrote: Jason Martin wrote: Does anyone know of a web-based tool that will let you graph arbi

Re: Upgrade correpted InnoDB tables

Ok. This is what happened: We removed MySQL from the server and re-installed 4.0(.21) then put back some old data. When trying to upgrade to 4.1.9 we encountered the same problem, with the exact same tables being corrupted! For one of the tables, as an example, the innodb_table_monitor says 05

Re: MySQL & Perl

Gerald, Your connect string needs to be DBI:mysql::. PB - Gerald Preston wrote: I am trying to get Perl to talk to MySQL that I have setup. According to "WinMySQLAdmin1.4" Local Host Name = GJW Local User name = Jerry Databases: GJW Club bar mysql test I am using the following

Re: Selecting a random record from more than 1 table

- Original Message - From: "Christian Biggins" <[EMAIL PROTECTED]> To: Sent: Friday, January 14, 2005 12:07 AM Subject: Selecting a random record from more than 1 table > Hi Guys > > I am trying to display 1 random record taken from 2 tables. > > I have tried the following; > > SELECT

Re: MySQL & Perl

Hi Gerald Looks like you need a username Jerry not gjw, here is the format I use to connect. Mike $dsn = "DBI:mysql:host=$host_name;database=$db_name" return (DBI->connect ($dsn, $username,$password, {PrintError => 0, RaiseError => 1})); - Original Message - From: "Gerald Pr

Re: Error in Insert on Duplicate Key Update

Quoting sam wun <[EMAIL PROTECTED]>: > HI, > > the following insert/update produced error. I m using MySQL 5.0. > $insert_sql = qq {insert into inventory > (prodcode,qty,lastupdatedate,prodname,basename,vendorname,cost) > values (?,?,?,?,?,?,?) ON DUPLICATE KEY > U

Where are warning messages redirected or logged to ?

A pain replying to digest in digest mode, change mode to normal Warning messages, as from a mysqlimport command, where are they to be found? Part of the construct from a cron job script file run at the command line interface $ /usr/local/bin/mysqlimport -v -l --fields-terminated-by="

data-warehouse ETL with MySQL

Hi everybody. This is just a note to tell people what I'm doing, hoping I might get some comments. In short: I have been using MySQL SQL scripts to do data-warehouse ETL for about 6 months. It's gone well, but perhaps getting a little creaky now. The general format is this: 1. Add any new recor

Re: Upgrade correpted InnoDB tables

Mattias, please use innodb_table_monitor to print the contents of the InnoDB internal data dictionary. http://dev.mysql.com/doc/mysql/en/InnoDB_Monitor.html Regards, Heikki - Original Message - From: "Mattias J" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, Januar

Translation in french

I would like to use eventum with french labels. Can anyone tell me if one version exists in french? Thank you for your help. Fred. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL/InnoDB-4.1.9 is released

Hi! InnoDB is the MySQL table type that supports FOREIGN KEY constraints, row-level locking, Oracle-style consistent, non-locking SELECTs, multiple tablespaces, and a non-free online hot backup tool. Release 4.1.9 is mainly a bugfix release. This release fixes the CRITICAL BUG #7496 in the inno

MySQL & Perl

I am trying to get Perl to talk to MySQL that I have setup. According to "WinMySQLAdmin1.4" Local Host Name = GJW Local User name = Jerry Databases: GJW Club bar mysql test I am using the following code: #!/perl use warnings; use strict; use DBI;