about increment backup

Mysql increment backup technique is different from others.When a binlog file be created after enable binlong? thanks!

Re: LIKE problem part II

on 11/18/05 7:18 AM, Peczöli Zoltán at [EMAIL PROTECTED] wrote: > The result of the second query matches that of the corresponding LIKE > query, but the first seems to be correct. > > Any ideas what the problem might be? You are getting strange results. At this point I would suggest dumping the

Re: case insensitive search

on 11/18/05 2:27 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: > but I'm getting case insensitive search?!? it's not the same I enter > afan or Afan or AFAN!?? > > Any ideas? Set the field type to binary, or use your php to compare the result to the entered result. -- --

Re: what function could detect a row locked by other client ?

I know a lot more about DB2, my main database, than MySQL. However, MySQL frequently does the same things in the same ways as DB2. _If_ MySQL behaves the same way as DB2 in this regard - and I do not know if it does - there is no function to determine if a given resource is locked. Instead, th

what function could detect a row locked by other client ?

Hi, I know select .. update could lock selected rows, if the connection not release the lock, others always wait. If I use get_lock() to get a logical lock by key xxxtable+xxxrow , but others may not update other database on the same server . What function could detect a row locked (by select ... u

Re: case insensitive search

[EMAIL PROTECTED] wrote: but I'm getting case insensitive search?!? it's not the same I enter afan or Afan or AFAN!?? Your two statements contradict each other. Either you are getting case insensitive search, meaning that it *is* the same if you enter afan, Afan or AFAN, or you're getting cas

case insensitive search

Hi! I have this code: Search: and this #searching for salesperson if(isset($_POST['SubmitSearch'])) { $SearchSalesperson = mysql_real_escape_string($_POST['SearchSalesperson']); $query = my_query(" SELECT FName, LName FRO

Re: any alias for MySQL cluster question?

On Fri, Nov 18, 2005 at 02:41:30PM -0800, Jenny Chen wrote: > I'd ask some questions on MySQL cluster. Does anyone know if there is any > email alias for the cluster questions? Yes, there is a mailing list for MySQL Cluster: http://lists.mysql.com/cluster Jim Winstead MySQL Inc. -- MySQL Ge

any alias for MySQL cluster question?

Hi, I'd ask some questions on MySQL cluster. Does anyone know if there is any email alias for the cluster questions? Thanks, Jenny

FW: Regarding SET FOREIGN_KEY_CHECKS=0;

Thank you Heikki! We had a problem where code in one of our program's EJB did not turn the FK CHECK back to 1. Another program that was started afterwards caused some bad data to be inserted in the database - as though the FK CHECK was = 0. It wasn't until we turned the FK CHECK back to 1 in the

Re: mysqld crash with archive engine > 2gb

Hello. It is strange for me that there isn't a stack trace. If you can - switch to the debug version of MySQL and run it under gdb to find out where it is crashing. See: http://dev.mysql.com/doc/refman/5.0/en/crashing.html http://dev.mysql.com/doc/refman/5.0/en/debugging-server.html

moving the datadir

Hi, I'm on Solaris 9 with mysql 4.1. I've moved the datadir to a new location, and edited the mysql start script directly so that it now has the line: datadir=/export/www1/data The server restarts no problem, and my phpBB web app can talk to it no problem. However when I try to connect to it us

Re: Runing MySQL on boot

Andrew Kuebler wrote: > I'm running FreeBSD and MySQL version 4.1. How do I get FreeBSD to load > MySQL on boot? I don't see a script file that came with the installation. > > Thank you. > > Andrew > Hi Andrew, You need edit your /etc/rc.conf file and add the following line: mysql_enable="YES"

Re: Mysql 4.1 full table (nearly) - best practice to alter?

sheeri kritzer wrote: Simon, If your tables are too big, you want to archive/delete some information. I certainly cannot guide you on what to delete. What you describe below isn't going to do anything. From the documentation (http://dev.mysql.com/doc/refman/5.0/en/create-table.html): ---

Re: Connection Problem

Michael, you hit the nail on the head. We added --skip-name-resolve and changed our connnection string to use the IP instead of FQDN and now things are working fine. It must have been something with our DNS/ISP since we changed nothing and that stuff is out of our control. The other thing was capt

Re: Connection Problem

Tripp Bishop wrote: Hello all, Suddenly in the last hour or so the connection speed between our webserver and database server has skyrocketed to the point that our site is no longer usable! Just trying to connection via the mysql client takes a long time. Once the connection is established, howe

Re: Mysql 4.1 full table (nearly) - best practice to alter?

Hi, 0. stop the web server or avoid hitting the db ! > 1). Backup everything! :) the mysqldump should suffice. > 2). do the alter The alter does already a create table with new data and then exchance table. You need 2x the storage space though. 3. do the opposite of 0. -- Pooly Webzine Rock

Re: Runing MySQL on boot

Andrew Kuebler wrote: I'm running FreeBSD and MySQL version 4.1. How do I get FreeBSD to load MySQL on boot? I don't see a script file that came with the installation. Thank you. Andrew Place a script called mysql-server.sh in /usr/local/etc/rc.d #!/bin/sh case "$1" in start) /usr/loca

RE: Runing MySQL on boot

If you´ve installed mysql from ports the startup sript is under /usr/local/etc/rc.d/ Change its permissions to be extecutable I hope that this help you Regards! ++ | ISC Edwin Cruz García | | IT Manager | | Tr

Runing MySQL on boot

I'm running FreeBSD and MySQL version 4.1. How do I get FreeBSD to load MySQL on boot? I don't see a script file that came with the installation. Thank you. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PRO

Connection Problem

Hello all, Suddenly in the last hour or so the connection speed between our webserver and database server has skyrocketed to the point that our site is no longer usable! Just trying to connection via the mysql client takes a long time. Once the connection is established, however, queries seem to e

Re: A "key" question

MySQL can use the index on one of the columns in a multi-column index, with caveats. If this is your index, UNIQUE KEY `tidadx` (`price_data_ticker`,`price_data_date`) and you plan to use "price_data_date" in all your queries, but never "price_data_ticker", then simply reverse the order of

RE: A "key" question

Michael, Thank you for your comments. This give me a new ideas how to work with this issues. And, no at this point we are not planning to work with price_data_ticker field itself. Regards, Mikhail Berman -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Friday,

Re: "Function Does Not Exist"

Jesse, >I'm using the following code in my ASP.NET application to add a new record >to the database, and return the added ID: You may have persuaded dotNet that your sproc returns something, ie that it is a function, but you apparently created it as a procedure. An sproc returns nothing. PB

Re: A "key" question

Mikhail Berman wrote: Hi Jeremy, This is still "work in progress" but here are some samples of queries we will be running, that involved this table and this date field: == #this fails -- join on is horrible What do you mean by "fails"? Takes too long

Re: To upgrade, or not to upgrade...

René Fournier wrote: ...that is the question. I have some queries that would possibly benefit from subqueries, which means upgrading my stock Mac OS X Server 10.3.9 installation of MySQL (version 4.1.10a). The question is, and I would appreciate any comments, should I go just to 4.0.26 f

Re: To upgrade, or not to upgrade...

Someone just asked this on the list, and another person answered -- MySQL recommends a 'gradual upgrade' -- http://dev.mysql.com/doc/refman/4.1/en/upgrade.html It all depends on what code is running against your database, etc. Read the upgrade section, it will help you devise a plan to figure out

Re: Mysql 4.1 full table (nearly) - best practice to alter?

Simon, If your tables are too big, you want to archive/delete some information. I certainly cannot guide you on what to delete. What you describe below isn't going to do anything. From the documentation (http://dev.mysql.com/doc/refman/5.0/en/create-table.html): ---

Re: A "key" question

Mikhail Berman wrote: Dear Jeremy, Thank you for your help. I do have an exact situation you have assume I have. Here is the output of SHOW CREATE TABLE CREATE TABLE `TICKER_HISTORY_PRICE_DATA` ( `price_data_ticker` char(8) NOT NULL default '', `price_data_date` date NOT NULL default '00

"Function Does Not Exist"

I'm using the following code in my ASP.NET application to add a new record to the database, and return the added ID: Cmd=New MySqlCommand("sp_InsertNewCamper",Conn) Cmd.CommandType = CommandType.StoredProcedure paramReqID = Cmd.Parameters.Add("return",SqlDbType.Int) paramReqID.Directio

RE: A "key" question

Hi Jeremy, This is still "work in progress" but here are some samples of queries we will be running, that involved this table and this date field: == #this fails -- join on is horrible update COMPANY_NUMBERS left join TICKER_HISTORY_PRICE_DATA on tick

Access to Stored Procedure Solved

I figured out a problem I was having, and just wanted to pass the solution along to anyone who may run into the same problem in the future. I've got a new problem now, but I'll deal with that in a separate message (if necessary). I was getting the error, "#42000SELECT command denied to user [EMAI

Can't switch databases 5.0.15-0 RedHat ES4

Is this something new with mysql 5, a bug, or something I'm missing? I'm not able to switch databases. [EMAIL PROTECTED] 5.0.15-0-es4]# rpm -ivh MySQL-client-standard-5.0.15-0.rhel4.i386.rpm MySQL-devel-standard-5.0.15-0.rhel4.i386.rpm MySQL-server-standard-5.0.15-0.rhel4.i386.rpm [EMAIL PR

Re: A "key" question

Hi Mikhail, Thank you for your help. I do have an exact situation you have assume I have. Here is the output of SHOW CREATE TABLE `price_data_ticker` char(8) NOT NULL default '', `price_data_date` date NOT NULL default '-00-00', ... UNIQUE KEY `tidadx` (`price_data_ticker`,`pric

LIKE problem part II

I tried to investigate my previous problem with statements containing LIKE clause on a specific table. The problem was basically the following: mysql> SELECT count(*) FROM user WHERE username LIKE 'o%'; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (0.00 sec) m

Re: a question of specifying Times for Recovery

Hello. >If "default-character-set" can't set in "[client]"? The comprehensive explanations you will find at: http://bugs.mysql.com/bug.php?id=11673 "wangxu" <[EMAIL PROTECTED]> wrote: >Follow is a part of my my.ini. >--

mysql_fix_privileges

hi, i just inherited a mysql server 4.1 and need to run mysql_fix_privileges on it. However one of the databases hosted on it is production and I'd rather avoid it to be down. I ran the script on an 4.0 server test that I had installed and which was running when I ran the script. I had no pr

RE: MySQL server has gone away

Thank you for your help, Shawn. I had to dig a little, but I found the way to set the global variable to a larger size and was able to complete my restore. I may yet get the hang of this. :-) Joseph "Tito" Kraer Business Systems Analyst Taylor, Bean & Whitaker Mortgage Corp ___

RE: A "key" question

Dear Jeremy, Thank you for your help. I do have an exact situation you have assume I have. Here is the output of SHOW CREATE TABLE +---+--- ---

How to list priviledges

Is there a way to list the privilidges that a user has in MySQL? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to list priviledges

Jesse Castleberry wrote: Is there a way to list the privilidges that a user has in MySQL? Thanks, Jesse Yes. SHOW GRANTS FOR [EMAIL PROTECTED]; Did you even try the manual ? Michael -- MySQL General Mailing List For list archiv

Re: How to list priviledges

Jesse Castleberry wrote: Is there a way to list the privilidges that a user has in MySQL? Thanks, Jesse http://dev.mysql.com/doc/refman/5.0/en/show-grants.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROT

setup permission for stored procedure on mysql 5

If I defined I stored procedure as root I can't be able to call this procedure from a normal user. I tried to grant it the execute method but the sintax seems wrong For example suppose a simple store procedure like this: CREATE PROCEDURE `test_root`() BEGIN declare a int default 0; END if I t

How to list priviledges

Is there a way to list the privilidges that a user has in MySQL? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

termcap functions library... configure: error: No curses/termcap library found

I try to run ./configure --with-ndbcluster --prefix=/STEFAN/mysql-5.1.2-binary --with-partition --with-row-based-replication --with-innodb --without-berkeley-db --enable-thread-safe-client --enable-shared but it fails with checking for termcap functions library... configure: error: No curses/

Multiple Query Execution

Hello, Am I correct in thinking that if there are no dependencies between the multiple statements then the various statements are executed "simultaneously" by separate threads in the server? If so is there any way to turn this behaviour off and just use multiple query execution s

dumping column password from table

Hi. I want to backup one table from a database, where one of the columns saves the passwords. If I use mysqldump I got the value in encrypted format, but I need to backup the table to load the table in mysql 4.1. The original table is a mysql 3.23 database. Iago.

Re: LIMIT in subquery or GROUP_CONCAT

On 17/11/2005, Peter Brodersen wrote: > I would like to select top three from different parts in the same > table, e.g. for the following data set: USE test; DROP TABLE IF EXISTS foo; CREATE TABLE foo ( fid INT NOT NULL, d INT NOT NULL ); INSERT INTO foo VALUES (1, 10), (1, 20),

Re: dynamic fieldname to assign to

Thanks, Roger You pointed me to the right direction. The only part I had to change, was using the SET term once, as below. UPDATE Data INNER JOIN Updates ON ... SET Data.Jan = IF(Updates.Month = 1,Updates.Cell,Data.Jan), Data.Feb = IF(Updates.Month = 2,Updates.Cell,Data.Feb), Data.Mar = IF(Updates

Assigment sign not work on Delphi

Using Delphi to with this query: SELECT TOTAL := PRICE * QTY FROM INV_PRODUCT will caused error "Parameter object is improperly defined. Inconsistent or incomplete information was provided." because Delphi look it as Parameter (a parameter of query in Delphi using ":" at the beginning). Is it