Timestamp is a session variable, so it must have been set to something
other than 0 (1372228034 epoch is the date you're showing) in your current
session.
mysql> set timestamp = 1372228034;
Query OK, 0 rows affected (0.00 sec)
mysql> select now(), sysdate();
+-+-
n, this is currently set globally - no matter what connection to
>the database, it all comes up with this value. Which means that all my
>time-based queries no longer work correctly.
>
>Does your message suggest that setting it to 0 might clear the problem?
>
>
>
>On 6/27/13 10:31
On 4/9/13 1:54 PM, "Joe Kosinski" wrote:
>Hi,
>
>I am trying to connect to a MySql database and I keep getting the
>following:
>
> Cannot find (ping) database host Joseph-Kosinskis-MacBook on the network
> Failed to connect to Unix socket '/var/run/lirc/lircd'
> No such file or
Nope. That's just granting replication privileges so it can read updates
on all tables on all databases. It cannot select anything.
Why are you trying to connect with a replication slave user?
On 4/2/13 1:47 PM, "Richard Reina" wrote:
>I did a "GRANT REPLICATION SLAVE ON *.* TO 'user'@'19
Assuming you copied and pasted the error, it looks like the host made a typo in
the config file:
'/var/lib/myswl/mysql.sock'
Should probably be mysql, not myswl.
-Original Message-
From: Rick James [mailto:rja...@yahoo-inc.com]
Sent: Monday, March 18, 2013 3:32 PM
To: Patrice Olivier
OP's first question: " I am not able to create a table on my own. what
privileges I need to create and modify tables in this database?"
The answer to that question is that he/she needs CREATE to create tables and
ALTER to alter them.
-Original Message-
From: Reindl Harald [mailto:h.rei
This might help with that task:
mysqlbinlog binary_log_file_name.01 --start-datetime="2013-02-25 16:45:00"
--stop-datetime="2013-02-25 16:50:00" | grep 'DELETE\|ALTER TABLE\|PARTITION'
-Original Message-
From: shawn green [mailto:shawn.l.gr...@oracle.com]
Sent: Tuesday, February 26
Are you actually querying the table (select count(*) from table_name), or just
the stats (show table status)? Is the table Innodb?
If you're using Innodb and aren't doing a select count (or other select query)
on the table, then yes you'll have varying results. This is because unlike
MyISAM, I
I definitely agree with using replication. As for delayed replication, this is
actually a built in feature of MySQL 5.6 (coming soon). 5.6 has numerous
improvements to replication. Definitely worth checking out:
http://dev.mysql.com/tech-resources/articles/whats-new-in-mysql-5.6.html
Scroll d
In the past when I used mysqldump, I used a slave database for backups and
periodically testing restores.
My process for testing:
- Stop the slave process (so the db doesn't get updated).
- Run the backup.
- Create restore_test database.
- Restore the backup to the restore_test database.
- Use my
By default, the mysql users/privileges tables are MyISAM, not ndbcluster.
ndb_mgm backup won't backup anything other than ndbcluster tables. The
--restore-privilege-tables only works if you've converted those user and
privileges tables to ndbcluster.
>From the manual:
>http://dev.mysql.com/do
I stand corrected and apologize. Numerous multi-master setup descriptions I've
read have said to set this (including the one linked in the original question).
However, as you said, the entry in the manual clearly says it defaults to 0.
Learn something new every day. Thanks Shawn.
On Sep 24, 2
log
entries with its own server ID.
From: Adarsh Sharma [mailto:eddy.ada...@gmail.com]
Sent: Monday, September 24, 2012 10:39 AM
To: Stillman, Benjamin
Subject: Re: Doubt Regd. Circular Replication In Mysql
Yes I fixed , but i solve the issue by enabling log-slave-updates only
Why we use the be
Sounds like you're missing the following in your my.cnf on server B (probably
all of them):
replicate-same-server-id = 0
log-slave-updates
While you're checking, might as well as make sure your auto-increment settings
are in there and correct also.
-Original Message-
From: Adarsh Sh
I think this will get you there:
SELECT LEAD, COUNT(*) FROM ORDERS GROUP BY LEAD;
It'll give you something more like:
| LEAD | COUNT(*) |
| F | 44 |
| S | 122 |
| R | 32 |
-Original Message-
From: Richard Reina [mai
I just realized I shouldn't be reading these first thing in the morning before
my first cup of coffee.. That says node id 10, then the IP. Sorry about
that.
-Original Message-
From: Stillman, Benjamin [mailto:bstill...@limitedbrands.com]
Sent: Wednesday, August 08, 2012 8:56
Unable to connect with connect string: nodeid=10,172.17.3.66:1186
There's a comma between 10 and 172 instead of a period.
-Original Message-
From: Aastha [mailto:aast...@gmail.com]
Sent: Tuesday, August 07, 2012 6:20 PM
To: mysql@lists.mysql.com
Subject: Error starting data node
Helo,
http://bixsolutions.net/forum/thread-18.html
-Original Message-
From: Elim Qiu [mailto:elim@gmail.com]
Sent: Monday, August 06, 2012 5:42 PM
To: mysql@lists.mysql.com
Subject: trouble with perl
To populate table for a perl forum, I got the following error:
aMac:mwf elim$ perl instal
Meant to add:
My workaround was to set the column as varchar then convert it to decimal after
the import. When adding to the table, I use a temp table to import to as
varchar, convert the column, the just select from temp table into prod table.
-Original Message-
From: Stillman
I don't believe this is limited to Workbench. I saw the same behavior using
LOAD INFILE and a pipe-delimited file. There's a bug report that's been open
since November of 2006 about this: http://bugs.mysql.com/bug.php?id=23212
-Original Message-
From: Fred G [mailto:bayespoker...@gmail.
7.2 introduces geographic clustering:
https://blogs.oracle.com/MySQL/entry/synchronously_replicating_databases_across_data
http://dev.mysql.com/tech-resources/articles/mysql-cluster-7.2.html (section
titled: Enhancing Cross Data Center Scalability: Multi-Site Clustering)
Data nodes can be located
As far as I know, a B-tree index can be used by LIKE as long as the string
doesn't begin with a wildcard. " LIKE 'X%' " should be fine to use an index on
the name column. The index only includes results in the search base which start
with X.
That said, I probably wouldn't use a subquery, either
age-
From: brian [mailto:mysql-l...@logi.ca]
Sent: Tuesday, July 03, 2012 1:47 PM
To: mysql@lists.mysql.com
Subject: Re: alternative to slow query
On 12-07-03 01:13 PM, Stillman, Benjamin wrote:
> I don't see an index for expression.id.
>
mysql db_lexi > s
I don't see an index for expression.id.
-Original Message-
From: brian [mailto:mysql-l...@logi.ca]
Sent: Tuesday, July 03, 2012 12:28 PM
To: mysql@lists.mysql.com
Subject: Re: alternative to slow query
On 12-07-02 09:33 PM, yoku ts wrote:
> Hello,
>
> add index to expression1_id and exp
By recent security breach, do you mean the issue with passwords? If so:
http://www.dbasquare.com/2012/06/11/a-security-flaw-in-mysql-authentication-is-your-system-vulnerable/
for i in `seq 1 2000`; do mysql -u USERNAME --password=INCORRECTPASSWORD -h
HOSTNAME ; done
If you get in using that, yo
25 matches
Mail list logo