Dear all,
Today I changed my database name from abc to abc1 by the below commands :-
1. Go to data dir : cd /hdd2-1/mysql_data/
2. mv abc abc1
But when I go to the mysql prompt try to use the tables in abc
database , below error occurs:
ERROR 1146 (42S02): Table 'abc1.job_queue' doesn't
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
1. Go to data dir : cd /hdd2-1/mysql_data/
2. mv abc abc1
Whatever gave you the idea that it's a good plan to start messing with the
files of a service whose inner workings you have no clue about?
ERROR 1146 (42S02
I am using debian squeeze and mysql 5.1.45. I am trying to use mysqldumpslow
-s c -t 10, but I keep getting the following error:
Can't determine basedir from 'my_print_defaults mysqld' output:
--general_log=on. Does anyone have any idea as to why? I am not getting
anything from google.
TIA
Hi All,
InnoDB repeatedly prints this message in the error log:
# InnoDB: Error: unlock row could not find a 4 mode lock on the record
Im not sure if the error message is critical or not, but its definitely not
nice to have in the error log.
After some exploration, I found this error
2012/01/02 15:47 +0530, Adarsh Sharma
ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE
line 31 of what? Likly it would be helpful to show it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Dear all,
I am running Mysql on a Linux System ( Caos ).
Today when I am trying to create a procedure in it, I m facing the below
issue :
ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE
My OS version is :
Systemr-5:~ # cat /etc/issue
Welcome to SUSE Linux Enterprise Server 10 SP1
yes - take your fingers away and go to a datarecovery company
if it is not too late because you are damaging the disk more
and more, NOW it is too late for backups!
Am 22.11.2011 06:03, schrieb Adarsh Sharma:
Any comments to get the data back know.
My hard disk crashes about 90% but when I
Any comments to get the data back know.
My hard disk crashes about 90% but when I start any kind of backup or
select output into a file from 40GB table , it stops after 30 GB then
stalled because there are bad sectors to read.
Is it possible to get the remaining data ( 10GB) , as all backups
Dear all,
Today i need to restore the backup of a 40GB table in a new system.
I create a script that takes the backup in compressed format ( 2.3 GB
).The existing hard disk crashes I need to restore my data.
But when I restore the data below error exists :-
[root@test1 hdd2-1]# gunzip
Am 18.11.2011 12:41, schrieb Adarsh Sharma:
But when I restore the data below error exists :-
[root@test1 hdd2-1]# gunzip source.sql.gz | mysql test
gunzip: stdin: unexpected end of file
ERROR 1064 (42000) at line 30309: You have an error in your SQL syntax; check
the manual
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
but anyways, the message sounds like a damaged compressed file
Looks more like he's got an HTML file instead of an SQL file, to me.
Have a look inside the file, maybe the HTML is just a wrapper or something.
How was the
Am 18.11.2011 14:18, schrieb Johan De Meersman:
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
but anyways, the message sounds like a damaged compressed file
Looks more like he's got an HTML file instead of an SQL file, to me.
Have a look inside the file, maybe
I'm getting an occasional error from one of my slaves running
community mysql 5.5.16:
'Got an error writing communication packets' on query. Query: 'flush tables'
Which halts replication on this slave until I issue a 'SET GLOBAL
sql_slave_skip_counter=1' command on the slave.
There are a few
=/usr/local/mysql -DMYSQL_MAINTAINER_MODE=OFF
-DWITH_DEBUG=OFF
The configuration was ok but we recieved an error when issuing make:
[ 85%] Generating ../include/mysqld_error.h, ../sql/share/english/errmsg.sys
Can't create output directory for
/usr/local/src/mysql-5.5.15/bld/sql/share/ukrainian
Failed
We have aded an internal domain, its assigned the latest id ( 20433), we
have safeguards in our portal that stop domains with id less than 5 from
being deleted, the table doesnt show 3 so it is not used, but when I try
alter the table it fails:
update virtual_domains set id='3' where id='20433'
2011/11/06 13:56 +1000, Edward avanti
#1451 - Cannot delete or update a parent row: a foreign key constraint
fails (`vmail`.`domain_admins`, CONSTRAINT `domain_admins_ibfk_1` FOREIGN
KEY (`domain_id`) REFERENCES `virtual_domains` (`id`) ON DELETE CASCADE)
In table domain_admins there is the
that is messing you up. The USING() clause needs
to pick one source for MemberID and you appear to have two. Try converting to a
more explicit ON clause instead.
However (ON, USING, NATURAL) I write joining the three tables on field
MemberID, the outcome is the same, that error message.
2011/10/20 10:21
$èÅwú÷EóþpE²Ë¡WDè
m×ÆkD®
pK̹ΨÛÔ°Õe$ÒöÀÐ1O3øPË{GP¾ÏRB,Rcó1Op»-Ô¦µ|ñËðÆõThã¯Qvìâs?É8Ñ}Rr5ioZS¸¶èrù5.p®¯}*«ÌC¨a3¢¿ÉÝ!ü»¶LÞ}«!ô
Ìì#Ð)'¥LkFL'p:Y§/¤%àµdÆR¼Q©[¬8þ±$(ùD_Ø
8K¤F¯k~·¦úÀbÌ?§ä(,g]è©ï'
Ī
ö0GÞçk´Òme'È¢ô𣸠¨ù#ö
it for a table, there is trouble:
mysql select * from memberp;
ERROR 1250 (42000): Table 'nam' from one of the SELECTs cannot be used in field
list
If I leave this, GROUP_CONCAT(DISTINCT GivenName ORDER BY Rank) AS, out, there is no
trouble. If I leave out any of the other like phrases
memberp;
ERROR 1250 (42000): Table 'nam' from one of the SELECTs cannot be used in field
list
If I leave this, GROUP_CONCAT(DISTINCT GivenName ORDER BY Rank) AS, out,
there is no trouble. If I leave out any of the other like phrases, there is yet
trouble. If I leave the ORDER BY ... out
@lists.mysql.com
Subject: Re: mysqldump: Got error: 1017: Can't find file:
'./ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES
Hello Shafi,
Adding to Prabhat alternatives, you can use --force to the mysqldump command
to ignore the errors and continue taking backup.
Regarding the error
Hello Shafi,
Adding to Prabhat alternatives, you can use --force to the mysqldump command
to ignore the errors and continue taking backup.
Regarding the error, we need to check whether the table is present or not
and the engine type specifically.
Thanks
Suresh Kuna
On Sat, Sep 24, 2011 at 3:31
Folks
I have a mysql database of 200G size and the backup fails due to the foll.
Issue.
mysqldump: Got error: 1017: Can't find file:
'./ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES
Can someone assist pls.?
Best Rgs,
Shafi AHMED
mysqld to
see if it works.
- Original Message -
From: Shafi AHMED shafi.ah...@sifycorp.com
To: mysql@lists.mysql.com
Sent: Friday, 23 September, 2011 1:42:26 PM
Subject: mysqldump: Got error: 1017: Can't find file:
'./ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK
In the last episode (Sep 23), Shafi AHMED said:
I have a mysql database of 200G size and the backup fails due to the foll.
Issue.
mysqldump: Got error: 1017: Can't find file:
'./ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES
Can someone assist pls.?
$ perror 24
OS
to the
foll.
Issue.
mysqldump: Got error: 1017: Can't find file:
'./ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES
Can someone assist pls.?
$ perror 24
OS error code 24: Too many open files
You need to bump up the max files limit in your OS. It may
- Original Message -
From: Hank hes...@gmail.com
While running a -rq on a large table, I got the following error:
myisamchk: warning: Duplicate key for record at 54381140 against
record at 54380810
How do I find which records are duplicated (without doing the typical
self
On Mon, Sep 19, 2011 at 7:19 AM, Johan De Meersman vegiv...@tuxera.bewrote:
- Original Message -
From: Hank hes...@gmail.com
While running a -rq on a large table, I got the following error:
myisamchk: warning: Duplicate key for record at 54381140 against
record
- Original Message -
From: Hank hes...@gmail.com
Exactly - I can't create an index on the table until I remove the
duplicate records.
I was under the impression you were seeing this during a myisamchk run - which
indicates you should *already* have a key on that field. Or am I
Exactly - I can't create an index on the table until I remove the
duplicate records.
I was under the impression you were seeing this during a myisamchk run -
which indicates you should *already* have a key on that field. Or am I
interpreting that wrong?
I'm trying to rebuild an index
- Original Message -
From: Hank hes...@gmail.com
I'm trying to rebuild an index after disabling all keys using
myisamchk and adding all 144 million records, so there is no current index on
the
table.
Ahhh... I didn't realise that.
But in order to create the index, mysql has to
While running a -rq on a large table, I got the following error:
myisamchk: warning: Duplicate key for record at 54381140 against
record at 54380810
How do I find which records are duplicated (without doing the typical
self-join or having cnt(*)1 query)? This table has 144 million rows, so
- Original Message -
From: David Lerer dle...@us.univision.com
Correct me if I am wrong, but my impression is that usage of
DEFINER=user in stored procedures has no impact on runtime and
is actually optional.
(not to be confused with the clause SQL SECURITY INVOKER which is
There is no 'root'@'%' registered
error message
- Original Message -
From: David Lerer dle...@us.univision.com
Correct me if I am wrong, but my impression is that usage of
DEFINER=user in stored procedures has no impact on runtime and
is actually optional.
(not to be confused
- Original Message -
From: David Lerer dle...@us.univision.com
Thanks Bier. I see what you mean.
(As a rule we always use SQL SECURITY INVOKER)
Both have their use, although I would very much prefer MySQL to default to
INVOKER if not specified, instead of the extremely
Hiya
Ill be up front my saying my knowledge of store procedures is limited.
A Developer gave me a procedure to load.
It starts off with:
CREATE DEFINER=`root`@`%` PROCEDURE
But now, the developer informs me that he gets the following message.
There is no 'root'@'%' registered
Change the definer to one of your registered root accounts. Root@127 or
root@localhost.
On Aug 17, 2011 8:39 AM, Brent Clark brentgclarkl...@gmail.com wrote:
Hiya
Ill be up front my saying my knowledge of store procedures is limited.
A Developer gave me a procedure to load.
It starts off
Hiya
Thank you so much for replying. I really appreciate it.
I know the answer (well I think I do :) ), but im still going to ask.
What is the risk if do the GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
IDENTIFIED BY 'mysql' WITH GRANT OPTION;
To satisfy the developer.
Thank you again.
Brent
It would allow anyone from anywhere to access your server as root with full
access to all databases using the password 'mysql'. Not very secure. I don't
recommend having a root@% defined.
On Aug 17, 2011 8:50 AM, Brent Clark brentgclarkl...@gmail.com wrote:
Hiya
Thank you so much for replying.
Perhaps he could make the stored procedure functional by creating a user
with the EXECUTE permission (somebody please fell free to correct me if I am
mistaken) if it is to be used to execute a stored procedure. You don't want
someone to attempt using the 'root' username with a typical 'mysql'
- Original Message -
From: Brent Clark brentgclarkl...@gmail.com
I know the answer (well I think I do :) ), but im still going to ask.
What is the risk if do the GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
IDENTIFIED BY 'mysql' WITH GRANT OPTION;
To satisfy the developer.
That said
Correct me if I am wrong, but my impression is that usage of
DEFINER=user in stored procedures has no impact on runtime and is
actually optional.
(not to be confused with the clause SQL SECURITY INVOKER which is
crucial.)
Note: I use 5.1.32-enterprise-gpl-advanced-log.
David.
--
MySQL General
On Aug 11, 2011, at 2:30 PM, Keith Murphy wrote:
Hey everyone,
I have run across something that has me stumped. I have some systems that
have very large error logs because we haven't moved from statement-based to
mixed-based replication yet so they get a lot of warnings logged. I need
systems that
have very large error logs because we haven't moved from statement-based
to
mixed-based replication yet so they get a lot of warnings logged. I need
to
rotate the error logs and have started looking at it doing so.
The problem is that on one system a normal course of action
Hey everyone,
the problem was that I have the error log in /var/log/mysqld/mysql.error and
SELinux was not configured to allow it to rotate. I have compiled a custom
module to allow it so the problem is resolved. It was not an issue with
MySQL Server itself.
thanks again.
Keith
On Fri, Aug 12
Hey everyone,
I have run across something that has me stumped. I have some systems that
have very large error logs because we haven't moved from statement-based to
mixed-based replication yet so they get a lot of warnings logged. I need to
rotate the error logs and have started looking
and found that it is read 200 MB of
binary file and few more need to be read by salve get in sync, still i think
200 MB file should not take hours to read, any ways but in error logs i am keep
on getting following error
110623 15:50:56 [Note] Semi-sync replication switched OFF.
110623 15:50:56 [Note
directory, and
executed the following installation commands under root:
# unzip openlogic-mysql-5.5.9-linux-ia32-bin-2.zip
# cd mysql-5.5.9
# chown -R mysql .
# chgrp -R mysql .
# scripts/mysql_install_db --user=mysql
I have the following error messages:
Installing MySQL system tables
Am 17.06.2011 19:53, schrieb Philippe Mokrani:
I have the following error messages:
Installing MySQL system tables...
110617 19:46:25 [ERROR] ./bin/mysqld: unknown variable
'default-character-set=latin1'
default-character-set=latin1 is way too old for 5.5
character-set-server should
I haven't bothered to look for the bug, but it seems to me to be quite
reasonable default behaviour to lock the whole lot when you're dumping
transactional tables - it ensures you dump all tables from the same consistent
view.
I would rather take this up with the ZRM people - it should just
'performance_schema' appears to eliminate the error. And it
seems does NOT cause a reliability-of-the-backup problem.
3.3 came out last week, you may want to have a look at wether it's
already been adressed there.
I believe that's an Amanda 3.3 release you're referring to. ZRM is still
at 2.2,
http
- Original Message -
From: ag...@airpost.net
Excluding 'performance_schema' appears to eliminate the error. And it
seems does NOT cause a reliability-of-the-backup problem.
Hah, no, backing that up is utterly pointless. Never noticed it doing that.
It's basically a virtual schema
On Mon, 06 Jun 2011 18:54 +0200, Johan De Meersman
vegiv...@tuxera.be wrote:
Excluding 'performance_schema' appears to eliminate the error. And it
seems does NOT cause a reliability-of-the-backup problem.
Hah, no, backing that up is utterly pointless.
that's a useful/final confirmation
of that backup cmd, i see an ERROR @ console,
...
manual:backup:INFO: PHASE START: Creating raw backup
manual:backup:INFO: Command used for raw backup is
/usr/share/mysql-zrm/plugins/socket-copy.pl
--mysqlhotcopy=/usr/bin --host=localhost --port=3306
manual --backup-level 0
to execute a manual backup.
i recently upgraded from v5.1.x - v5.5.12,
mysqladmin -V
mysqladmin Ver 8.42 Distrib 5.5.12, for Linux on i686
now, at exec of that backup cmd, i see an ERROR @ console,
...
manual:backup:INFO: PHASE START
hi,
On Sun, 05 Jun 2011 22:24 +0200, Reindl Harald
h.rei...@thelounge.net wrote:
have you checked you permissions-table if all privileges are active for root
i've got,
mysql show grants for 'root'@'localhost';
the grant statements does nobody interest
maybe use phpmyadmin for a clearer display
mysql select * from mysql.user where user='root' limit 1;
fwiw, others are seeing this. e.g., in addition to the two bugs i'd
already referenced,
http://www.directadmin.com/forum/showthread.php?p=202053
and one
http://qa.lampcms.com/q122897/Can-t-backup-mysql-table-with-mysqldump-SELECT-LOCK-TABL-command
claims a solution
Add --skip-add-locks to
hm - bad
i would use a replication slave and stop him for consistent backups
because dumb locks are not really a good solution independent
if this works normally
Am 05.06.2011 23:26, schrieb ag...@airpost.net:
fwiw, others are seeing this. e.g., in addition to the two bugs i'd
already
BTW
WHY is everybody ansering to the list AND the author of the last post?
this reults in get every message twice :-(
Am 05.06.2011 23:26, schrieb ag...@airpost.net:
fwiw, others are seeing this. e.g., in addition to the two bugs i'd
already referenced,
On Sun, 05 Jun 2011 23:30 +0200, Reindl Harald
h.rei...@thelounge.net wrote:
BTW
WHY is everybody ansering to the list AND the author of the last post?
this reults in get every message twice :-(
Reply - sends to ONLY the From == h.rei...@thelounge.net
Reply to all sends to BOTH the From ==
apparently broken with mysqldump -- enough so that lots of
people are seeing and reporting this same error after the 5.1 - 5.5
upgrade.
why would setting up a replication slave be necessary or a good solution
to the problem?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
unfortunately, i have no idea what that means.
something's apparently broken with mysqldump -- enough so that lots of
people are seeing and reporting this same error after the 5.1 - 5.5
upgrade.
why would setting up a replication slave be necessary or a good solution
to the problem?
because
i still have no idea why this is necessary.
there seems to be a but, problem, misconfiguration, etc.
wouldn't it make some sense to try to FIX it, rather than setting up a
completely different server?
perhaps someone with an idea of the problem and its solution will be
able to chime in.
--
Am 05.06.2011 23:55, schrieb ag...@airpost.net:
i still have no idea why this is necessary.
take it or not
it is a professional solution which works for
databses with 20 GB every day here with rsync
without interrupt/lock mysqld a second
and it is much faster
there seems to be a but,
Inhalt uebernehmen.
Date: Fri, 6 May 2011 15:42:56 +0530
Subject: Fwd: DBCP error
From: dhaval.jais...@via.com
To: mysql@lists.mysql.com
CC: shrinivas.devarko...@via.com
Hi All,
We are frequently getting DBCP error. We have seen this error in
catalina.log apps log. This issue
'mysql_db_FETCH_attrib':
dbdimp.c:2447: error: 'sv_undef' undeclared (first use in this function)
dbdimp.c:2447: error: (Each undeclared identifier is reported only once
dbdimp.c:2447: error: for each function it appears in.)
dbdimp.c: In function 'mysql_st_internal_execute41':
dbdimp.c:3298: warning: format '%d
l'information seulement et n'aura
pas n'importe quel effet légalement obligatoire. Étant donné que les email
peuvent facilement être sujets à la manipulation, nous ne pouvons accepter
aucune responsabilité pour le contenu fourni.
Subject: Re: Fwd: DBCP error
From: nw...@plus.net
interactive/wait_timeout = 120Seconds
max_connection = 1500
still we are getting errors.
--
Regards,
Dhaval
On Fri, May 6, 2011 at 4:05 PM, Nigel Wood nw...@plus.net wrote:
On Fri, 2011-05-06 at 11:12 +0100, Dhaval Jaiswal wrote:
Caused by: java.net.SocketException: Socket closed
I'd
que les email
peuvent facilement être sujets à la manipulation, nous ne pouvons accepter
aucune responsabilité pour le contenu fourni.
Subject: Re: Fwd: DBCP error
From: nw...@plus.net
To: dhaval.jais...@via.com
CC: mysql@lists.mysql.com; shrinivas.devarko...@via.com
Date: Fri, 6
Hi All,
We are frequently getting DBCP error. We have seen this error in
catalina.log apps log. This issue has started since last 2 -3 days. We
have checked the application code when this error has occured and assure
that there is no connection leakage in code. Mysql server is also running
fine
On Fri, 2011-05-06 at 11:12 +0100, Dhaval Jaiswal wrote:
Caused by: java.net.SocketException: Socket closed
I'd suggest you look at server side timeout and maximum connection
settings in
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html I'd
suspect wait_timeout is the setting
lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.
Date: Fri, 6 May 2011 15:42:56 +0530
Subject: Fwd: DBCP error
From: dhaval.jais...@via.com
On Thu, May 5, 2011 at 10:29, Grega Leskovšek legr...@gmail.com wrote:
Can smbd please look at this sentence - I got an error and do not
know how to fix it - I am still very unfamiliar with MYSQL:
CREATE TABLE log ( idlog int auto_increment not null, imepriimek
varchar(50), clock
varchar(100), filesize float(6,2));
On Thu, May 5, 2011 at 10:49 AM, Daniel Brown danbr...@php.net wrote:
On Thu, May 5, 2011 at 10:29, Grega Leskovšek legr...@gmail.com wrote:
Can smbd please look at this sentence - I got an error and do not
know how to fix it - I am still very unfamiliar
I'm getting
ERROR 2006 (HY000) at line 10: MySQL server has gone away
while trying to do an insert through the MySQL CLI. Our database is so small
that I haven't gotten around to doing any tuning, so this came out of the
blue. I'm not quite sure where to start.
Here's what things look like
On Fri, Apr 29, 2011 at 3:23 PM, Jerry Schwartz je...@gii.co.jp wrote:
I'm getting
ERROR 2006 (HY000) at line 10: MySQL server has gone away
while trying to do an insert through the MySQL CLI. Our database is so small
that I haven't gotten around to doing any tuning, so this came out
-Original Message-
From: Larry Martell [mailto:larry.mart...@gmail.com]
Sent: Friday, April 29, 2011 5:31 PM
To: Jerry Schwartz
Cc: mysql mailing list
Subject: Re: ERROR 2006 (HY000)
On Fri, Apr 29, 2011 at 3:23 PM, Jerry Schwartz je...@gii.co.jp wrote:
I'm getting
ERROR 2006 (HY000
`user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=31592 DEFAULT CHARSET=latin1
Today don't know why below error occurs when i am going insert some
data in it :
mysql insert into login(user_id,log_status) values(2,1);
ERROR 1062 (23000): Duplicate entry '31592' for key 'PRIMARY'
I check
`)
) ENGINE=MyISAM AUTO_INCREMENT=31592 DEFAULT CHARSET=latin1
Today don't know why below error occurs when i am going insert some
data in it :
mysql insert into login(user_id,log_status) values(2,1);
ERROR 1062 (23000): Duplicate entry '31592' for key 'PRIMARY'
I check the latest entries
a link but cannot understand
below mentioned things :- Please have some comments on them
(... cut ...)
It means there are 31581 rows but max(log_id suggests 10 more , how this
could be possible, may be some rows deleted.
I solved the error by repairing the table
repair table login
Hi,
It's quite simple and quick change in *nix. But would recommend to check your
server performance first (processlist, tmp tables, slow query log etc).
Regards,
m
Jerry Schwartz je...@gii.co.jp pisze:
You are seeing *NIX error messages. You need to increase the operating system
settings
--
Apr 24 23:32:50 maj-web01 mysqld: 110424 23:32:50 [ERROR] Error in
accept: Too many open files
Apr 24 23:35:03 maj-web01 mysqld: 110424 23:35:03 [ERROR]
/usr/sbin/mysqld: Can't open file: './maj_fs2
restrictions, too.
- Original Message -
From: Brent Clark brentgclarkl...@gmail.com
To: mysql mailing list mysql@lists.mysql.com
Sent: Tuesday, 26 April, 2011 9:44:16 AM
Subject: Error in accept: Too many open files
Hiya
I recently imported data on a new server (5.1). But before
2011/04/25 18:45 +, Larry McGhaw
CREATE VIEW `myview2` AS
SELECT a.*, IF(b.`Name` IS NULL, '', b.`Name`) AS `TypeName`
FROM `mytable` a
LEFT JOIN `types` b ON a.`Type` = b.`ID`;
Well, for this construct
IF(b.`Name` IS NULL, '', b.`Name`)
there is a special function
You are seeing *NIX error messages. You need to increase the operating system
settings that control the number of files that a process can open.
I'm very rusty, and never really used Linux, so I can't tell you the exact
parameters. There are probably two: total number of open files, and files
On 04/26/11 05:32, Halász Sándor wrote:
2011/04/25 18:45 +, Larry McGhaw
CREATE VIEW `myview2` AS
SELECT a.*, IF(b.`Name` IS NULL, '', b.`Name`) AS `TypeName`
FROM `mytable` a
LEFT JOIN `types` b ON a.`Type` = b.`ID`;
Well, for this construct
IF(b.`Name` IS NULL,
Cc: Daevid Vincent; mysql@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list
error in the Text body
On 04/22/11 22:41, Larry McGhaw wrote:
It does appear to be some type of bug to me.
Hm... do you have an idea how to work around this bug then?
Yours
Hi,
On 04/25/11 20:45, Larry McGhaw wrote:
My best advice is to not use a custom MySQL function in a view when the
parameter to that function
is a column or expression that has the potential to result in NULL because of
being on the right side
of a left outer join (or the left side of a right
-
From: Daniel Kraft [mailto:d...@domob.eu]
Sent: Friday, April 22, 2011 1:05 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list
error in the Text body
Hi,
thanks for the fast reply!
On 04/22/11 21:39, Daevid Vincent
@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list
error in the Text body
Hi,
thanks for the fast reply!
On 04/22/11 21:39, Daevid Vincent wrote:
DROP DATABASE `test`;
CREATE DATABASE `test`;
USE `test`;
CREATE TABLE `mytable`
(`ID` SERIAL,
`Type
On 22.04.2011 22:41, Larry McGhaw wrote:
It does appear to be some type of bug to me.
I agree. I was thrown by Daniels first and third comment, which I
guess should read second and third
I reproduced the behavior in 5.1.53-community on Windows.
/ Carsten
--
MySQL General Mailing List
For
Dear all,
I am facing the below problem while installing mysql in a debian based
system from the last 2 days.
I tried the command apt-get install mysql-server but the server doesn't
start properly due to below exception in /var/log/syslog
41 [ERROR] /usr/sbin/mysqld: Can't find file
install mysql-server but the server doesn't
start properly due to below exception in /var/log/syslog
41 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno:
13)
Mar 14 10:36:41 sun-cloud mysqld[3500]: ERROR: 1017 Can't find file:
'./mysql/user.frm' (errno: 13)
Mar 14 10:36:41
The following occurs when running the Live version of GnackTrack, if you
install from the LiveDVD this issue is no longer present.
LiveDVD can be downloaded from www.gnacktrack.co.uk - this can be used to
demonstrate issue but i think it's likely somethign simple
root@root:~# mysql
ERROR 2002
Hi I am getting a Foreign key error .
The command that gives the error is
ALTER TABLE child ADD CONSTRAINT child_parent_fk FOREIGN KEY (id) REFERENCES
parent(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
And the error message is
ERROR 1005 (HY000): Can't create table
'./testforeignkeysyntax_lap
Hello Hari,
You already posted the best answer we could provide :)
On 2/22/2011 13:00, hari jayaram wrote:
Hi I am getting a Foreign key error .
...
I have attached the create table syntax for both the parent and child tables
and the innodb status below. ...
mysql show innodb status
the best answer we could provide :)
On 2/22/2011 13:00, hari jayaram wrote:
Hi I am getting a Foreign key error .
...
I have attached the create table syntax for both the parent and child
tables
and the innodb status below. ...
mysql show innodb status
/22/2011 13:00, hari jayaram wrote:
Hi I am getting a Foreign key error .
...
I have attached the create table syntax for both the parent and child
tables
and the innodb status below. ...
mysql show innodb status
;
show innodb status prints out this:
LATEST FOREIGN KEY ERROR
110214 15:03:43 Error in foreign key constraint of table
test/categoriesRelationships:
foreign key (Parent) references categories (ID), Child integer not null,
foreign key (Child
201 - 300 of 6326 matches
Mail list logo