AES 256-Bit Encryption

Does anyone know where to find the 256-Bit patch for AES encryption? Thanks...=) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unicode(ucs2) setup question

In wich version of Windows do you have compiled mysql? I have Win XP and I need a mysql version that works with UTF-I. I am waiting for the development of MySQL 4.1 beta, but it is too late for me. It is posible if you publish your compiled version? (I suppose that is for windows). Or if you send

Re: Unicode(ucs2) setup question

Hi Juan, I understood Yuji is using OS FreeBSD 4.8 DB MySQL4.1.0-alpha Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 16:54、Juan Sebastian Alarcon さんは書きました: > In wich version of Windows do you have compiled mysql? > > I have Win XP and I need a mysql version that works with UTF-I. I

efficiency join

Hi, I was wondering is it efficient to use join with 7 tables, and also is it possible if we don't yet have any records in the table to check the efficiency of the table? Thanx Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

Re: mysqlhotcopy generates a segmentation fault

On Wed, 2003-06-11 at 01:55, Danny Cron wrote: > I have three boxes. Mysqlhotcopy works on box1, but it generates a > segmentation fault on box2 and box3. I want it to work on all boxes. > I am prepared to upgrade them all to the level of box3 (but > mysqlhotcopy doesn't work with that configura

Re: tables size in mysql database

I got these : | Name | Type | Row_format | Rows| Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_ti me | Update_time | Check_time | Create_options | Comment I guess Data_length shows the size in bytes of the table. if

not allowed to connect to this mysql server

Hi I am using a .Net project to connect to a mysql server. I have a winXP (IIS installed) machine as a network client to our mysql server hold on a linux machine. I have mydobc installed. I made a connection in .Net. But when I try to connect to mysql I get an error message saying: "'My ip' is

Error running mysql test

Dear all I had installed mysql. Things comes right till i tried to execute " perl run-all-tests" i got the following error /usr/local/bin/perl: relocation error: /usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init Any ideas? hamid

Re: not allowed to connect to this mysql server

<[EMAIL PROTECTED]> writes: > Hi I am using a .Net project to connect to a mysql server. I have a > winXP (IIS installed) machine as a network client to our mysql server > hold on a linux machine. I have mydobc installed. I made a connection > in .Net. But when I try to connect to mysql I get an e

Re: tables size in mysql database

http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html Searching is usually faster than waiting for the list to respond, too. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Sohail Hasan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, 11 Jun

Re: mysql windows passwd probleme

I've been having the same problem with one of my systems, also on Windows XP, but using 4.0.12. Perhaps it's time for a bug report... Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Jonas Geiregat" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tues

Re: MySQL server 4.1 & getColumns ()

Hello Mark, Thanks for your help... Since I have received your mail, I have made a few more tests. I took the part of the web application and made a short one. The result is that I can repeat the problem with the databases that are generated by the web application, but if I use the database te

Fwd: MySQL server 4.1 & getColumns ()

Hello again, One more thing... There is no problem with MySql server 4.0.xx... Regards. Thierry Boucheny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql and clustering

> They're completely different clustering solution. What, exactly, are > you trying to acheive? LVS is primarily for load balancing and > possibly fail-over. OpenMosix is a different beast entirely. > > Jeremy Thanks for the reply Jeremy. What i need to build are a mysql master server with two

Re: not allowed to connect to this mysql server

Hi, First you must add grants to the user which you want to connect to the MySQL server.In documentation (4.3.5 Adding New Users to MySQL) you will find how you can achieved this. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address

Hot backup in mysql

Hi all I'm new to this part of mysql. I've never done somme kind of backup/dump with mysql I read that for myIsam I can Just copy the frm, idx form the database directory But I've to manage hot backup with a database mixed with InnoDB tables and MyIsam. I searched for a tutorial / a software or an

SELECT question

I have a question on how to substitute a subselect in mysql. For example lets say i have 3 tables Cars, Options and CarOptions Cars consists of: uid, make Options consists of: uid, option CarOption consists of: uid, Caruid, Optionsuid I want to select all Cars that have ALL of requested optio

mySQL GUIs

hi! i am looking for a good mySQL gui for windows i have used mySQL front, which was an excellent free program, but i did not handle relations and diagrams. also the program is no longer being developed i have now found the prog mySQL tools (http://www.mysqltools.com/) and mySQL explorer that w

Doing a count of a count in mysql

Hi everybody, I do a query like select count(*) from SPECTRUM where SPECTRUM.REVIEW_FLAG ="true" group by MOLECULE_ID which gives back a lot of figures, mainly 1 and 2, perhaps 3. What I actually want is the count how many 1s and 2s (and 3s ...) are in this result set. What would be the best way

Re: mySQL GUIs

Why not try MySQL Control Center? It's MySQL AB's own project. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Rodolphe Toots" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, 11 June, 2003 07:16 Subject: mySQL GUIs hi! i am looking for

same query different result on slightly different db

Dear all, i'm sorry if this kind of question was already posted, i'm a newbie and i hope you will find anyway the time to answer me. I've installed mysql version 4.0.12-nt on my Windows XP Professional notebook and mysql version 4.0.12-standard on a Solaris 8 machine. Some antefacts: I need a v

Re: Doing a count of a count in mysql

On Wednesday, June 11, 2003, at 07:23 AM, Stefan Kuhn wrote: do a query like select count(*) from SPECTRUM where SPECTRUM.REVIEW_FLAG ="true" group by MOLECULE_ID which gives back a lot of figures, mainly 1 and 2, perhaps 3. What I actually want is the count how many 1s and 2s (and 3s ...) are

Replication problems

I am frequently getting errors as given below on my slave server. - 030605 3:27:19 Slave: did not get the expected error running query from master - expected: 'Got error %d from table handler' (1030), got 'no error' (0) 030605 3:27:19 Slave: er

Re: Hot backup in mysql

InnoDB Hot Backup is non-free and works only with InnoDB. mysqlhotcopy is free and works with MyISAM tables but not InnoDB. mysqldump is free and works with both. The easiest thing to do is use mysqldump...you'll get text files that contain create and insert statements allowing you to restore yo

RE: Can't insert data from Apache/PHP

[snip] Sorry, but I am a bit behind on MySQL digest, but isn't turning Register Globals 'on' for php a security risk? [/snip] We recently had this discussion on the PHP-General list and the upshot is that having register_globals 'on' is only a security risk if the code is sloppy. PHP allows this

Re: not allowed to connect to this mysql server

[EMAIL PROTECTED] wrote: > > I am using a .Net project to connect to a mysql server. I have a winXP (IIS > installed) machine as a network client to our mysql server hold on a linux machine. > I have mydobc installed. I made a connection in .Net. But when I try to connect to > mysql I get an er

Re: forming foreign keys

"Nils Valentin" <[EMAIL PROTECTED]> wrote: > > I believe that the User column is indexed (please see below): > > show index from user; > +---++--+--+-+---+-+--++--++-+ > | Table | Non_uniqu

Re: How to make Cascade Update?

"William IT" <[EMAIL PROTECTED]> wrote: > > I just migeate from MS SQL to MySQL but have problem on "Cascade Update". > Suppose I have BOOK and LIST_TYPE tables like this: > > BOOK, field: Book_Name, Book_Type > LIST_TYPE, field: Book_Type > > If I already define Cascade Update between BOOK and

Re: data path

unplug <[EMAIL PROTECTED]> wrote: > > By default, data dir is located at /var/lib/mysql. I have run mysql > for serveral month with data in that path. Now, I want to move all > database data to another path, say /var2/lib/mysql. What is the > suitable purpose to do it? Is it only shutdown mys

Re: forming foreign keys

Hi Victoria, I thought so, but also if I try somthing similar like: ALTER TABLE db ADD FOREIGN KEY (Host) REFERENCES user (Host); I get the same error. BTW: Can I change the order of the keys ? Best regards Nils Valentin 2003年 6月 11日 水曜日 17:17、Victoria Reznichenko さんは書きました: > "Nils Valenti

Re: Can't insert data from Apache/PHP

On Tuesday 10 June 2003 22:49, CM Miller wrote: > > globals >back to ON. > > Sorry, but I am a bit behind on MySQL digest, but > isn't turning Register Globals 'on' for php a security > risk? Yes. He needs to take a look at the documentation on the PHP website. I also sent instructions on how t

Re: forming foreign keys

Hi Victoria, Thank you for the reply. I understand now that it must be the first part of the primary index in both related tables. But what I still dont understand is the following: How do I create several foreign keys in a single table (f.e a link table) which relates f.e to 10 other tables ?

Join "with no matches on other table"

Hello, I have two tables, other having information of cottages and other including information when each cottage is booked. The table structures are following: Cottages: - code - name - equipment Reservations: - cottagecode - begindate - enddate I'm looking for a query structure that I can use

Static Table

Hi, I read the document about Static table and Dynamic table. When we have VARCHAR, BLOB, and TEXT, default is Dynamic. But if we don't have BLOB, we can force MySQL to create static table. Now my question: There is a table with more than 15 records and about 130 fields and there are some fie

Re: Copy database to another Server

William IT wrote: I do mysqlamin shutdown and copy all /var/lib/mysql file from another MySQL server. And then run: chmod -R 660 * Try 770 Mysql needs to be able to scan the directories to find tables. chown -R mysql:mysql * shutdown now -r But I can't logon to Mysql. What's wrong? -- My

Printing table descriptions

Hi! I need to print the description of all tables in my database. The problem is, there are about 200 of them, and the only way I know to do this is send each of the screens to a file, an then print the file. Isn't there any easier way, like printing directly from mysql or at least saving all d

Re: Join "with no matches on other table"

On Wed, 2003-06-11 at 13:48, Ville Mattila wrote: > Hello, > > I have two tables, other having information of cottages and other including > information when each cottage is booked. The table structures are following: > > Cottages: > - code > - name > - equipment > > Reservations: > - cottagecod

Re: Printing table descriptions

On Wed, 2003-06-11 at 14:29, Fernando Gerent wrote: > Hi! > > I need to print the description of all tables in my database. The problem is, there > are about 200 of them, and the only way I know to do this is send each of the > screens to a file, an then print the file. Isn't there any easier wa

deadlock problem?

dear all! I am running mysql 4.0.13 (Linux-X86) my innodb table accasionally comes to a deadlock, when i run some sql such a "delete from tb_memfee where no='206681'". if it come to a deadlock, i cannot update any column of the row - where no is '206681' in the table tb_memfee. how can i

Newbie Question

Hello, I'm sure there's an answer somewhere but the 900+ page manual is a bit overwhelming. I have MySQL 4.1 running on one machine and I'd like to access using the client software I alerady have on another machine which was built against 3.23.33. Access is via command line client (mysql),

Re: Printing table descriptions

Hi Gerald, How about like this ? mysql> \P lp; PAGER set to lp; mysql> SHOW INNODB STATUS ; lp is the printer queue which you have probably setup. Exchange lp with your printer spooler name. I am not sure about printing several tables. How about making a script or batch file (in case you want

underscore character?

I'm getting an error with "create table", appears that field names cannot have the underscore character. Is this correct? It would be quite fatal for us, as we need some sort of delimeter character, so we can group variables by instrument. You have an error in your SQL syntax near 'A2DEE1_RWO

Re: Printing table descriptions

Martin, my compliment. Excellent answer. I completely forgot about the -d option for mysqldump. Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 22:32、Martin Waite さんは書きました: > On Wed, 2003-06-11 at 14:29, Fernando Gerent wrote: > > Hi! > > > > I need to print the description of all tab

RE: underscore character?

The underscore is a valid character. Maybe it's the FLOAT(1) that's causing a problem. -Original Message- From: Chris Webster [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 9:09 PM To: [EMAIL PROTECTED] Subject: underscore character? I'm getting an error with "create table", appe

Re: deadlock problem?

Hi! It is not a deadlock. These two transactions have been dangling uncommitted for 14 hours: > ---TRANSACTION 0 713900169, ACTIVE 50231 sec, process no 17432, OS thread id > 98317 > 19 lock struct(s), heap size 2496, undo log entries 13 > MySQL thread id 9, query id 1213960 db2 10.10.7.2 web > T

Re: ON DELETE CASCADE ON UPDATE CASCADE

Vinita, thank you for the bug report. The BLOB silently changes the CHAR(20) field to a VARCHAR(20) field in te parent table. But the field in the child stays CHAR(20). There is a bug in ON UPDATE CASCADE which forgets to pad the field in the child table with spaces. The child table becomes corru

Re: need help

I have no idea. sorry. Sibananda Sahoo wrote: > > Thanks for your reply. Could you please tell me is it > possible to achieve foreign key constraint in MySQL > 3.23.56. > > Rgds, > Sibananda > > --- Jeff Mathis <[EMAIL PROTECTED]> wrote: > > i'm not an expert by any means :) > > > > but, you d

RE: need help

Do a show variables like '%inno%'; This should tell you if you have innodb enabled or not. If not you will need to configure your cnf file. -Original Message- From: Jeff Mathis [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 10:07 AM To: Sibananda Sahoo; [EMAIL PROTECTED] Subject

my.cnf

I have been plowing through the mysql.com resources for something regarding the run-time configuration options as well as the my.cnf. In particular, I am trying to move the entire information store to a separate hard-drive. This line confuses me: ---> Note that this is the directory that was spe

RE: my.cnf

Are you wanting to physically relocate the myd, myi and frm files to a new location? If so specify datadir in the cnf file or --datadir on the command line for mysqld. -Original Message- From: Chris McKeever [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 10:35 AM To: [EMAIL PROTE

Qwery help please

I have two tables; TESTtblRC ++++-+ | id | npanxx | RCname | RCstate | ++++-+ | 1 | 11 | ONE| CA | | 2 | 22 | ONE| CA | | 3 | 33 | ONE| CA | | 4 | 44 | TWO| CA | | 5 | 55 | TWO|

mySql BUG

Hi, Try to do the following: *) Import the dump file I sent to you attached to this e-mail. There is a table called l5 and some data in the dump file. *) run the command: select conjuge.l5_nome from l5 as conjuge, l5 as parte where parte.l5_parte = 8 and parte.l5_seq = 0 and conjuge.l5_parte =

Group by and Count query

Hello, I am trying to count the number of unique records that exist in my database based on a given criteria. My table looks like this: TABLE_HOST id host path_a path_b The field host will have duplicates like: myway.com hisway.com hisway.com hisway.com someway.com someway.com yourway.com The

MySQL 4.1 and MyCC

I upgraded my test MySQL server yesterday to 4.1 and I'm now receiving an error when I try to connect using MyCC. The error is ERROR 1249: Client does not support authentification protocol requested by server. Consider upgrading MySQL client. I've tried to find a solution on the website, but ei

Re: Group by and Count query

What about SELECT COUNT(DISTINCT(host)) FROM TABLE_HOST WHERE path_a=""; Mithun Karl J. Stubsjoen wrote: Hello, I am trying to count the number of unique records that exist in my database based on a given criteria. My table looks like this: TABLE_HOST id host path_a path_b The field host will

Re: mySql BUG

Dyego Souza do Carmo writes: > Hi, > > > Try to do the following: > [skip] > > > - > ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento > ---

Re[2]: mySql BUG

Sinisa: Wednesday, June 11, 2003, 2:16:16 PM, você escreveu: ---[inicio]-- SM> Hi! SM> Your attachment was stripped off. SM> Please upload it to: SM> ftp://support.mysql.com:/pub/mysql/secret SM> and let us know it's filename. The FileName is l5.zip -

Re: Re[2]: mySql BUG

Dyego Souza do Carmo writes: > Sinisa: > > Wednesday, June 11, 2003, 2:16:16 PM, você escreveu: > > ---[inicio]-- > > > > The FileName is l5.zip > > > ---[cortar]-- > > > >

Re: Group by and Count query

> > Here is the query I'd like to run (which fails - but is exactly what I need > > for a query): > > select sum(count(host)) from TABLE_HOST where path_a='' group by host well I think this one fails because count only ever returns one number (correct?). So I would think sum would take in a stre

left join

Which mysql´s version is able to make sub selects statament??? And left join? could you there give me some left join examples??? thanks a lot

Thousands of users? Newbie question

Hi Guys, I intend my online database to be used by 100 or so companies each with up to 100 employees. Each of these employees may add data as required. I don't want to assign one password for an entire company, in case one disgruntled ex-employee decides to post erroneous data. So presumably I

Re: mySQL GUIs

Greeting I find SQLyog ( http://www.webyog.com ) the best of all. You will find lot of articles and tutorials on it on various MySQL/PHP site. It is comparable to any MySQL GUI in the market and is FREE!!! I think you should definately take a look at it. MyCCI dont like...coz its bloated and

RE: MySQL 4.1 and MyCC

Don't know if I agree with that. I can connect via VPN to a test server at the home office running RH 8.0 and MySQL 4.1. I can also connect to a RH 7.3 machine running MySQL 4.0.12. BUT I can't connect to my local test server running Red Hat 7.3 and MySQL 4.1 without receiving the error message.

complie for hp-ux bug

I think I have encountered a bug in trying to install mysql 4.0.13 on hp-ux 11.0 when I try to install per sec 2.3 in your documentation I get the errors below. I believe the problem is identified ;in the fragment from config.log on the fourth line you will see a space between the "u" and the "x

4.1 character set documentation

Alexander Barkov and Peter Gulutzan have written up some documentation on the new character set support in MySQL 4.1, which has now been added to the online manual. You can read it here: http://www.mysql.com/doc/en/Charset.html Note that this documentation actually is ahead of the current release

Re: my.cnf

At 10:34 -0500 6/11/03, Chris McKeever wrote: I have been plowing through the mysql.com resources for something regarding the run-time configuration options as well as the my.cnf. In particular, I am trying to move the entire information store to a separate hard-drive. This line confuses me: --->

Re: MySQL 4.1 and MyCC

At 11:55 -0500 6/11/03, Christensen, Dave wrote: I upgraded my test MySQL server yesterday to 4.1 and I'm now receiving an error when I try to connect using MyCC. The error is ERROR 1249: Client does not support authentification protocol requested by server. Consider upgrading MySQL client. I'v

RE: mySQL GUIs

I'm a big fan of Scibit's "Mascon" -Original Message- From: Rodolphe Toots [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 5:17 AM To: [EMAIL PROTECTED] Subject: mySQL GUIs hi! i am looking for a good mySQL gui for windows i have used mySQL front, which was an excellent free

replicate

I don't really think this can be done, but I figured that I would ask anyways I want 3 mysql server running (A,B and C) I want only one table from A to replicate to B and I want all of B but the one table from A to replicate to C and I want C to replicate back to B -Michael "This marks yo

Problem with MAX()

We are running v4.0.12. Consider the following: mysql> SELECT MAX(assets) as assets -> FROM do_deductibles -> WHERE currency = 'usd'; ++ | assets | ++ | NULL | ++ 1 row in set (0.00 sec) mysql> SELECT MAX(assets) as assets -> FROM do_deductibles -> WHERE

sub select

Hi, I've just downloaded the version 4.1. I tryed to run my first sub-select : SELECT curso.* FROM curso where curso.cdCurso IN (SELECT EstabMantemCurso.cdCurso FROM EstabMantemCurso) The following ERROR returned: [local] ERROR 1235: This version of MySQL doesn't yet support 'LIMIT &

binary log

Is it possible to have more than one binary log per master or is it possible to start more than one thread to execute queries? I have 2 computers in a master and slave configuration. The slave is running without error but it can't keep up with the volume of updates being performed on the maste

timestamp

hello and thank you for your time, i have insert into table (column1, column2, create_dt) values (fname, lname, 'what do i put for create_dt?') does timestamp automatically insert the date without me specifying? thank you for your time again, tad -- Addison Ellis small independent publishing c

RE: Group by and Count query

You could do the following: select host,count(*) as counthost from TABLE_HOST group by 1 having counthost = 1; Which will list all the hosts with only 1 record.. Then get the "numrows" from that query to find uot how many there are.. Cheers, Andrew -Original Message- From: Mithun Bhat

Re: timestamp

yes, it automatically inserts the time. >From the manual: 6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types: ( http://www.mysql.com/doc/en/DATETIME.html ) "The TIMESTAMP column type provides a type that you can use to automatically mark INSERT or UPDATE operations with the current date and time. If

timestamp solved - thanks

timestamp solved - thanks... -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED] addisonellis.com THIS E-MAIL AND ANY FIL

RE: binary log

In order to help, could you post some info about both servers config (cpu speed, disk speed and OS as well as network capacity) - That would really help people understand the problem and find the bottleneck... Cheers, A -Original Message- From: Sam Jumper [mailto:[EMAIL PROTECTED] Sent:

Re: MySQL 4.1 and MyCC

Paul DuBois wrote: At 11:55 -0500 6/11/03, Christensen, Dave wrote: I upgraded my test MySQL server yesterday to 4.1 and I'm now receiving an error when I try to connect using MyCC. The error is ERROR 1249: Client does not support authentification protocol requested by server. Consider upgra

Re: binary log

On Wed, Jun 11, 2003 at 03:30:01PM -0500, Sam Jumper wrote: > Is it possible to have more than one binary log per master or is it > possible to start more than one thread to execute queries? > > I have 2 computers in a master and slave configuration. The slave is > running without error but it

configuration questions - newbie getting up-to-speed

Sorry from the low-level posts, but I am trying to get my grips around some simple set-up configuration. - What exactly does basedir do? It defauts to / which to me means it is at the 'base' of the filesystem. Why/when would you need to change it (since you would only be moving it up levels - or

Re: MySQL 4.1 and MyCC

At 23:18 +0100 6/11/03, Peter Burden wrote: Paul DuBois wrote: At 11:55 -0500 6/11/03, Christensen, Dave wrote: I upgraded my test MySQL server yesterday to 4.1 and I'm now receiving an error when I try to connect using MyCC. The error is ERROR 1249: Client does not support authentification pr

Re: configuration questions - newbie getting up-to-speed

At 17:04 -0500 6/11/03, Chris McKeever wrote: Sorry from the low-level posts, but I am trying to get my grips around some simple set-up configuration. - What exactly does basedir do? It defauts to / which to me means it is at the 'base' of the filesystem. Why/when would you need to change it (sin

RE: configuration questions - newbie getting up-to-speed

I also found out that mysqld --help provides a whole lot more of the information that I was looking for than just mysql --help! whoops > -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 11, 2003 5:15 PM > To: Chris McKeever; [EMAIL PROTECTED] > Su

RE: MySQL 4.1 and MyCC

Tried this and it didn't make any difference. Still getting the error when I try to connect to the server with MyCC. I CAN connect using the command line mysql program. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 5:08 PM To: Peter Burden

RE: MySQL 4.1 and MyCC

Okay, I've now added this using the 'old-passwords' syntax in my.cnf file. Still doesn't make any difference. Have no idea about how to change passwords from 'old' to 'new' -Original Message- From: Peter Burden [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 5:19 PM To: Pa

RE: MySQL 4.1 and MyCC

At 17:25 -0500 6/11/03, Christensen, Dave wrote: Tried this and it didn't make any difference. Still getting the error when I try to connect to the server with MyCC. I CAN connect using the command line mysql program. Are you using the 4.0 mysql or the 4.1 mysql? Are you trying to connect (with

Need help with an update

Here is the scenario. I was running 3.23.39 that came with BSD/OS 4.3 , All the databases were running active. I upgraded to BSD/OS 5.0 which has Mysql 3.23.49 and suddenly NO databases are seen. Everything is where is is supposed to be, but the mysqld is not seeing the DBs that were running w

Programmatically building table

Hello All: I'm working on an application that has to drop and then recreate tables programmatically and does not have 'file' privileges. i.e., I can't use 'load data infile'. On a smaller venue, I programmatically create a .sql script file that drops, then re-creates the table, and then writes

How to import MySQL tables from Linux?

Instead of creating tables manually in MySQL, I would like to import them. I have done this under Oracle, with the following @a:\sqlfiles\foo.sql How do I import sql files into mysql using Linux? I have a directory under /root/sql thanks -Chris = GTFG GAIM ID: cmmiller1973

Re: configuration questions - newbie getting up-to-speed

Hi Chris, Not sure which OS you are using, but in case you use Linux you should try info mysql You will most probably find what you are after. Best regards Nils Valentin 2003年 6月 12日 木曜日 07:18、Chris McKeever さんは書きました: > I also found out that > > mysqld --help provides a whole lot more of the

Table design suggestions?

I have to add group functionality to an existing database. The functionality required will be something like /etc/group in linux. I have a need to create and maintain a list of groups. Then, each group will have a list of members. I will need to be able to search by member name and get a list of wh

about replication

Hello, mysql, 2 Mysql 4.0.12 windows version with INNODB replciate sucessfully,both in myisam and innodb table. According to mysql manual(PDF),there is only one master database in the same time,but with many slave server. Master for query,and slave for update or insert op

Re: Table design suggestions?

On Wednesday 11 June 2003 08:47 pm, JJ wrote: > I have to add group functionality to an existing database. The > functionality required will be something like /etc/group in linux. How about 3 tables. Groups, Members, and Relationships. Table Group id int auto_increment name char Table Memb

Re: Table design suggestions?

On Wed, 11 Jun 2003 22:17:09 -0230, "JJ" <[EMAIL PROTECTED]> wrote: [...] | *** | * The second idea is to create two tables. | *** | table groups | groupName varchar primary key | groupDescription text | | table groupRelations

Re: Table design suggestions?

given this, how would you write a query to list all members that are part of group_id=1 AND group_id=2 AND ... group_id 20. without having to write 20 "JOIN relationship r1 on r1.group_id =1 JOIN relationship r20 on r20.group_id =20) wich gets extremely slow with large ammounts of JOINS.

Question about insert failed.

Hello all, In version 3.23.X we had a script running: 1 - Create a temp table from imported cdf files. 2 - Select into the production table using criteria. 3 - Use production table. -- On a duplicate record, for some reason our Oracle folks think this is acceptable, the duplicate record was ign

Second Auto-increment

I would like to auto-increment within an auto-incremented value. For example, if I have a rental agreement(auto-incremented) and that rental agreement becomes month-to-month. I was thinking that I would want to track the receipts as such: Contract # | Type | Second Auto # | Duration |payment t

Re: Table design suggestions?

> Table Group > id int auto_increment > name char > > Table Member > groupID int auto_increment > name char > > Table Relationship > group_id int > member_id int > i'd set it up like this Table Group id int auto_increment name char Table Member userID int auto_increment name cha

Re: Question about insert failed.

At 20:23 -0700 6/11/03, T R O D A T wrote: Hello all, In version 3.23.X we had a script running: 1 - Create a temp table from imported cdf files. 2 - Select into the production table using criteria. 3 - Use production table. -- On a duplicate record, for some reason our Oracle folks think this is

Re: Second Auto-increment

At 19:43 -0700 6/11/03, Q Zantos wrote: I would like to auto-increment within an auto-incremented value. For example, if I have a rental agreement(auto-incremented) and that rental agreement becomes month-to-month. I was thinking that I would want to track the receipts as such: Contract # | Type

  1   2   >