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 your
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
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
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
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
# 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
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
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
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
How about in c:\Program Files\MySQL\MySQL Server 5.0\data\hostname.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
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
\hostname.err?
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.
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
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
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
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
16 matches
Mail list logo