Problems with timestamp and leap seconds?

qldump", but all I can find is information on setting up timezone tables in MySQL. In case it matters, "SELECT COUNT(*) FROM mysql.time_zone_name;" returns 0, and $ mysqladmin variables | grep zone | system_time_zone| CST | | time_zone

Re: Problems with timestamp and leap seconds?

an internal format would have jumped at the transition, but this example above doesn't have any sort of transition involved that I can see.) -- Tim McDaniel, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Problems with timestamp and leap seconds?

fault CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, Also, it's a Bugzilla database, and I'm not free to change the schema. -- Tim McDaniel, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Problems with timestamp and leap seconds?

hat does it when you update some other column without setting this TIMESTAMP column or, of course, setting it to NOW() or one of its synonyms. -- Tim McDaniel, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Im being dumb!

d.id; Is that last SELECT equivalent to my version here? select a.id, a.desc1, b.desc2, c.desc3, d.desc4 from a, b, c, d where a.id = b.id and a.id = c.id and a.id = d.id; I mean: the two versions get the same result -- is one translated into the other / processed exactly the sa

Re: mysqldump on specific columns only?

INSERT statements, though for all I know MySQL provides other mechanisms to load that sort of data. But those are tab-separated columns: what if one of the columns were a text field with a literal tab? -- Tim McDaniel, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MYSQL FUNCTIONS

he the proposed query would be to stop time. Otherwise, the result of running NOW() will change from run to run, causing a different result set. -- Tim McDaniel, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: No database selected error when running mysql_tzinfo_to_sql

ther servers with identical software without issue Have you tried the SELECT command above to verify? I don't know about MySQL, but in other databases I've used, it's possible to specify a default database to use on each session unless another database is explicitly specified. Brie

Re: No database selected error when running mysql_tzinfo_to_sql

n the current directory. It does not run the mysql_tzinfo_to_sql command. The way to redirect command output into the input of another command is to use "|" in the proper way. Please see the on-line man pages that I posted in my other note a minute ago. -- Tim McDaniel, [EMAIL PROTECTED]

Re: No database selected error when running mysql_tzinfo_to_sql

re emitted without a database specified, as shown in the output above. I can see a use for omitting the database name from the output. Without it, you can load the timezone data into a test database and examine it there with SQL, without clobbering the system information. -- Tim McDaniel, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Migrate HUGE Database

lation to the password), in this case as the database name. How very inconsistent and obnoxious. Daniel, thank you for the prompt to look at this. -- Tim McDaniel, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Copying tables

databases db_name1 [db_name2 db_name3...] shell> mysqldump [options] --all-databases Read the manual for your version of MySQL for more options. --opt looks like it might be most useful. -- Tim McDaniel, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists

Re: Migrate HUGE Database

ve any questions about what mysqldump outputs, you can feed its output into a pager program like "less" or "more", or into a temporary file, and just look at it. One way to reduce a mountain of output would be to just mysqldump specific databases or tables. -- Tim McDaniel,

Re: reg: on delete cascade

e here is the "child table" and CUSTOMERS is the "parent table", so I gather that deleting from CUSTOMERS should indeed delete from ORDERS if you use InnoDB. -- Tim McDaniel, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Migrate HUGE Database

. I'm kvetching about how mysql and mysqldump parse their arguments, that * -uUSERNAME and -pPASSWORD are parsed similarly * -u USERNAME and -p UNRELATED_ARGUMENT are not -- Tim McDaniel, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Migrate HUGE Database

27;d made it clear above that I understand the rule. I am complaining (in a forum where no maintainer is likely to be present, unfortunately) that it was a bad design that made -p be parsed differently from -u and likely all the other switches. A wise consistency is useful, because users have t

Re: i quick question please

logs are extremely detailed, probably more detailed that you want to see. For example, SELECT ... FOR UPDATE is now supported. is a general note, but most are like Creating a table with a 19 digit DECIMAL column would cause incorrect data to be stored. ... which seems like an obscure

RE: mysql privileges

uot; dumps just as well as using --all-databases? Our backup script does a mysqldump for each separate database, and soon will separately dump every table in every database. (Easier to do a diff when I change just one table.) -- Tim McDaniel, [EMAIL PROTECTED] -- MySQL General Mailing Li

Re: select *

will you be supplying a WHERE clause to keep from getting all possible combinations of rows from tbl1, tbl2, and tbl3? (Or am I misunderstanding something?) Please also consider using explicit JOINs. Another way to do the same thing with different syntax, right? -- Tim McDaniel, [EMAIL PROTECTE

Re: Help with ORDER BY using two colomns

s what you can use in a WHERE, et cetera. The last bit is a link. If you follow it, to <http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html>, it describes the CASE expression for 5.0, and the link at the top points to the slightly different 4.1 version, <http://dev.mysql.

RE: \x96 in column value?

d not expect it to be a problem per se. I just wanted to point out what it might not mean. -- Tim McDaniel, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Performance problem

w: what sorts of things did you do? Restructuring, different queries, what? -- Tim McDaniel, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Migration from 32-bit to 64-bit MySQL

On Fri, 25 Apr 2008, B. Keith Murphy <[EMAIL PROTECTED]> wrote: I would just dump the database from the 32-bit platform and import it into the 64-bit server. By "dump" do you mean "mysqldump", or some other process? -- Tim McDaniel, n00b, [EMAIL PROTECTED] -- MySQ

RE: Problem with character set and connection collation

points with printable characters. -- Tim McDaniel, [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]