Hello Nicu,
On 4/6/2014 1:51 AM, Nicolae Marasoiu wrote:
Hi,
A directory in datadir does not show up as database. Please help!
drwx-- 2 mysql root 24576 oct 9 00:34 *opendental*
drwx-- 2 mysql mysql 4096 mar 22 19:54 performance_schema
drwx-- 2 mysql root 4096 mar 22
Hello Christophe,
On 3/23/2014 2:34 PM, Christophe wrote:
Hi all,
Le 20/03/2014 13:20, Christophe a écrit :
Hi Morgan, Harald, and all,
Thanks for the answers.
While reading your answers, I realize one more time this problem does
not seem so obvious ... That's why I asked ;) .
Beyond the
Hi David.
On 3/21/2014 1:42 PM, David Lerer wrote:
Frequently, we import a production dump that contains only 1 or 2 databases into one of our QA instances
that contains many more databases. (i.e. database being a schema or a
catalogue).
At the beginning of the import script, we first drop
Hello Christophe,
On 3/21/2014 4:47 PM, Christophe wrote:
Hi list,
I'd like your advice, (one more time ;) ) about this case :
The context is :
A huge database using InnoDB engine from filling about several years
(without possible shrinking, as I've seen, except dropping all databases
to
On 3/19/2014 7:27 PM, Mogens Melander wrote:
G'morning
A function in a where equals what ?
On Wed, March 19, 2014 15:05, Morgan Tocker wrote:
Hi Christophe,
Considering the following simple query :
SELECT * FROM Status WHERE DWProcessed = 0 AND PreviousStatus NOT IN
('PENDING',
Hello Brad,
On 3/17/2014 5:50 PM, Brad Heller wrote:
Hey Morgan,
We actually only have about 60 tables in that database. I've tried
increasing the cache and open tables limits and get the same behavior.
mysql select @@table_definition_cache, @@table_open_cache,
@@innodb_file_per_table,
On 2/25/2014 9:55 PM, Zhigang Zhang wrote:
How to make multiple master replicate to single slave in mysql?
Tell me some approaches?
Put your masters in a replication ring, hang a slave from one of them
(as suggested by Mr. Van der Westhuizen)
Use an external product, such as
Hello Femitha,
On 2/17/2014 12:16 AM, Femitha Majeed wrote:
Hi,
Please help me by answering this question.
Currently we've a database link between Oracle database and MySQL database using
mysql-connector-odbc-5.1.8, will this connector work if I change my MySQL to
enterprise edition ?
Thank
Hi Jennifer,
On 2/17/2014 3:11 PM, Jennifer wrote:
CREATE TEMPORARY TABLE temp_ip AS
(SELECT `ip`
FROM `ip_addresses`
WHERE (`time_stamp` BETWEEN date_add( CURDATE(), INTERVAL -1 DAY ) AND
CURDATE() - INTERVAL 1 SECOND)
AND TRIM(`referrer`) LIKE ''
GROUP BY `ip`
HAVING
Hello Neubyr,
On 1/29/2014 7:16 PM, neubyr wrote:
I am trying to understand MySQL statement based replication with LOAD DATA
LOCAL INFILE statement'.
According to manual -
https://dev.mysql.com/doc/refman/5.0/en/replication-features-load.html -
LOAD DATA LOCAL INFILE is replicated as LOAD DATA
Hello Larry,
On 1/13/2014 2:43 AM, Peter Brawley wrote:
On 2014-01-12 9:13 PM, Larry Martell wrote:
On Sun, Jan 12, 2014 at 2:47 PM, Peter Brawley
peter.braw...@earthlink.net wrote:
On 2014-01-12 1:17 PM, Larry Martell wrote:
I've been asked to do something that I do not think is possible
Hello Érico,
On 1/13/2014 1:49 PM, Érico wrote:
Hi
didn't work
look ... isn't this something related to this :
are you using localhost or 127.0.0.1 in the web-application
root@localhost != root@127.0.0.1 = different users
localhost: Unix-Socket
127.0.0.1: TCP
...
since I am not able to
Hello Reindl,
On 1/13/2014 3:01 PM, Reindl Harald wrote:
*your application* is connecting to mysql
*your application* is using a hostname
*your application* *may* use 127.0.0.1
*your application* should use localhost to *connect to the databse*
*your application* can only use TCP *if there is*
Hello Sabika,
On 12/4/2013 2:56 PM, Sabika Makhdoom wrote:
I would from 5.1.40 to 5.5.8 first and then to 5.6
Why 5.5.8? Our current release is 5.5.35. 5.5.8 is an ancient release
of 5.5 and represents the very first GA release of 5.5 . There have been
27 additional releases (each with
On 6/10/2010 4:38 PM, Steven Staples wrote:
Ok, I have done it before, where I have used the AS result in an ORDER BY,
but now, I can't figure out why I can't use it in a WHERE clause?
SELECT `email`, (SELECT CONCAT(`phone_pref`, '-', `phone_suff`) FROM `pnums`
WHERE `id`=`usertable`.`id`) AS
On 6/10/2010 6:38 PM, Lola Lee Beno wrote:
I'm trying to create a database, using code generated by MySQL Workbench
5.2.21 RC. I'm running into this strange issue:
ERROR 1005 (HY000): Can't create table 'nxdb.#sql-a6_3b' (errno: 150)
Database was created using utf8 as charset, collation
On 6/10/2010 10:16 PM, Andy wrote:
Hello all,
I am new to MySQL and am exploring the possibility of using it for my work.
I have about ~300,000 e-books, each about 100 pages long. I am first going
to extract each chapter from each e-book and then basically store an e-book
as a collection of
101 - 117 of 117 matches
Mail list logo