filename-safe conversion of database-/tablenames

t didn't find a way in which it exposes this conversion function to the outside. Did I overlook some way this could be done? If not, would this be a feature that a future version of MySQL should provide? Best regards Simon Fromme [1]: https://dev.mysql.com/doc/refman/5.7/en/identi

Re: mysql 5.5 crashed on Debian 6 after server crash

Hi, I have managed to get the dB open with [mysqld] innodb_force_recovery = 2 I did a mysqldump for all tables, and restarted with innodb_force_recordy but still have the same old error messages. Regards, S On Wed, Aug 28, 2013 at 12:12 PM, Simon Loewenthal < simon.loewent...@gmail.

mysql 5.5 crashed on Debian 6 after server crash

replicated over there. Mysql boots with these types of errors recorded in syslog. Also is the my.cnf If you know of ideas that could be of help, then I woul dbe really grateful. I've been trying to get this to run for 4 hours solid. Best regards, Simon My.cnf ( My server only has 512Mb

Re: Connect to MySQL server from a c++ application

On 06/08/2012 01:55 AM, Claudio Nanni wrote: Hi, you guys don't like the official API? http://dev.mysql.com/downloads/connector/c/ That's C isn't it? I think there is also a C++ connector. I'm interested to hear how that performs. It seems like a waste of time to write a bunch of wrappers

Re: Connect to MySQL server from a c++ application

On 06/07/2012 12:29 PM, Lars Nilsson wrote: On Wed, Jun 6, 2012 at 10:41 PM, Simon Walter wrote: However, memory leaks are not acceptable. So I am open to suggestions. What do other c++ programmers use? I've been happy using SQLAPI++ (http://www.sqlapi.com/) where I work. Commercia

Connect to MySQL server from a c++ application

;s auto-responders going off like a digital ghost town. :/) Thanks, Simon -- simonsmicrophone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

date comparison query

some values (I am trying to find results that fall into different weekly ranges), but then some are just way off. Does anybody have any ideas for why this is happening? Thanks, Simon

RE: Formatting Numbers with commas

Please see http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_format Regards, Simon Griffiths -Original Message- From: Mike Blezien [mailto:mick...@frontiernet.net] Sent: 12 February 2012 16:00 To: MySQL List Subject: Formatting Numbers with commas Hello, Is

Re: change from an OR to an AND condition

in this instance, what I'm looking for are the entries where they have two entries in entries_tags with tag ids 5 and 6, instead of entries that have either. Thanks again, Simon On 27 September 2011 09:46, Simon Wilkinson wrote: > Hi, > > I have a query where I'm using a

change from an OR to an AND condition

WHERE entries_tags.tag_id IN (x, y, z) What I would like to do is switch this from an OR condition to an AND condition, so that an entry is only returned if it has all of x, y, and z. How would I go about doing this? Thanks, Simon

Re: optimizing query

indexes. Cheers, Simon On 19 January 2011 02:11, Steve Meyers wrote: > On 1/18/11 10:22 AM, Simon Wilkinson wrote: > >> SELECT articles.* FROM articles INNER JOIN newsletters ON >> articles.newsletter_id = newsletters.id INNER JOIN users ON users.id = >> newsletters.user_i

optimizing query

e entries' and 'analyze table entries' also didn't seem to have any real impact on the performance. I was wondering if anybody had any suggestions for what else I might be able to try, or if there is a better way to search on dates in this manner. Any ideas would be greatly appreciated. Thanks, Simon

Re: help with query

Thank you, that did the trick. Simon On 11 January 2011 12:09, Steve Meyers wrote: > On 1/11/11 9:31 AM, Simon Wilkinson wrote: > >> select users.id from users where users.id in (select newletters.user_id >> from >> newletters left join articles on newletters.id

help with query

newletters.id = articles.newsletter_id where articles.newsletter_id is null); But I believe this is finding users that have any empty newletters, and not users that have only empty newletters. How could I change this to return only the users that have only empty newsletters? Thanks, Simon

Index not being used

hows it using the correct index. Thanks for your time! Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Simple join very slow

need to add some sort of multi-column index? I'm guessing not as I'm doing OR's Thanks Simon

Simple query slow on large table

something to make sure it using the index when sorting? Any help will be greatly appreciated! Regards Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Need advice on a good setup for "generic queries"

est. 70% of the records in the table will be > >status "closed". As mentioned if you are not interested in "closed" queries get rid of them. put them in another table. That reduces the number of rows and hence the query time. Simon -- MySQL General Mailing List For list arc

Re: Replication, Stored Proceedures and Databases

one server to another. The rows changed on the master will be changed on the slave. You don't need to depend on the effect of the stored procedure on master and slave being the same. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:ht

Re: Indexing dynamics in MySQL Community Edition 5.1.34

machines. Earlier versions of 5.0 did indeed have this problem. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Should I be able to DELETE FROM ... WHERE .. IN ( ... ) with multiple a column key?

per...@elem.com (Perrin Harkins) writes: > On Wed, May 27, 2009 at 6:43 AM, Simon J Mudd wrote: > > So is the format of the DELETE FROM .. WHERE ... IN ( ... )  clause I > > propose valid and SHOULD the optimiser recognise this and be expected > > to just find the 2 row

Should I be able to DELETE FROM ... WHERE .. IN ( ... ) with multiple a column key?

| transaction_history | range | PRIMARY,customer_id | PRIMARY | 16 | NULL |2 | Using WHERE | ++-+---+---+--+-+-+--+--+-+ 1 row IN set (0.02 sec) So is the format of the DELETE FROM .. WHERE ... IN ( ... ) clause I propose valid and SHOULD the

Re: Replication config

ights he can't change things in the database. There are some minor exceptions: - you can create temporary tables - you can run ANALYZE TABLE These are normally not an issue. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

Re: Replication config

ignore this. > > replicate-do-db = somedbname1 > replicate-do-db = somedbname2 required if you don't want to replicate all the dbs on the server. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Replication config

> slave that has been used as a master, and go from there? If the end that may be necessary. You can configure master / master replication but as I said you have to be careful with this as it can be quite critical how you actually setup your tables. If you don't do things correctly it

Re: Replication config

permissions. 7. Run: START SLAVE 8. Use: show slave status\G to check how the replication is working, and and adjust as necessary. It's true that initial mysql replication setup is a bit fiddly, but once you've done it once or twice it's not so hard. Simon -- MySQL General M

Re: splitting large tables vertically

more inclined to go with InnoDB for its > reliability. This is a fairly important table. Well disk (and memory) usage can also be important so as it seems InnoDB storage is "less efficient" this may actually degrade performance. Until you are more concrete it's hard

Re: Still going in cicrles

d: ready > for connections. > > Version: '5.1.32' socket: '/home/qsys/mysql-5.1.32/mysql.sock' port: > 3305 Source distribution This looks correct. > > > > I would suggest that the developers team might change the error messages. Indeed, I'll crea

Re: Still going in cicrles

e installing MySQL so we can determine why MySQL thinks that it needs to do an upgrade. My guess would be that you have multiple mysql binaries on your server and are not running the version you expect. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: splitting large tables vertically

with behaviour you see later. Also if you are looking at a large amount of data like this appropriate server tuning can influence performance significantly. Hope this helps. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Help with mysql query, multiple list

---+-+ | 1 | 2009-05-09 10:00:00 | 2009-05-09 11:00:00 | ++-----+-+ 1 row in set (0.00 sec) Hope this helps. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: innodb rollback 30x slower than commit normal?

ld easily do a single "atomic" update involving the SELECT and UPDATE. That would be much easier as you would either run the "combined UPDATE" or not. Perhaps that would work for you? Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Oracle , what else ?

doubt) there is always PostgreSQL to fall back on. Simon. smime.p7s Description: S/MIME cryptographic signature

Trying to work out why a join query is so slow

lem or how I could rewrite the query to significantly speed it up? Thanks! Simon

Re: Problem with MySQL prompt

ysql.com for this? I had a quick look but couldn't find one. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQl and LVM

hot will run out of space and suddenly it will lose its contents. It's only a temporary staging area. Hope this helps. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Virtualizing MySQL

n issue for your virtual servers may not be an ideal solution as most of the free virtualisation options don't control sufficiently the hardware resources distributed to each virtual machine. YMMV. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Server Setup Question

6_64 bit version as you won't be limited in memory by the 32-bit architecture. MySQL seems to work pretty well with the 32-bit version but using it with more than 4GB of RAM is going to be a problem. The 64-bit version doesn't have any trouble with 32GB (not tried more). Simon --

Re: Why different engines in one database?

. There are a few things you can do with MyISAM which can't be done with InnoDB (merge tables[1] comes to mind) and therefore it can sometimes be better to use a different storage engine. As long as you are aware of the advantages and limitations of the different engines you should be fine. S

Re: Master-master setup

ry time. Be aware that if the updates to the tables are very frequent it's quite possible that replication delay may mean that the data on both servers is not the same. The only way to ensure that this is avoided is to use explicit WHERE id IN (1,3,43,5,...,nn) clauses so that you are

Re: C api - mysql_list_fields

? I think that if it is MySQL will allocate space for each character and is forced to allocate 3x20 bytes as a UTF-8 character can be up to 3-bytes in length. SHOW CREATE TABLE a\G should show if this is the case. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Consulting

ta/mysql/log/binlog will do what you want. Don't change basedir. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Configuration and improvement advice.

r period. It also gives you time to tweak all values while doing the conversion from MyISAM to InnoDB. Hope this helps. Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: revoke all on *.* ??

m $above_user > ? DROP USER [EMAIL PROTECTED]; Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Large import into MYISAM - performance problems

Olaf, Mike Thanks for the input, the blob data is just text, I'll have a go at using the load data command Regards Simon mos wrote: At 10:30 AM 6/5/2008, you wrote: Simon, In my experience load data infile is a lot faster than a sql file htrough the client. I would parse the sql

Re: Large import into MYISAM - performance problems

tting bigger. Regards Simon Ananda Kumar wrote: Simon, Why dont u split the file and use LOAD DATA INFILE command which would improve the performance while loading into an empty table with keys disabled. regards anandkl On 6/5/08, Simon Collins <[EMAIL PROTECTED]> wrote: I'm

Re: Large import into MYISAM - performance problems

eparate tables as it would change the schema and I'm not in charge of the schema design - just the DBA at the backend. Cheers Simon mos wrote: Simon, As someone else mentioned, how are you loading the data? Can you post the SQL? You have an Id field, so is that not the primary key? If

Large import into MYISAM - performance problems

able time, if at all. Can anyone suggest to me why this is happening and if there's a way to improve performance. If there's a more suitable list to discuss this, please let me know. Regards Simon -- Dr Simon Collins Data Grid Consultant National Grid Service University of Manchest

Re: external mysqldump

, but it will achieve the permissions you need without giving away all the data as well. Simon Simon Elliston Ball [EMAIL PROTECTED] On 20 Feb 2008, at 12:03, Andre Hübner wrote: i tried, but always got error: "ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES&

Re: transfer huge mysql db

| ssh [EMAIL PROTECTED] 'cat - | bzip2 -9dc | mysql -uwhatever etc' assuming of course that you have nice fast processors and horrible slow connectivity (gzip, and something less severe than 9 would do almost as well) simon Simon Elliston Ball [EMAIL PROTECTED] On 24 Jan

Re: MySql on Leopard

The easiest way to get mysql working on os x is with a fink build. The version is a little behind 5.0.38, but I can't imagine there would be any problems with a source build from the latest. Maybe you could give it a go, and report any problems, then I'll happily help out. Simo

help with error messages please

I am unable to connect to mysql 5.1 with phpmyadmin 2.10.2 on win2k running php 5.2.3. I get the following errors:- Event viewer:- Event Type: Information Event Source: Application Popup Event Category: None Application popup: httpd.exe - Entry Point Not Found : The procedure entry point mysql_

Re: Update failing with error 1062

Found the source of my problem. I had an update trigger connected to this table which was trying to create a new entry in another table instead of updating an existing one! There we go! Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Update failing with error 1062

t(10) unsigned default '0', PRIMARY KEY (`idCalendarEntry`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; As you can see, there are no other unique keys here. In addition, there are no foreign keys which point here either. Any ideas? Simon Michael Dykman wrote: Simon, send in the

Update failing with error 1062

Entry = 6; In the table, the field 'idCalendarEntry' is declared as : `idCalendarEntry` int(10) unsigned NOT NULL auto_increment The server version of MySql I am using is 5.0.24 The client version of MySql I am using is 5.0.11 Is anyone able to help? Simon -- MySQL Gene

How to switch off auto-checks ?

My mysql-db starts a "check tables xy fast" for all tables as soon as I re-start the db-server. I didn't find a place where I can control if the db should be checked at start or not. So where can I switch of this checkings at db-server-start ? Thanks in advance Greetings Marco smime.p7s Descrip

Too many table-locks

Hi everybody, I've got a little problem with a web and mysql based bulleting-board-application. The board is quite well visited and users are writing aprox. 1 new post per second. In total the db gets aprox. 250 queries/sec. The webserver and mysql-server are running on different hosts, the db se

Who's locking ?

Hello list, I've a question about understanding table-locks of myisam-tables: >From time to time it happens that my proccesslist gets flooded by Queries, that are waiting for a locked table. Quickly there are 100-500 waiting Queries in the queue - some of them waiting since more than 1000 seconds

Re: Reset (or Defrag) the AUTO_INCREMENT columns

Hi wolverine, of course you could "defrag" your autoincrement-values, but there's no automation for that - you've do do that via normal insert/update statements. Perhaps you'll need an intermediate table. But: In most cases the autoincrement-value is used as an id (as in your case) - in db-langua

Re: example when indexing hurts simple select?

Hi Gasper, MySql allows to package the index - to get its size smaller and to gain performance. Some information about that can be found here: http://www.mysqlperformanceblog.com/2006/05/13/to-pack-or-not-to-pack-myisam-key-compression/ Gaspar Bakos schrieb: > Hi, > > > RE: > >> Have you tri

Trouble with aborted connections

Hello everybody, I'm using mysql in an clustered environment: Several loadbalanced webservers get the requests from the users' clients and query the needed information from several webservers. Every webserver connects to every database-server. So in this case the webservers are the mysql-clients.

Re: auto_increment and the value 0

IGNED). Assuming the current zero row has some kind of special significance, this may make more sense than just giving it the next unused auto_increment value. This would also keep it in the same place with an ORDER BY. -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/

Re: auto_increment syntax

ative ID number, and this gives you an extra byte. -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Signal 11 crashes on MySQL V5

m (tried both the glibc23 and statically linked ones, no difference - the above trace is from the glibc23 one). Running a mix of both Fedora 3 and Fedora 4 on Intel P4s. -Simon On 3/8/06, Dave Pullin <[EMAIL PROTECTED]> wrote: I am running MySQL on 6 servers - 3 Linux and 3 Windows. I re

Re: Signal 11 crashes on MySQL V5

we were seeing the same thing with 5.0. We had to roll back to 4.1 the other day, 5.0 was just too unstable. I haven't reported a bug though because I couldn't narrow down the cause of the problem. Just seemed to be random crashes, several times per day (more often when under load).

Re: selecting records newer than say 20 min

select * from table where mytimestamp > (unix_timestamp - 20) ?? Gregory Machin schrieb: > Hi > What, is the easest way to select all the records created in the last 20 min > stay based on a column that has a timestamp record. > > Many Thanks > > -- > Gregory Machin > [EMAIL PROTECTED] > [EMAIL PR

Re: Using Network Block Device on Linux to build HUGE/cheap memory-base MySQL boxes.

o run your database in RAM and make real gains in scalability and fault tolerance (although it is a little rough round the edges still). -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Adding data from one table to another

The easiest way to do that would be to CREATE TABLE new_table_name SELECT (query you use to join the tables) The old tables then become redundant. On 11 Jan 2006, at 17:30, 2wsxdr5 wrote: I have two tables with data on people in them. Table A is a subset of table B, However, there is dat

ISAM tables broken

database but not the tables I have tried ISAM check and it seems OK but MySQL won't open the tables. I have even tried the files in a fresh compiled MySQL rather than the FC4 version in case that's a problem. Are my tables doomed? TIA Simon PS they are at http://titanic.co.

Re: ERROR 2003 (HY000): Can't connect to MySQL server on 'gandalf' (111)

accepts local connections via the Unix socket. This sounds like your situation. Note that a "could not connect" error means just that. If the problem was related to user privileges you would get an "access denied" error. HTH, -Simon -- MySQL General Mailing List For l

Re: LEFT JOIN not working on 5.0.16 - urgent help

d dm. The solution is to put the FROM tables in parentheses, like: SELECT ... FROM (user_master um, role_master rm) LEFT JOIN department_master dm ON um.department_id = dm.department_id) ... You can read more about this here: http://dev.mysql.com/doc/refman/5.0/en/join.html -Simon -- MySQL

Re: Reset root password to mysql?

Jerry Swanson schrieb: How to reset mysql password to mysql? mysql -u root ERROR 1045 (0): Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) You could start your mysqld with "--*without-grant-tables"* option. But keep in mind that this will stop the complete permission

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

n a MyISAM table. To have a larger table, you need to tell mysql that it needs to use a larger pointer for that table, either at table creation, or with an ALTER TABLE such as the one Simon is proposing to run. See the last half of <http://dev.mysql.com/doc/refman/5.0/en/table-size.html> for

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

to live data? how does this work? Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Active user sessions

On 31/10/2005 3:43 p.m., Cabbar Duzayak wrote: Hi, Is there a way of listing all the active db sessions and their IP addresses and/or db user names? Something like v$session in oracle? Thanks... SHOW PROCESSLIST; -Simon -- MySQL General Mailing List For list archives: http

Does MySQL 3.23.58 Support UNION

;s failing saying SQL Error: You have an error in your SQL syntax near 'UNION SELECT DISTINCT A.B_IP FROM w3t_Posts A , w3t_Users B WHERE A.B_PosterID ' at line 2 SQL Error #: 1064 Query: SELECT DISTINCT A.B_IP FROM w3t_Posts A , w3t_Users B WHERE A.B_PosterID = B.U_Number and B.U_

compiling + making source for 5.7 on alpha

Can anyone advise please, tried binary installation but other users have reported encountering similar problems so I thought I'd try a source installation. Adjusted the "pentiumpro" flags out and configure reported no errors -when I use "make" I get "*** no targets. stop." The makefile is in ther

Re: Shifting dates

re a date as an int when you can store it as a date? :) Also a question of whether you prefer to do date manipulations in your application or at the SQL level. But both ways work. -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://

Re: Shifting dates

:00', INTERVAL 3 HOUR) http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

problem installing 5.7 on alpha

Can anyone help, please, when I tar -xvzf this file I am getting the error "Archive contains obsolescent base-64 headers gzip: stdin: invalid compressed data--crc error" and installation exits I tried to acquire the Compaq compilers mentioned under "platforms" in case it is a gcc problem, but th

Re: idepontent inserts? Allowing INSERT to fail faster than SELECT/INSERT

On 15/06/2005 11:22 a.m., Kevin Burton wrote: Simon Garner wrote: I'm not entirely clear what you're talking about, but you could also have a look at INSERT IGNORE..., or INSERT... ON DUPLICATE KEY UPDATE, or REPLACE INTO...: The problem is that I do NOT want it to update. Also

Re: idepontent inserts? Allowing INSERT to fail faster than SELECT/INSERT

/en/insert.html http://dev.mysql.com/doc/mysql/en/replace.html -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CASE .. WHEN .. returns NULL

0) >50 THEN 9 WHEN (SUM(a.GraExtPredio)/SUM(a.GraExtUPA)*100) >25 THEN 6 WHEN (SUM(a.GraExtPredio)/SUM(a.GraExtUPA)*100) >10 THEN 3 ELSE 0 END AS agroland FROM tbl_f4Granjas AS a GROUP BY FK_ProjectHolderId -Simon

Re: If statment in query

Sebastian wrote: I have two fields: topic | title topic does not always have data in it, so i want to select `title` when `topic` is null.. i thought i could do this (does not work): IF(title IS NULL, topic, title) AS heading Thanks. Try SELECT IFNULL(title, topic) AS heading -Simon

Re: Sync 2 live MySQL Databases

red in RAM), or if you're just after high availability, set up one-way replication with dynamic master failover (which I am currently trying to figure out how to do myself). -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

Re: Using AVG

urely SELECT (5+8+10)/3 AS rate; is what you want? -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Different TIMESTAMP columns

date, not a dynamic value. e.g. UPDATE bookmark SET last_scanned=NOW() -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Different TIMESTAMP columns

Lieven De Keyzer wrote: But how do I initialize the 2 datetime fields? With no DEFAULT, their values are -00-00 00:00:00. Just what I wanted to avoid with TIMESTAMP Set their value to NOW() if you want the current date/time. -Simon -- MySQL General Mailing List For list archives: http

Re: Replication with failover

stion... Kevin That would be nice, because I googled and searched the list archives and found nothing. -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Replication with failover

involves a bit of scripting to glue it all together, but I was hoping somebody would have created such scripts already so I don't screw it up myself :) tia -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

Re: select count(*) table

his allows you to get the values of expressions or functions. E.g. SELECT 1+1 will return 2, and SELECT NOW() will return the current date and time. Your query is selecting "COUNT(*) AS table" rather than "COUNT(*) FROM table". Naturally, without a table,

Re: beginner guide

until you get to "Source downloads", or click http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-4.1.11.tar.gz/from/pick -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: amPiguous!

elect pk" part because it doesn't know whether to select a.pk or b.pk. I think what Dan is arguing is that MySQL should know from the join that a.pk and b.pk are the same, so it doesn't matter which one it uses. -Simon - Original Message - From: "Dan Bolser" <[E

Re: no /tmp/mysql.sock

re to talk in terms of filesystem standards, /tmp would not be the 'correct' place for a socket file. -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: no /tmp/mysql.sock

y /var/lib/mysql/mysql.sock, or look at `mysqladmin variables` and check the 'socket' value. -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

d] section in your my.cnf file. -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

your client is an older version. -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: many to many

7;t tested this but I think it would work... I'm implementing this in perl, so I can break the queries into pieces if I absolutely have to. Thanks > -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Multi-master replication / clustering

nice if MySQL could implement something like this themselves. Does anybody know of any other options for MySQL clustering? TIA, -Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: install failure on XP toshiba laptop

oks like it was mysql client program. > Start mysqld instead. Have you been at: > http://dev.mysql.com/doc/mysql/en/Windows_start_command_line.html > > > "Simon Tierney" <[EMAIL PROTECTED]> wrote: > > Hi, Can anyone help please, I am trying to install 4.1 onto this

  1   2   3   4   5   >