Re: Insert...on duplicate key update

Hi, ON DUPLICATE KEY UPDATE is only available with MySQL 4.1.x. Regards, Jocelyn - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 08, 2003 8:32 AM Subject: Insert...on duplicate key update > >Description: > I have been writing an update progr

Insert...on duplicate key update

>Description: I have been writing an update program in perl, and sought to make use of the insert...update construct described in the insert syntax section of the manual supplied with the download of mysql-4.0.13-standard. However, upon using the construct in my code, I receive syn

derived tables

I am trying a query using derived tables, but have had little success. Tables follow: user_table --- |user|tbl | --- |bud |t2 | |guy |t4 | |abc |t5 | --- t2 --- |a|b|c| --- |data | --- t4 --- |d|e|f| --- |data | --- etc... I would like to sel

Re: mysqldump

Hi Kalle, I understood that you already received 4 answers in the meanwhile, why are you reposting the same question like yesterday ?? Best regards Nils Valentin Tokyo/Japan 2003年 7月 8日 火曜日 14:06、Kalle Saarinen さんは書きました: > Hello > > I'm trying to make mysqldump in a shell script but I can't

Re: mysqldump

mysqldump dbname -u -p > /dir/dump.sql notice no spaces. On Tue, 8 Jul 2003, Kalle Saarinen wrote: > Hello > > I'm trying to make mysqldump in a shell script but I can't deliver password > to sql server. > > I have command in the script: > > mysqldump databasename -u username -p password >

mysqldump

Hello I'm trying to make mysqldump in a shell script but I can't deliver password to sql server. I have command in the script: mysqldump databasename -u username -p password > /to/a/directory/dump.sql When i run the script it asks for a password and takes the password given in the script for a

Re: "select * from table where field=hex" doesnt work

Hi Koh, Shouldn't the value in the first sample be used like this ? 1) SELECT * FROM table1 WHERE field1 = '0x6100620063006400'; Correct me if I am wrong. Best regards Nils Valentin Tokyo/Japan 2003年 7月 8日 火曜日 11:55、Koh Swee Meng さんは書きました: > i inserted a new record with this SQL > "INSERT

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

2003年 7月 8日 火曜日 11:40、Kevin H. Phillips さんは書きました: > Hi, Nils > I just thought that it would be better, more particularized, for my > system. Would it be better to use the precompiled rpms? Generally talking I believe you can avoid some trouble by using the provided rpm binary packages. However,

Re: "select * from table where field=hex" doesnt work

oh, i found the solution for this, by doing "SELECT * FROM table1 WHERE STRCMP(field1, 0x6100620063006400)=0" will work as expected, so no need to worry that character %(ASCII 25) will cause any problem. Regards, Koh Swee Meng - Original Message - From: "Koh Swee Meng" <[EMAIL PROTE

"select * from table where field=hex" doesnt work

i inserted a new record with this SQL "INSERT INTO table1(field1) VALUES(0x6100620063006400)" type of table1.field1 is tinyblob. to retrieve the record, i tried SQL belows, 1) SELECT * FROM table1 WHERE field1 = 0x6100620063006400; 2) SELECT * FROM table1 WHERE field1 LIKE 0x6100620063006

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

Forgot to mention that I installed from an rpm. I rebuilt a source rpm. Kevin Nils Valentin wrote: How did you install the mysql server (rpm or tar.gz ) ? Best regards Nils Valentin Tokyo/Japan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

Hi, Nils Here's what I get: mysql> GRANT ALL ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'password' WITH GRANT OPTION; ERROR 1047: Unknown command mysql> I'm sorry I should have asked before if the apostrophes were necessary. And, the first one is an apostrophe and not the little tilted apostr

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

2003年 7月 8日 火曜日 10:25、Kevin H. Phillips さんは書きました: > Hi, Nils > OK, here's a copy of the terminal screen I am getting after killing the > mysqld daemon and then re-starting it: > > [EMAIL PROTECTED] root]# ps ax |grep mysqld > 32309 pts/0S 0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tabl

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

Hi, Nils OK, here's a copy of the terminal screen I am getting after killing the mysqld daemon and then re-starting it: [EMAIL PROTECTED] root]# ps ax |grep mysqld 32309 pts/0S 0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables 32334 pts/0S 0:00 /usr/libexec/mysqld --basedir=

Re: Difference of MySQL Standard and Max Version

Hi Dan, 2003年 7月 8日 火曜日 00:57、Dan Nelson さんは書きました: > In the last episode (Jul 07), Nils Valentin said: > > Thank you for the superfast reply. I actually was looking for other > > information. I understood the actual feature difference of the > > standard and f.e max version. Sorry if this didnt

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

Hi Kevin; Try to start it as mysqld_safe --skip-grant-tables & to start the service in the background, you will then be able to continue in the same window. Sorry I didn't mention this. Can you post the grant command you try exactly as it is to the mailing list please (without password of c

Re: Trouble creating users

Hi Michael; I took once moe a sharp look now that you did a reply with another sample. Actually I was wrong the SQL statement was NOT correct - you forgot the semicolon in the first exapmple ;-) 'Y', 'Y', 'Y');\"" Best regards Nils Valentin Tokyo/Japan 2003年 7月 8日 火曜日 09:38、Michael I

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

Hi, Nils I was able to stop the mysqld daemon using the kill command. However, when I tried to start it using mysqld_safe --skip-grant-tables, a line would appear saying: [EMAIL PROTECTED] root]# mysqld_safe --skip-grant-tables Starting mysqld daemon with databases from /var/lib/mysql with the

Re: AUTOEXTEND

How about this ?? (MySQL 4.1-alpha) +-++ | Variable_name | Value | +-++ | have_innodb | YES| | innodb_additiona

Re: Trouble creating users

Thanks for your reply, Nils. and then I would like you to take a sharp look at whats left, then there should perhaps be something with this part above. Perhaps the " at the very end is not escaped correctly (double) or something similar. The actual SQL statement works perfectly fine. I thought

Re: Trouble creating users

Hi Michael, I am not a script person, but let me try to help you figuring out whats wrong. First I assumed that the user executing the script has the necessary privileges t update the privilege database /datadir/mysql (for Linux f.e /var/lib/mysql/mysql) . The second I tried your SQL statemen

oledb provider with transaction support?

i downloaded oledb provider from mysql.com, i use Delphi's ADO. but i found that this oledb provider does not support transaction. is there any oledb provider that does support transaction? thanks

concat() differences between mssql and mysql

I've run into a problem with the behavior of concat(). If I have two fields, char(10), and I do this: concat(field1,fields) With MSSQL I get both fields including trailing spaces. With MYSql, I get the two fields with the trailing spaces trimmed. Example: Field1 = "abc " Field2 = "qwerty

Trouble creating users

I've been having a little trouble creating users cross-platform. I have a little script that works just fine on Solaris 8 using this command: eval "/path/to/mysql --user=root --password=* --socket=/path/to/socket --database=mysql --execute=\"INSERT INTO user (Host, User, Password, Select_p

RE: MySQLDriverCS Data Typing problem in tables

Kim I don't know anything about MySQLDriverCS but if you continue to have problems, you might try my provider at www.bytefx.com Thanks Reggie > -Original Message- > From: Kimberly Clark [mailto:[EMAIL PROTECTED] > Sent: Monday, July 07, 2003 10:14 AM > To: [EMAIL PROTECTED] > Subject: My

RE: AUTOEXTEND

Hi, I tried SHOW VARIABLES LIKE '%innodb%'; but I couldn't find any variables that show information about auto extend property. Please clarify... For my second question, I need only the table_name and table_type information, and avoid the rest, for an instance. I tried the tables_priv table in

Re: InnoDb and fragmentation

Mike, - Original Message - From: "mos" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, July 07, 2003 5:54 PM Subject: InnoDb and fragmentation > Heikki, > Do InnoDb tables suffer from internal table fragmentation. (Is there any > way to measure it?) I only mention t

Re: AUTOEXTEND

Subhakar, - Original Message - From: ""Subhakar Burri"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, July 07, 2003 11:52 PM Subject: AUTOEXTEND > Sorry to post the same question again .. last time when I sent I = > received a couple of mails with some error messa

Re: 3.23.x to 4.0.x INNODB

Wendell, - Original Message - From: ""Wendell Dingus"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, July 08, 2003 12:09 AM Subject: 3.23.x to 4.0.x INNODB > I think I know the answer to this question, but.. Just to be sure. > > Can I take multiple 2GB files in /

3.23.x to 4.0.x INNODB

I think I know the answer to this question, but.. Just to be sure. Can I take multiple 2GB files in /var/lib/innodb and the corresponding files in /var/lib/iblogs created with 3.32.55 (INNODB) and upgrade to 4.0.13 and let it use those existing files without a problem? Without dumping and re-impor

AUTOEXTEND

Sorry to post the same question again .. last time when I sent I received a couple of mails with some error messages .. so, not sure if my question was posted ... Here we go again .. Hi, I have a couple of questions, and really appreciate your help ... How can I find out if a data file is set

RE: Newbie questions (3) - listeners / BLOB / PHP

-Original Message- From: Jeremy [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 12:49 PM To: [EMAIL PROTECTED] Subject: Newbie questions (3) - listeners / BLOB / PHP Hi I'm from an Oracle background and wanted to ask a couple of questions: 1) Have installed mysql 4 on a linux ser

Re: Newbie questions (3) - listeners / BLOB / PHP

> 1) Have installed mysql 4 on a linux server. If I want to access this from > another machine (i.e. run a MySQL-compliant client), is there a 'listener' > of some sort that has to run on the server where the database is? Nope, proper permissions is the only requirement. MySQL listens on port 33

RE: Newbie questions (3) - listeners / BLOB / PHP

No Yes www.php.net Regards, Mike Hillyer > -Original Message- > From: Jeremy [mailto:[EMAIL PROTECTED] > Sent: Monday, July 07, 2003 1:49 PM > To: [EMAIL PROTECTED] > Subject: Newbie questions (3) - listeners / BLOB / PHP > > > Hi I'm from an Oracle background and wanted to ask a coup

Re: Replication bin log rollover....

Jeff Kilbride wrote: > > I remember seeing this same question a few months ago, so you might try the > archives. I'm pretty sure the answer was that mysql continues incrementing > to 4 digits. If you have a dev box, you could create a .999 binlog and put > it in your bin-index file -- then start m

Newbie questions (3) - listeners / BLOB / PHP

Hi I'm from an Oracle background and wanted to ask a couple of questions: 1) Have installed mysql 4 on a linux server. If I want to access this from another machine (i.e. run a MySQL-compliant client), is there a 'listener' of some sort that has to run on the server where the database is? 2) Can

RE: issue with 'count'

Paul, Try SELECT c.id, count(cug2.id_curso) as num_profe_curso FROM nuke_elearning_curso as c, LEFT JOIN nuke_elearning_curso_usuario_grupo as cug2 ON c.id = cug2.id_curso group by c.id HAVING num_profe_curso > 0 Andy > -Original Message- > From: Paul [mailto:[EMAIL PROTECTED] > Sent: 0

2013: Lost connection to MySQL server during query & ERROR 1129: Host 'webfrontend' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'

Hi! I've look a bit around google for theese errors - but i can't find any useful answers to my problem. My setup is; web frontend running apache/php for dynamic page creation (p4 - 2,4 Ghz - 1Gb - ide) sql backend running mysql 4.0.12-log (p3 - 1 Ghz - ide) both machines running deb

issue with 'count'

hi to all, and thank for your valuable help my problem SELECT c.id, count(cug2.id_curso) as num_profe_curso FROM nuke_elearning_curso as c, LEFT JOIN nuke_elearning_curso_usuario_grupo as cug2 ON c.id = cug2.id_curso WHERE num_profe_curso > 0 group by c.id esta sentencia sql busca la canti

AUTOEXTEND

Hi, I have a couple of questions, and really appreciate your help ... How can I find out if a data file is set to auto-extend without looking in my.cnf file? ie.. is there any variable that stores this information inside a database that I can query? I need the table_name & table_type of all th

RE: Replication stops for no reason...

UPDATED INFO mysql> show slave status \G; *** 1. row *** Master_Host: 10.32.1.10 Master_User: repli Master_Port: 3306 Connect_retry: 60 Log_File: db01tc0927-bin.034 Pos: 468335571 Slave_R

Re: innodb transaction

hi many thanks for that quick and precise answer - a big smile. i am very impressed by this user group, especially regarding the speed and quality of the answers. regards benny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.c

Re: Replication bin log rollover....

I remember seeing this same question a few months ago, so you might try the archives. I'm pretty sure the answer was that mysql continues incrementing to 4 digits. If you have a dev box, you could create a .999 binlog and put it in your bin-index file -- then start mysql, issue a flush logs command

RE: Epoch time to MM-DD-YYYY

FROM_UNIXTIME() Jeff -Original Message- From: Brei, Matt [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 1:42 PM To: [EMAIL PROTECTED] Subject: Epoch time to MM-DD- I have a small database for logging support tickets for the IS department that logs all timestamps in UNIX epoc

Replication stops for no reason...

mysql Ver 11.15 Distrib 3.23.41, for pc-linux-gnu (i686) I have the following replication setup... DB1 --> DB2 --> DB3 Every often, replication from DB1 to DB2 just stops. There is no error messages that I can see. I know it's stopped because I have a check that runs every 5 minutes to see a

Epoch time to MM-DD-YYYY

I have a small database for logging support tickets for the IS department that logs all timestamps in UNIX epoch time. I'm trying to use Crystal Reports for various reporting and I'm having a problem with timestamps. Is there a MySQL function that will convert epoch to a human readable format?

Re: innodb transaction

Benny, - Original Message - From: ""Bernhard Schmidt"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, July 07, 2003 6:33 PM Subject: innodb transaction > --=_NextPart_000_0144_01C344AD.CB5B11C0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transf

Mysql embeded

Hello, The application I'm dealing with, is writen in java, jsp, jdbc, mysql 4.0... I use a broker between java classes and mysql db. broker creates n connections when the server tomcat start and shares connections. Here is the code to create connections : for (int i = 0; i < n; i++) { Cl

ERROR 2002: Can't connect to local MySQL server through socket

I have installed a Mac OS X 'PKG' binary package on my OS version 10.2.6 Mac. I have been instructed that after the installation I can start up MySQL by running the following command lines: [Computer:/usr/local/mysql] mark% sudo ./bin/mysqld_safe Password: Starting mysqld daemon with databases

Re: OS X User - Start up help

Mark Depenbrock wrote: I have installed a Mac OS X 'PKG' binary package on my OS version 10.2.6 Mac. I have been instructed that after the installation I can start up MySQL by running the following command lines: [Computer:/usr/local/mysql] mark% sudo ./bin/mysqld_safe Password: Starting mys

OS X User - Start up help

I have installed a Mac OS X 'PKG' binary package on my OS version 10.2.6 Mac. I have been instructed that after the installation I can start up MySQL by running the following command lines: [Computer:/usr/local/mysql] mark% sudo ./bin/mysqld_safe Password: Starting mysqld daemon with databases

RE: Delete user/no access to mysql db

The REVOKE command should do most of the job for you, which is removing the privileges for a specific user. See the manual for more. However, the user remains defined in the "user" table (while having no privileges), until one with access, deletes him/her manually. HTH, Lian > -Original Mess

Re: mysqldump

hi kalle, i had exactely the same problem as you before from the command prompt. All i did to go around that was to create a blank user before running the script, remove it after and then flush. _ MSN 8 helps eliminate e-mail viruses

Re: Difference of MySQL Standard and Max Version

In the last episode (Jul 07), Nils Valentin said: > Thank you for the superfast reply. I actually was looking for other > information. I understood the actual feature difference of the > standard and f.e max version. Sorry if this didnt came out so clear. > I will try to make it clearer. > > My q

test

-- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/

MySQLDriverCS Data Typing problem in tables

I'm really hoping someone here can at least point me in a new direction. For background, I'm using MySQLDriverCS and C# in VS.NET 2003. I can create the connection, read in data, and even display it fine. The problem I'm encountering is that everything is typed as a string, even though it may be

newbie question, link tables

Hi all, Can I link two fields in two tables, in the way that if I add a new value into a table in the other table the value is added automatically, or Do I need to add the values one time for every table? Thanks for helping me. Pedro -- MySQL General Mailing List For list archives: http://li

new to databases, multiple relations

Hi all, I have to create a database where the elements of a table are related to elements on the same table. What is the best (optimised) way to do that? I came with the model: CREATE TABLE locations( location_id int(11) auto_increment, location_name varchar(50) NOT NULL default '',

RE: Need help with a 1005 error (errno: 150), please...

Please ignore my last email. I made a nauseatingly dumb error in the book table (sku should be CHAR(14), not INT). The only help I need is to get some sleep. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE

innodb transaction

hi all i started working with the innodb databasel. after reading the manual i am not sure how i shall use transctions. say i have the following case: SELECT read some row UPDATE depending on the select COMMIT to make the command sequence safe, the select has to lock the table. it would be nice

Re: Need help with a 1005 error (errno: 150), please...

You must create the key (sku), it is not created for you. Tom Gazzini wrote: I would appreciate some help with a problem. I'm trying to create two tables that have referential integrity. If I try and create the following table it works fine: CREATE TABLE book ( sku INT ) TYPE=INNODB; However, i

Need help with a 1005 error (errno: 150), please...

I would appreciate some help with a problem. I'm trying to create two tables that have referential integrity. If I try and create the following table it works fine: CREATE TABLE book ( sku INT ) TYPE=INNODB; However, if I creating this table, I get an error: CREATE TABLE book ( sku INT,

Re: Problem With RAND()

Hi! On Jul 07, Scott A. Hammond, Sr. wrote: > I am running MySQL 3.23.54. > > Query: SELECT column1, column2, RAND() AS column3 FROM table WHERE column2 > IS NOT NULL ORDER BY column3 LIMIT 10; > > I am running this query within a PHP page that uses mysql_connect. More > then 9 out of 10 times

Re: Problem With RAND()

Since you are ordering by column3, ( in other words sorting your random mumbers ), what do you expect? Scott A. Hammond, Sr. wrote: I am running MySQL 3.23.54. Query: SELECT column1, column2, RAND() AS column3 FROM table WHERE column2 IS NOT NULL ORDER BY column3 LIMIT 10; I am running this que

Re: Update and/or Insert

Try looking up the REPLACE command. That does exactly what you are looking to do, but you do need a primary key for it to lookup on. On Monday, July 7, 2003, at 10:54 AM, LeTortorec, Jean-Louis wrote: Hello everyone, Is there a function that first tests if a record exists, and if so updates it

Update and/or Insert

Hello everyone, Is there a function that first tests if a record exists, and if so updates it, or if it does not exists, it creates that new record? I know I can do that by checking the list of records, then update the table. But that requires 2 queries. If I could get that done by one, that wou

InnoDb and fragmentation

Heikki, Do InnoDb tables suffer from internal table fragmentation. (Is there any way to measure it?) I only mention this because of a problem I have with another database system (not MySQL). Some of its tables are hopelessly fragmented (800,000 file fragments for one table alone! Did I set a ne

Re: Optimal Disk Configuration

Jim McAtee wrote: David Lloyd wrote: What would be the ideal RAID configuration for a dedicated MySQL db server running on FreeBSD? We're also running some MySQL databases on Windows 2000 Servers. What about the best configuration for a dedicated W2k server running MySQL? That depends

Delete user/no access to mysql db

Hi. I'm using MySQL on my web host. I'm a dba of the db's that I create, but I have no access to the mysql db. I can create users (GRANT USAGE ON my_db ... works), but I don't know how to get rid of them. I searched the manual, and the only reference to removing users that I could find was deleti

RE: My query string might be too long

Well, I have sent queries over 4 times as long without difficulty, so I do not think you are coming up against a limit on query length. I would not use MySQL 5 for any production or even development machines, as a development tree is not even guaranteed to work. Regards, Mike Hillyer www.vbmysql.c

RE: Possible OT: ADONewConnection Error

I also see this: [ODBC] ;odbc.default_db= Not yet implemented ;odbc.default_user = Not yet implemented ;odbc.default_pw= Not yet implemented ; Allow or prevent persistent links. odbc.allow_persistent = On ; Check that a connection is still valid before reuse. odbc.check_persistent

FW: Possible OT: ADONewConnection Error

-Original Message- From: marvc [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 10:18 AM To: 'Jay Blanchard' Subject: RE: Possible OT: ADONewConnection Error Here's what I found in my php.ini.dist file: ;; ; Dynamic Extensions ; ;; ; ; If

My query string might be too long

Is there a line limit to a query in MySQL? ( I couldn't find this in the MySQL manual) Here is my query: SELECT a.field_name, b.field_option, c.project_name FROM field_master a, field_options_master b, project_master c where a.field_option_id = b.id and a.project_id=b.project_id and a.project_id='1

dbf2mysql

Hi to all :) I'm looking for the rpm of the great prog dbf2mysql version 1.14. I've found a rpm of an older version (1.10) but that's not enough. Anybody ? thanx in advance ;) fabrice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

Re: Compiling MySQL on Windows

At 10:40 07-07-2003 -0300, Dyego Souza do Carmo wrote: Hi, I get the last bk tree of mysql and want to compile on windows... i have the VC++ 6.0 whith SP5 and PROCESSOR PACK... but i try to compile using the Vc++Files directory and the MySQL print an error... what is the steps to compile on window

Problem With RAND()

I am running MySQL 3.23.54. Query: SELECT column1, column2, RAND() AS column3 FROM table WHERE column2 IS NOT NULL ORDER BY column3 LIMIT 10; I am running this query within a PHP page that uses mysql_connect. More then 9 out of 10 times I get the first 10 rows of the database in order, i.e. 1, 2

Re: mysqldump

Hi Just read this last night. Try mysqldump databasename -u username --password=yourpassword > /to/a/directory/dump.sql Mike - Original Message - From: "Kalle Saarinen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: July 7, 2003 8:21 AM Subject: mysqldump > Hello > > I'm tryi

Compiling MySQL on Windows

I get the last bk tree of mysql and want to compile on windows... i have the VC++ 6.0 whith SP5 and PROCESSOR PACK... but i try to compile using the Vc++Files directory and the MySQL print an error... what is the steps to compile on windows the LAST BK TREE ? Tnks... --

RE: Possible OT: ADONewConnection Error

[snip] I haven't tried that. What am I looking for in the php.ini? Check the php.ini to make sure that the driver is not commented out. [/snip] Look in your php.ini for extensions and .dll. If the first character of the line is ";" it is commented out. Look for dealing with ADO HTH! Jay -- M

Re: Mysql - Dual Xeon or Dual Opteron

Konstantin Yotov <[EMAIL PROTECTED]> writes: > 2x1GHz Intel, 1GB RAM, 40GB WD 7200 8MB cache. > We are going to uprade our server but I'am wondering > between new Opteron (1.4GHz)and Xeon (2.4). Can't you get a machine for testing before you buy it? Xeon processors aren't necessarily a signific

RE: [HELP] Newbie experiences problems AND receives no help for the moment

Matthias, I, like everyone else on the list it appears, have no idea how to help you as you have provided no example of what you are trying to do, no output and no error messages. Remember everyone gives help here for free, so people tend to help people who make it clear what the problem is. I k

RE: Enable Create_tmp_table_priv

> you must have Create_tmp_table_priv privilege set to Yes No matter. Found it, cunningly hidden in the 'user' table:-) -- Aidan Whitehall Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003

RE: Possible OT: ADONewConnection Error

Thanks I haven't tried that. What am I looking for in the php.ini? -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 7:32 AM To: marvc; [EMAIL PROTECTED] Subject: RE: Possible OT: ADONewConnection Error [snip] ADONewConnection: Unable to load

[HELP] Newbie experiences problems AND receives no help for the moment

Hi, I was trying to install, via an sql file (not enclosed, since 4MB big), a MySQL db, but I experience some problems: - when installing from shell>, I get the output mysql.out (originally enclosed, not sure whether the server tolerated the enclosure); I don't think anything useful is achieved by

RE: Mysql - Dual Xeon or Dual Opteron

yes i was very impressed with the benchmark on the opteron , frankly i rekon the opterons are more optimised to a unix environment where xeons are more optimised for a windoze environment, we just got a dual 2G zeon dell system for a production box for a project which is doin full text searching on

Re: mysqldump

Try removing the space between -p and password. i.e., like this: mysqldump databasename -u username -ppassword >/to/a/directory/dump.sql > Hello > > I'm trying to make mysqldump in a shell script but I can't deliver > password to sql server. > > I have command in the script: > > mysqldump data

mysqldump

Hello I'm trying to make mysqldump in a shell script but I can't deliver password to sql server. I have command in the script: mysqldump databasename -u username -p password > /to/a/directory/dump.sql When i run the script it asks for a password and takes the password given in the script for a

Mysql - Dual Xeon or Dual Opteron

Hello! :) Our server is very heavy loaded: CPUs states are in 0.0% idle almost all day. Linux 7.3 running myslq 3.23.56 and apache 1.3.27 on 2x1GHz Intel, 1GB RAM, 40GB WD 7200 8MB cache. Mysql have around 166 threads and perforn over 400 Queries per second. We are going to uprade our server but

RE: Possible OT: ADONewConnection Error

[snip] ADONewConnection: Unable to load database driver '' Fatal error: Call to a member function on a non-object in /wwwroot/htdocs/webdev/nubiint/includes/pnAPI.php on line 486 I get this error when trying to configure multisites in my postnuke site. I thought it was an ODBC issue but I've inst

Enable Create_tmp_table_priv

I'm trying to install FarCry (a web-based Content Management System) on a development machine (Windows XP, Apache 2.0.46 & MySQL 4.0.13) and the installation guide says http://farcry.daemon.com.au/go/developers/install-guide "Note for MySQL 4.x users, you must have Create_tmp_table_priv pri

Re: need help with select statement

No, no you are welcome. I made a reserved word list and some other stuff, which is not complete yet. I concentrate on topics which I (personally) would like to be covered more detailed than it is done in the original MySQLmanual. http://www.knowd.co.jp/staff/nils Feel free to browse around, but

[HELP] Newbie experiences problems

Hi, I was trying to install, via an sql file (not enclosed, since 4MB big), a MySQL db, but I experience some problems: - when installing from shell>, I get the output mysql.out (enclosed); I don't think anything useful is achieved by my command, as I cannot see any confirmation of creating db, ta

mysql_install_db

Hello, I have downloaded a binary distribution for HP-UX 10.20. (in /usr/local) and would it install. Following I had realized this steps: shell> groupadd mysql shell> useradd -g mysql mysql shell> cd /usr/local shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell> ln -s /usr/local/m

Won't mysql_init();

I am trying to connect to a simple database, basically to check that I have the gist of programming with MySQL. I have tried the following code: #include #include "linlog.h" LinLog::LinLog(QWidget *parent, const char *name) : PGM_Window(parent, name) { MYSQL mysql; mysql_init(&mysql); if

Replication bin log rollover....

Hi, I have a MySQL master server doing huge amounts of inserts and updates. I'm rapidly reaching the point where my binlogs will get to: myserver-bin.999 Does anyone know if MySQL treats the rollover gracefully? Will it rollover to myserver-bin.001 or will it move to a 4 figure extension? I c

Re: need help with select statement

Hi Antony, Eventually "key" is a reserved word ?? ;-) nice one !! Best regards Nils Valentin Tokyo/Japan 2003年 7月 7日 月曜日 18:20、Anthony Scism さんは書きました: > I am relatively new at this, but is there any way to perform the > > following: > | obs_date | date | YES | | NULL

Re: Difference of MySQL Standard and Max Version

Dear Delfim, Thank you for the superfast reply. I actually was looking for other information. I understood the actual feature difference of the standard and f.e max version. Sorry if this didnt came out so clear. I will try to make it clearer. My question was more aiming at what advantages th

need help with select statement

I am relatively new at this, but is there any way to perform the following: | obs_date | date | YES | | NULL | | | obs_time | time | YES | | NULL | | | object | varchar(40) | YES | | NULL | | | observing_site | varchar(40)

Re: Difference of MySQL Standard and Max Version

http://www.mysql.com/downloads/mysql-4.0.html The Standard binaries are recommended for most users, and includes the InnoDB storage engine. The Max version includes additional features such as the Berkeley DB storage engine and other features that have not been exhaustively tested or are not requ

Re: CREATE TABLE problem ..

2003年 7月 7日 月曜日 18:02、Rafal Kedziorski さんは書きました: > At 17:58 07.07.2003 +0900, Nils Valentin wrote: > >2003å¹´ 7月 7æ—¥ 月曜日 17:43、Rafal Kedziorski さんは書きました: > > > hi, > > > > > > I'm porting an PostgreSQL script to MySQL. I get an error: > > > > > > Can't create table '.\m

  1   2   >