On Dec 9, 2007 9:17 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
>
> On Dec 9, 2007 10:53 AM, David Scott <[EMAIL PROTECTED]> wrote:
> > I have a field in a DB that contains something like
> > "lvlscore4:4493,lvlscore5:3232,lvlscore6:6128"
> > I need to select all records where the "lvlscore5:" is gr
Hello All,
I set up replication between 2 servers recently. I just need one db to be
replicated and the SHOW SLAVE STATUS shows this:
Relay_Master_Log_File: gyana01-bin.02
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB: tallydb,tallydb
Now the problem is that there is anoth
On Dec 9, 2007 10:53 AM, David Scott <[EMAIL PROTECTED]> wrote:
> I have a field in a DB that contains something like
> "lvlscore4:4493,lvlscore5:3232,lvlscore6:6128"
> I need to select all records where the "lvlscore5:" is greater than 3000.
> I think this can be done using REGEXP but I have read
regex discussion are a little outside of the scope of this list, but I
will offer an opinion: You can't do math, no matter how simple, in
regular expressions. I have seen many try and fail.
While I am sure there are circumstances around how that data got that
way, what you really need to do is u
Hmm..,
I thought the temp tables were created in the temp directory.
What version of MySQL are you using?
Perhaps you can temporarily increase the user's hard_limit, and not increase
the soft_limit. When they have finished recovering, you can reset the
hard_limit.
Or perhaps it is possible to c
I have a field in a DB that contains something like
"lvlscore4:4493,lvlscore5:3232,lvlscore6:6128"
I need to select all records where the "lvlscore5:" is greater than 3000.
I think this can be done using REGEXP but I have read the docs and am non
the wiser for it. Can anyone point me in the right d
I won't convert thread style, so, i'm top-posting :)
All this would be great if it worked. The main problem is that
temporary directory option for mysqld iS NOT USED while doing
table repair. All files while repairing tables are placed
in the same directoty with the same owner and group as the or
Hi,
I installed MysqL 4.1.22 on windows vista. When I try to run any command in
Mysql/MySQL server 4.1/bin path it gives me the following error :
C:\Program Files\MySQL\MySQL Server 4.1\bin>mysqld-max-nt --standalone
Can't start server: Bind on TCP/IP port: Invalid argument
071207 22:50:57 [ERRO