[5.1 Vs 5.5 ] ERROR 1045 (28000): Access denied for user 'testuser'@'Serv1.corp.domain.in' (using password: YES)

Hi, I am trying to connect two mysql servers with different versions ( 5.1 5.5 ) . But in Mysql 5.1 i am facing strange issues. Below testuser exists in both Mysql Versions : mysql select host,user,password from mysql.user where user='testuser';

E/R Tool

Hello , Is there a mysql or any other tool that generates a E/R diagram using an existing mysql database. Thank You Vinay

E/R Tool

Hello , Is there a mysql or any other tool that generates a E/R diagram using an existing mysql database. Thank You Vinay

Re: INstalling DBD for mysql--Help needed

created 64 bit objects and I had to use right 64-bit flags for DBD::mysql installation. Thanks for all who helped Vinay - Original Message - From: Jake Peavy [EMAIL PROTECTED] To: MySQL mysql@lists.mysql.com Sent: Friday, March 03, 2006 5:38 PM Subject: Re: INstalling DBD for mysql

INstalling DBD for mysql--Help needed

you, vinay

Enforcing Isolation in MySQL database

by the User2 to different value. How does it affect the database when normal select , update queries are used. What should the application programmer to enforce database concurrency. Thank you, Vinay

Enforcing Isolation in MySQL database

- Original Message - From: Vinay To: mysql@lists.mysql.com Sent: Wednesday, March 01, 2006 5:00 PM Subject: Enforcing Isolation in MySQL database Hello , I suppose the InnoDB tables in Mysql have REPEATABLE-READ as the default isolation. Is the concurrency enforced

ERROR 1060 while creating a view

column name 'accxsk' Thank You, Any help appreciated, Vinay

Pro*c and Oracle,Need help

into.Is there some kind of similar API in Oracle like mysql C API.If pro*c is the only is there a technique or better way to retrieve the row results into a characer array. Any Help Appreciated, Thank You Vinay

Insert performance

I am using mysql5.0 on Hp-UX. IT took about 14 hours to insert 1.7 millin records. How do I make my insert run faster.The table has three foreign key references and the referencing columns are indexed . Is that impacting the insert statement performance. Thanks for the help Vinay

Dump table

Hi, I just like to know what is the best way to dump the databases to flat files as some of the tables on my system are up to 1.4G and the whole database size is over 2.5G . I trying to set up a cron job that will back up the table everyday and my main consern is the size of the tables and the

Re: Dump table

but with lager one this takes too much time and somtimes freezers the server. V!nay Brian Reichert wrote: On Tue, Jun 15, 2004 at 10:14:54AM +0400, Vinay wrote: Hi, I just like to know what is the best way to dump the databases to flat files as some of the tables on my system are up to 1.4G

SQL statement

Is their a way of using insert into newtablename select * from oldtablename where ID=xxx But with an aditional column in newtablename V!nay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem duplicating table

Hi i'm trying to write an sql statement which will make a copy of a table including all its data and indexes. The problem comes with the fact that the table contain over 20 million lines and i'm looking for a code or an sql statement that will duplicate this table including its indexes. i'm using

ODBC crashes

] [ODBC][4509][SQLFreeHandle.c][349] Entry: Handle Type = 3 Input Handle = 0x80673a8 [ODBC][4509][SQLFreeHandle.c][450] Exit:[SQL_SUCCESS] regards -- Vinay Kumar Software Engineer Prologix Software Solutions Pvt

Problem deleteing records

I have a problem with a table that is too big it contains around 35,000,000 lines and each end of month i have to take out about 20,000,000 lines from it so my delete command is : delete from table where column_value** on a column that is indexed. But each time i do that i have mysql that

ODBC, my_SQLPrepare() fails

(SQL_NTS)] here it just stops without any error. thanks in advance. regards Vinay Kumar Software Engineer Prologix Software Solutions Pvt. Ltd. Lucknow-226016.India Ph: +91(522)2721387. Res: 2702453. Fax: +91(522)2722286 E-Mail: [EMAIL PROTECTED] Web: www.prologixsoft.com

Re: Database problem.

try to use the myisamchk to check/repair MyISAM tables Pablo Pragana wrote: I hope you can help me with this: Incorrect information in file: './sarara/searchindex.frm' Error consulta SQL : SHOW KEYS FROM `searchindex` MySQL ha dicho: #1033 - Incorrect information in file:

Re: DATE Manipulation

this could help http://www.mysql.com/doc/en/Date_and_time_functions.html V!nay Chris W wrote: Andy Prasetya wrote: Hello, I'm a newbie in MySQL. I have a table that contains column 'startdate [date]' and 'enddate [date]'. Somehow, I have to execute SQL that search any entry

myISAM to innodb

hi, i have been using mysql-3.23.49a and now i want innodb support for the same version of the database, can any one tell how should i proceed. regards -- Vinay Kumar Software Engineer Prologix Software Solutions Pvt. Ltd. Lucknow-226016.India Ph: +91(522)2721387. Res: 2702453. Fax: +91(522

enable Innodb

installing when i restart mysql service, the mysql-max starts the mysqld from some address where it is not, so where can i give the correct address for mysqld, as i haven't been able to locate any my.cnf file on my system. 3:=does adding a my.cnf file on my part would help. regards Vinay Kumar

Re: strings of variables, php, mysql

a simple way is to do select $form as new_column_name from structure; as the query. thus the return value of you column will be in new_column_name. Vinay joffrey leevy wrote: Would appreciate in anyone can help me. Let's say I do a query in php, eg. $query = select shed from structure

Re: How many records can a single MySql Table Hold.

Apart from my.cnf MySQL also provide you with my-huge.cnf, my-large.cnf, my-medium.cnf and my-small.cnf. Files whih are used for diferrent sizes of datadases. Check them out it can help. if you find the conf you r looking for in one of the cnf file you just have to rename it to my.cnf. Vinay

Database name

Is there an SQL command that i can perform which will return me the name of the Database i'm currently conected to. Thanks for your help. Vinay -- http://www.uptoten.com - The fun place to learn on-line UpToTen Kids : 600 educational games and activities. UpToTen Parents : Practical ideas

mysql select query returns incorrect no of rows

it works perfectly but only sometimes it returns incorrect no of rows. Everything works fine if I restart the mysql service and try again. Please guide me as I m unable to get the cause of this problem. Please help me urgently Thanks Regards, Vinay Mhapankar

MySQL install on OpenBSD 2.9

is at the end of this message, if that's any help. Thanks, Vinay /* start config.log */ This file contains any messages produced by compilers while running configure, to aid debugging if configure makes a mistake. configure:812: checking host system type configure:833: checking target system type