dump a xml result

When i dump a table to a xml result mysqldump throw a warning: - Warning: Can't set SQL_QUOTE_SHOW_CREATE option () - If i dump the table to a txt result mysqldump don't throw the warning.

Compiling mysql-5.0.18 under solaris 10

Hello Am trying to compile mysql-5.0.18 under solaris 10 but get the following error Making all in zlib make[2]: Entering directory `/tmp/mysql-5.0.18/zlib' /bin/bash ../libtool --preserve-dup-deps --mode=link gcc -O3 -DDBUG_OFF -DHAVE_RWLOCK_T -o libz.la -rpath /usr/local/mysql/lib/mysql -ver

Re: Trouble connecting to 5.0.18

oh i forgot to mention, the new passwords are stored in the database already. you need to reset the password with the OLD_PASSWORD() function. they detail that in the documentation b Brandon Ooi wrote: this refers to a new password scheme used in mysql 4.1 and above. see here to fix this...

RE: INNODB Questions and Optimization help

:~> -Original Message- :~> From: Shaun Adams [mailto:[EMAIL PROTECTED] :~> Sent: Tuesday, February 07, 2006 4:32 PM :~> To: mysql@lists.mysql.com :~> Subject: INNODB Questions and Optimization help :~> :~> Questions: :~> :~> 1. The ibdata1 file size is 10GB. Does that sound right? Shou

Re: Trouble connecting to 5.0.18

this refers to a new password scheme used in mysql 4.1 and above. see here to fix this... http://dev.mysql.com/doc/refman/5.0/en/old-client.html b John Hoover wrote: I've been running MySQL 4.0.20 on Mac OS 10.3.5 for some months and had been working on a custom client. It was working well

Re: INNODB Questions and Optimization help

Shaun Adams wrote: 1. The ibdata1 file size is 10GB. Does that sound right? Should this file be this big? That sounds right. Innodb seems to incur large space overheads. but with the cost of diskspace nowadays... 2. Once a week, I have to perform HUGE insert imports into the database.

Trouble connecting to 5.0.18

I've been running MySQL 4.0.20 on Mac OS 10.3.5 for some months and had been working on a custom client. It was working well until I upgraded by computer to 10.4.3 and MySQL to 5.0.18. My client can not longer connect - I get an error message: "Client does not support authentication protocol req

Silicon Valley MySQL Meetup: MySQL Optimization, Monday, Feb 13, 2006 @ 7:00pm in Santa Clara, CA

Hi All, Are you interested in MySQL? Do you live/work in Silicon Valley? Join a fun group of professionals for the monthly MySQL Meetup in Silicon Valley, held at Yahoo! in Santa Clara, California. The topic this month is: MySQL Optimization and the EXPLAIN command Speaker: Jeremy Cole

INNODB Questions and Optimization help

I currently have a customer who we switched over to INNODB from MyISM. It's a Dell Server with 4GB or Memory and RHEL4 64-bit. It's a fairly big database the size of the MyISM folders (before we converted to INNODB) was about 2-3Gigs. Questions: 1. The ibdata1 file size is 10GB. Does tha

Strange query error with clustered backend

Hi, I'm running a 2-node cluster with MySQL 5.0.18 on two Solaris 10 boxes - call them sun3 and sun5. Each server is running as a storage node (i.e. ndbd) and a MySQL server node (mysqld). I created the cluster by converting an existing database from MyISAM engine type to "ndbcluster". sun3 host

MySQL 4.1.18 has been released

Hi, MySQL 4.1.18, a new version of the popular Open Source Database Management System, has been released. The Community Edition is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Note that not all mir

Re: How to create an application for managing users

Thank you Shawn! 2006/2/7, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > > > Célio Cidral Junior <[EMAIL PROTECTED]> wrote on 02/05/2006 02:20:48 > PM: > > There already IS a users table that you can either send CRUD statements to > or manage through the GRANT and REVOKE statements. Since MySQL securit

RE: Fastest way to log IP's

I work at a security company, and we store many thousands of IPs in mySQL for networks as large as /16. Use INTEGERS. It's much more efficient. It's easier to use. And it allows your sorting (ORDER BY) to be in the proper order. If you stored as characters you'd eroneously get: 192.168.1.1 192

Re: Spatial Extensions in MySQL: Multidimensional Points?

Use 3d pythagorean theorem. the distance d between point1 (x1,y1,z1) and point2 (x2,y2,z2) is... d = sqrt((x1-x2)^2 + (y1-y2)^2 + (z1-z2)^2) as for building an index for this? i have no idea. but that is how you find the distance between two 3D points. b Jose Antonio wrote: MySQL offers Sp

Re: Query Complexity Limit Question [Newbie Question]

At 3:46 pm + 7/2/06, [EMAIL PROTECTED] wrote: >Yes, you can do multi-way joins, and people often do. My biggest is 3-way, but >some people do at least 5-way. My record is and 8-way join (7 tables, one twice). So there! ;-) >Beware that it is easy to specify operations which will heavily load

Re: 5.0.18-max-log as a slave of a 4.1.13-standard-log master problem - slave hangs

Hi you may be having issues with the byte order on the opetron's and the P4's , this was asked earlier in the list, and here's what Jimmy from Mysql had to say All machines used in the cluster must have the same architecture; that is, all machines hosting nodes must be either big-endi

Re: 5.0.18-max-log as a slave of a 4.1.13-standard-log master problem - slave hangs

A neverending story. I thought it worked (without having an idea what has been the problem), but it broke down again after a few hours. My current set up is: -A p4 production server (Server1) running debian linux, 2.4 kernel, mysql 4.1.13-standard-log. This server is replicating to several oth

Re: Query Complexity Limit Question [Newbie Question]

On Tue, February 7, 2006 10:46 am, [EMAIL PROTECTED] wrote: > "David T. Ashley" <[EMAIL PROTECTED]> wrote on 07/02/2006 14:03:04: > >> a)Will MySQL allow joins that involve more than two tables (in my case, >> perhaps as many as 5)? >> >> b)Can limits on a key field be included in the join in the s

Re: Spatial Extensions in MySQL: Multidimensional Points?

Hello. For a pity, I do not have an exact answer on how to do your task in a best way with MySQL. Searching in the archives gave me these links: http://lists.mysql.com/mysql/185851 http://lists.mysql.com/mysql/185846 Perhaps, you will need the help of stored routines or UDFs: http://dev.mys

Re: Can't Create Foreign Key Constraints

Hello. You can post a bug: http://dev.mysql.com/doc/refman/5.0/en/bug-reports.html Lola J. Lee Beno wrote: > Gleb Paharenko wrote: > >> Hello. >> >> The query which is works is: > > > > Thanks - just what I needed. Looks like I'll need to be extra careful > with sql scripts generated from

Re: Query Complexity Limit Question [Newbie Question]

"David T. Ashley" <[EMAIL PROTECTED]> wrote on 07/02/2006 14:03:04: > Hi, > > I have several tables linked in various ways so that an inner join is > possible. However, at the same time and in the same SQL query, I'd also > like to query by some field values in one of the tables. > > Two quick

Re: Can't Create Foreign Key Constraints

Gleb Paharenko wrote: Hello. The query which is works is: Thanks - just what I needed. Looks like I'll need to be extra careful with sql scripts generated from Mysql Workbench, which is still alpha right now. -- Lola - mailto:[EMAIL PROTECTED] http://www.lolajl.net | Blog at http://www

Re: Can't Create Foreign Key Constraints

Hello. The query which is works is: CREATE TABLE `Films` ( `FilmID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `MovieTitle` TEXT NULL ,`PitchText` TEXT NULL, `AmountBudgeted` DECIMAL(11, 0) NULL, `RatingID` INT(11) unsigned , `Summary` L

Re: Can't Create Foreign Key Constraints

Peter Brawley wrote: Lola, />And got this following error message: >ERROR 1072 (42000): Key column '(not null)' doesn't exist in table / Yes, it's telling you what;s wrong: to define a constraint on a key, the table def must first define the key. Looking over the script again, RatingID is b

Re: Can't Create Foreign Key Constraints

Lola, >And got this following error message: >ERROR 1072 (42000): Key column '(not null)' doesn't exist in table Yes, it's telling you what;s wrong: to define a constraint on a key, the table def must first define the key. PB - Lola J. Lee Beno wrote: I'm trying to create foreign

Re: replacement for Oracle initcap function

Hello. It seems that there is no such functions: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html However, it should be possible to do with: http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html http://dev.mysql.com/doc/refman/5.0/en/adding-functions.html Sid Lane wro

Re: Query Complexity Limit Question [Newbie Question]

David T. Ashley wrote: Hi, I have several tables linked in various ways so that an inner join is possible. However, at the same time and in the same SQL query, I'd also like to query by some field values in one of the tables. Two quick questions: a)Will MySQL allow joins that involve more th

Re: Moving from PowWeb to Rackspace

Hello. Usually my preferred option is mysqldump, however, a lot of depends on your production environment, and how long your server can be off-line. You should know about different ways to move your databases to another machine: http://dev.mysql.com/doc/refman/5.0/en/moving.html http://dev.mys

Re: Pro*c and Oracle,Need help

"Vinay" <[EMAIL PROTECTED]> wrote on 02/07/2006 09:28:05 AM: > Hi, > I am using Pro*c to connect to oracle and get the results. All > I want to do is send a query as parameter and get the results in > some two dimensional character, Oracle Pro*c does not provide enough > flexibility with it

Pro*c and Oracle,Need help

Hi, I am using Pro*c to connect to oracle and get the results. All I want to do is send a query as parameter and get the results in some two dimensional character, Oracle Pro*c does not provide enough flexibility with its EXEC FETCH variable which forces use to declare variables to fetct in

Re: Can't Create Foreign Key Constraints

Michael Stassen wrote: 1) I'm not sure what you are intending with "(`(not null)`)" in the middle of your foreign key definition, but that isn't valid mysql syntax. See the manual for the correct syntax . This is f

Re: How to create an application for managing users

Célio Cidral Junior <[EMAIL PROTECTED]> wrote on 02/05/2006 02:20:48 PM: > 2006/2/4, sol beach <[EMAIL PROTECTED]>: > > What other C# applications have you previously written? > > Do you know anything more than how to spell SQL? > > Have you ever installed and administered MYSQL? > > I have been

Re: Can't Create Foreign Key Constraints

Lola J. Lee Beno wrote: I'm trying to create foreign key constraints and keep getting an error message 1005 (I did look it up, but didn't see an obvious solution to fixing this for my database). The version I'm using is 5.0.17-max. I used Mysql WorkBench to create the database schema and had

Spatial Extensions in MySQL: Multidimensional Points?

MySQL offers Spacial Extensions to operate with points in a 2 dimensional space. For a project I'm working on, I need to work with points in an N dimensional space and measure the distance among them. Is there a clever do to solve the following problem?: Let's say I have 4 3D point (X,Y,Z): (0,0

Query Complexity Limit Question [Newbie Question]

Hi, I have several tables linked in various ways so that an inner join is possible. However, at the same time and in the same SQL query, I'd also like to query by some field values in one of the tables. Two quick questions: a)Will MySQL allow joins that involve more than two tables (in my case,

Can't Create Foreign Key Constraints

I'm trying to create foreign key constraints and keep getting an error message 1005 (I did look it up, but didn't see an obvious solution to fixing this for my database). The version I'm using is 5.0.17-max. I used Mysql WorkBench to create the database schema and had it generate the sql scri

launch store procedures from windows client

Hello, list if launch a store procedure from two differents clients from windows, Visual FoxPro 8.0 and Asp, for eject a store procedure in the database MySql 5, the mysql connector answer with : >From Asp MyOdbcConnector 3.51.12 [MySQL][ODBC 3.51 Driver]You have an error in your SQL > syntax; che

Re: split a datafile

wangxu wrote: > No,i don't want to do this. > > My previous variable is > "innodb_data_file_path=ibdata1:2G;ibdata2:10M:autoextend". > > But ibdata2 had exceed 3G! > > I changed the variable to > "innodb_data_file_path=ibdata1:2G;ibdata2:2G;ibdata3:10M:autoextend". > > But Server couldn't sta

Re: split a datafile

No,i don't want to do this. My previous variable is "innodb_data_file_path=ibdata1:2G;ibdata2:10M:autoextend". But ibdata2 had exceed 3G! I changed the variable to "innodb_data_file_path=ibdata1:2G;ibdata2:2G;ibdata3:10M:autoextend". But Server couldn't start. How can i to achieve my idea?

Re: split a datafile

On Tue, 2006-02-07 at 15:48 +0800, wangxu wrote: > I want to split a datafile to two datafiles.How can i do? Will this do? $ split --help Usage: split [OPTION] [INPUT [PREFIX]] Output fixed-size pieces of INPUT to PREFIXaa, PREFIXab, ...; default PREFIX is `x'. With no INPUT, or when INPUT is -,