[ANN] [Qt ORM] QxOrm 1.4.5 and QxEntityEditor 1.2.3 released : support MongoDB database and code source now on GitHub

2018-09-06 Thread QxOrm contact
QxOrm manual (https://www.qxorm.com/qxorm_en/manual.html#manual_95 <https://www.qxorm.com/qxorm_en/manual.html#manual_95>) and new sample project available in ./test/qxBlogMongoDB/ directory- QxOrm library is now available on GitHub (official repository) : https://github.com/QxOrm/QxOrm

ANN: Database Workbench 5.2 now includes PostgreSQL support

2016-09-08 Thread Martijn Tonies (Upscene Productions)
st InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.

Re: commands out of sync, you can't run this command now'

2016-01-08 Thread Reindl Harald
-of-sync.html http://stackoverflow.com/questions/15798762/mysqli-commands-out-of-sync-you-cant-run-this-command-now On Friday, January 8, 2016 10:47 AM, geetanjali mehra <mailtogeetanj...@gmail.com> wrote: Hi all, Suddenly I have started getting below error from our web site: 'comman

Re: commands out of sync, you can't run this command now'

2016-01-08 Thread Peter Brawley
r from our web site: 'commands out of sync, you can't run this command now' This error is generated sometimes when opening a page ,and immediately after refreshing the page, error gone. Can you please help me to troubleshoot this issue, so that above error disappears permanently? Is it a database

commands out of sync, you can't run this command now'

2016-01-07 Thread geetanjali mehra
Hi all, Suddenly I have started getting below error from our web site: 'commands out of sync, you can't run this command now' This error is generated sometimes when opening a page ,and immediately after refreshing the page, error gone. Can you please help me to troubleshoot this issue, so

Re: database developer tool Database Workbench 5 now available

2014-09-05 Thread Martijn Tonies (Upscene Productions)
Hello Jan, list, From: Martijn Tonies (Upscene Productions) m.ton...@upscene.com Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! Unless you don't do Winblows. Please put Windows dependency clearly in your

RE: database developer tool Database Workbench 5 now available

2014-09-05 Thread Martin Gainty
From: m.ton...@upscene.com To: j...@ecoreality.org; mysql@lists.mysql.com Subject: Re: database developer tool Database Workbench 5 now available Date: Fri, 5 Sep 2014 07:57:37 +0200 Hello Jan, list, From: Martijn Tonies (Upscene Productions) m.ton...@upscene.com Database

Re: database developer tool Database Workbench 5 now available

2014-09-05 Thread Martijn Tonies (Upscene Productions)
MGMy development is identical ..Development on Windows..Production on Linux MGWhen google routes me to Vladimir Putins site for Official Windows Mysql Stack you download god knows what MGsolution is to give the customer an in-between solution such as mysqld, mysqladmin and mysql shell

ANN: database developer tool Database Workbench 5 now available

2014-09-04 Thread Martijn Tonies (Upscene Productions)
is better than ever and works fine under Wine on Linux. Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! There is so much new in Database Workbench 5, I don't know where to start, says Martijn Tonies, founder of Upscene

Re: ANN: database developer tool Database Workbench 5 now available

2014-09-04 Thread Jan Steinman
From: Martijn Tonies (Upscene Productions) m.ton...@upscene.com Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! Unless you don't do Winblows. Please put Windows dependency clearly in your announcements and on your

ANN: Database Workbench 4.4.7, the multi-DBMS IDE now available!

2014-06-17 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.7, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.7 Pro For more information, see http://www.upscene.com/go/?go

ANN: Database Workbench 4.4.6, the multi-DBMS IDE now available!

2014-04-29 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.6, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.6 Pro For more information, see http://www.upscene.com/go/?go=newsid

ANN: Database Workbench 4.4.4, the multi-DBMS IDE now available!

2014-01-27 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.4, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.4 Pro For more information, see http://www.upscene.com/go/?go

ANN: Database Workbench 4.4.3, the multi-DBMS IDE now available!

2013-11-27 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.3, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.3 Pro This release fixes a blocking problem after a recent Windows

ANN: Database Workbench 4.4.2, the multi-DBMS IDE now available!

2013-10-24 Thread Martijn Tonies (Upscene Productions)
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.2 Pro There's a 15% autumn discount until the end of November! This release includes enhancements and fixes several bugs as

ANN: Database Workbench 4.4.1, the multi-DBMS IDE now available!

2013-08-19 Thread Martijn Tonies
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.1 Pro This release includes new features and fixes several bugs as reported by the users. For more information, see

ANN: Database Workbench 4.4.0, free Lite Editions now available!

2013-07-17 Thread Martijn Tonies
ANN: Database Workbench 4.4.0, free Lite Editions now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.0 Lite Today we are making the free Lite Editions available

Re: NOW() is stuck...

2013-06-28 Thread walter harms
'timestamp' is a SESSION variable and can't be used with SET GLOBAL This does indeed persist across sessions. Any command line connection I make to the database shows the bad value for NOW(). I also tweaked the application code to include NOW() in an existing query, and the value returned to my PHP

Re: NOW() is stuck...

2013-06-28 Thread Claudio Nanni
Avoid FreeBSD, Unless they did some real big magic on the scheduler of 9. Claudio On Jun 28, 2013 6:12 PM, Andy Wallace awall...@ihouseweb.com wrote: Nope, it was locked on a single value for about 36 hours, until we restarted the engine last night. Now it's running fine, and we're setting up

Re: NOW() is stuck...

2013-06-28 Thread Andy Wallace
Nope, it was locked on a single value for about 36 hours, until we restarted the engine last night. Now it's running fine, and we're setting up a testbed to evaluate MySQL 5.6 and FreeBSD 9 (?) for replacing our current Solaris 10/MySQL 5.1.46 setup. On 6/28/13 12:44 AM, walter harms wrote

Re: NOW() is stuck...

2013-06-27 Thread Johan De Meersman
, mysql list mysql@lists.mysql.com Sent: Thursday, 27 June, 2013 1:36:31 AM Subject: Re: NOW() is stuck... Random I-can't-sleep thought: you wouldn't be testint this in a single -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List

Re: NOW() is stuck...

2013-06-27 Thread Andy Wallace
select now(); +-+ | now() | +-+ | 2013-06-26 02:27:14 | +-+ While the machine/system date is: $ date Thu Jun 27 09:15:25 PDT 2013 I had actually planned to restart the mysql instance on this server last night

Re: NOW() is stuck...

2013-06-27 Thread Andy Wallace
current session. mysql set timestamp = 1372228034; Query OK, 0 rows affected (0.00 sec) mysql select now(), sysdate(); +-+-+ | now() | sysdate() | +-+-+ | 2013-06-26 02:27:14 | 2013-06-27 13:20

Re: NOW() is stuck...

2013-06-27 Thread Eric Bergen
line connection I make to the database shows the bad value for NOW(). I also tweaked the application code to include NOW() in an existing query, and the value returned to my PHP code is also the bad value. Thanks for looking, andy On 6/27/13 11:10 AM, Stillman, Benjamin wrote

Re: NOW() is stuck...

2013-06-27 Thread Stillman, Benjamin
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(); +-+-+ | now() | sysdate

Re: NOW() is stuck...

2013-06-27 Thread Stillman, Benjamin
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

Re: NOW() is stuck...

2013-06-27 Thread Andy Wallace
row in set (0.00 sec) And: mysql set global timestamp = 0; ERROR 1228 (HY000): Variable 'timestamp' is a SESSION variable and can't be used with SET GLOBAL This does indeed persist across sessions. Any command line connection I make to the database shows the bad value for NOW(). I also tweaked

Re: NOW() is stuck...

2013-06-27 Thread Andy Wallace
1228 (HY000): Variable 'timestamp' is a SESSION variable and can't be used with SET GLOBAL This does indeed persist across sessions. Any command line connection I make to the database shows the bad value for NOW(). I also tweaked the application code to include NOW() in an existing query

Re: NOW() is stuck...

2013-06-27 Thread Claudio Nanni
Hi, On 06/27/2013 08:19 PM, Andy Wallace wrote: Benjamin - Unfortunately: mysql show global variables like 'timestamp'; +---++ | Variable_name | Value | +---++ | timestamp | 1372238834 | +---++ 1 row in set (0.00

Re: NOW() is stuck...

2013-06-27 Thread Andy Wallace
Well, that begs the question - will restarting the MySQL server instance tonight fix the current problem? We do have a plan in place to test and eventually deploy a more recent version of MySQL (5.6?), but for now, I have to support 1000's of customers. My fingers are crossed. On 6/27/13 12

Re: NOW() is stuck...

2013-06-27 Thread Nick Khamis
Just out of curiosity, is the hardware stationed, or traveling close to the speed of light (i.e., 18,000 miles per second)? Sorry I could not help it N. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: NOW() is stuck...

2013-06-27 Thread Andy Wallace
Ok, I appreciate the Einsteinian and Vonnegut humor... just wanted to say. Still have the problem though. 8-( On 6/27/13 9:51 AM, Nick Khamis wrote: Just out of curiosity, is the hardware stationed, or traveling close to the speed of light (i.e., 18,000 miles per second)? Sorry I could not help

NOW() is stuck...

2013-06-26 Thread Andy Wallace
We've been having some issues with one of our MySQL servers lately, and currently the dang thing is stuck. For at least the last hour, NOW() is returning the same value: mysql select now(); +-+ | now() | +-+ | 2013-06-26 02:27:14

RE: NOW() is stuck...

2013-06-26 Thread Rick James
To: mysql list Subject: NOW() is stuck... We've been having some issues with one of our MySQL servers lately, and currently the dang thing is stuck. For at least the last hour, NOW() is returning the same value: mysql select now(); +-+ | now

Re: NOW() is stuck...

2013-06-26 Thread John Meyer
Well, if you want to get unstuck in time, maybe you need to call Billy Pilgrim ;-) Andy Wallace wrote: We've been having some issues with one of our MySQL servers lately, and currently the dang thing is stuck. For at least the last hour, NOW() is returning the same value: mysql select now

Re: NOW() is stuck...

2013-06-26 Thread Eric Bergen
=1372296737; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)] select now(); select sleep(5); select now(); +-+ | now() | +-+ | 2013-06-26 21:32:17 | +-+ 1 row in set (0.00 sec) +--+ | sleep(5

ANN: Database Workbench 4.4.0, the multi-DBMS IDE now available!

2013-04-24 Thread Martijn Tonies
ANN: Database Workbench 4.4.0, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.0 Pro This release includes new features and fixes several bugs

ANN: Database Workbench 4.3.2, free Lite Editions now available!

2013-02-04 Thread Martijn Tonies
ANN: Database Workbench 4.3.2, free Lite Editions now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.3.2 Lite Today we are making the free Lite Editions available

ANN: Database Workbench 4.3.2, the multi-DBMS IDE now available!

2012-11-12 Thread Martijn Tonies
ANN: Database Workbench 4.3.2, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.3.2 Pro This release fixes several bugs as reported by the users

ANN: Database Workbench 4.3.1, free Lite Editions now available!

2012-09-25 Thread Martijn Tonies
ANN: Database Workbench 4.3.1, free Lite Editions now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.3.1 Lite Today we are making the free Lite Editions available

New Fast Server Now Available at GoGrid.com

2012-09-24 Thread Hiromichi Watari
Parallel Universe* is now available as part of Linux OS images at www.GoGrid.com. GoGrid.com is a dedicated/cloud server hosing site. -- *Parallel Universe is a new extension

ANN: Database Workbench 4.3.1, the multi-DBMS IDE now available!

2012-08-20 Thread Martijn Tonies
ANN: Database Workbench 4.3.1, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.3.1 Pro This release fixes a few issues with MySQL support. For more

ANN: Database Workbench 4.3.0, the multi-DBMS IDE now available!

2012-08-13 Thread Martijn Tonies
ANN: Database Workbench 4.3.0, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.3.0 Pro For more information, see http://www.upscene.com/go/?go

ANN: Database Workbench 4.2.4, free Lite Editions now available!

2012-06-01 Thread Martijn Tonies
ANN: Database Workbench 4.2.4, free Lite Editions now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.2.4 Pro Today we are making the free Lite Editions available

RE: engine is now innoDB instead of MyISAM.

2012-04-30 Thread Rick James
: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: Sunday, April 29, 2012 6:31 AM To: Brown, Charles Cc: mysql@lists.mysql.com Subject: RE: engine is now innoDB instead of MyISAM. Charles, I think going back to MyISAM as default is a good idea. All you have to do is: Export all

Re: engine is now innoDB instead of MyISAM.

2012-04-29 Thread Claudio Nanni
, Charles *Cc:* mysql@lists.mysql.com *Subject:* Re: engine is now innoDB instead of MyISAM. ** ** Charles, ** ** first, my opinion is that if you are paying Oracle you should get answers from them about this, and then of course is good to have a second opinion here

RE: engine is now innoDB instead of MyISAM.

2012-04-29 Thread Brown, Charles
Hello Claudio, Thanks for quick response and the whitepaper. What precipitated my research and questions is a complain I received from one of my developer that after following our MySQL Cluster migration, tables are now defaulting to innodb ( how can he tell) and performance is poor. I'm

Re: engine is now innoDB instead of MyISAM.

2012-04-29 Thread Reindl Harald
Am 29.04.2012 14:50, schrieb Brown: is a complain I received from one of my developer that after following our MySQL Cluster migration, tables are now defaulting to innodb (how can he tell) as already said: the builtin default has changed an you have to configure MyISAM as default

RE: engine is now innoDB instead of MyISAM.

2012-04-29 Thread Claudio Nanni
my.cnf on all SQL nodes .restart the cluster .reimport your dump , which should drop all Innodb tables I'm on a bus now I can't check better ;) Cheers Claudio On Apr 29, 2012 2:50 PM, Brown, Charles cbr...@bmi.com wrote: Hello Claudio, ** ** Thanks for quick response and the whitepaper

Re: engine is now innoDB instead of MyISAM.

2012-04-29 Thread Brown, Charles
Well said. Thanks so much. Sent from my iPhone On Apr 29, 2012, at 8:02 AM, Reindl Harald h.rei...@thelounge.net wrote: Am 29.04.2012 14:50, schrieb Brown: is a complain I received from one of my developer that after following our MySQL Cluster migration, tables are now defaulting

engine is now innoDB instead of MyISAM.

2012-04-28 Thread Brown, Charles
Hello all, We recently switched from MySQL community to Mysql clustered using Oracle supported MySQl. The problem is, during our testing phase, we observed the default engine is now innoDB instead of MyISAM. Any thoughts on that? We're not getting the performance that we expected - any

Re: engine is now innoDB instead of MyISAM.

2012-04-28 Thread Reindl Harald
Am 28.04.2012 09:00, schrieb Brown: We recently switched from MySQL community to Mysql clustered using Oracle supported MySQl. The problem is, during our testing phase, we observed the default engine is now innoDB instead of MyISAM. Any thoughts on that? We're not getting the performance

RE: engine is now innoDB instead of MyISAM.

2012-04-28 Thread Brown, Charles
Harald [mailto:h.rei...@thelounge.net] Sent: Saturday, April 28, 2012 3:01 AM To: mysql@lists.mysql.com Subject: Re: engine is now innoDB instead of MyISAM. Am 28.04.2012 09:00, schrieb Brown: We recently switched from MySQL community to Mysql clustered using Oracle supported MySQl. The problem

Re: engine is now innoDB instead of MyISAM.

2012-04-28 Thread Claudio Nanni
: Saturday, April 28, 2012 3:01 AM To: mysql@lists.mysql.com Subject: Re: engine is now innoDB instead of MyISAM. Am 28.04.2012 09:00, schrieb Brown: We recently switched from MySQL community to Mysql clustered using Oracle supported MySQl. The problem is, during our testing phase, we

Re: Database Workbench 4.2.3, the multi-DBMS IDE now available!

2012-03-26 Thread Martijn Tonies
Hello Daevid, Any plans to add sqlite to your list of supported DBs there? I develop Android and use LAMP as the server backend. Currently I use SQLYog as I have for like 10 years. But I would really like one GUI to work on both the android sqlite and the mysql backend since they usually

ANN: Database Workbench 4.2.3, the multi-DBMS IDE now available!

2012-03-23 Thread Martijn Tonies
ANN: Database Workbench 4.2.3, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.2.3 Pro For more information, see http://www.upscene.com/go/?go

RE: Database Workbench 4.2.3, the multi-DBMS IDE now available!

2012-03-23 Thread Daevid Vincent
. -Original Message- From: Martijn Tonies [mailto:m.ton...@upscene.com] Sent: Friday, March 23, 2012 2:10 AM To: mysql@lists.mysql.com; firebird-to...@yahoogroups.com Subject: ANN: Database Workbench 4.2.3, the multi-DBMS IDE now available! ANN: Database Workbench 4.2.3, the multi-DBMS IDE

ANN: Database Workbench 4.2.1, the multi-DBMS IDE now available!

2012-02-15 Thread Martijn Tonies
ANN: Database Workbench 4.2.1, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.2.1 Pro This release includes the FREE Lite versions for InterBase

Database Workbench 4.2.0, the multi-DBMS IDE now available!

2011-12-12 Thread Martijn Tonies
ANN: Database Workbench 4.2.0, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS Windows-based development tool: Database Workbench 4.2.0 Pro This release includes the FREE Lite versions for InterBase

Re: ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!

2011-08-18 Thread Martijn Tonies
Hi all, No SQLite support? http://www.sqlite.org/ Seems curious you wouldn't have this yet, especially given its popularity on both embedded systems and Android to say the least. Indeed, no native SQLite support. Lots of other systems are popular and not supported. The reason for this is

Re: ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!

2011-08-17 Thread Jan Steinman
Apparently Winblows-only. It sure would be nice if people would note platform requirements in their announcement, rather than forcing people to dig through their websites for such info. I guess I should know better; if it doesn't list platform requirements, the developer hasn't thought beyond

ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!

2011-08-16 Thread Martijn Tonies
ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.1.3 Pro This release includes the FREE Lite versions for InterBase, Firebird

RE: Database Workbench 4.1.3, the multi-DBMS IDE now available!

2011-08-16 Thread Daevid Vincent
To: mysql@lists.mysql.com Cc: firebird-to...@yahoogroups.com Subject: ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available! ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular

Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?

2011-06-06 Thread Johan De Meersman
I haven't bothered to look for the bug, but it seems to me to be quite reasonable default behaviour to lock the whole lot when you're dumping transactional tables - it ensures you dump all tables from the same consistent view. I would rather take this up with the ZRM people - it should just

Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?

2011-06-06 Thread agd85
On Mon, 06 Jun 2011 12:44 +0200, Johan De Meersman vegiv...@tuxera.be wrote: I haven't bothered to look for the bug, but it seems to me to be quite reasonable default behaviour to lock the whole lot when you're dumping transactional tables - it ensures you dump all tables from the same

Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?

2011-06-06 Thread Johan De Meersman
- Original Message - From: ag...@airpost.net Excluding 'performance_schema' appears to eliminate the error. And it seems does NOT cause a reliability-of-the-backup problem. Hah, no, backing that up is utterly pointless. Never noticed it doing that. It's basically a virtual schema

Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?

2011-06-06 Thread agd85
On Mon, 06 Jun 2011 18:54 +0200, Johan De Meersman vegiv...@tuxera.be wrote: Excluding 'performance_schema' appears to eliminate the error. And it seems does NOT cause a reliability-of-the-backup problem. Hah, no, backing that up is utterly pointless. that's a useful/final confirmation.

upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?

2011-06-05 Thread agd85
i use ZRM to do backups of my databases. with v5.1.x, this works fine, mysql-zrm-scheduler --now --backup-set manual --backup-level 0 to execute a manual backup. i recently upgraded from v5.1.x - v5.5.12, mysqladmin -V mysqladmin Ver 8.42 Distrib 5.5.12, for Linux on i686 now, at exec

Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?

2011-06-05 Thread Reindl Harald
have you checked you permissions-table if all privileges are active for root and have you started ymsql_upgrade after all updates? Am 05.06.2011 22:20, schrieb ag...@airpost.net: i use ZRM to do backups of my databases. with v5.1.x, this works fine, mysql-zrm-scheduler --now --backup-set

Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?

2011-06-05 Thread agd85
hi, On Sun, 05 Jun 2011 22:24 +0200, Reindl Harald h.rei...@thelounge.net wrote: have you checked you permissions-table if all privileges are active for root i've got, mysql show grants for 'root'@'localhost';

Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?

2011-06-05 Thread Reindl Harald
the grant statements does nobody interest maybe use phpmyadmin for a clearer display mysql select * from mysql.user where user='root' limit 1;

Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?

2011-06-05 Thread agd85
fwiw, others are seeing this. e.g., in addition to the two bugs i'd already referenced, http://www.directadmin.com/forum/showthread.php?p=202053 and one http://qa.lampcms.com/q122897/Can-t-backup-mysql-table-with-mysqldump-SELECT-LOCK-TABL-command claims a solution Add --skip-add-locks to

Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?

2011-06-05 Thread Reindl Harald
hm - bad i would use a replication slave and stop him for consistent backups because dumb locks are not really a good solution independent if this works normally Am 05.06.2011 23:26, schrieb ag...@airpost.net: fwiw, others are seeing this. e.g., in addition to the two bugs i'd already

Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?

2011-06-05 Thread Reindl Harald
BTW WHY is everybody ansering to the list AND the author of the last post? this reults in get every message twice :-( Am 05.06.2011 23:26, schrieb ag...@airpost.net: fwiw, others are seeing this. e.g., in addition to the two bugs i'd already referenced,

Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?

2011-06-05 Thread agd85
On Sun, 05 Jun 2011 23:30 +0200, Reindl Harald h.rei...@thelounge.net wrote: BTW WHY is everybody ansering to the list AND the author of the last post? this reults in get every message twice :-( Reply - sends to ONLY the From == h.rei...@thelounge.net Reply to all sends to BOTH the From ==

Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?

2011-06-05 Thread agd85
On Sun, 05 Jun 2011 23:29 +0200, Reindl Harald h.rei...@thelounge.net wrote: i would use a replication slave and stop him for consistent backups because dumb locks are not really a good solution independent if this works normally unfortunately, i have no idea what that means. something's

Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?

2011-06-05 Thread Reindl Harald
Am 05.06.2011 23:49, schrieb ag...@airpost.net: On Sun, 05 Jun 2011 23:29 +0200, Reindl Harald h.rei...@thelounge.net wrote: i would use a replication slave and stop him for consistent backups because dumb locks are not really a good solution independent if this works normally

Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?

2011-06-05 Thread agd85
i still have no idea why this is necessary. there seems to be a but, problem, misconfiguration, etc. wouldn't it make some sense to try to FIX it, rather than setting up a completely different server? perhaps someone with an idea of the problem and its solution will be able to chime in. --

Re: upgraded from 5.1-5.5. now getting a mysqldump ERROR 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES. a bug or my config?

2011-06-05 Thread Reindl Harald
Am 05.06.2011 23:55, schrieb ag...@airpost.net: i still have no idea why this is necessary. take it or not it is a professional solution which works for databses with 20 GB every day here with rsync without interrupt/lock mysqld a second and it is much faster there seems to be a but,

ANN: Database Workbench 4.1.2, the multi-DBMS IDE now available!

2011-03-30 Thread Martijn Tonies
ANN: Database Workbench 4.1.2, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.1.2 Pro This release includes the FREE Lite versions for InterBase, Firebird

MySQL Enterprise support now at Oracle?

2011-03-10 Thread Jim McNeely
Wow! We paid for MySQL enterprise plus enterprise support back in the good old days before ORACLE bought MySQL. I just sacrificed the sacred chicken and sprinkled the blood around my computer and went to sign up for support at support.oracle.com. After wading through the crappy Flash interface

Re: MySQL Enterprise support now at Oracle?

2011-03-10 Thread Jim McNeely
Shawn Green works for Oracle and has been very helpful, and I am happy to eat a little bit of shoe leather! Thanks Shawn! Jim On Mar 10, 2011, at 11:11 AM, Jim McNeely wrote: Wow! We paid for MySQL enterprise plus enterprise support back in the good old days before ORACLE bought MySQL. I

Re: MySQL Enterprise support now at Oracle?

2011-03-10 Thread David Giragosian
On Thu, Mar 10, 2011 at 5:05 PM, Jim McNeely j...@newcenturydata.com wrote: Shawn Green works for Oracle and has been very helpful, and I am happy to eat a little bit of shoe leather! Thanks Shawn! Jim Check the archives for Shawn's posts. IMNSHO, they are unparalleled in clarity and

ANN: Database Workbench 4.1.1, the multi-DBMS IDE now available!

2011-02-16 Thread Martijn Tonies
ANN: Database Workbench 4.1.1, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.1.1 Pro This release includes the FREE Lite versions for InterBase, Firebird

ANN: Database Workbench 4.1.0, the multi-DBMS IDE now available!

2010-12-24 Thread Martijn Tonies
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.1.0 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. Version 4 introduced full Unicode support, 4.1.0 adds new

Register now for Surge 2010

2010-08-02 Thread Jason Dixon
environments; the lessons learned from failure and how to re-engineer your way to a successful, highly scalable Internet architecture. The conference takes place at the Tremont Grand Historic Venue on Sept 30 and Oct 1, 2010 in Baltimore, MD. Register now to enjoy the Early Bird discount and guarantee your

ANN: Database Workbench 4.0.3, the multi-DBMS IDE now available!

2010-07-13 Thread Martijn Tonies
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.0.3 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. Version 4 introduced full Unicode support, 4.0.3 fixes some

ANN: New version of Database Workbench, the multi-DBMS IDE now available!

2010-04-22 Thread Martijn Tonies
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.0 Pro With this version we're reached a milestone: Database Workbench is now fully Unicode enabled and offers new tools to increase your productivity

What's she doing now

2009-11-29 Thread Kory Wheatley
Lincoln feared that the issue of slavery would weaken the northern war effort. Many men throughout the north would fight to save the Union. They would not fight to free the slaves. Although it is often confused with common cold, influenza is a much more severe disease!

MyQuery 3.0 Alpha available now

2009-07-30 Thread Anders Karlsson
Sorry for crossposting, but I felt this might be of intrerest to both lists. MyQuery 3.0 is an interactive Windows GUI based query tool for MySQL. Among the features are - Support running scripts from a position, up to a position of just a single query in the script, allowing you to run up to

Re: Copy 70GB ibdata, etc. and server won't start now

2009-07-15 Thread Todd Lyons
On Tue, Jul 14, 2009 at 2:14 AM, Marcus Bointonmar...@synchromedia.co.uk wrote: You should take a look at Percona's xtrabackup utility to do this. It takes a clean snapshot of an innodb database that can be restored on a target machine in a few minutes, though it does crash recovery at backup

Re: Re: Copy 70GB ibdata, etc. and server won't start now (Action Required)

2009-07-15 Thread Todd Lyons
70GB ibdata, etc. and server won't start now, you are not currently on my email Guest List. I'll be more likely to see your email and future messages if you are on my priority Guest List. Click here to be put directly on my Guest List Thank you, gurunatha...@gmail.com About this Notice

Re: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Marcus Bointon
You should take a look at Percona's xtrabackup utility to do this. It takes a clean snapshot of an innodb database that can be restored on a target machine in a few minutes, though it does crash recovery at backup time which can take a while. Marcus -- MySQL General Mailing List For list

RE: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Daevid Vincent
-Original Message- From: Gary Smith [mailto:g...@primeexalia.com] Sent: Monday, July 13, 2009 8:54 PM To: Daevid Vincent; mysql@lists.mysql.com Subject: RE: Copy 70GB ibdata, etc. and server won't start now InnoDB: Your database may be corrupt or you may have copied

Re: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Johnny Withers
; mysql@lists.mysql.com Subject: RE: Copy 70GB ibdata, etc. and server won't start now InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html InnoDB

RE: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Gary Smith
, the startup recovery flags might be your best bet. From: Daevid Vincent [dae...@daevid.com] Sent: Tuesday, July 14, 2009 12:23 PM To: mysql@lists.mysql.com Cc: Gary Smith Subject: RE: Copy 70GB ibdata, etc. and server won't start now -Original Message

RE: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Gary Smith
ibdata, etc. and server won't start now Why do the dates on the log files differ by almost a month between Old and New? On Tue, Jul 14, 2009 at 2:23 PM, Daevid Vincent dae...@daevid.commailto:dae...@daevid.com wrote: -Original Message- From: Gary Smith [mailto:g...@primeexalia.commailto:g

RE: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Daevid Vincent
_ From: Johnny Withers [mailto:joh...@pixelated.net] Sent: Tuesday, July 14, 2009 1:41 PM To: Daevid Vincent Cc: mysql@lists.mysql.com; Gary Smith Subject: Re: Copy 70GB ibdata, etc. and server won't start now Why do the dates on the log files differ by almost a month between Old

RE: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Daevid Vincent
Smith [mailto:g...@primeexalia.com] Sent: Tuesday, July 14, 2009 2:11 PM To: Johnny Withers; Daevid Vincent Cc: mysql@lists.mysql.com Subject: RE: Copy 70GB ibdata, etc. and server won't start now Johnny, I'm less worried

Re: Copy 70GB ibdata, etc. and server won't start now

2009-07-14 Thread Carlos Proal
14, 2009 2:11 PM To: Johnny Withers; Daevid Vincent Cc: mysql@lists.mysql.com Subject: RE: Copy 70GB ibdata, etc. and server won't start now Johnny, I'm less worried about the month in between than the fact that all of the dates for the files on his

  1   2   3   4   5   >