Re: MySQL Connector/ODBC 5.2.6 has been released

no binaries for AIX? -- saqib http://hivemined.net On Wed, Oct 9, 2013 at 3:02 PM, Kent Boortz wrote: > > Dear MySQL users, > > MySQL Connector/ODBC 5.2.6, a new version of the ODBC driver for the > MySQL database management system, has been released. > > The availa

Connecting to MySQL Community Edition from Informatica Powercenter 9.5.1 running on AIX

Is it possible to MySQL Community Edition (as target) from Informatica Powercenter 9.5.1 running on AIX? If so, what is ODBC driver should we use?

using a subquery/self-join to recursively retrieve a tree

up to a manager, regardless of how deep the tree is. I can do this usindg LDAP and/or PHP, but not sure how to do it as a mysql query. Any thoughts? Thanks saqib http://www.capital-punishment.us -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: How to create a unicode capable table??

Hello, Any thoughts on this? Thanks. On Tue, Nov 25, 2008 at 8:14 PM, Ali, Saqib <[EMAIL PROTECTED]> wrote: > What Charset and Collation should I use while creating a mysql table > such that it can take data from unicode SQL Server DB table? > > Thanks > saqib > http:

How to create a unicode capable table??

What Charset and Collation should I use while creating a mysql table such that it can take data from unicode SQL Server DB table? Thanks saqib http://doctrina.wordpress.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Importing MS SQL exported CSV files adds spaces

> try "OPTIONALLY ENCLOSED BY ' " ' already tried that. no help :( saqib http://doctrina.wordpress.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Importing MS SQL exported CSV files adds spaces

I exported a large data set from from Microsoft SQL server in CSV format. However whenever I try to import that data to a a mySQL server running on Linux, it adds a space between each character in each field. Essentially: Saqib Ali becomes S a q i b A l i I have tried to use the dos2unix cmd on

Re: What to do if a table is supposed to get > 3GB data per day?

wow 30GB is a lot of data. Do let us know what kind of hardware / OS you are using. In the past I have worked with larger tables then these, but I was using Objectivity DB running on UltraSPARC 64bit architecture. -- Saqib Ali, CISSP, ISSAP http://www.full-disk-encryption.net -- MySQL General

Re: What is your favorite GUI tool for creating and querying tables in MySQL?

and also http://fabforce.net/dbdesigner4/ sorry for 2 seperate emails. saqib http://www.full-disk-encryption.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: What is your favorite GUI tool for creating and querying tables in MySQL?

sqlyog is pretty nice: http://www.webyog.com/ saqib http://www.full-disk-encryption.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Retaining last primary key value

try the DELETE with the WHERE clause e.g. DELETE FROM table_name WHERE 1=1 saqib http://www.full-disk-encryption.net On 12/8/06, Adam Zerlin <[EMAIL PROTECTED]> wrote: Hello, When I run a DELETE FROM table_name, my primary key field is reset back to 1. Is there any way for it to not d

OT: LAMP appliance for non-profit use

Sun Cobalt 550 servers. But now I think Sun has stopped making them and you can only buy them refurbished and the auto-update features are severely limited. Any other suggestion??? We want the appliance to cost us $1,000 / unit. Thanks saqib http://www.full-disk-encryption.net -- MySQL General

Best practices for deleting and restoring records - moving vs flagging

. However if we just flag the record as deleted the restoring is quite easy. Any thoughts/ideas ? -- In Peace, Saqib Ali http://www.xml-dev.com/blog/ Consensus is good, but informed dictatorship is better. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Query Speed in Terminal vs. PHP

Is index defined on all of your tables? Saqib Ali - http://validate.sf.net < (X)HTML / DocBook Validator and Transformer On Tue, 2 Mar 2004, Chris Fowler wrote: > I have a query that is admittedly inefficient in that it is doing > multiple OR clauses and joining multip

Re: Database-design

you need to normalize your database structure, and create an ER diagram based on that. On Tue, 11 Nov 2003, Meli Meli wrote: > > I have a table with following structure: > > Id > first quarter > second quarter > third quarter > last quarter > year > month > week > day > > On an entry not all fie

Re: phpmyadmin screw up

seems like you set the mysql root passwd which is the right thing to do. now should connect as follows: # /usr/local/mysql/bin/mysql -u root -p Saqib Ali - http://validate.sf.net <--- XHTML/HTML/DocBook Validator On Tue, 4 Nov 2003, joffrey leevy wrote: > Hi all: > > I w

Re: Lost Password

you can always reset the mysql root passwd http://www.mysql.com/doc/en/Resetting_permissions.html Saqib Ali - http://validate.sf.net <--- XHTML/HTML/DocBook Validator On Tue, 4 Nov 2003, Carol Andrejak wrote: > Hello Listers, > > I have a problem in that I cannot find my

RE: Is MySQL Relational? (was: Foreigner keys in MySQL?)

so funtions that can be performed by relation algebra are a subset of the functions performed by a relational database? however isn't it required for a relational database to perform all the functions of relation algebra? Saqib Ali - http://validate.sourceforge.net <--- XH

Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)

a question... is any DB that complies to the "Relational Algebra" a "Relational DB"??? Saqib Ali - http://validate.sourceforge.net <--- XHTML/HTML/DocBook Validator On Tue, 28 Oct 2003 [EMAIL PROTECTED] wrote: > > I tend to agree with the past two posts tha

corrupted passwd

-skip-grant-tables Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! Any ideas? Saqib Ali - http://www.xml-dev.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

Re: Need help optimizing query, awfully slow on only 20000 records

Are your tables indexed? http://www.mysql.com/doc/en/MySQL_indexes.html Saqib Ali - http://www.xml-dev.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: multiple ORs

Paul, Does this optimize the query? I thought both of the queries will have the same relational algebra representation. Am I wrong? Thanks. Saqib Ali - http://www.xml-dev.com On Fri, 18 Jul 2003, Paul DuBois wrote: > At 15:42 -0400 7/18/03, Chris Edwards wrote: > >Hi > &

Re: multiple ORs

If your data is properly Normalized, then this is the best way. Saqib Ali - http://www.xml-dev.com On Fri, 18 Jul 2003, Chris Edwards wrote: > Hi > > This has probably come up before... > > Using version 3.23.54 > > I have multiple OR logic in the where clause. &

Re: Sun Cobalt Web Server RTX

For my Cobalt server, I just d/l th mysql build from the Cobalt website (which is now @ sun.com) . And it worx just fine. Saqib Ali - http://www.xml-dev.com On Thu, 17 Jul 2003, Clint S. Jones wrote: > What type of MySql can I install on a cobalt web server??? Please help...

Re: Good Database Philosophy Book?

use it for reference. It is the best books for understanding Relational Algebra and Normalization. The second book was written by my Professor Dr. Dietrich and is also a very good book. Saqib Ali - http://www.xml-dev.com On Wed, 9 Jul 2003, David Thompson wrote: > Looking for a book

NAS vs SAN for data directory

I achieve any better performance using one storage vs the other storage? In the past (for about 2 years), I have I used SAN with 33Mhz FCAL, and the performance has been quite exceptional. And I have encountered no problems. Any suggestions? Thanks Saqib Ali http://www.xml-dev.com -- MySQL

Re: Best Pratices for mySQL Backups in Enterprise

> mysqlhotcopy does your locking for you. So running ./mysqlhostcopy dbase /path/to/backup/dir is perfectly safe while database operations (selct, insert, update etc) are being performed? --- Saqib Ali http://www.xml-dev.com -- MySQL General Mailing List For list archives: h

RE: Best Pratices for mySQL Backups in Enterprise

> If your tables are InnoDB, you could look at InnoDB HotBackup: > http://www.innodb.com/hotbackup.html No I m not using InnoDB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Best Pratices for mySQL Backups in Enterprise

DB is frequently? I have already read "mySQL: The definitive guide to to using, programming and administring mySQL 4", but did not find ay good information about backing up and restoring, in the 24x7 operation for Data Center use. Any ideas will highly appreciated. Thanks Saqib Ali

Re: optimizing left join query

Diana, Thanks for the suggestion. I completely forgot to add the index/primary key. Now it works just fine :) Thanks again. In Peace, Saqib Ali "I fear, if I rebel against my Lord, the retribution of an Awful Day (The Day of Resurrection)" Al-Quran 6:15 http://docbook.

optimizing left join query

g how I can optimize the Query/MySQL DB to make this query go faster. In Peace, Saqib Ali "I fear, if I rebel against my Lord, the retribution of an Awful Day (The Day of Resurrection)" Al-Quran 6:15 http://docbook.sc-icc.org

Not able to compile "mysql-test"

`/download/mysql-3.23.43/mysql-test' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/download/mysql-3.23.43' make: *** [all-recursive-am] Error 2 Any help would be highly appreciated. Thanks Saqib Ali -

load data local infile problems

affected (0.00 sec) Records: 29 deleted: 0 Skipped: 29 warnings: 0 I cannot seem to find any consistancy in MySQL's behaviour. This is an extremely annoying problem! If anyone out there can help then please do contact me. Thanks in advance. Regards, Saqib Shaikh Email: [EMAIL PROTE

loading data into a table and 1->many relations

now how to enter say 10 ordered_item IDs into the tab-separated table contained in orders.txt. I'm sure that people on this list must make similar databases every day, and some basic help would be much appreciated. Regards, Saqib Shaikh

currency: which data type?

that decimal or numeric would be more appropriate. I only used double(4,2) because this is what is used in the MySQL tutorial (I think it's chapter 3 of the manual). Any thoughts on this matter appreciated. Regards, Saqib Shaikh Email: [EMAIL PROTECTED] Web site: http://www.saqib

Re: how to get a script to run/work

em. If you are designing a database for a web site etc then you may need to provide extra parameters like the hostname. Hope this helps. Regards, Saqib Shaikh Email: [EMAIL PROTECTED] Web site: http://www.saqibshaikh.com/ - Original Message - From: "Barbara Ferrell" <[EMAIL

Create Table

l having difficulties getting other tables to work. Hopefully the answer to this question may shed some light on my difficulties. Thanks very much in advance. Regards, Saqib Shaikh Email: [EMAIL PROTECTED] Web site: http://www.saqibshaikh.com/ -