Gotit Thnx ;)
You have set innodb_force_recovery to 3 which means , do not run transaction
rollbacks after recovery.
Just try removing the innodb_force_recovery from my.cnf file or change the
value
More info : http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html
--Praj
On Wed, 5 Apr 20
Prasanna Raj <[EMAIL PROTECTED]> wrote:
Gotit Thnx ;)
You have set innodb_force_recovery to 3 which means , do not run transaction
rollbacks after recovery.
http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html
1 (SRV_FORCE_IGNORE_CORRUPT)
2 (SRV_FORCE_NO_BACKGROUND)
3 (SRV_FORCE_NO_
john simms wrote:
Hello MySQL!
Hello User!
At last! It has taken a couple of days - but, I have, at last, found you.
*hides* haha, you think so ...
You have invaded my computer without being requested, or invited.
Did i? Man, my schedules are really weird nowadays.
Whenever I try to access
NiCK Song wrote:
Hi, experts
How can I make mysql database users password with expire date?
Does mysql can do it?
--
NiCK
Set a DATE field with the time of expire.
Then do something like
SELECT * FROM users WHERE datefield_of_insert > CURDATE();
HTH
Barry
--
Smileys rule (cX.x)C --o
Hello,
Is there a way to enable the Slow Query Log on the fly without having to
restart mysqld
Regards,
Marc.
On Wed, 2006-04-05 at 11:38 +0200, Mechain Marc wrote:
> Is there a way to enable the Slow Query Log on the fly without having to
> restart mysqld
No.
Petr
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi ,
Yesterday our main database was dropped by mystake.
This has never happened before.
Furtunately we had a daily backup performed with mysqldump at about
06:00 am that day.
As the problem ocurred at about 12:00am we had to restore the
transactions from the binary log ( we have several bina
Hi,
Thank you for your answer.
But is there a chance to be able to do it one day?
I think it could be a nice feature.
Marc.
-Message d'origine-
De : Petr Chardin [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 5 avril 2006 13:06
À : Mechain Marc
Cc : MySQL
Objet : Re: Slow query log
On We
Hi All
Correct me if iam wrong
You might have run the create table syntax from hrdb database .So it gives you
the create table also when you do mysqlbinlog .
CREATE TABLE intra.table1 AS SELECT * FROM table2 , which
means you are under hrdb database.
Else you can use below syntax which won
Mechain Marc wrote:
Hi,
Thank you for your answer.
But is there a chance to be able to do it one day?
I think it could be a nice feature.
Marc.
That should be asked to one of the devs.
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General
Hi, please see comments below..
thank you
Mauricio
On Wed, 2006-04-05 at 09:02, Prasanna Raj wrote:
> Hi All
>
> Correct me if iam wrong
>
> You might have run the create table syntax from hrdb database .So it gives
> you the create table also when you do mysqlbinlog .
>
> CREATE TABLE intr
2006/4/5, Mechain Marc <[EMAIL PROTECTED]>:
> Hi,
>
> Thank you for your answer.
> But is there a chance to be able to do it one day?
> I think it could be a nice feature.
>
You still have the option to sponsor that feature ;-D
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
You must be able to run it as a single call, or as a single TRANSACTION?
What do you mean by "single call"? One PHP command? One command on
the commandline? one script run?
-Sheeri
On 4/4/06, Ed Reed <[EMAIL PROTECTED]> wrote:
> Thanks for the quick reply Peter. Unfortunately, this is all leg
"NiCK Song" <[EMAIL PROTECTED]> wrote on 04/04/2006 11:05:57 PM:
> Hi, experts
>
> How can I make mysql database users password with expire date?
> Does mysql can do it?
>
> --
> NiCK
>
Sorry!! MySQL does not auto-expire any user accounts. You will need to
script something to do that manuall
WOW!!! THAT WAS AWESOME!!!
Thanks a lot Peter. Ok, so what is SUM(1)? How is it able to do this? And where
can I learn more about it?
Thanks again.
>>> Peter Brawley <[EMAIL PROTECTED]> 4/4/06 10:13:00 PM >>>
Ed,e: Thanks for the quick reply Peter. Unfortunately, this is all legacy stuff
th
Hi Ed,
Count(1) works just as well. Sum(1) just adds 1 for each row so it's
logically equivalent.
PB
-
Ed Reed wrote:
WOW!!! THAT WAS AWESOME!!!
Thanks a lot Peter. Ok, so what is SUM(1)? How is it able to do this? And where can I learn more about it?
Thanks again.
On 4/5/06, NiCK Song <[EMAIL PROTECTED]> wrote:
> Hi, experts
>
> How can I make mysql database users password with expire date?
> Does mysql can do it?
>
> --
> NiCK
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[
Hi,
What command used to check table size and database size?
thanks
-
Blab-away for as little as 1¢/min. Make PC-to-Phone Calls using Yahoo!
Messenger with Voice.
At 2:15 pm -0700 5/4/06, Ravi Kumar wrote:
>What command used to check table size and database size?
For table size:
http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html
I imagine (though I don't know for sure) that you can get the same info from
the information_schema database that wa
Thank you MySQL Cluster, for ignoring my information request after
submitting about a year and a half ago. I was told in email that I was
supposed to be contacted, that never happened. Thank you for automatically
signing me up for all sorts of MySQL mailinglists for seminars that I do
not want to a
It will be written in binary file but when you do
mysqlbinlog -d hrdb --start-date-time="2006-04-04 06:00:00" > src.sql
It wont be loaded in src.sql
--Praj
On Wed, 05 Apr 2006 09:53:34 -0300
Mauricio Pellegrini <[EMAIL PROTECTED]> wrote:
> Hi, please see comments below..
>
> thank you
> Ma
Many thanks for your reply Shawn - I have some comments below.
> Hello,
>
> I need to be able to sum over distinct values but I can't seem to do it
> unless I use sub-selects (which I want to avoid doing).
>
> To see what I mean, I've constructed a toy DB:
>
> DROP TABLE IF EXISTS spell;
> CREA
Hello,
I have a mysql data bcp file ( using select into outfile ) from a table
in mysql database. I have a similar table existing in a sybase database.
I need to bcp in the mysql data file into sybase. Can anyone help me on
how to go about the same ?
Thanks in advance,
Abdul.
___
23 matches
Mail list logo