Thanks to all for this reply.
regards
anandkl
On 6/17/07, Geoffroy Cogniaux <[EMAIL PROTECTED]> wrote:
2007/6/16, ViSolve DB Team <[EMAIL PROTECTED]>:
> -- this itself takes consistent backup. mysqldump utility by default
locks
> the table.
yes with --lock-tables option which do a "FLUSH TABL
Ok... this error has just started popping up in my .err log file...
070618 14:31:10 InnoDB: ERROR: the age of the last checkpoint is
237821842,
InnoDB: which exceeds the log group capacity 237813351.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log
Good day,
Someone gives me several limitations of DRBD For MySQL? Here is the list,
1. Idle resource – secondary host sits idle, wasted investment
2. Failover is not instant, nor transparent
-"Cold standby" failover
3. Recovery requires time to start / recover database
4. Recovery process
I'm out of ideas right now. I don't actually use mysqldump that much and have
never had this happen. Hopefully someone else on the mailing list can help, or
perhaps you can try #mysql on Freenode IRC.
Baron
Hartleigh Burton wrote:
No there is no indication of that at all. The server service
No there is no indication of that at all. The server service appears
to be in perfect order, does not drop/restart and my other
applications continue to function without any interruption.
It appears as if the mysqldump connection to the server is
interrupted or maybe there is something in r
Is there any indication that the mysqldump crash is killing the server and
causing it to restart? For example, "ready for connections" notifications just
after you try a mysqldump?
Hartleigh Burton wrote:
H no there are no new errors in there. Nothing out of the ordinary
thats for sure. J
H no there are no new errors in there. Nothing out of the
ordinary thats for sure. Just notifications that MySQL has started
and is accepting connections etc. :|
On 18/06/2007, at 11:06 AM, Baron Schwartz wrote:
How about in c:\Program Files\MySQL\MySQL Server 5.0\data
\.err?
Cheers
How about in c:\Program Files\MySQL\MySQL Server 5.0\data\.err?
Cheers
Baron
Hartleigh Burton wrote:
Hi Baron,
There are no MySQL errors in the event viewer.
On 18/06/2007, at 10:36 AM, Baron Schwartz wrote:
Hi Hartleigh,
Hartleigh Burton wrote:
Hi All,
I have a database which is currentl
Hi Baron,
There are no MySQL errors in the event viewer.
On 18/06/2007, at 10:36 AM, Baron Schwartz wrote:
Hi Hartleigh,
Hartleigh Burton wrote:
Hi All,
I have a database which is currently at ~10GB in it's test phase.
It is containing uncompressed audio and is expected to reach 1.5TB
in
Hi Hartleigh,
Hartleigh Burton wrote:
Hi All,
I have a database which is currently at ~10GB in it's test phase. It is
containing uncompressed audio and is expected to reach 1.5TB in no time
at all. I am just running some backup tests and I have been having lots
of problems creating an accura
Hi All,
I have a database which is currently at ~10GB in it's test phase. It
is containing uncompressed audio and is expected to reach 1.5TB in no
time at all. I am just running some backup tests and I have been
having lots of problems creating an accurate backup.
I have tried both MySQL
# uname -a
6.1-RELEASE FreeBSD 6.1-RELEASE #0: Sun May 7 04:15:57 UTC 2006
[EMAIL PROTECTED]:/usr/obj/usr/src/sys/SMP amd64
#
Just upgraded mysql to include:
# pkg_info |grep mysql
mysql-client-5.1.19 Multithreaded SQL database (client)
mysql-server-5.1.19 Multithreaded SQL database (serv
Reynier,
Normally with PHP I add every field, I mean (eval1, eval2,
eval3, eval4, eval5) and then divide this result by 5, like
a average. I know that SQL can do this directly using AVG
function but I don't know how. Can any help me?
AVG computes an average across rows. If I understand you c
Hi every:
I have this table:
smp_evaluacion
---
id_evaluacion
eval1
eval2
eval3
eval4
eval5
This is for a rating system. I need to build a query for retrieve the best
rating files. Normally with PHP I add every field, I mean (eval1, eval2, eval3,
eval4, eval5) and then
2007/6/16, ViSolve DB Team <[EMAIL PROTECTED]>:
-- this itself takes consistent backup. mysqldump utility by default locks
the table.
yes with --lock-tables option which do a "FLUSH TABLES WITH READ LOCK"
and is a good consistent way for myisam tables.
--
MySQL General Mailing List
For list arc
Hi,
You're running MySQL with a mysql linux user, verify that he have
write access on mysql datadir. You should specify it with --datadir=
at command line invoking mysql_install_db too.
2007/6/16, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
Hi everybody,
I am trying to compile/configure MySQl 5.0.
2007/6/16, mos <[EMAIL PROTECTED]>:
At 09:39 AM 6/16/2007, Stanley wrote:
>Is it possible to undelete a dropped MyISAM table?
Nope, not from within MySQL. Your operating system might allow you to
undelete the file then you might have a chance of importing the data to a
new table.
Mike
If you
17 matches
Mail list logo
