On Apr 29, 2009, at 11:29 AM, Antonio PHP wrote:
This is MySQL data structure. - I underlined where it causes the error
message. (datetime)
`id_Company` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
`Revenue` mediumint(6) NO
I am trying to compile mysql 5.4 for windows on fedora using the cross
compiler and I am stuck with this error: checking for termcap functions
library... configure: error: No curses/termcap library found.
I have looked and saw that I should install ncurses-devel
(ncurses-devel-5.7-2.20090207.fc
Hi Mark,
I am all set now, The log said it could not find the sql file, so I
put it in /tmp and hard coded the path to /tmp/cloudsql.sql and it
works now!
Weird because I had used ~/cloudsql.sql and /root/cloudsql.sql as
paths too
Thank you so much for your help! John and Andy too!
OK, I have done this:
[r...@server1 ~]# mysqld_safe
A mysqld process already exists
[r...@server1 ~]# /etc/init.d/mysqld stop
Stopping MySQL:[ OK ]
[r...@server1 ~]# mysqld_safe --init-file=~/cloudsql.sql
Starting mysqld daemon with databases from /v
i dont think that the init.d script will accept the argument.
you need to run /usr/bin/mysqld_safe --init-file=clouds.sql &
(or whatever the path to mysqld_safe is)
2009/4/29 Jason Todd Slack-Moehrle
> Hi Guys,
>
> i am still lost here:
>
> GRANT ALL ON mysql.* TO 'root'@'localhost' IDENTIFIE
At 09:49 AM 4/29/2009, you wrote:
Hi
I have a table that stores huge rows in 15 years, now we have to do some
analysis about these row in Time dimension.To gain performance,at begining,
i've extrait the data according to years from my DB to build my fact table.
But since I have 15 fact tables,
Hi Guys,
i am still lost here:
GRANT ALL ON mysql.* TO 'root'@'localhost' IDENTIFIED BY 'XXX';
GRANT ALL ON mysql.* TO 'root'@'173.8.172.53' IDENTIFIED BY 'XXX';
FLUSH PRIVILEGES;
Here is the command that I am executing:
[r...@server1 ~]# /etc/init.d/mysqld restart --init-file=~/cloudsql.sql
I think what's really being sought after, here is clustering.
--C
Eric Bergen wrote:
Dual master replication can be either dual master dual write or dual
master single writer. The latter is preferred. In this configuration
replication is connected in both directions but clients only ever
conne
Thanks. NOW() and php date(); work for my newly created test tables, but it
doesn't work for my working table. I can't insert date, time or now()
into my old table (which is as below).
For now, I'm using MySQL auto timestamp ('Updated' field), but I need to
insert date when the data was created!
Dual master replication can be either dual master dual write or dual
master single writer. The latter is preferred. In this configuration
replication is connected in both directions but clients only ever
connect to one master at a time. It's just as safe as master -> slave
replication if you handle
Lin,
I've had mixes results but you might have better success. As John mentioned,
there are a couple factors that you need to take into account.
How much data are you talking about (physical size and number of rows). I know
you say 15 years of data but is that 100's of millions of rows?
Giv
Hello Lin
What tools are you using to model your data and build your OLAP cube? If I
were building a cube which required data from 15 fact tables which only
differed in that they contained a different years data, I would model the
15 tables so they appeared as one using something like Cognos Frame
> From: haidarpes...@gmail.com
> To: mysql@lists.mysql.com
> Subject: select data from two table and will sort by price in second table
> Date: Wed, 29 Apr 2009 10:46:48 +0700
>
> dear all,
> please help us mien for select data from two table with details as follows:
>
> primery tabel : bookcat
Hi
I have a table that stores huge rows in 15 years, now we have to do some
analysis about these row in Time dimension.To gain performance,at begining,
i've extrait the data according to years from my DB to build my fact table.
But since I have 15 fact tables, that complicate my olap cube.Today,
Yes, every user has select privileges on information_schema but only see
objects they have permissions for anyway so why would you want to disable
this?
>From the MySQL 5.0 Manual: "Each MySQL user has the right to access these
tables, but can see only the rows in the tables that correspond to obj
To me the update seems fairly pointless, unless there are other users with
the name 'root' in addition to the the two specifiied in the grant
commands.
Specifiy the full path in the '--init-file=' option.
Issue the Flush Privileges command after the two GRANT statements not in
between them.
This
Hmm, seems indeed every non-privileged user can access it:
Your MySQL connection id is 13949
Server version: 5.1.34 FreeBSD port: mysql-server-5.1.34
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
mysql>
mysql>
mysql> show databases;
++
| Dat
Hi,
try putting the full path to the init file, and also try putting
the "update" command after the two grant commands (if you put it first
and the user r...@173.8.172.53 didn't already exist then the password
will not be set for that user) and put a flush privileges as the last
line ,
Seems I was in error suggesting a file limit issue; which is why I wisely
left it to to, Jörg. :)
Ok, next step, then:
ERRORS
pthread_create() will fail if:
[EAGAIN] The system lacked the necessary resources to create
another thread, or the system-imposed limit on the
total nu
Hi, I'm trying to debug a stored procedure. This SP has a few queries and
also call another SP. I'm starting mysql with the --log=my_queries.log but I
found that mysql only log the "call my_sp(param1, param2)" but don't log any
query inside my_sp neither log the nested SP call. By the way, how can
20 matches
Mail list logo
