does MySql Supports shared Objects

hi! Dynamic shared objects could enable user written code to be integrated with the server at run time! . Does MySql support shared objects, since MySql is an open source database i believe it can support DSO. If its not true is there any alternative! ___

RE: MySQL Dual Master Replication

Thanks Sol -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 2:05 AM To: Solomon Sokolovsky Cc: [EMAIL PROTECTED] Subject: Re: MySQL Dual Master Replication On Thu, Jun 19, 2003 at 05:04:06PM +1000, Solomon Sokolovsky wrote: > So then no one i

MySQL 3.23.57 has been released

Hi, MySQL 3.23.57, a new version of the popular Open Source Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. Note that not all mirror sites may be up to date a

Re: GRANTs Options

Thnx for the hint Paul, I will do that. Regards.. From: Paul DuBois <[EMAIL PROTECTED]> To: "Miguel Perez" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject: Re: GRANTs Options Date: Thu, 19 Jun 2003 18:57:15 -0500 At 18:47 -0500 6/19/03, Miguel Perez wrote: Hi everyone: I wonder if the command G

Re: Same Problem about starting MySQL on a Mac

At 14:31 -0400 6/19/03, Pushpinder Singh Garcha wrote: Hello Everyone, I have been running MySQL on my Mac for almost a year now. suddenly I am unable to start the mysqld, I keep getting "mysqld ended" error.

Re: GRANTs Options

At 18:47 -0500 6/19/03, Miguel Perez wrote: Hi everyone: I wonder if the command GRANT could be alered. I mean if I have the following privileges over certain database: +--+ | Grants for [EMAIL PROTECTED]

GRANTs Options

Hi everyone: I wonder if the command GRANT could be alered. I mean if I have the following privileges over certain database: +--+ | Grants for [EMAIL PROTECTED]

Re: Distributed/Fault Tolerant DB operation... possible?

On Thu, 19 Jun 2003, Michael Conlen wrote: > First get an acceptable outtage rate. Your only going to get so many > nines, and your budget depends on how many. The system will fail at some > point, no matter what, even if it's only for a few seconds. That's > reality. Figure out what kinds of f

RE: linux and mysql socket

If it truly ran fine for a few days and then you couldn't run the client, you may have another problem. If you rebooted the box, mysqld may not have automatically started. So, all of the sudden, the client can't connect to the socket since it is not there as the server is not running. You can ch

Re: What's wrong with this query?

On 19 Jun 2003 at 16:18, Chris Boget wrote: > Why isn't the key being used in the "c" (certificate) table? > > SELECT DISTINCT a.uid, a.company, a.firstname, a.lastname > FROM master_info a, logins lsl, logins lc, certificate c WHERE > a.uid = lsl.uid AND lc.parent = lsl.uid AND lc.uid = c.uid

MySQL Kerberos or Ldap authentication

Hello All, I am evaluating MySQL as a DB backend for project I am working on. I have used MySQL in the past and I think it is an excellent product and would be perfect for my current environment. HOWEVER !! One of the major requirements for my project is that the DB backed support Kerberos o

Re: mac osx

There are some good Mac clients to access MySQL. I personally use CocoaMySQL for much of my day to day activity. You can find them all on versiontracker.org. YourSQL looks okay too. I agree though, the fancy interface, should you choose to use one of the above clients, is much more useful if y

What's wrong with this query?

Why isn't the key being used in the "c" (certificate) table? SELECT DISTINCT a.uid, a.company, a.firstname, a.lastname FROM master_info a, logins lsl, logins lc, certificate c WHERE a.uid = lsl.uid AND lc.parent = lsl.uid AND lc.uid = c.uid AND c.void <> 1 AND c.status IN ('CP', 'MC', 'AIC', '

Re: Distributed/Fault Tolerant DB operation... possible?

First get an acceptable outtage rate. Your only going to get so many nines, and your budget depends on how many. The system will fail at some point, no matter what, even if it's only for a few seconds. That's reality. Figure out what kinds of failures you can tolerate based on how many 9's you

RE: SQL query question

Well, from what limited info I have, it looks like your image tag is not closed properly. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Rolf C [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 19, 2003 2:57 PM > To: [EMAIL PROTECTED] > Subject: SQL query question >

SQL query question

Hello all, I am a totally newby to MYSQL but here i go. I want to create an ASP page that shows an image (screendump of game) a game name a game description and an url. I created a database with the following table: filename, urldesc, desc Now i have to create an SQL query that will put this

RE: Distributed/Fault Tolerant DB operation... possible?

-->-Original Message---> --> Has anyone done this with two (or more, if possible!) machines? Is it -->possible to do at the present time? Your going to need to have a chain master setup. This is what I propose. 1) Application(s) must know about all the master / slaves (or hide it behind

RE: linux and mysql socket

Your client is configured to connect via UNIX sock on localhost. It thinks the sock is on /tmp when it's probably /var/lib/mysql Take a look at /etc/my.cnf and make the change there or at the command line. -->-Original Message- -->From: azamka [mailto:[EMAIL PROTECTED] -->Sent: Thursday,

Re: mac osx

There is no built-in graphically interface for running MySQL. It's all command line, meaning you need to use your terminal. You absolutely must read something on how to use MySQL. There are a lot of good books out there, I used "MySQL" by Paul DuBois (who is also on this list). MySQL is a datab

Distributed/Fault Tolerant DB operation... possible?

Hi guys, I've been doing some digging around and found some information about master/slave database duplication, but it always sees to focus on increasing query performance by spreading the db out. My situation is that there's a database which must absolutely, guaranteedly be operational 2

How to UNSUBSCRIBE

I swear we went over this today... for anybody still unsure... give a look at the bottom of any email you recieve from the list and it will say 'To unsubscribe' on the last line... just click the link It will probably be at the end of this message even.. -- MySQL General Mailing List For list a

linux and mysql socket

I installed mysql manually on red hat 9. It worked fine couple days but from yesterday i am getting a weird error when i tried to run the mysql. the error statement is " Error 2002: Can't connect to local MySql server through socket '/tmp/mysql.sock'(2). I am new user of Linux and I am unable t

Re: fastest DB engine

How do I unscribe from this list? Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Complex SQL involving 10 checkboxes

Why not have each one look like this: if (isset($HTTP_GET_VARS['check00'])) { $SQL .= "penpals.agegroup = '00' OR"; } Then after you go through them all, strip the last two characters (the trailing OR) and then attach and AND That way it will accommodate any checks, and because you rip t

Re: Complex SQL involving 10 checkboxes

When I have these kind of settings/testing, I make one text-field and set a specific code ex. age 0-5 "[age00-05]" age 6-10 "[age06-10]" and so on - then you reduce the SQL to always read that specific tablefield, and leave the complexity to the program instead. best regards Peter - Origin

RE: Complex SQL involving 10 checkboxes

Well first of all, I am obviously having an off day for using AND at all in my example. Why not this? if (isset($HTTP_GET_VARS['check00'])) { $SQL .= "penpals.agegroup = '00' OR"; } This is probably a question for the PHP general mailing list as it is more a code question. Essentially yo

RE: Complex SQL involving 10 checkboxes

OK, I've done this. Problem occurs when a user selects 1 and 9. The SQL statement I have reads like so: if (isset($HTTP_GET_VARS['check00'])) { $age00 = '00'; $s_age00 = "penpals.agegroup = $age00 AND"; } Problem is the AND statement. Some times the user will pick checkbox 1 a

RE: Odd thing

Gerald, That may be a preference, but the scripts typically run on the LINUX command line just fine in the form that we've entered. We've been entering them in that manner for months with no operational issues. Thanks for the input though. Have a great day! Dave -Original Message- Fro

Newbie trying to make root password

Hi, I'm installing and using mySQL for the first time, and it shows. I've downloaded and installed mysql-standard-4.0.13.pkg on my OS X box (b&w G3, OS X 10.2.6) I'm following the directions given in the Readme: " If you installed MySQL for the first time, *please remember to set a password for

MySql C API

Can anybody please list known Forums with regard to "MySql C API" programming and development, Interfacing with multi-language programming, COBOL, PHP, GDK+, XForms, etc... Help for newbies to C API, techniques, sample codes, creating wrappers, list of great reference books (ones that are not padd

RE: C API - mysql_free_result

After I use mysql_free_result(), I immediately set the resultset to NULL. -Original Message- From: Adam Lawrence [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:36 AM To: [EMAIL PROTECTED] Subject: C API - mysql_free_result Stats: MySQL 4.0.13, under Windows98, using the C API

RE: Complex SQL involving 10 checkboxes

Well, if one checkbox represents ages 1-5, another represents 6-9, and another represents 10-15, then you have the checkboxes add where clauses. Here is a pseudocode/basic example: *START WITH A SELECT* SQL = "SELECT * FROM TABLE WHERE" *BUILD THE WHERE CLAUSES* IF check1 THEN SQL = SQL & " age B

Complex SQL involving 10 checkboxes

I'm trying to setup a SQL statement that involes using 10 different checkboxes. The checkboxes repersent age groups that I need to forward to an SQL statement. What would be the easiest way to do this? As I think this through I'm thinking I have to check it 1 and 2 are checked and not 3-9 and

Re: Post-installation Testing

On Thu, Jun 19, 2003 at 01:57:25PM -0400, Mazhar Malik wrote: > Hi guys > > I have just installed MySQL 4.0.13-standard on Mac OS X 10.2.6 for > the first time. While doing post-installation testing I got access > denied error. e.g > > > Shell > ./bin/mysqladmin -u root shutdown > ./bin/mysqladmin:

Re: selecting PRIMARY KEY when there is no unique value

On 19-Jun-2003 Mojtaba Faridzad wrote: Please don't hi-jack threads. > Hi, > > In a docuement such as Invoice Form, we have a header and a couple of > records for the detail. In header table, Invoice# can be the PRIMARY KEY > but > in detail table, Invoice# is not unique. I think there are two

Same Problem about starting MySQL on a Mac

Hello Everyone, I have been running MySQL on my Mac for almost a year now. suddenly I am unable to start the mysqld, I keep getting "mysqld ended" error. - [psg:/usr/local/mysql] psgarcha% s

AIX 4.3.x Binary of MySQL

I downloaded MySQL AIX 4.3.x and was looking to see if it would run on an as/400. The as/400 ( iSeries ) has an AIX runtime library support (PASE), when I try to execute mysqld I get: Dependent module libnsl.a(shr.o) could not be loaded. Does MySQL actually use this library ? If not is there a

Re: Odd thing

On 19-Jun-2003 Christensen, Dave wrote: > We're trying to set up some scripts that will run mysqldump to create > export > files for each table in a database that can be downloaded to a test > server > and reloaded. What's weird is that the files are created with the "?" > character as the traili

mysql 4.0.13 and show databases topic

Hello, I have installed mysql 4.0.13 but suddenly all users can see names of all databases on the server in phpmyadmin (show databases command afaik) Is there something to avoid it ??? Sincerely, Roman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

Post-installation Testing

Hi guys I have just installed MySQL 4.0.13-standard on Mac OS X 10.2.6 for the first time. While doing post-installation testing I got access denied error. e.g Shell > ./bin/mysqladmin -u root shutdown ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[E

Re: How do we convert a well-structured XML file to its corresponding tables in a MySQL Database ?

Eldrid Rensburg wrote: How do we convert a well-structured XML file to its corresponding tables in a MySQL Database ? With your own Perl/Python/C code ... And how do we normalize this well-structured XML file prior to conversion ? By basically tracking how deep you are in the nesting. In Pyth

RE: Can we crypt passwords on MySQL

Technically MD5/SHA1 are hashing algorithms and shouldn't be confused with encryption algorithms like DES, 3DES or AES. From the looks of the document link you gave us it seems that AES_ENCRYT is the way to go if you want to encrypt the data. So the command would look something like this: INSER

Re: C API - mysql_free_result

At 13:36 -0400 6/19/03, Adam Lawrence wrote: Stats: MySQL 4.0.13, under Windows98, using the C API with lcc-win32. Is there any way to determine if mysql_free_result() has been called on a result set pointer? There's no API function for that, no. Occasionally I recycle the pointer (use it, free i

Re: C API Query Semantics

Look at the source for the mysql client. It is a perfect example. Sean Macmillan wrote: Using the C API I have written a program that calls mysql_query() on a table with values I know to be in the table. It returns fine and I then call mysql_store_result. The problem I am having is figuring ou

Re: suggestions - server options/mysql variables

We don't know anything about you structures, your data, or your indicies. You should show them along with the output of EXPLAIN on your query. Derick Smith wrote: Hi! All the select statements have indexes on appropriate fields. Mysql appears to run fast, I was just wondering if there was anyway

MySQL compilation

Hello, Compiled MySQL with ./configure --prefix=/usr/local/mysql \ --localstatedir=/usr/db/mysql \ CFLAGS=-O3 \ CXX=gcc \ CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" --enable-assembler \ --with-openssl gmake gmake install Forgot to i

C API - mysql_free_result

Stats: MySQL 4.0.13, under Windows98, using the C API with lcc-win32. Is there any way to determine if mysql_free_result() has been called on a result set pointer? Occasionally I recycle the pointer (use it, free it, use it again, free it again, etc.) and if my code calls mysql_free_result() on a

mac osx

Hi, I have installed mysql-standard 4.0.13 for Mac OSX10.2. I cannot get the mysql application to work-the files are white and cannot be launched. Any ideas what to do? Regards JB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysq

C API Query Semantics

Using the C API I have written a program that calls mysql_query() on a table with values I know to be in the table. It returns fine and I then call mysql_store_result. The problem I am having is figuring out how to dump the contents of that query to the screen (printf for example). I have tr

RE: suggestions - server options/mysql variables

Hi! All the select statements have indexes on appropriate fields. Mysql appears to run fast, I was just wondering if there was anyway to make it faster. It is currently running on Windows, I have also ported it to HP-UX 11. The queries are of the type : SELECT * FROM textl WHERE parsetext = "" a

Access denied for user: '@localhost' to database 'mysql'

I ran a command which was part of the installation process for some php accounting software. update user set host='%' where host='localhost' and user='root'; Figured it just let root log in from anywhere. Dunno if that is what caused the problem or not. But now root can't access anything in

Re: Odd thing

Christensen, Dave wrote: Oops! Sorry. Deleted that 'temp' table and didn't remove it from my script file. -Original Message- From: Christensen, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:34 AM To: 'Jay Blanchard'; Dickey, Dallas; '[EMAIL PROTECTED]' Subject: RE: O

Re: wierd sort query, how do you do it? (sort by ip proximity guess)

Remember that this is a binary XOR, not a logical XOR. Mysql does have a binary XOR operator, the '^' operator. So 'ipAddress1 ^ ipAddress2' is the binary XOR between the two values. The binary AND is the '&' operator and the binary OR is the '|'. Just don't confuse them with the AND operator a

RE: Odd thing

Oops! Sorry. Deleted that 'temp' table and didn't remove it from my script file. -Original Message- From: Christensen, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:34 AM To: 'Jay Blanchard'; Dickey, Dallas; '[EMAIL PROTECTED]' Subject: RE: Odd thing Importance: High

RE: Odd thing

When I run this script file, I receive errors like this: [EMAIL PROTECTED] work]# ./BackupByTable.bat mysqldump: Got error: 1146: Table 'AgentAdminDB.MissedPages' doesn't exist when doing LOCK TABLES -Original Message- From: Christensen, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, J

Re: selecting PRIMARY KEY when there is no unique value

Hi Paul, (good to hear from you!) We use (invoice number+date) number as the primary key for the header and (invoice number+body item number+date) in the body of the invoice. We do not allow the same invoice number to be reused on the same day. However they can eventually rollover (ours is a

Re: worst result in killing an optimize table query

On Thu, Jun 19, 2003 at 02:24:52AM +0530, gamin wrote: > Hi, > >What would happen to my_table (~70MB of indexes) and its indexes >if someone kills a an optimize table query - 'OPTIMIZE TABLE >my_table' . Im wondering if i should provide a cancel button in >my application during the

Re: Can we crypt passwords on MySQL

At a certain time, now past [Jun.18.2003-11:55:18PM +0200], [EMAIL PROTECTED] spake thusly: > Hi all, > > Is it possible to crypt the passwords on MySQL. If yes, how does it > work, and how is it to be implemented. > Any link would be great. Passwords from/for what? Are these MySQL user passwo

Re: Help me!!!

Hola, Puedes encontrar una lista Mysql Espanol a http://lists.mysql.com/list.php?list=mysql-es#b . Yo pienso que ellos pueden ayudarte ma's que nosotros podemos. You can find a spanish MySQL list at http://lists.mysql.com/list.php?list=mysql-es#b . I think they can help you more than we can.

Re: Help me!!!

mailto:[EMAIL PROTECTED] - Original Message - From: "Luis Enrique Bauzá Peña" <[EMAIL PROTECTED]> To: "Lista Mysql Inglés" <[EMAIL PROTECTED]> Sent: Thursday, June 19, 2003 11:59 AM Subject: Help me!!! Hi, I need some link to a spanish mysql list, would you ...? -- MySQL General Mai

RE: Help me!!!

Luis Enrique Bauzá Peña, [EMAIL PROTECTED] David M Friscia friscia.rootsweb.com [EMAIL PROTECTED] -Original Message- From: Luis Enrique Bauzá Peña [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 9:00 AM To: Lista My

RE: Help me!!!

mailto:[EMAIL PROTECTED] This is what I found at lists.mysql.com Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Luis Enrique Bauzá Peña [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 19, 2003 10:00 AM > To: Lista Mysql Inglés > Subject: Help me!!! > > > Hi, I ne

Re: selecting PRIMARY KEY when there is no unique value

Thanks a lot. after all of these helpful responses, I will add a new field for Primary key. Thanks again - Original Message - From: "Michael Conlen" <[EMAIL PROTECTED]> To: "Mojtaba Faridzad" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, June 19, 2003 11:43 AM Subject: Re:

Re: MySQL Dual Master Replication

On Thu, Jun 19, 2003 at 05:04:06PM +1000, Solomon Sokolovsky wrote: > So then no one is the master?? > > Please confirm! Both are just slaves??? They're both masters and both slaves. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo MySQL Geek Desk: (408) 349-7878 Cell: (408) 6

Re: support for Prepared statement

Deepak> I wrote a program to check for Stored Procdures is running fine. Deepak> Now what i want to knwo is whether MySQL server is supporting Stored Procedures or not? Not yet, but will be supported in the 5.o version. Ivan --

Help me!!!

Hi, I need some link to a spanish mysql list, would you ...?

RE: Odd thing

I've also tried creating the script manually (script follows) and all that's being created is a text header with nothing else in the file. At least in these instances we can use the text files. Just be nice if they were valid... :-) ---> Here's the script mysqldump --add

Re: selecting PRIMARY KEY when there is no unique value

At 11:15 -0400 6/19/03, Mojtaba Faridzad wrote: Hi, In a docuement such as Invoice Form, we have a header and a couple of records for the detail. In header table, Invoice# can be the PRIMARY KEY but in detail table, Invoice# is not unique. I think there are two solutions to choose a Primary Key (i

Re: Can't drop a database

Hi I really don't have an answer but would question whether MySQL will allow zero db's with it's own grant tables. Usually there is a test db, at least after an install. Why not try adding a database and then try to drop clone_updater??. Mike - Original Message - From: "Leo Genyu

Re: selecting PRIMARY KEY when there is no unique value

Mojtaba Faridzad wrote: Hi, In a docuement such as Invoice Form, we have a header and a couple of records for the detail. In header table, Invoice# can be the PRIMARY KEY but in detail table, Invoice# is not unique. I think there are two solutions to choose a Primary Key (in MyISAM type) : 1) Add

Re: selecting PRIMARY KEY when there is no unique value

Hi, >From my point of view, you should always add a autoincrement_field for having a unique identifier and keeping each record unique, ex. in case of programmingmistakes and so. Best regards Peter - Original Message - From: "Mojtaba Faridzad" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>

Re: wierd sort query, how do you do it? (sort by ip proximity guess)

hehe, guess there is 1 problem with this solution. mysql doesn't do xor. but found a ref saying "a XOR b is mathematically equal to (a AND (NOT b)) OR ((NOT a) and b)" On Thursday 19 June 2003 09:51, Matthew Smith wrote: > Hi, > > If you convert the IP address into integers, then do an xor (excl

Re: selecting PRIMARY KEY when there is no unique value

Mojtaba Faridzad wrote: In a docuement such as Invoice Form, we have a header and a couple of records for the detail. In header table, Invoice# can be the PRIMARY KEY but in detail table, Invoice# is not unique. I think there are two solutions to choose a Primary Key (in MyISAM type) : 1) Adding a

Re: wierd sort query, how do you do it? (sort by ip proximity guess)

great! that was the trick i was looking for. thank you. i had the feeling i was doing it the hard way :-) On Thursday 19 June 2003 09:51, you wrote: > Hi, > > If you convert the IP address into integers, then do an xor (exclusive or), > you could call the resultant value the approximate 'distance

RE: selecting PRIMARY KEY when there is no unique value

When I last did an invoice-type project, he had the header table with an invoice# as PRIMARY KEY, then we had an invoice_line table with a rowid PRIMARY KEY as auto-increment and a invoice# with a non-unique key INDEX. This worked fine for our purposes, so I would probably go with option #1 I guess

selecting PRIMARY KEY when there is no unique value

Hi, In a docuement such as Invoice Form, we have a header and a couple of records for the detail. In header table, Invoice# can be the PRIMARY KEY but in detail table, Invoice# is not unique. I think there are two solutions to choose a Primary Key (in MyISAM type) : 1) Adding an id field ( auto_i

RE: Odd thing

Yes, we'd be creating the file on a Windows box, then transferring the file to either a Samba share or using FTP to the LINUX machine. -Original Message- From: Matthew Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 9:54 AM To: Christensen, Dave; 'Jay Blanchard'; [EMAIL PROT

RE: suggestions - server options/mysql variables

If you have queries that are only selects, in small tables, with few rows, you should have very fast performance as is. Are your queries properly indexed? What hardware are you running on? What do these queries look like? Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From:

RE: Odd thing

[snip] mysqldump AgentAdminDB activitylookup -u UserName -pPassword > //var/data/mysql/activitylookup.sql mysqldump AgentAdminDB agencies -u UserName -pPassword > //var/data/mysql/agencies.sql mysqldump AgentAdminDB agentdocuments -u UserName -pPassword > //var/data/mysql/agentdocuments.sql mysqldu

suggestions - server options/mysql variables

Hi! Does anyone know any mysql options I can change in the my.ini file or mysql variables to increase the speed of select statements? About database: -uses only select statements for queries -no transactions -if database becomes corrupt in anyway, not a big deal I can recreate it -it is a small d

RE: Odd thing

Delphi is being used to create a file with a mysqldump command per table -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 9:43 AM To: Christensen, Dave; [EMAIL PROTECTED] Cc: Dickey, Dallas Subject: RE: Odd thing [snip] We're trying to set u

RE: Odd thing

mysqldump AgentAdminDB activitylookup -u UserName -pPassword > //var/data/mysql/activitylookup.sql mysqldump AgentAdminDB agencies -u UserName -pPassword > //var/data/mysql/agencies.sql mysqldump AgentAdminDB agentdocuments -u UserName -pPassword > //var/data/mysql/agentdocuments.sql mysqldump Agen

RE: Odd thing

Hi, are you using MSDOS/Windows anywhere here - it might be a trailing ^M which Windows uses before ^J as the end of line character. Regards Matthew -Original Message- From: Christensen, Dave [mailto:[EMAIL PROTECTED] Sent: 19 June 2003 15:50 To: 'Jay Blanchard'; '[EMAIL PROTECTED]' Cc:

RE: Odd thing

[snip] Just creating shell scripts with one line creating each file. This is our first attempt to see how working with the smaller files performs while transferring data between sites. [/snip] It sounds as if (based on past experience) that the filename is being created with an additional charac

RE: wierd sort query, how do you do it? (sort by ip proximity guess)

Hi, If you convert the IP address into integers, then do an xor (exclusive or), you could call the resultant value the approximate 'distance' between the values. (think of the IP address in binary, any identical bits will result in 0, any differing will be 1. This means that the most significant

Re: SQL question

Jake Johnson wrote: Nice approach Bruce, but I too won't have any problems with your case because I am grouping by sku and stock in the sub-query. You're right; you do avoid the problem with the specific sample data I gave you. Sorry about that! But, there are still potential problems because

RE: Odd thing

Just creating shell scripts with one line creating each file. This is our first attempt to see how working with the smaller files performs while transferring data between sites. -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 9:43 AM To: C

RE: Odd thing

[snip] We're trying to set up some scripts that will run mysqldump to create export files for each table in a database that can be downloaded to a test server and reloaded. What's weird is that the files are created with the "?" character as the trailing character in the file name and we can't ope

Additional info.

The server (our development test server) is running Red Hat 8.0 and Mysql 4.1. The remote test server to which we're trying to transfer data is running Red Hat 7.3 and Mysql 4.013. David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 75

Odd thing

We're trying to set up some scripts that will run mysqldump to create export files for each table in a database that can be downloaded to a test server and reloaded. What's weird is that the files are created with the "?" character as the trailing character in the file name and we can't open them

wierd sort query, how do you do it? (sort by ip proximity guess)

currently i have a table with an ip coloumn in text 123.45.67.89 though it shouldn't be a big deal to convert it to binary, but was wondering if there is an easy way to sort by closeness to a given ip address? ie records that come out sorted as same class sub-c same class c same class c same cla

RE: Is There An Automated Way To Convert A Well-structured XML File T o Its Corresponding Tables In A MySQL Database ?

You need only ask once. This article by Paul Dubois may help :http://www.kitebird.com/articles/mysql-xml.html This Google search resulted in hundreds of resources: http://www.google.com/search?hl=en&edition=ca&q=convert+xml+to+mysql&btn meta%3Dsearch%3Dsearch=Search+the+Web Regards, Mike Hillyer

Is There An Automated Way To Convert A Well-structured XML File T o Its Corresponding Tables In A MySQL Database ?

How do we convert a well-structured XML file to its corresponding tables in a MySQL Database ? And How do we normalize this well-structured XML file prior to conversion ? This message and any attachments are confidential and intended solely for the addressee. Any unauthorized use, alteration o

Re: unknow SQL Error!

--Original Message- > > CREATE TABLE nuke_contactbook( > workphone varchar( 255 ) , > homepage varchar( 255 ) , > IM varchar( 255 ) , > events text, > reminders int( 11 ) , > notes text, > PRIMARY KEY ( contactid ) , > KEY contactid( contactid ) , > KEY uid( uid ) You seem

How do we convert a well-structured XML file to its corresponding tables in a MySQL Database ?

How do we convert a well-structured XML file to its corresponding tables in a MySQL Database ? And How do we normalize this well-structured XML file prior to conversion ? This message and any attachments are confidential and intended solely for the addressee. Any unauthorized use, alteration o

Re: SQL question

Nice approach Bruce, but I too won't have any problems with your case because I am grouping by sku and stock in the sub-query. Regards, Jake Johnson [EMAIL PROTECTED] -- Plutoid - http://www.plutoid.com Shop Plutoid for the best pric

Re: insert hang problem on Solaris 8

It looks like my MYI file was seriously corrupted, beyond myisamchk being able to do a thing with it. Has anyone seen this before on Solaris 8? Fortunately the data was trashable but when this hits production it wont always be. Thanks.. Randy On Wed, 2003-06-18 at 21:46, Nils Valentin wrote: >

unknow SQL Error!

Hi People, Please, how are the error whit my sql? I receive this message when I execute it in phpMyAdmin 2.5.0: My sql host server is the portlandsql. Erro comando SQL : CREATE TABLE nuke_contactbook( uid int( 11 ) DEFAULT '0' NOT NULL , contactid int( 11 ) NOT NULL AUTO_INCREMENT , firstnam

Can't drop a database

Hello. I am running MySQL database on Sun Solaris 9. # mysql -V mysql Ver 11.18 Distrib 3.23.54, for sun-solaris2.8 (sparc) I am having a problem dropping a database. All the tables in the database have been dropped successfully, but the database does not want to go away. To be more specific, w

RE: MySQL Mailing list.

Was it really that bad :D Click on the link below and you should be unsubscribed http://lists.mysql.com/[EMAIL PROTECTED] -Original Message- From: Jason [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 3:40 PM To: Dathan Vance Pattishall; 'Grégoire Dubois'; 'Mysql' Subject: MySQL

  1   2   >