query

Hi A query... is the bulk update call from JDBC supported by MySQL? Regards Deepak Saini **Disclaimer Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use on

BDB or InnoDB

Hi MySQL Fans, I am sure this question was asked before, but I did not find sufficient info, so please allow me to ask this question again. When comparing BDB and InnoDB which one would be (generally speaking) a better choice for a certain purpose ? I understood that BDB and InnoDB have basica

Re: Can't insert data from Apache/PHP

> having register_globals 'on' is only a security risk if the code is sloppy. We're in agreement here, Jay. I see turning register_globals off as a band-aid fix for poor coding rather than a rule of thumb. That 'off' was made the default only recently emphasizes this, in my opinion. Edward Dudl

Re: about replication

On Thu, Jun 12, 2003 at 09:51:06AM +0800, MaFai wrote: > 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. Right.

Re: Second Auto-increment

While I'm not sure I understand your intention, it seems to me like you need another table to hold your data. As Paul stated, AUTO_INCREMENT doesn't work this way. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Q Zantos" <[EMAIL PROTECTED]> To: <[EMAI

Re: How to import MySQL tables from Linux?

http://www.mysql.com/doc/en/mysql.html In the MySQL client, end your command line statement with \. >From the shell, use this syntax: shell> mysql database < script.sql > output.tab Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "CM Miller" <[EMA

Re: 4.1 character set documentation

Paul DuBois advised us that > 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 Question about this: In

Re: Need help with an update

The OS upgrade probably just over-wrote the old MySQL install. Hopefully it left the files intact and you can import them as described in the manual. FWIW, MySQL is at v4.0.13 and some major improvements came with v4. You might want to consider reading the upgrade section of the manual, too. ;)

bulk updates

Hi All, Can I do bulk updates with MySQL. I am planning to use 4.0 vers. Regards Deepak Saini **Disclaimer Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for us

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

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: 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

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

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

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.

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?

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

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

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

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

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

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

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

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

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

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: 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: 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: 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

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: 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

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

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:

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: 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

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

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

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

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 &

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

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

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

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: 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: --->

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

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

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.

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

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

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

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

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[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: mySql BUG

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

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

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

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 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 =

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|

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

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: 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

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: 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: 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: 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: 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

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

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

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),

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

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

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

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: 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

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

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

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 ?

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, 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: 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: 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: 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: 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: 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: 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

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: 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

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: 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

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

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

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

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

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

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

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 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

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: 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

  1   2   >