Unknown auto ROLLBACK

Hi all, I found out today that MySQL is adding a 'ROLLBACK' command to each session connecting to it, without explicitly ordering this. This is new since we never had this behavior before. Why is this happening, and how can I revert to the old beahvior (each command sent is carried out and

Compile error on Solaris

Getting the following error trying to build mysql-3.23.52 on a solaris 8 box. g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H

RE: automating import process

On Sun, 29 Sep 2002 [EMAIL PROTECTED] wrote: The script so far is like this: ./mysql -u 'root' -ppassword use import_test1; When it executes, it just waits at the mysql prompt. It does not seem to recognize that I want to input use import_test1; Can anyone help? Sure! You have to

Re: Copying to tmp table

Sender: [EMAIL PROTECTED] Date: Tue, 24 Sep 2002 08:21:20 +0200 From: Lars Heidieker [EMAIL PROTECTED] on solaris it probably a good idea to change the tmp directory from /var/tmp - /tmp I recalled this feature and decided to look into linux for it's

Re: Problem on ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY..

Jungsu, - Original Message - From: Heo, Jungsu [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, September 28, 2002 9:34 AM Subject: Problem on ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY.. Hello. I have a problem on ALTER TABLE ... ADD FOREIGN KEY. I'm using

Re: MySQL as a desktop DB

I don't think Access is crap at all. In fact I think it's a) the best RAD front end going for SQL Server and perhaps for MySQL too. I use Access 2000 and 2002 + MyODBC to create front ends to MySQL databases and the combination works great. In less than one morning I successfully ported the

Runaway mysqld

Hi! We are operating several MySQL servers and most are running just fine even under high load. However we have one site (High traffic PHP based site) where we currently is experiencing problems with some strange lock up that causes MySQL to spawn new threads and have a huge number of

Urgent!!

Hi, I have a certain task to be done, which is a Database Driven website based on MySQL operated on Linux, my Question is: Can I develope such a site using ASP (Active Server Pages)? So, I will avoid spending a lot of time in learning other technology instead of ASP. and also if there is

Optimizing Configuring For Heavy Loads

Greetings Everyone, I am new to this list - I have lurked for awhile and have examined the archives - if I am out of form in my questions please let me know. My situation is this - I have acquired a red hat 7.3 server at a new pop. I am moving our MySQL driven web applications over to this new

Re: Urgent!!

Greetings... I believe that ASP works well with MySQL thru ODBC. As of learning other technologies it really depends what all you require. Still MySQL works best with PERL and PHP. Rgs Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative Front End for MySQL - Original Message

Setting Permission For Column Level Only

Greetings... I want to create a user which will have only Select privileges in two columns a particular table. For that I creates a entry in the User table in MySQL and set it as default with N in all. Also I entered some rows in the Columns_Priv table. Now my question is - Do I have to enter

Retrieving Table Schema

Hello All, Suggestions Feedback Requested: I'm looking for a solution that will not lock a table, yet allow me to retrieve the: field name, field type as integer, field size, and other attributes of each column from a table. The Issue: When requesting the Table Schema from

MySQL a quotas?

Hi, I'm solving problem how to set up quota on MySQL db. I've look for that in mailing lists and docummentation but with no success. Can someone help me with this problem? Thanks -- jiri musil [EMAIL PROTECTED], icq# 125282227

4.0.3 executables problem on SCO 5.0.6

Sorry for the duplicate post - subject missing from initial post. I was finally able to get 3.23.52 successfully compiled and running on SCO 5.0.6 with the help of list members; gcc 2.95.2, FSU pthreads and the SCO assembler with libraries were used for the build. The server and client programs

RE: MySQL as a desktop DB

Hi Arthur, Which version of MySQL / MyODBC are you using? I tried building an app with an Acc2000 frontend and a MySQL backend using MyODBC and kept running into a problem where the record being edited would become 'locked' and wouldn't allow me to update (from memory it was something along the

Re:Re: Problem on ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY..

Hello, Heikki. Thank you very much for your reply!. I Found the problem. If I give FK name explicitly, ALTER TABLE FOREIGN KEY .. dose not works. Example 1 - give FK name explictly # mysql alter table CONS_CHILD ADD constraint foreign key CONS_CHILD_FK - ( A,

ANN: DataDiff 0.1.0.

Please accept my apologies for consuming bandwidth with such a blatant plug. I just released a utility that will compare the rows of corresponding tables in two MySQL databases and return any rows which differ. In addition, it can optionally ignore any DATE/TIME/DATETIME/TIMESTAMP columns in

ANN: DataDiff 0.1.0.

Please accept my apologies for consuming bandwidth with such a blatant plug. I just released a utility that will compare the rows of corresponding tables in two MySQL databases and return any rows which differ. In addition, it can optionally ignore any DATE/TIME/DATETIME/TIMESTAMP columns

Re: Re: Replication

hi Victoria, The Master's server id is 1 while the slave's server id was set to 5. There is no problem for the slave to establish connection to the master. However, the slave complains that error reading packet from server, the reason is misconfigured-master, server id was not set and this

A rookie question

Hello, and apologies for such a novice question... I have a need to find a method to allow a user to update information on members of our organization. The typical number of students' info that needs updated is 50-75. The info to be updated is grade change, and year of Latin change for each

Re: Setting Permission For Column Level Only

On Sunday, September 29, 2002, at 10:17 24h, Insanely Great wrote: Greetings... I want to create a user which will have only Select privileges in two columns a particular table. For that I creates a entry in the User table in MySQL and set it as default with N in all. Also I entered

mysql server won't keep running

Hi, I am attempting to use mysql 3.23.52 on win2000pro. I have installed it and I believe everything went okay for that. At least I did get any errors. When I open services, mysql is set for automatic but it is not started. When I try to start it, I get an error 1067: the process

Re: mysql permanent connections

What are the advantages and disadvantages of permanent connections to mysql (using php mysql_pconnect())? I am developing a site where each users session will have a number of interactions with the database from different web pages. Should I use permanent connections? How can I close a

Re: Japanese Charset

Dawn, I'm going to give in to the temptation to be pedantic. Apologies in advance. Kirk Samuelson wrote: I've read lots of similar posts in the archives at http://lists.mysql.com/. Many suggestions to use a BLOB instead of a text field. But MySQL supports double-byte languages. Why

ÑûÇ뺯

¡îC.KÌåÓýÓéÀÖ»áԱͨѶ¡î ×ð¾´µÄmysql

ÑûÇ뺯

¡îC.KÌåÓýÓéÀÖ»áԱͨѶ¡î ×ð¾´µÄmysql

Re: connecting to mysql via ODBC from asp.net

dear jay fields, pls try this, hope this can help u... dim objconn, objrs set objconn = server.createobject(adodb.connection) set objrs = server.createobject(adodb.recordset) objconn.connectionstring=server=192.168.0.1;driver=MySQL;db=[database_name] ;uid=[user_name];pwd=[user_password]

Re: connecting to mysql via ODBC from asp.net

ops, sorry jay, i forgot this... do you install mysql in your web server? if you install it on your web server, so i think you should install the odbc driver for mysql in your web server... and after that u can use your asp script to make connection to your mysql database have a nice try

Re: Setting Permission For Column Level Only

Thx Well I have one more question What is the exact GRANT SQL statement for giving column level privilege. Whatever text I have read till now allow me to give table level privilege. I am unable to give a column level privilege. I have a db..product with tables prod_user and

Re: Setting Permission For Column Level Only

On Sunday, September 29, 2002, at 09:21 24h, Insanely Great wrote: Thx Well I have one more question What is the exact GRANT SQL statement for giving column level privilege. Whatever text I have read till now allow me to give table level privilege. I am unable to give a

InnoDb Question

I am new to InnoDb and was wondering what steps I would have to do to restore a table. Lets assume I am backing up the data by backing up the tablespaces. Thanks in advance (MySQL, query) - Before posting, please check:

RE: export to .sql to other SQL platforms

I repeat my question to a diferent form : how is possible to export my MySQL data to a diferent SQL form? Makis -Original Message- From: Savaidis [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 1:38 PM To: [EMAIL PROTECTED] Subject: export to .sql to other SQL platforms