Re: problems with relationships created by mysql

oops..sorryproblem seems to be with base...so i meant to post it in base mailing list On Mon, May 13, 2013 at 9:37 AM, rounak jain wrote: > I have connected MySql to Base. I created some relationships in MySql. > They are properly visible in the Relationships chart in Base. See image. > htt

RE: problems with INNODB tables

> > Sent: Monday, April 23, 2012 9:00 AM > > To: Malka Cymbalista > > Cc: mysql@lists.mysql.com; Shlomit Afgin; Ronen Hayun > > Subject: Re: problems with INNODB tables > > > > Weird, I use a lot Innodb, and no issue, I even kill bravely the > mysql > >

Re: problems with INNODB tables

] > Sent: Monday, April 23, 2012 9:42 PM > To: Andrés Tello; Malka Cymbalista > Cc: mysql@lists.mysql.com; Shlomit Afgin; Ronen Hayun > Subject: RE: problems with INNODB tables > > Check your memory usage according to > http://mysql.rjweb.org/doc.php/memory > > > -Original

RE: problems with INNODB tables

...@weizmann.ac.il 08-9343036 -Original Message- From: Rick James [mailto:rja...@yahoo-inc.com] Sent: Monday, April 23, 2012 9:42 PM To: Andrés Tello; Malka Cymbalista Cc: mysql@lists.mysql.com; Shlomit Afgin; Ronen Hayun Subject: RE: problems with INNODB tables Check your memory usage

RE: problems with INNODB tables

Check your memory usage according to http://mysql.rjweb.org/doc.php/memory > -Original Message- > From: Andrés Tello [mailto:mr.crip...@gmail.com] > Sent: Monday, April 23, 2012 9:00 AM > To: Malka Cymbalista > Cc: mysql@lists.mysql.com; Shlomit Afgin; Ronen Hayun > Sub

Re: problems with INNODB tables

Weird, I use a lot Innodb, and no issue, I even kill bravely the mysql process with pkill -9 -f mysql Y suppose the way drupal is being programed. PHP open and closes database connections each time a webpage with db access is issued. When a php exceution ends and the apache webserver have fullfill

Re: Problems Connecting with SSL

Hi! Martin Gainty wrote: > [[...]] > > joerg ..any thoughts on this matter?? Sorry - none. I never dealt with the inner workings of the SSL library. Just seeing file descriptor 2 (standard error) used for socket operations makes me assume *very* strongly that something went wrong well before t

Re: Problems Connecting with SSL

> perhaps a misconfiguration on the failing client .. > can you go to successful client, enable DEBUG level > debugging and log the connection and then go to the > failing client..enable DEBUG level debugging and log > the connection to the failing client this would determine > deltas between the

Re: Problems Connecting with SSL

> Interesting that you can request advice from finland vs > calling from redwood shores CA for technical advice > > first take a look at: > http://dev.mysql.com/doc/refman/5.0/en/secure-basics.html > > once you've determined the algorithm you will want to implement > take a look at SSL 1,2,3 a

Re: Problems Connecting with SSL

> Sorry, but I have to start with a negative remark: > Why, oh why, don't you mention the version number you > are using? I hope it is some roughly current 5.1, but > I'd rather like you to tell it. Doh! Right you are! Sorry, that was totally my bad. mysql> select version(); ++ | ve

Re: Problems Connecting with SSL

Hi Tim, all! Sorry, but I have to start with a negative remark: Why, oh why, don't you mention the version number you are using? I hope it is some roughly current 5.1, but I'd rather like you to tell it. Tim Gustafson wrote: > I have three mySQL server, all of which are SSL-enable and all of w

Re: Problems posting to the list lists.mysql.com

Is the MySQL mailing list admin subscribed to the list? I have also sent a message or more telling about this issue, with no response. -- Octavian "mos" wrote in message news:6.0.0.22.2.20100215120015.02cd4...@mail.messagingengine.com... > At 10:51 AM 2/15/2010, Frank Becker wrote: >>Hello, >>

Re: Problems posting to the list lists.mysql.com

At 10:51 AM 2/15/2010, Frank Becker wrote: Hello, I tried to response to a posting on the list named in the subject. But it is rejected with the following message: SMTP error from remote mail server after end of data: host lists.mysql.com [213.136.52.31]: 552 spam score exceeded thresho

Re: Problems with slave_skip_errors on replication

Ok, Suresh. . .I started MySQL with slave_skip_errors = all and It solve the problem! Thanks. WB 2010/1/25 Suresh Kuna > Hi Wagner, > > You have to start the server with the option as below for skipping the > error. > > --slave-skip-errorr= 1062 or all > > 1062 - will skip the your error as the

Re: Problems with slave_skip_errors on replication

Hi Wagner, You have to start the server with the option as below for skipping the error. --slave-skip-errorr= 1062 or all 1062 - will skip the your error as the error number is 1062 and all will skip all the errors. You have to mention specific error numbers to skip the same. -- Thanks Sure

Re: Problems with auto_increment updating when (i think) it shouldn't

Hmm, that makes sense. I should have thought of that. Thanks! On Fri, Aug 7, 2009 at 12:32 PM, Johnny Withers wrote: > It will also update the auto_increment column when you ROLLBACK a failed > insert: > > mysql> USE test; > Database changed > mysql> SELECT * FROM t1\G > Empty set (0.00 sec) > m

Re: Problems with auto_increment updating when (i think) it shouldn't

It will also update the auto_increment column when you ROLLBACK a failed insert: mysql> USE test; Database changed mysql> SELECT * FROM t1\G Empty set (0.00 sec) mysql> DROP TABLE t1; Query OK, 0 rows affected (0.06 sec) mysql> mysql> CREATE TABLE t1( -> id INT UNSIGNED NOT NULL AUTO_INCREMENT

Re: Problems After MySql 5.1.34 - THANKS

mysql@lists.mysql.com Subject: RE: Problems After MySql 5.1.34 Gary wrote: Welcome to the hell that is php + apache + mysql. If you upgrade your MySql (especially major versions 5.0 => 5.1) you will also need to recompile php against the new MySql client libs. We've had very limited success tryin

RE: Problems After MySql 5.1.34

You are right. I misspoke regarding mysql -> php -> apache hell. It happens anytime an interface changes. From: Mark [ad...@asarian-host.net] Sent: Thursday, May 07, 2009 5:57 AM To: mysql@lists.mysql.com Subject: RE: Problems After MySql 5.1.34

RE: Problems After MySql 5.1.34

From: joerg.bru...@sun.com [joerg.bru...@sun.com] Sent: Thursday, May 07, 2009 2:40 AM To: Gary Smith Cc: mysql@lists.mysql.com Subject: Re: Problems After MySql 5.1.34 Hi Gary, all, Gary Smith wrote: > Johnny, > > Welcome to the hell that is php + apache + mysql. If you upgrade your MySql

RE: Problems After MySql 5.1.34

.@hotmail.com] Sent: donderdag 7 mei 2009 15:15 To: ad...@asarian-host.net; mysql@lists.mysql.com Subject: RE: Problems After MySql 5.1.34 Gary this isnt mysql's fault that php has such abysmal build tools..try requesting a web developer to simply download php and run the proprietary binary tools

RE: Problems After MySql 5.1.34

Gary wrote: > Welcome to the hell that is php + apache + mysql. If you upgrade your > MySql (especially major versions 5.0 => 5.1) you will also need to > recompile php against the new MySql client libs. We've had very > limited success trying to get it to work otherwise. Well, you don't actually

Re: Problems After MySql 5.1.34

Hi Gary, all, Gary Smith wrote: > Johnny, > > Welcome to the hell that is php + apache + mysql. If you upgrade your MySql > (especially major versions 5.0 => 5.1) you will also need to recompile php > against the new MySql client libs. We've had very limited success trying to > get it to w

Re: Problems After MySql 5.1.34

Hi Johnny, all! Johnny Stork wrote: > Typo, moved from 5.0.67 to 5.1.34 Ok, that helps - I checked the contents. > > Johnny Stork wrote: >> I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from >> 5.64. Access to the db seesm fine from the shell, phpmyadmin or even >> the Trixbox

Re: Problems After MySql 5.1.34

se, please do as I would like to be wrong here > as it would make my compiling life easier every time I update MySql on all of > my boxes. > > Gary > > > From: Johnny Stork [li...@openenterprise.ca] > Sent: Wednesday, May 06, 2009

RE: Problems After MySql 5.1.34

s. Gary From: Johnny Stork [li...@openenterprise.ca] Sent: Wednesday, May 06, 2009 1:03 PM Cc: mysql@lists.mysql.com Subject: Re: Problems After MySql 5.1.34 Typo, moved from 5.0.67 to 5.1.34 Johnny Stork wrote: > I recently upgraded an asterisk/trixbox server to mysql 5.1.34

Re: Problems After MySql 5.1.34

Typo, moved from 5.0.67 to 5.1.34 Johnny Stork wrote: I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from 5.64. Access to the db seesm fine from the shell, phpmyadmin or even the Trixbox/FreePBX tool, but trying to apply Trixbox changes, or running a "pear update" produces the

Re: problems w/ Replication over the Internet

Hmmm... no more ideas or suggestions anybody? :( -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: problems w/ Replication over the Internet

Eric Bergen schrieb: > TCP checksums aren't as strong as encryption. It's rare but corruption > can happen. > But it happens every other day? that means at least one error in 4GB of data (I have around 2GB of binlogs/day)? Every DVD-ISO you download would be corrupt (statistically)? > Where are

Re: problems w/ Replication over the Internet

TCP checksums aren't as strong as encryption. It's rare but corruption can happen. Where are you reading the positions from and how are you taking the snapshot to restore the slave? On Mon, Apr 21, 2008 at 12:30 AM, Jan Kirchhoff <[EMAIL PROTECTED]> wrote: > Eric Bergen schrieb: > > > Hi Jan, >

Re: problems w/ Replication over the Internet

Eric Bergen schrieb: > Hi Jan, > > You have two separate issues here. First the issue with the link > between the external slave and the master. Running mysql through > something like stunnel may help with the connection and data loss > issues. > I wonder how any corruption could happen on a TCP

Re: problems w/ Replication over the Internet

Hi Jan, You have two separate issues here. First the issue with the link between the external slave and the master. Running mysql through something like stunnel may help with the connection and data loss issues. The second problem is that your slave is corrupt. Duplicate key errors are sometimes

Re: Problems with unauthenticated user and DB slowing down

2008/3/28 Aleksandar Skodric <[EMAIL PROTECTED]>: > Hi all, > > I am having problems with the following issue. > > Since couple of days ago, we got signs from our customers that website > 'feels' very slow. > One of our tests is IQ test. For this one, timing is crucial and it is > unacceptable

RE: Problems with timestamp and leap seconds?

On Tue, 4 Mar 2008, Jay Blanchard <[EMAIL PROTECTED]> wrote: It was much too quick a reply on my part but it is my understanding that a TIMESTAMP field is updated according to server time and you cannot actually insert a value. I may be wrong as I have never tested this. Even in pre-4.1 version

RE: Problems with timestamp and leap seconds?

[snip] > The column type needs to be DATETIME. Thank you for pointing me at TIMESTAMP versus DATETIME. I'll read thoroughly when I can. Can you give a little more detail as to why DATETIME is necessary? [/snip] It was much too qu

RE: Problems with timestamp and leap seconds?

On Tue, 4 Mar 2008, Jay Blanchard <[EMAIL PROTECTED]> wrote: [snip] I had a bit of BFOTO and tried simple inserts. mysql> create table t (f timestamp); Query OK, 0 rows affected (0.00 sec) mysql> insert into t values ('2008-03-04 16:17:00'); Query OK, 1 row affected (0.00 sec)

RE: Problems with timestamp and leap seconds?

[snip] I had a bit of BFOTO and tried simple inserts. mysql> create table t (f timestamp); Query OK, 0 rows affected (0.00 sec) mysql> insert into t values ('2008-03-04 16:17:00'); Query OK, 1 row affected (0.00 sec) mysql> select * from t; +-+

Re: Problems with timestamp and leap seconds?

I had a bit of BFOTO and tried simple inserts. mysql> create table t (f timestamp); Query OK, 0 rows affected (0.00 sec) mysql> insert into t values ('2008-03-04 16:17:00'); Query OK, 1 row affected (0.00 sec) mysql> select * from t; +-+ | f

Re: problems with mysql 4.1+suse 10

mario henriquez wrote: > hi, i got a problemas in mysql with suse 10 enterprise server, the error: > > #1064 - You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use near '' > at line 1. > > when i treat to create a new d

Re: Problems Adding User

Thank you! That was it! Victor On Dec 20, 2007 9:20 PM, Moon's Father <[EMAIL PROTECTED]> wrote: > You forgot to enter the command flush privileges after your creating user. > The try on my mathine is as follows: > mysql> create user 'mail_list'@'localhost' identified by '1234656'; > Query OK, 0

Re: Problems Adding User

You're right and I should have thought that through. This is a new build on a new server with an imported dump, and of course that data was conserved. However, why doesn't it let me connect to the databases? I've entered as the root user, and granted the priviledges, as in my previous email, and th

RE: Problems Adding User

My guess: The user could already be there. Is this a fresh DB, can you check the server logs for more info? Regards, Amit Sharma E: [EMAIL PROTECTED] M: +91 9971 490 700 W: www.affle.co.uk > -Original Message- > From: Victor Subervi [mailto:[EMAIL PROTECTED] > Sent: 20 December 2007 22

Re: Problems with create procedure

Marc ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) It has to do with whether the fnc is deterministic and how its results m

Re: problems with replication when db is changed

Bgs a écrit : > > Greetings, > > We have regular problems with mysql replication when there is a db > change. This is mostly ALTER TABLE. The sync breaks and we either have > to do the changes manually or either shut down the whole system for a > new sync from zero. Is there a way to sync alter

Re: Problems with Spam on MySQL guest book

On 3/9/07, Gloria McMillan <[EMAIL PROTECTED]> wrote: Dear MySQL general list members, I have a guest book on a small club web page that has been getting regular spam in with the legitimate replies. I use MySQL and (I think) Apache-style PHP to run the database. I know it is PHP and am certain

Re: Problems w/ Grant Tables

Problem solved: /usr/local/bin/mysql_fix_privilege_tables2 Drew Jenkins <[EMAIL PROTECTED]> wrote: Hi; I rebuilt mysql and injected the database which had user "mysqluser" and a root user. Both got wiped out. It looks like the data is intact other than that. Look at this: mysql> CREATE USER dev

Re: problems with a select

I'm spanish speaker too .. but I write it in english for everyone can read it. The version 5 implements subqueries. You can do something like: SELECT id_room FROM rooms WHERE id_room NOT IN (SELECT id_room FROM reservations WHERE date = '22-03-07'); Regards, RAUL DUQUE Bogotá, Colombia ---

Re: Problems with INSERT

Haig Dedeyan (Home) wrote: Hi everyone, I'm a dbase rookie and I've ran into a small problem. I created a basic faq table and all is fine regarding displaying & searching the Q & A's on a web page. Up until now, I;ve entered all Q & A's from phpMyAdmin. I'm trying to create an admin page to

Re: Problems with INSERT

[EMAIL PROTECTED] wrote: > I keep getting the following error: > > You have an error in your SQL syntax; check the manual that corresponds > to your MySQL server version for the right syntax to use near 's > resources than dual monitor mode to generate the video output. Running > in dual' at l

Re: Problems with INSERT

> I keep getting the following error: > > You have an error in your SQL syntax; check the manual that corresponds > to your MySQL server version for the right syntax to use near 's > resources than dual monitor mode to generate the video output. Running > in dual' at line 2 > > when I try to add

RE: Problems with INSERT

[snip] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's resources than dual monitor mode to generate the video output. Running in dual' at line 2 when I try to add: Note : Single-monitor mode uses more of y

Re: Problems inserting chinese characters

Hi Barbara, The hex value '3F' represents the question mark, which means your server CAN'T convert the characters correctly from your client. Regards, "Barbara Deaton" <[EMAIL PROTECTED]> wrote on 2006-11-28 11:16:09: > All, > > I have an application in which I am trying to insert some > tra

RE: Problems Updating Database

, 2006 9:15 AM To: mysql@lists.mysql.com Subject: Re: Problems Updating Database At 08:22 AM 9/6/2006, Nicholas Vettese wrote: >I have a registration script that inserts data into the database, and >then emails you an activation code to activate your account. The >problem is that when I

Re: Problems Updating Database

At 08:22 AM 9/6/2006, Nicholas Vettese wrote: I have a registration script that inserts data into the database, and then emails you an activation code to activate your account. The problem is that when I click on the link in the email, the account does not get updated. The portion of the scrip

Re: Problems Updating Database

I can see something that can be the problem, in mysql 3 you don´t have trigger, then you cannot use trigger_error function, try to use mysql_error instead. ""Nicholas Vettese"" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] I have a registration script that inserts data into t

Re: Problems Updating Database

Which error do you get in activation page? ""Nicholas Vettese"" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] I have a registration script that inserts data into the database, and then emails you an activation code to activate your account. The problem is that when I click on t

Re: problems with sql-mysql mode of emacs on Windows

Jieqi Wang wrote: I am using WinXP, GNU Emacs 23, MySQL 5. When I start a mysql process with `sql-mysql' in emacs, no output is displayed in the buffer until I quit or kill the process. After I add the following line into the initialization file of emacs, (setq sql-mysql-options '("-C" "-

Re: Problems connecting using "-h hostname" with new installation

On 8/6/06, Ro BGCT <[EMAIL PROTECTED]> wrote: Hello, I installed MySQL on a remote server and am having a problem. I am connected to it via SSH and I can do "mysql -u root -h localhost" just fine and connect. However, when I try to connect via "mysql -u root -h web1.server.com", I get the foll

Re: Problems connecting using "-h hostname" with new installation

On 8/6/06, Ro BGCT <[EMAIL PROTECTED]> wrote: Hello, I installed MySQL on a remote server and am having a problem. I am connected to it via SSH and I can do "mysql -u root -h localhost" just fine and connect. However, when I try to connect via "mysql -u root -h web1.server.com", I get the foll

Re: Problems with WHERE clause

Jørn Dahl-Stamnes wrote: > I got the following query: > > select s.id,s.name,sum(p.fee) as fee from serie as s inner join race_serie as > rs on (rs.serie_id=s.id) inner join races as r on (r.id=rs.race_id) inner > join participants as p on (p.race_id=r.id) where s.receipt=1 and > p.rider_id=236 an

Re: Problems with WHERE clause

Do the right thing(TM) and don't use an alias that is the same as a field that exists (this was mentioned before by someone else). Since there is a field in your join named "fee", using "fee" as an alias, is bound to cause your trouble. Also, trying to call sum(p.fee) twice is a waste of cputime.

Re: Problems with WHERE clause

On Sunday 30 July 2006 12:37, Gabriel PREDA wrote: > You must specify explicitly what 'fee' to use... so if you wand every > p.fee to be greater than zero then you must do: > > SELECT s.id, s.name, SUM(p.fee) AS fee > FROM serie AS s > INNER JOIN race_serie AS rs ON rs.serie_id = s.id >

Re: Problems with WHERE clause

You must specify explicitly what 'fee' to use... so if you wand every p.fee to be greater than zero then you must do: SELECT s.id, s.name, SUM(p.fee) AS fee FROM serie AS s INNER JOIN race_serie AS rs ON rs.serie_id = s.id INNER JOIN races AS r ON r.id = rs.race_id INNER JOIN particip

Re: Problems with WHERE clause

Hello Jørn Dahl-Stamnes, The column 'fee' is existing in more than one table . To overcome this problem use the correct instance name of the table for the column "fee" In WHERE clause select s.id, s.name, sum(p.fee) as fee from serie as s inner join race_serie as rs on (rs

Re: Problems with WHERE clause

At 11:10 +0200 30/7/06, Jørn Dahl-Stamnes wrote: select s.id,s.name,sum(p.fee) as fee from serie as s inner join race_serie as rs on (rs.serie_id=s.id) inner join races as r on (r.id=rs.race_id) inner join participants as p on (p.race_id=r.id) where s.receipt=1 and p.rider_id=236 and fee > 0 grou

Re: Problems with synchronisation master -> slave

Hi Thomas I try to configure replication from master to one slave for a database with various table types (InnoDB, MyISAM) without stopping the master. Therefore I make a mysqldump on the slave from master with this options: mysqldump -h master-db \ -udummyuser \ -pd

Re: Problems with: MySQL 5.0.21 - 64bit

Hi Gabriel, Yesterday MySQL died again... there is nothing in the log files... (be it mysqld.log, .err, or /var/log/messages). The hosting provider is running an application called 'big-brother' and a lot of sef-faults appear in the logs from this. I don't know if thins is the cause... if this

Re: Problems with: MySQL 5.0.21 - 64bit

Spoken too soon... Yesterday MySQL died again... there is nothing in the log files... (be it mysqld.log, .err, or /var/log/messages). The hosting provider is running an application called 'big-brother' and a lot of sef-faults appear in the logs from this. I don't know if thins is the cause... if

Re: Problems with: MySQL 5.0.21 - 64bit

Yup... For now the problem stopped... These humongos values were because they were initialized at MAX_INT on that 64bit machine... In the my.cnf file they were not mentioned at all ! 2^64 - 1 == 18446744073709551615 Now look at the values below ! -- Gabriel PREDA Senior Web Developer On 6/22

Re: Problems with: MySQL 5.0.21 - 64bit

Gabriel, in your SHOW VARIABLES, I see a handful of settings that are much, much larger than normal: | max_binlog_cache_size | 18446744073709551615 | max_join_size | 18446744073709551615 | max_seeks_for_key | 18446744073709551615 | max_write_lock_coun

Re: Problems with: MySQL 5.0.21 - 64bit

Hi, Please let us know what all variables you have configured in your my.cnf files. what is your total size of memory in box. eg : max_connections key_buffer_size sort_buffer_size. Gabriel PREDA wrote: Hi list, Since we bought a better hardware for our dedicated MySQL Server we

Re: Problems when compiling the source

I thought of that, but i didn't think it'd be a problem since i do have thpse shared libraries for the application to use at runtime - and since the server runs just fine, i doubt that is what is causing the problem (tho it is definately worth trying). It seems to me that if this is truely the

Re: Problems when compiling the source

On Tuesday 20 June 2006 12:02 pm, Martin Jespersen wrote: > ./configure --prefix=/opt/.mysql-4.1.20 --enable-assembler > --enable-thread-safe-client --enable-static=all --with-gnu-ld > --with-mysqld-user=mysql --without-debug > --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static > -

Re: Problems with Mysql 5 and Visual Basic 5

I think you will need to give the list some more information! What error message do you get? Is it an error when running SQL queries, or a problem connecting to the database? James Harvard At 9:22 am -0300 24/4/06, Gabriel Mahiques wrote: >I migrated to mysql 5 but the applications with Visual

Re: Problems with UTF and MySQL

Yes you are right it works... but if the documentation is wrong I will be wrong in the following also... Majority of SET statements are documented without quotes: AUTOCOMMIT = {0 | 1} BIG_TABLES = {0 | 1} FOREIGN_KEY_CHECKS = {0 | 1} IDENTITY = value INSERT_ID = value LAST_INSERT_ID = value SQL_AU

Re: problems/feature request ideas

Sheeri, - Original Message - From: ""sheeri kritzer"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, March 28, 2006 9:29 PM Subject: problems/feature request ideas 2 weeks ago we had a server crashing, and while I was checking it out (before, during and after

Re: Problems with UTF and MySQL

On 2006-03-20, at 16:12, Gabriel PREDA wrote: One must issue immediately after connection: SET NAMES 'utf8' Also look at: SHOW VARIABLES LIKE 'collation_%'; SHOW VARIABLES LIKE 'character_set_%'; Server must know what you are assking for... and they ALL have to "talk the same language" !!

Re: Problems with UTF and MySQL

One must issue immediately after connection: SET NAMES 'utf8' Also look at: SHOW VARIABLES LIKE 'collation_%'; SHOW VARIABLES LIKE 'character_set_%'; Server must know what you are assking for... and they ALL have to "talk the same language" !!! -- Gabriel PREDA Senior Web Developer

Re: Problems with timestamp field after upgrading MySQL Server.

Alternatively, you might be able to re-render times and dates in their "condensed" format by auto-converting them to a numeric value. Try adding zero to your date columns in your select clauses. Once condensed, your substring code should begin working as before. SELECT datecol +0 as datecol FR

Re: Problems with timestamp field after upgrading MySQL Server.

Sure is... SELECT DATE_FORMAT(dateField,'%Y%m%d') as dateField Take a look at: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html -Josh --- Yesmin Patwary <[EMAIL PROTECTED]> wrote: > Dear All, > > First of all, I would like to thank to Josh and > Peter Brawley for their

RE: Problems getting MySqlDump to use sub-queries

Henry, Maybe the shell is doing something funky with the parens? maybe try escaping them with the \ ?? Just a wild guess :) > -Original Message- > From: Henry Dall [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 15, 2006 12:06 PM > To: mysql@lists.mysql.com > Subject: Problem

Re: Problems Starting MySQL

Anyone have any ideas on this one? Many thanks. RobL On Friday 10 February 2006 15:07, Rob Lacey wrote: > Running as root. > > RobL > > On Friday 10 February 2006 14:55, sheeri kritzer wrote: > > Are you running the startup script as root, or is it setuid? > > > > -Sheeri > > > > On 2/10/06, Rob

Re: Problems Starting MySQL

Running as root. RobL On Friday 10 February 2006 14:55, sheeri kritzer wrote: > Are you running the startup script as root, or is it setuid? > > -Sheeri > > On 2/10/06, Rob Lacey <[EMAIL PROTECTED]> wrote: > > Wondering if anyone can shed some light on a problem I am experiencing. > > > > I am ru

Re: Problems Starting MySQL

Are you running the startup script as root, or is it setuid? -Sheeri On 2/10/06, Rob Lacey <[EMAIL PROTECTED]> wrote: > Wondering if anyone can shed some light on a problem I am experiencing. > > I am running MySQL 4.1 on a Red Hat Enterprise Linux ES release 4 (Nahant > Update 2) machine. > > I

Re: problems with old isam tables

Also, you may find that check table/repair table are able to fix the problem. See http://dev.mysql.com/doc/mysql/en/Table_maintenance.html for more information. Greg On Thursday 12 January 2006 08:28, Greg Fortune wrote: > That looks a little odd. Do isam tables have a .myi file for each tabl

Re: problems with old isam tables

That looks a little odd. Do isam tables have a .myi file for each table that stores the indexes? If so, yours appears to be missing. I would suggest you use mysqldump to dump the table, change the ENGINE= section in the resulting dump file, and then reload the table and data from that dump fil

Re: Problems with indexes on Date/DateTime fields

Javier Diaz wrote: EXPLAIN SELECT * FROM process_times WHERE date <= date_sub(now(), INTERVAL 2 day) date_idx,date_proc_idx (NULL) 10778561 EXPLAIN SELECT * FROM process_times WHERE date = date_sub(now(), INTERVAL 2 day) date_idx,date_proc_idx date_idx 1863456 My

RE: Problems with indexes on Date/DateTime fields

NDITIONS] Thanks a lot for your help Javier -Original Message- From: Jigal van Hemert [mailto:[EMAIL PROTECTED] Sent: 05 January 2006 14:39 To: Javier Diaz Cc: Aftab Khan; mysql@lists.mysql.com Subject: Re: Problems with indexes on Date/DateTime fields Javier Diaz wrote: > I would

Re: Problems with indexes on Date/DateTime fields

Javier Diaz wrote: I would like to know if there is any problem which cause Mysql to not use date indexes at least you use the "=" operator, because if that is the case we will need to re-visit a few queries If you do a select instead of a delete, will the index be used? (You can check th

RE: Problems with indexes on Date/DateTime fields

hat is the case we will need to re-visit a few queries Thx Javier -Original Message- From: Aftab Khan [mailto:[EMAIL PROTECTED] Sent: 05 January 2006 11:25 To: Javier Diaz Subject: RE: Problems with indexes on Date/DateTime fields I agree. Some time full table scan is faster than

RE: Problems with indexes on Date/DateTime fields

avier -Original Message- From: Aftab Khan [mailto:[EMAIL PROTECTED] Sent: 05 January 2006 11:03 To: Javier Diaz Subject: Re: Problems with indexes on Date/DateTime fields Is not the second quary doing a full table scan? The parser may find this better than using the Index. --- Javier

Re: Problems with back up and restore mysql 5.0

Hello. >dump, it just cannot restore it back. Please provide exact actions which you're doing to restore a backup. "Sandeep Raul" <[EMAIL PROTECTED]> wrote: >Hi, > >Need your help in restoring mysqldump from version 4.1 to 5.0 > >We wanted to update our mysql server from version

Re: Problems with back up and restore mysql 5.0

When under 5.0 you need to export your data doing a character set translation to latin1 or iso-8859-1. You also need to adjust the export for compatibilty with older versions (some SQL verbs used in 5.0 are not understood by older versions) Jacques Brignon You can do that either with mysqldump or

Re: Problems finding the MAX value

How it works... "KEVIN ZEMBOWER" <[EMAIL PROTECTED]> wrote on 11/04/2005 12:40:50 PM: > Man, you're awesome. Only two typos in the whole procedure. However, > for the life of me, I'm puzzled over how it works. If you have more > patience can you explain? > > Correct query (table is singular, no

Re: Problems finding the MAX value

Man, you're awesome. Only two typos in the whole procedure. However, for the life of me, I'm puzzled over how it works. If you have more patience can you explain? Correct query (table is singular, not PHPAUCTIONS_...): CREATE TEMPORARY TABLE tmpWinners SELECT auction, max(bid) as winningbid FRO

Re: Problems finding the MAX value

Shawn, thank you for your complete answer. I'm still working through your first post. I apologize for not noticing this FAQ. I didn't take it into account because I thought it only applied to MySQL 5 and I'm using 4.0.24. Thanks, again. I'll be in touch regarding your first post as I work with y

Re: Problems finding the MAX value

[EMAIL PROTECTED] wrote on 11/04/2005 11:22:35 AM: > This is such a FAQ that they put the answer in the manual: > http://dev.mysql.com/doc/refman/5.0/en/index.html > OOPS! I copied the wrong link. It should have been: http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html

Re: Problems finding the MAX value

"KEVIN ZEMBOWER" <[EMAIL PROTECTED]> wrote on 11/04/2005 11:05:05 AM: > My organization runs an online auction on our intranet server for > the United Way. I'm having a hard time printing out a list of the > winning bidders (I'm under a lot of pressure; the baked goods are > getting stale). >

Re: Problems with creating of foreign key

Tatjana Cukic <[EMAIL PROTECTED]> wrote on 10/12/2005 12:28:47 PM: > hello, > > does anybody knows the error: > can't create table '.\Cherry\#sql-288_5d.frm' > (errno:150) > > it happens when i try to create foreign keys in > Table1, and that foreign key is actually primary key > in Table2 (to w

Re: Problems setting up on Mac OS X

on 9/28/05 9:49 PM, Jim C. at [EMAIL PROTECTED] wrote: > I'm not fond of the idea, but perhaps if I can't get it working, I'll > try compiling it from source. There is no reason to do this unless you really want to, I assure you, mysql can run on OS X. You may want to not use the startup pane thi

  1   2   3   4   5   6   >