Scott,
Based on earlier messages, there's no way to just restore the master
again. But can the data be recovered from the files? If it's InnoDB,
then perhaps. See http://code.google.com/p/innodb-tools/. If it's
MyISAM, one of our guys has made some partial work on a set of tools
to serve a
Hi everyone,
Many thanks for alot of response for my question.
I learned a lot from following article.
http://people.freebsd.org/~kris/scaling/mysql.html
I will try using FreeBsd 7.0 for MySQL.
Best regards.
--- On Wed, 7/8/09, Ken Menzel kenmy...@icarz.com wrote:
From: Ken Menzel
I would like to prevent users from changing their passwords unless they have
grant permission. Is this possible?
We have an set of stored procedures for managing users/databases for a single
signon project that we are working on. The problem is if a user connects
directly to the database
I have been getting this error on a database: Incorrect key file for table
'/tmp/#sql_a99_0.MYI'; try to repair it. How do I know which table is causing
this error?
TIA,
ZK
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On Thursday 09 July 2009 01:56:37 pm Zakai Kinan wrote:
I have been getting this error on a database: Incorrect key file for
table '/tmp/#sql_a99_0.MYI'; try to repair it. How do I know which table
is causing this error?
TIA,
ZK
You could be running out of space on your temp
run a quick df
df
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede
Oh wise and all knowing MySQL Guru's:
I've been running into a problem recently that has be confused.
I have 2 tables, both with the structure:
DROP TABLE IF EXISTS `acn_market_level`.`market_scans`;
CREATE TABLE `acn_market_level`.`market_scans` (
`Retailer` char(3) NOT NULL,
`Marketkey`
Walton,
The table in the select is getting locked for the duration of the query because
it is part of the insert statement. I don't know the technical reason for
this, but I know it works this way. (having experienced this behavior several
times myself) The only way (that I am aware of) to
Forwarded response from Micheal. I haven't tested it yet (have to wait till
I have more data to move), but this sounds about right.
Thanks!
-Original Message-
From: Michael Dykman [mailto:mdyk...@gmail.com]
Sent: Thursday, July 09, 2009 1:22 PM
To: Walton Hoops
Subject: Re: Lock
two servers were having the same problem and they each have 1GB of space in the
temp dir. I was able to fix the problem by recreating the biggest table in the
database. The total space in each database is 350MB. The deleted table's size
was 500kb. The mysql version is 5.0.51a. I am afraid
Nope, Nathan is right: INSERT...SELECT is a locking statement due to
statement-based replication. There's lots of info on this if you
google it. The common solution is to dump to disk and load back in
with SELECT INTO OUTFILE and LOAD DATA INFILE.
- Perrin
On Thu, Jul 9, 2009 at 3:55 PM,
I have this query on my current application:
SELECT count(sql_id) AS total, DATE_FORMAT(insertdate, '%H:%i' ) AS
mydate FROM momt WHERE 1=1 AND insertdate BETWEEN DATE_ADD(NOW(),
INTERVAL - 1 HOUR) AND NOW() AND (sms_type = 1 OR sms_type =2) GROUP BY
mydate ORDER BY insertdate
Is there any
Hello,
I've run into an odd problem. I have a connection data management library for
a project that we have been working with for a while. The purpose of this
library was to work around some oddities in the ODBC environment where lots of
connections were being held open for a long period of
Is there a way to test a connection prior to using it to find out if
it's actually open? Like pinging the active connection.
If I could do something like that prior to returning the connection, I
could then loop through the connections to check until I get a good
one. We have all of the
14 matches
Mail list logo
