Useses of MYSQL workbench

Problems with connections pool in Tomcat 6.0.18 6.0.20 + MySQL 5.1 + mysql-connector 5.1.x
January 27, 2011 01:47:26 AM
Hi all, I have a problem with: Tomcat 6.0.x + MySQL 5.1 + mysql-connector.5.1.x And I test with Ubuntu 10.04, Windows 2003 and Mac OSX 10.6.6 I configured the connection in tomcat like this: <Resource driverClassName="com.mysql.jdbc.Driver" …

MySql overload: auth mysql + cache?
March 24, 2011 07:42:41 AM
Hello all, I'm facing a major issue on one of my DB after an application upgrade that switch to AuthMysql for a subversion server authentication My DB server is overloaded by tons of: > SELECT user.unix_pw, length(user.unix_pw) FROM user,…

Mysql Admin
December 10, 2010 05:35:22 AM
I'm trying to administer the mysql database on some servers using puppet. When I'm done, I want: *) The DB to have a root password. *) I want to define a few databases, users and grants. Any advice what to use? I want to use the…

migration from mysql
August 24, 2010 09:42:45 AM
Hello there, I am new to Riak, but we are thinking of migrating some of our data from mysql into it and running with it for some of our website. Temporarily we would need to keep the data in sync whilst we make other changes. So for some time we…

Re: mysql apache md5
March 8, 2011 06:21:21 PM
On 3/8/2011 5:47 PM, Noel Butler wrote: > > Incidentally, when will httpd accept sha2? Planned in 2.2.x? or only 2.3/4.x ? We won't implement the hash itself... so it would likely originate from tighter integration with openssl (which…

moving from mysql
October 16, 2010 03:09:08 PM
Hi there, I am thinking of moving from mysql to sqlite3 and want to know if there are any gotchas? My current situation is a web based school booking system using a mysql database with four tables. The busiest of the tables may have 6000 rows…

Re: Mysql to Postgresql
February 24, 2011 06:50:59 AM
2011/2/22 Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>: > Dear all, > > Today I need to back up a mysql database and restore in Postgresql database > but I don't know how to achieve this accurately. In addition to other…

storeconfig / mysql
December 6, 2010 12:18:28 AM
hello! centos 5.5, puppet 2.6.4, storeconfig, mysql, about150 clients. time to time i recive following error: Puppet (err): Could not retrieve catalog from remote server: Error 400 on SERVER: Mysql::Error: MySQL server has gone away how can i…

Re: mysql apache md5
March 7, 2011 05:32:47 PM
On Mon, 2011-03-07 at 13:51 +0100, Johan De Meersman wrote: > Umm... I'm no crypto guru, but I've never heard of MD5 having variants, let alone a salt. MD5 is MD5 is MD5. APR, incidentally, is the Apache Runtime, afaik - part of the build kit…

Tomcat 7 and mySQL
September 19, 2010 01:26:08 AM
Hello, I try to connect the Tomacat 7 to a mySQL. My server.xml looks like that <?xml version='1.0' encoding='utf-8'?> <!-- Licensed to the Apache Software Foundation (ASF) under one or more contributor license…

Re: mysql apache md5
March 8, 2011 03:53:37 PM
From the peanut gallery: Oh dear. The password encryption is called "MD5 based crypt" (as opposed to the DES based crypt used in the early days by various systems). "MD5 based crypt" is now standard with modern systems. There's nothing…

metastore with mysql
February 23, 2011 06:29:37 AM
Hello, I am running hive with a hadoop mini cluster and want to switch to mysql as a metastore because I need multiple connections at same time (not sure if this will work at all). I tried the local metastore config. The DB and two tables in mysql…

mysql 2 pg script...
February 18, 2011 11:51:49 PM
hi all, I need to load mysql dump to postgre 8.3 . Is there a script to do that? I hoped to use my2pg.pl , but couldn't find it. It looks like it's not a part of /contrib in debian lenny. what shoud I use for 8.3? thanks.

Re: verify db with mysql
January 5, 2011 05:47:47 PM
On Tuesday, 14th of December 2010, 20:09:26 Wietse Venema wrote: <snip> > > Yes, I have tested that and it worked without problems. If you > > are interested then I will send you the logs of that test. > > Yes, it would…

connecting jsp with mysql
February 21, 2011 07:55:44 AM
Hi, I am having difficulty in connecting jsp and mysql using Tomcat 7.0 . I downloaded jdbc driver "mysql-connector-java-5.1.15-bin.jar" and placed it in two locations: - CATALINE_HOME\lib - C:\Program Files\Apache Software…

Mysql to Postgresql
February 22, 2011 03:17:43 AM
Dear all, Today I need to back up a mysql database and restore in Postgresql database but I don't know how to achieve this accurately. Can anyone kindly describe me the way to do this. Thanks & best Regards, Adarsh Sharma

Trouble using mysql metastore
March 2, 2011 08:16:13 AM
I've checked the mysql connection with a separate java file with the same string. Also, I've checked the code works by running it against the original derby metastore. Thanks, Ajo. Some of the variables set: javax.jdo.option.ConnectionURL =…

Batch Import from mysql?
September 28, 2010 08:15:41 PM
Hey, I need to migrate data stored in mysql to jackrabbit. I'm using JCR API (Node.addNode().. etc). And it takes many hours to do so. Is there a way to speed things up? I was wondering if there is a way to directly output JCR files and copy…

Migrating from Mysql to Cassandra
September 28, 2010 10:33:30 AM
Hi I am involving in migrating our database Mysql to Cassandra. After Google about Cassandra database i feel following are some issues we need to find the solutions. Suggest me if my analysis is wrong or for my doubts. *1) Projecting all the…

Using mySQL to emulate Cassandra
November 28, 2010 02:29:48 AM
As our launch date approaches, I am getting increasingly nervous about Cassandra tuning. It is a mysterious black art that I haven't mastered even at the low usages that we have now. I know of a few more things I can do to improve things, but how…