Re: extending MySql

thanx alan! is there any C API available to detect MySql restarts! which file(s) do i have to monitor so that i can track server restarts. The server does not know how many times it has been restarted. You can easily enough write a wrapper script that keeps count, though. As for the

Query excution time

hi ! what is the best way to find query excution time in MySql plz help me! Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- MySQL General Mailing List For

Re: Query excution time

MTop (MySQL Top) is a really nice little utility: http://mtop.sourceforge.net/ Shows what queries are running, and elapsed time. Daivd - Original Message - From: Prem Soman [EMAIL PROTECTED] To: mysql groups [EMAIL PROTECTED] Sent: Saturday, June 21, 2003 12:02 AM Subject: Query excution

MySQL - MS SQL

Hi, I have designed a site using PHP MySQL. Recently an urgent requirement has come up from the client side to change the web server to IIS. So I have to migrate the scripts and database to Windows based ASP MS SQL. Can any body provide me some details regarding migrating MySQL databases to

HAI SIR

Dear Sir , this is bhanuprakash m from smartifacts , india , ap , hyderabad please can you provide me a solution tomy problem , my problem is , while loding large amount oF data FILE ( more then 16MB ) to LONGBLOB i am getting exception , i am using Mysql with INNODB , please can you provide

Re: MySQL - MS SQL

On Sat, Jun 21, 2003 at 12:42:58PM +0400, Sheni R. Meledath wrote: I have designed a site using PHP MySQL. Recently an urgent requirement has come up from the client side to change the web server to IIS. So I have to migrate the scripts and database to Windows based ASP MS SQL. Unless

RE: Connecting ASP

Can anybody help me? I have a Windows PC, however to test this I'm doing something like this: In Notepad I create a file test.asp Write some ASP code into the file Save the File Upload the file to my remote host that works in Linux Run my ASP script See my script working ok /*So ASP can run in

Re: HAI SIR

Did you set max_allowed_packet variable? If not set it in your configuration file like this: set variable = max_allowed_packet = thesizeyouneedM [EMAIL PROTECTED] wrote: Dear Sir , this is bhanuprakash m from smartifacts , india , ap , hyderabad please can you provide me a solution tomy

Re: MySQL - MS SQL

Hi, MySQL is running fine on Win2000 and IIS, so why change to MS SQL ? Best regards Peter - Original Message - From: Sheni R. Meledath [EMAIL PROTECTED] To: MySQL Masters [EMAIL PROTECTED] Sent: Saturday, June 21, 2003 10:42 AM Subject: MySQL - MS SQL Hi, I have designed a site

Re: Query excution time

If you want a simple solution for windows, check RSSmyperfmon www.rss-software.de/en MTop (MySQL Top) is a really nice little utility: http://mtop.sourceforge.net/ Shows what queries are running, and elapsed time. Daivd - Original Message - From: Prem Soman [EMAIL PROTECTED] To:

Re: ERROR 2013: Lost connection to MySQL server during query on LOAD LOCAL IN FILE

At 03:57 PM 6/20/2003 -0300, Dyego Souza do Carmo wrote: Hi, I wasn't able for to repeat with the last bk tree 4.0 on Linux and Windows. The query was performed from a Linux machine and also from a Windows machine. c:\mysql\binmysql -uroot test --local-infile=1 Welcome to the MySQL monitor.

Re: Query excution time

On Sat, Jun 21, 2003 at 08:02:42AM +0100, Prem Soman wrote: hi ! what is the best way to find query excution time in MySql Ususally, I do the timing in my application(s). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] |

RE: Query excution time

Can you run it from the client and see how long it tells you it takes? -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Saturday, June 21, 2003 10:52 AM To: Prem Soman Cc: mysql groups Subject: Re: Query excution time On Sat, Jun 21, 2003 at 08:02:42AM +0100,

Driver 3.51 Not Found

Hello, I'm new to mySQL. In Windows, after clicking winmysqladmin.exe in Explorer, I get the message - Driver 3.51 Not Found. Any help would be greatly appreciated. Ellen

How can I get the number of entries retrieved by a SELECT - FROM Thanks!

Dell 4500, mem 1g, disk 45g, mhz 2g, Mysql-3.23.54a-linux-i686, PHP-4.30, httpd_2.0.44 Thanks to Paul DuBois, Roger Davis, Helen Sallee, Ronan Chilvers, and Edward Dudlik for thier response to my question. I've included the a (one of many?) snippit of code that I've decided to use as a pattern

why me??!

I'm trying to load a couple tons of data into a shopping cart system and for some reason it keeps kicking back with an error. I'm too dumb to figure out why. Can anyone tell me what's wrong with this code and why it doesn't work? INSERT INTO 'products' VALUES (153328, 2, '181150',

Re: why me??!

Try explicitly stating the columns you're inserting to (IE, INSERT INTO products (quantity, model, image, etc.)), and not inserting a value for the products_id. If it's auto_increment, the DB sets the value for you. Cassidy NETPACQ Systems, Inc. Full Service Web Media 5205 Kearny Villa Way,

RE: Complex SQL involving 10 checkboxes

It comes down to detecting if the value you are adding to your list is a continuation of the list or the first item. You need to set a variable or even a counter at the start of processing then you can use the value of that variable to determine if you are processing the first list item or not.

RE: why me??!

Hi You need nothing or backtics - ` - around the table name - you have quotes INSERT INTO products VALUES (153328, 2, '181150', 'noimage.gif', '154.1000', '2003-06-20 23:03:00', NULL, '-00-00 00:00:00', '0.00', 1, 1, 1, 0); also better to state the field names - if you add or remove a field

Re: Remote access to MySQL

Hi Renato, I think you should check once more the right sfor the user you have. Log in to mysql and do: mysql SHOW GRANS FOR root ; You will get something like this: GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '17cb702624900fa5' Check what it says for the combinaion of username

Re: Advanced how to's

Hi Jeremy, Straight from the top of my had I would think that posting the info everybody would be expecting from such a domain name. F.e consider setting up some how to's for Replication Optimizing Backup/Import/transfer transfers +Version upgrades Raid usage Table Type features / MySQL

Difference between MERGE and MRG_MYISAM tables ?

Hi Mysql fans ;-), I just came across this in the manual http://www.mysql.com/doc/en/CREATE_TABLE.html where it show as table types MERGE and MRG_MYISAM tables. Than I continued onto this page http://localhost/xoops/manuals/mysql/en/MERGE.html Where it says You can only use identical MyISAM

Re: Long turn-around time.... and double sending

Well I have posted 4 replies (5 including this one), but they didnt came up yet in the mailing list. So let s wait and see. Best regards Nils Valentin Tokyo/Japan 2003 6 18 18:23Primaria Falticeni : Yes, in the last day the messages came twice and earlier. Iulian - Original Message

Re: MySQL, Second Edition -- German Translation

Hi Paul, Thank you. When are you posting the rest ? - o.k just joking ;-) Best reards Nils Valentin Tokyo/Japan 2003 6 19 05:46Paul DuBois : A German translation of MySQL, Second Edition is now (or will soon be) available. The translation of Chapter 6 (The MySQL C API) is available for

Re: insert hang problem on Solaris 8

Hi Randy, I am not sure if this is working, but did you try the slow query log ?? Why I am not sure is because I believe the result is logged AFTER the request is complete (which never happens in your case if I understood correctly)? Best regards Nils Valentin Tokyo/Japan 2003 6 18

Re: development cycles at mysql-ab

1) www.mysql.com look at the top left corner 2) - Gamma (widely deployed, no more critical bugs reported by users, thus almost production), - Beta (not so widely deployed, so the server might still contain critical bugs that show up only in certain environments / situations), - Alpha (no bugs

Re: my.cnf and passwords

Hi Chris, I believe you are looking in the wrong place. The my.cnf is used to set startup options for the mysql server or the mysql clients - refering to the client tools that come with the RDBMS. You want to look into /etc/php.ini or the config.inc.php file from phpmyadmin. Best regards

Re: mysql ended error

Somehow the Index of the mysql.user table is crashed. mysql is a database within the MYSQL RDBMS that stores the user accounts, passwords, user rights (privileges). And somehow you managed to mess up the most important table. There are 6 tables within the privilege system (mysql database)

RE: Difference between MERGE and MRG_MYISAM tables ?

I believe this won't work: http://localhost/xoops/manuals/mysql/en/MERGE.html localhost??? put your Ip if you like us to read your work. -Mensaje original- De: Nils Valentin [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 18 de Junio de 2003 12:53 a.m. Para: [EMAIL PROTECTED] Asunto:

Driver 3.51 Not Found 2

I downloaded MyODBC-3.51.06.zip , unzipped it, and there isn't a setup.exe file - only 'setup.c' Should MyODBC-3.51.06.exe be downloaded?

Re: Difference between MERGE and MRG_MYISAM tables ?

At 14:52 +0900 6/18/03, Nils Valentin wrote: Hi Mysql fans ;-), I just came across this in the manual http://www.mysql.com/doc/en/CREATE_TABLE.html where it show as table types MERGE and MRG_MYISAM tables. Than I continued onto this page http://localhost/xoops/manuals/mysql/en/MERGE.html

scaling

I have some general questions regarding a number of things.. I am not looking for what's wrong with my code? type answers, just some friendly advice from anyone who want's to answer. HEre goes: What are the gotchas with respect to scaling? What am I going to wish I didn't do when I start getting

Re: Difference between MERGE and MRG_MYISAM tables ?

Hi Jorge, Paul, MySQL List, I believe Paul gave me a sufficient answer. Thanks Paul. It's a synonym for MERGE. Best regards Nils Valentin Toky/Japan 2003 6 22 06:40Jorge Cornejo : I believe this won't work: http://localhost/xoops/manuals/mysql/en/MERGE.html localhost??? put your Ip if

mysql + mingw

I'm trying to compile the mysql c++ api with mingw When I run configure I get this error what could it be ? loading cache ./config.cache checking whether to enable maintainer-specific portions of Makefiles... no checking for MySQL library directory... configure: error: Didn't find the mysql

add users for single database

I have a user who has permissions for a single database. The user wants to be able to add/delete users for the database. Can this be done? Thanks GNH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query Question - handheldspecs

Hi all, I'm working on a simple site to help me and others determine which handheld/game/phone to buy. Before it had a table like this: Phone,color y/n,wireless y/n, etc... Now it is many tables so that new fields can be added while the site is up without having to change the db structure.

Re: add users for single database

At 19:07 -0700 6/21/03, Mailing List wrote: I have a user who has permissions for a single database. The user wants to be able to add/delete users for the database. Can this be done? Grant this use the GRANT OPTION permission. For example, if this use has control over the abc database, use