RE: [Warning] Aborted connection...... (Got timeout reading communication packets)

t Rgs, Shafi AHMED Sify - Chennai -Original Message- From: Shafi AHMED [mailto:shafi.ah...@sifycorp.com] Sent: Monday, May 21, 2012 2:04 PM To: 'Suresh Kuna' Cc: 'mysql@lists.mysql.com'; 'shafi...@gmail.com' Subject: RE: [Warning] Aborted co

RE: [Warning] Aborted connection...... (Got timeout reading communication packets)

t Rgs, Shafi AHMED Sify - Chennai -Original Message- From: Suresh Kuna [mailto:sureshkumar...@gmail.com] Sent: Monday, May 21, 2012 1:29 PM To: Shafi AHMED Cc: mysql@lists.mysql.com; shafi...@gmail.com Subject: Re: [Warning] Aborted connection.. (Got timeout reading communic

[Warning] Aborted connection...... (Got timeout reading communication packets)

d seems to be fine. Thanks a ton! Best Rgs, Shafi AHMED Sify - Chennai Get your world in your inbox! Mail, widgets, documents, spreadsheets, organizer and much more with your Sifymail WIYI id! Log on to http://www.sify.com ** DISCLAIMER ** Information contained

error 1041: Out of memory;

ble memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space - SPFC: ERROR: db_connect(master): can't connect from 202.144.65.151 to 202.144.65.185:3306 as spfclogin:spfcpw/cms at : DB Error: connect failed Best Rgs, Shafi

RE: Force drop table

Hi, What is the error associated with pls? Best Rgs, Shafi AHMED -Original Message- From: Suporte Avanutri [mailto:supor...@avanutri.com.br] Sent: Tuesday, January 24, 2012 6:05 PM To: mysql@lists.mysql.com Subject: Force drop table Hello, I need to drop a table

RE: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES

Thanks dear everyone for sharing your views! Let me try the workarounds and keep you posted. Best Rgs, Shafi AHMED _ From: Suresh Kuna [mailto:sureshkumar...@gmail.com] Sent: Saturday, September 24, 2011 8:56 PM To: Prabhat Kumar Cc: Dan Nelson; Shafi AHMED; mysql

mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES

Folks I have a mysql database of 200G size and the backup fails due to the foll. Issue. mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES Can someone assist pls.? Best Rgs, Shafi AHMED

RE: Reg...My Hung MYSQL instance

Great, thank you sir! Appreciate your comprehensive reply Best Rgs, Shafi AHMED -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Thursday, August 25, 2011 1:30 PM To: Shafi AHMED Cc: mysql@lists.mysql.com Subject: Re: Reg...My Hung MYSQL instance

RE: Reg...My Hung MYSQL instance

Thank you everyone who have responded back... The issue is fixed now after increasing the max connections param Shafi M -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Tuesday, August 23, 2011 4:06 PM To: Suresh Kuna Cc: Shafi AHMED; mysql@lists.mysql.com

Reg...My Hung MYSQL instance

Dear, Today suddenly my database went into hung state due to Out of Memory [ Killed process 1330 (mysqld) ]. Please advise me folks.This happens now often Shafi Get your world in your inbox! Mail, widgets, documents, spreadsheets, organizer and much more with your Sifymail WIYI id! Log on

RE: Which is better

I hope the former better. Test with query plan output, though Best Rgs, Shafi AHMED -Original Message- From: Adarsh Sharma [mailto:adarsh.sha...@orkash.com] Sent: Tuesday, August 02, 2011 12:12 PM To: mysql@lists.mysql.com Subject: Which is better Dear all, Just want to know which

Re: error creating table

tried the below syntax. It failed. > > Then I redefined the primary keys in the parent tables to be the exact same > type as the foreign keys in UserRole and it worked. > > So, check the datatype of all your keys and make sure they match. > > On Mon, Nov 30, 2009 at 11:50 AM,

error creating table

ION ON UPDATE NO ACTION, CONSTRAINT `fk_roleid` FOREIGN KEY (`roleid` ) REFERENCES `mydb`.`Roles` (`roleid` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci; -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT

Re: error creating table

KEY (`roleid`, `userid`), >> INDEX `FK1_user` (`userid`), >> CONSTRAINT `fk_userid` FOREIGN KEY (`userid`) REFERENCES `users` >> (`userid`) ON UPDATE CASCADE ON DELETE CASCADE, >> CONSTRAINT `fk_roleid` FOREIGN KEY (`roleid`) REFERENCES `roles` >> (`roleid`) ON UPDATE CA

error creating table

FERENCES `roles` (`roleid`) ON UPDATE CASCADE ON DELETE CASCADE ) COLLATE=utf8_general_ci ENGINE=InnoDB ROW_FORMAT=COMPACT AVG_ROW_LENGTH=0 -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot.com/ "Peace" is the Ultimate thing we want. -- MySQL Gene

linq with mysql

o brackets '[' ? select [t0].[amount], [t0].[acct_num] FROM [Account] AS [t0] -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot.com/ "Peace" is the Ultimate thing we want. -- MySQL General Mailing List For list archives: http://lists.mysql.c

roles table design

e mapping table. -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot.com/ "Peace" is the Ultimate thing we want. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

foreign key cautions

HI, What are the caution should be taken when designing a db regarding foreign key? I have "user" table , from which userid is taken as reference in many tables, is it ok? -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot.com/ "Peace&q

error creating table

utest`.`permission` (`idpermission` ) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE = InnoDB; -- here is the error mssage :Can't create table '.\menutest\role_perm.frm' (errno: 150) -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot

Linq support

Hi, Did latest Mysql .net provider (5.1.4) support Linq? -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and I are "the initiator".

mysql to mysql conversion tool

Hi, I'm looking an application which let me convert one mysql to another db. I need this to port my website from one cms (Vivvo) to another (Drupal). -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and

monitoring utility

Hi, I have a website running on Linux based cluster server. We don't have access to logs, nor we have ssh access. I want monitor mysql server usage of my site for the purpose of optimizing my site scripts. Pls suggest php based application. -- Sharique uddin Ahmed Farooqui (C++/C# Develope

Fwd: Table crashing

7; in * /www/ims/includes/database**.mysqli.inc* on line *151* I don't understand what's wrong with db. -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and me are "the initiator".

Table crashing

7; in * /www/ims/includes/database.mysqli.inc* on line *151* I don't understand what's wrong with db. -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and me are "the initiator".

Re: CSV import

MysqlAdmin? -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and me are "the initiator". On 5/28/07, Geoffroy Cogniaux <[EMAIL PROTECTED]> wrote: Hi, It can be done easily with PhpMyAdmin, but it

CSV import

I want to import data from a CSV file in a table. MySql admin doesn't support import from CSV files. Format of data is different from structure of table. Is there any app/snippet written for this task in .net , which I can modify according to my need. -- Sharique uddin Ahmed Farooqui (

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)

his in drupal forum http://drupal.org/node/140303. What I've done is I have exported data from old db via phpMyAdmin and imported into new database. Since it related to mysql so i'm posting here. -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://www.managefolio.net

PHP/MyphpAdmin/MySql

Dear MySql List experts, I have the following installed on redhat 9: [EMAIL PROTECTED] html]#php -v PHP 4.3.10 (cgi) (built: Mar 8 2005 17:52:13) Copyright (c) 1997-2004 The PHP Group Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies - [EMAIL PROTECTED] html]# rpm

MySql Configuraton on Redhat

Hi, This is the only place where I can ask these questions, and would greatly appreciate if anyone can give me some clue on how to resolve these issues. I have MySql running on Redhat 9, and I am trying to create a New Database. When I issue the command: mysqladmin -u root ver Result: mysqladmi

Login error

Hi, I have MySql running on Redhat 9, and I am trying to create a New Database. When I issue the command: mysqladmin -u root ver Result: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' Command: [EMAIL PROTECTED] home]

Transfer data from mySql to access

Hi, How do I transfer mySql Database (e.g Test Case Manager ) to MS Access ( Test Director) The Table names are different for the two DB's , but the content is similar Let say I have a Table CASE in Test Case Manager having 10 columns , and want to transfer indivisual columns to an access DB ( T

RE: TOP

--- ---- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 28, 2004 2:44 PM To: Kamal Ahmed Cc: [EMAIL PROTECTED] Subject: Re: TOP

TOP

Hi, Does anyone know how to do a TOP function in MySQL ? Thanks, -Kamal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Installation of mysql-3.23.58 on Redhat 9

#/usr/local/mysql/bin/mysqld_safe -user=mysql & #/usr/local/mysql/bin/mysqladmin -u root password new_password Kamal Ahmed Sr. Test Engineer e-Security, Inc. Enterprise Security Management 1921 Gallows Road, Suite 700 Vienna, VA 22182 phone: 703-852-8055 fax: 703-852-8010

error compiling

files please help Syed Nadeem Ahmed

View all temporary tables in a database

HI, I create temporary tables using the query CREATE TEMPORARY TABLE .. How do i list all the temporary tables in the database "SHOW TABLES STATUS " does not show the temporary tables. Thanks Anis - Before posting,

How to view all the temporary tables ?

Hi, I am able to create temporary tables in MYSQL,using CREATE TEMPORARY TABLE I am using JDBC for this. Just like "show tables" will give all the table names in that databases, is there any query to view all current Temporary table names? Rgds Anis ---

Temporary tables/ view in MySQL

Hi. Are temporary tabels or views supported in MySQL? Some info required please Thanks Anis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archi

MySQL Limits....streched !

Hi, I need to set a variable limit on the MySQL file size (Average row length * no of rows ) When we insert data in to the table using JDBC .i should get a unique JDBC exception (so that i trigger an archive). Is this posible in MySQL? I notice that during creation of table i can give such op

Re: Rights required to archive a table

Yes you can. Try this query grant file on database.* to user@'. also remember grant file on database.table to user@'. does not work Anis >>> "Lakshminarayna U" <[EMAIL PROTECTED]> Friday, March 07, 2003 5:00:30 PM >>> Hi, I want to archive and restore a table in MySQL using

MySQL Rights query

HI, I need to create a new user who can can run these two queries 1. SELECT ... INTO OUTFILE 2 LOAD DATA INFILE. I create a user with this query, GRANT USAGE, SELECT, FILE ON database.table to [EMAIL PROTECTED] It gives error running this query...it says illegal Grant/comman check the manual.

maximum column width

What is the maximum column width allowed in MySQL. 255 or 256? Anis >>> Floyd Wellershaus <[EMAIL PROTECTED]> Tuesday, March 04, 2003 6:24:50 PM >>> Hello, I am trying to start replication between 2 linux servers mysql version is 4.0.8. I am following all instructions, but I keep getting the fo

problem connecting to mysqld

I am having problems using MYSQL on Windows ME operating system. It installs fine with no problems, but at the point where I try to connect to mysqld i get the error of bad command or file name at the dos propmt. therefore when I try to create a database I keep getting "Error-2003: Can't connect

Archive on remote Machine .

Any other opton.? >>> Victoria Reznichenko <[EMAIL PROTECTED]> Tuesday, February 18, 2003 7:15:01 PM >>> On Tuesday 18 February 2003 12:51, Ahmed S K Anis wrote: > I use Select * into outfile "filepath" from table to archive the > database. > Is t

Archive on remote Machine.

Hi, I use Select * into outfile "filepath" from table to archive the database. Is there any way to archive this into a different machine. (Not current machine) Yes Mapping to new machine and then giving path is an option. Any other opton.? Anis -

Re: JDBC and LOAD DATA LOCAL INFILE :

HI, Thanks all for the suggestions given for load data... It indeed helped me a lot. Right now i am using J/connector version 3 . Load data local works fine with version 3. I hit a new problem. It works fine when there are below 2 records in the file. When i tried wiht 4,00,000

Re: JDBC and LOAD DATA LOCAL INFILE :

r why ? Like to add here that Select * into outfile works perfect from JDBC wiht same filepath >>> Mark Matthews <[EMAIL PROTECTED]> Wednesday, February 12, 2003 7:49:42 PM >>> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed S K Anis wrote: > Thanks Mark, >

Re: JDBC and LOAD DATA LOCAL INFILE :

Thanks Mark, I tried to work with the latest driver. 3.0.4 Now it gave error shown below . Also see code snippet below at the end Error code is0 estoredata1.txt'for 'LOAD DATA LOCAL INFILE' command.Due to underlying IOExcepti on: ** BEGIN NESTED EXCEPTION ** java.io.FileNotFoundException esto

Re: JDBC and LOAD DATA LOCAL INFILE : The used command is notallowed with this MySQL version

Hi all, please let me now if there is a solution to this. I am facing the same problem. Anis >>> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Wednesday, February 12, >2003 3:48:16 PM >>> Hello, I'm using this command into a Java servlet LOAD DATA LOCAL INFILE \"" + FIC_DB + "\" REPLACE INT

Re: [mysql] Counting rows

show table status: check out the columns names you will get as idea as to how info it gives. >>> olinux <[EMAIL PROTECTED]> Wednesday, February 12, 2003 12:21:16 PM >>> SELECT count(*) FROM table WHERE whatever olinux --- Tim Johnson <[EMAIL PROTECTED]> wrote: > Hello All: > Let's sup

Testing thr list

>>> Francesco Leonetti <[EMAIL PROTECTED]> Sunday, February 09, 2003 5:43:45 AM >>> Dear list, I've been searching the archives before posting this request since it is about something you've already discussed. But I didn't find the solution, so here it comes my question. It is about RAM consu

MM driver / connector support for DB Acrhive

HI, I would like to know if MM driver / Connector J for MySQL gives any facility to archive a database. Not sure if JDBC covers this. I have seen the mysqldump/ mysqlexport options but, i need to invoke the Archive and Restore from a Java program. Any bright ideas or solutions to this ? Regards

MM driver / connector support for DB Acrhive

HI, I would like to know if MM driver / Connector J for MySQL gives any facility to archive a database. Not sure if JDBC covers this. I have seen the mysqldump/ mysqlexport options but, i need to invoke the Archive and Restore from a Java program. Any bright ideas or solutions to this ? Regards

Archive and retrieval in MySQL

HI, I have a few questions related to DB archving / restore capability of MySQL. Most of them are design issues but have a lot to do with what MySQL provides. PLease share your view on them. 1. How can i trigger a database archive when a certain data base limit is reached in a table. Ex: when 1,

Re: subselects

Thanks Greg for the hint but I also wanted to know when is MySQL version 4.1 to be expected to show up in binaries ? Ahmed - Original Message - From: <[EMAIL PROTECTED]> To: "Ahmed Farouk" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 0

subselects

enable our company to transfer many applications from Oracle to MySQL and I think the same holds for many people out there so we are really eager to see it working. Thanks Ahmed Farouk - Before posting, please check: http

Re: Complex Query

try this: > select a.name, b.invitation_status, count(*) from stations a, invitations b > where a.id = b.station_id group by a.name, b.invitation_status > - Original Message - > From: "Ahmed Farouk" <[EMAIL PROTECTED]> > Date: Fri, 29 Nov 2002 22:50:34 +0200 >

Complex Query

se to get the previous output, and if I can't get these results with a direct query how would I manage to generate this report. Thanks Ahmed - Before posting, please check: http://www.mysql.com/manual.php (the manua

MySql on Non english locales.

Hi, I am using MySql 3.22 on a server with code page set to Japanese. I am using MM JDBC driver. I insert english and Japanese data into a few tables, when i query for the data from MySql i get junk characters in place where Japanese charaters need to appear. How can i enable MySql for Non engl

Re: ACCESS to MySQL

just connect to Access using the odbc driver, then pull data from Access and through it into MySQL, that's it :) Ahmed - Original Message - From: "César Aracena" <[EMAIL PROTECTED]> To: "'MySQL General'" <[EMAIL PROTECTED]> Sent: Wedne

Problem with MM MySql driver on Solaris

I am currently using MySql. I am using the mm.mysql-2.0.4-bin.jar downloaded from mysql site as the DB driver on SOLARIS. Java version being used is Java 1.2.1 I Tested using Test programs and i found everything to be fine. Our application creates JVM in its address space and loads Java programs.

Case sensitivity in Mysql

Hi, I run mysql on windows as well as linux. table creation and access right are given by java program. Problem im facing is., i create a table with name TEMP in windows in creates table with name "temp" and linux "TEMP" while giving rights thru GRANTstatement , it fails in windows cause it exp

Mysql on Windows accessed client on Solaris--gives problem

hi, Mysql is installed on Windows 95. Client program runs on solarisConnection to DB fails I used the mm driver for mysql. see stack trace. please help!! *** panic: symbol "ioctl" undefinedSIGABRT 6* abort (generated by abort(3) routine)si_signo [6]: SIGABRT 6* abort (genera

RE: Mysql/Solaris: can't run configure or mysql_install_db

Hi, I too am stuck with mysql installaiton on solaris. Please let me know if you can help me out. I prefer downlaoding the binary and installing ot..rather then getting the src and building. thanks Anis >>> "Chuck Roberts" <[EMAIL PROTECTED]> 03/11/02 07:47PM >>> > -Original Message-

MySql in Linux, Unable to connect from windows

Hi, i am using the standard Mysql installation on Redhat Linux. I am trying to run a simple JDBC test pgm from windows machine and connect to DB on linux. I am not getting any error , but its hanging at this statment . statement is Connection connection = DriverManager.getConnection("jdbc:mysq

MySQL installation On solaris.

hi, I am resending this query. Anyone who has information on installing the MySQL binaries on solaris please help me with some information. The product doc doesnt seem to help. I am NOT too keen on building MYSQL by down loading the source code. Any help on installation of binaires? Thanx Anis

MySql on Solaris

Hi members, This is my first query :) My query is about installing MySql on Solaris. I am interested in downloading and installing the stable version of MySql on solaris 2.6. I downloaded mysql-3.22.25-solaris7-x86.pkg.tgz and MySQL 3.23. I tried to install the first one (used GNU tar) . I foll

is this a mysql Bug ?

is this a mysql Bug ? curdate()-3 returns 20020299 curdate()-2 returns 20020300 Keep smiling, ;^) ~Jamil * mysql> select curdate(); ++ | curdate() | ++ | 2002-03-02 | ++ 1 row in set (0.00 sec) mysql>

mysql c api

hi all i hope that some one send me a programme illustrating how to access to mysql database with c api .. ahmed Portail mobile DIALY! visitez www.dialy.net DIALY! mobile portal visit www.dialy.net

C API mysql client

please can you give me a cooorect programme source using C APIs mysql to acces mysql database ahmed Portail mobile DIALY! visitez www.dialy.net DIALY! mobile portal visit www.dialy.net

Sysdate????Date????Please help

Hiya Everyone, I have a small problem,I am a java programmer working for a small company, We have just been given project to build a greetings program for a website,thats no problem but one of the parameters is an option to send the greeting at a later date,not today. I have kinda worked out

MYSQL to Oracle

Can anybody tell me what datatype exists in Oracle that is similar or could be used instead of BIGINT and TIMESTAMP. Also, what does the LIMIT # expression do in the select query. Can this be converted to be used in Oracle somehow? Thanks Totalise - the Users ISP -- To beco

ISM,FRM Problem plese help if possible

Q:--have you heard about that guy who finally discovered what a woman is all about A:sadly,he died laughing before he could tell anybody (And one for the ladies) Q:---Why was moses wandering around in the desert for 40 years? A:---Coz even then men couldnt take directions!!! Hi Ever

HELP "Server configuration denies access to data source"

Hi Everyone, I am in a very very desperate state 'coz my whole site is down and if I cannot connect to the database through my servlet my @ss is grass. Everything seems to be working fine except when I execute the servlet I get this frustrating error: " Server configuration denies access to dat