27;t
> locate it on the site / documentation.
>
>
#1
select host,user from mysql.user;
#2
show grants for u...@host;
--
Maurice
copied badly to the secondary server.
Anyway, it seems the problem is definitely hardware and not due to
either ext3, drbd or mysql!
--
Maurice Volaski, [EMAIL PROTECTED]
Computing Support, Rose F. Kennedy Center
Albert Einstein College of Medicine of Yeshiva University
--
MySQL General M
I hadn't heard of such a thing until I just looked it
up. But in any case that adds yet another variable (and a fairly
uncommon one) to the mix.
It's this one: http://www.acnc.com/02_01_jetstor_sata_416s.html. I
thought units like it are very popular.
--
Maurice Volas
Hi Maurice,
If you're running into corruption both in ext3 metadata and in MySQL
data, it is certainly not he fault of MySQL as you're likely aware.
I am hoping they are not related. The problems with MySQL surfaced
almost immediately after upgrading to 5.0.x.
[details deleted
On Sep 17, 2007 13:31 -0400, Maurice Volaski wrote:
In using drbd 8.0.5 recently, I have come across at least two
instances where a bit on disk apparently flipped spontaneously in the
ext3 metadata on volumes running on top of drbd.
Also, I have been seeing regular corruption of a mysql
underlying that
is a RAID 6-based SATA disk array.
The answer to the bug report regarding mysql data corruption, who is
blaming drbd!
http://bugs.mysql.com/?id=31038
Updated by: Heikki Tuuri
Reported by: Maurice Volaski
Category:Server: InnoDB
Severity:S2 (Serious)
Status:
community's 5.0.45 came out a few months ago and enterprise's 5.0.48
came out just a few weeks ago, and from the look of the release
notes, I want to believe that community version is indeed out of date.
In the last episode (Sep 13), Maurice Volaski said:
I just learned that the current
release, 5.0.46. Is there some reason we shouldn't be 5.0.48?
--
Maurice Volaski, [EMAIL PROTECTED]
Computing Support, Rose F. Kennedy Center
Albert Einstein College of Medicine of Yeshiva University
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
recovery.
InnoDB: Ending processing because of a corrupt database page.
--
Maurice Volaski, [EMAIL PROTECTED]
Computing Support, Rose F. Kennedy Center
Albert Einstein College of Medicine of Yeshiva University
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
is corrupt.
InnoDB: Cannot continue operation.
Is it wrong to expect InnoDB to have avoided this or does it suggest
that it couldn't have, i.e., a hardware defect?
--
Maurice Volaski, [EMAIL PROTECTED]
Computing Support, Rose F. Kennedy Center
Albert Einstein College of Medicine of
le out any hardware issue.
--
Thanks
Alex
<http://alexlurthu.wordpress.com>http://alexlurthu.wordpress.com
On 8/31/07, Maurice Volaski
<<mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]> wrote:
A 64-bit Gentoo Linux box had just been upgraded from MySQL 4.1 to
5.0.44 fresh (by dum
K
InnoDB: TABLE to scan your table for corruption.
InnoDB: See also InnoDB:
http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
InnoDB: about forcing recovery.
InnoDB: Ending processing because of a corrupt database page.
--
Maurice Volaski, [EMAIL PROTECTED]
Computing Support, Rose F.
| t2.id | t1.val
1 | NULL | A
2 | 1 | B
NULL | 2 | C
As far as I can tell this is not possible in MySQL. Is there a way to
construct a MySQL statement that produces this result?
Maurice
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
anyone lead me in the right
direction?
Thanks,
Maurice van Peursem
The Netherlands
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ve. Can any of you suggest to me some helpful
learning material?
Thanks,
Maurice van Peursem
The Netherlands
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
Looking for a way to automate backup I was thinking of scheduling mysqldump on
a daily base. It want to use the read lock, but I am not really sure about the
consequences of this.
Does putting a read lock on the files can cause loss of data?
It is no problem pausing the flow of incoming
I had the same stuff going on for 4.0.7g on windows.
Olivier
Hi,
I have this weird things happens.
kaspia:/var/lib/mysql# mysql --version
mysql Ver 12.22 Distrib 4.0.21, for pc-linux-gnu (i386)
mysql> show grants for \"root\"@\"localhost\";
+--
it if you could.
thanks,
maurice
IncrediMail - Email has finally evolved - Click Here
Hello,
I wondered if there is a way to create a mysql
database using Visual C++ 6.0. I don't want the
database to be registered, I want the program to
create the database for me.
Thanks a lot for your help.
__
Do You Yahoo!?
Yahoo! Tax Center - on
are created while we
create a new database and what they contain?
Thank you very much for your help.
Guy-Maurice
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com
Some more specifics would be appreciated. What 3ware cards? 7410s?
What type of drives? What motherboard? Were you doing RAID 1+0?
Do you run your application-specific benchmarks, or general benchmarks?
Have any actual numbers?
Thanks,
Maurice
sql, query
---
nstalled precompiled mysql. Perhaps,
i have to download source code and compile it.
Thanks in advance to any help.
-----
Maurice Foschiatti
Estel s.p.a
Via del Teatro 4
34100 Trieste
mailto: [EMAIL PROTECTED]
cel. +39.329.9028085
nstalled precompiled mysql. Perhaps,
i have to download source code and compile it.
Thanks in advance to any help.
-----
Maurice Foschiatti
Estel s.p.a
Via del Teatro 4
34100 Trieste
mailto: [EMAIL PROTECTED]
cel. +39.329.9028085
clude
after all other included header files (especially
those of MFC)
4) If errors occur, see the "Problems" section
Thanks a lot for your help
--- Sinisa Milivojevic <[EMAIL PROTECTED]> wrote:
> Guy-Maurice Lepoutre writes:
> > Hello,
> >
> > I am usi
Hello,
I am using Visual C++ 6.0 and I have some linking
problems while trying to run the example program
MFC_ex.cpp included in the downloading files in the
mysql.com website.
Here are the errors I get:
Configuration: MFC_ex - Win32
Debug
Linking...
MFC_e
7) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(340) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(345) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\vallist1.hh(56) : error C2872:
'
Hello,
I have troubles compiling this program:
#include
#include
#include "c:/sqlplus/sqlplus.hh"
int main()
{return(0);}
As you can see, the program itself isn't very
complicated.
When I run this program (using MS Visual C++), here
are the errors I get. Can anybody help me please. I
would r
so see 'man chkconfig' and 'man ntsysv'
which can simplify the maintenance of those links.
For example, you should be able to run this to
add mysql to the default run levels:
/usr/sbin/chkconfig --add mysql.server
And run this to check it:
/usr/sbin/chkconfig --list mysql.
10708 where requstID = 2' at line 1
> >> I can't see any reason for the error.
> >
> >Your web based interface is mangling your query.
Hi Julian. I'd recommend taking the suggestion and try the
query through the command-line interface. If it works there
;c:
> \temp\testpicture.gif");
>
> picturename is defined as char(50) - picturedatea is defined as blob
No, you're just inserting the string "c:\temp\testpicture.gif" into
the blob column. MySQL won't go out to the disk and fetch the image
for you. You'
ed
> "AUTO_INCREMENT problem in table"
Huh? You had a problem with an auto_increment column because
you mistakenly inserted too large a value. As long as you're
careful not to do that, it works fine.
--
Maurice Aubrey <[EMAIL PROTECTED]>
"Watch the costs and the profits wil
l it.
pr:12345:powerokwait:/sbin/shutdown -c "Power Restored; Shutdown Cancelled"
Maurice
On Wed, Jul 25, 2001 at 10:01:27AM -0700, Andis wrote:
> Hi!
>
> I have LAN with some PC, which use MySQL database. Sometime power supplay failure
>occurs. I have back-UPS too, but the
----
>
> Returned message in Netscape
>
> Attempting to connect to the database...
> Successful connection to database: DBI:mysql:URW
> Command: CREATE TABLE test_0 (ID INTEGER(6), name VARCHAR(20), address1
> VARCHAR(40), address2
The various table types are discussed here:
http://www.mysql.com/doc/T/a/Table_types.html
Maurice
On Wed, Jul 18, 2001 at 02:12:37PM +0530, Chandrashekhar wrote:
> Thanks for your prompt reply.
> I would like to know which version of mysql does supports transactions. and
> is
. Verify again
that the update worked.
Finally, one by one, add the variables back in.
Maurice Aubrey
On Mon, Jun 11, 2001 at 05:39:43PM -0700, Vladimir Kravtsov wrote:
> The table sitesats won't update and shows no errors! (even though there
> are two instances of echo(mysql_error(
w, you'll know you
have more to display.
Maurice
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <
value
of ID_tb2. If you're using the perl DBI, I believe it's in
$sth->{'mysql_insertid'} (see perldoc DBD::mysql). Finally, do your
insert into TB1.
--
Maurice Aubrey <[EMAIL PROTECTED]>
---
37 matches
Mail list logo