On Thu, 30 Jun 2005 16:47:43 +0100, wrote:
>Hi,
>I'm designing a simple family tree db which is at present just a flat table
>In which each record everyone has a father & mother, a variable number of
>wives,and variable number
>of children.
>The links to other family tree members is always the r
Approximately a half year ago I started to install bugzilla on windows which
uses mysql and perl.
After much grief, I discovered that there was a problem with windows perl
and the latest version of mysql at the time. I finally solved the problem by
rolling back to 4.0.23.
It looks like there are
i am working on a database system where a number of tables (5-10) each
with possibly hundreds of columns share an identical primary key name.
the truth is if it weren't for a limitation in the number of columns in
M$ Access (long story: we're creating a client server scheme so they
can get
Hi,
I will give the output below. I just ran an insert of a small amount of data
into Windoz/MySQL 5.0.6. Then, I ran a "myisampack" agains it. Finally, I ran
a myisamchk against it and keep coming up against this error:
Found wrong record at 687081
Now, I'm the only one who has access to this
In the last episode (Jun 30), Mathias said:
> We've been benchmarking a database that in real-life will have a huge
> write load (max peak load 1 inserts/second) to the same table
> (MyISAM).
>
> We will need about 4 indexes for that table. However, from our
> benchmark tests, it is clear that
Hallo,
Op 30 Jun 05 schreef blackwater dev aan mysql@lists.mysql.com:
bd> "1","23","345","45";
bd> "34","4","444","1er";
bd> Load data local infile '/httpd/htdocs/sql/loader.sql' into table
bd> vehicles fields terminated by ',' enclosed by "'" lines terminated by
bd> ';'
I think it should b
Write to a memory table first then do a hotcopy on a scheduled basis.
- Original Message -
From: "Mathias" <[EMAIL PROTECTED]>
To:
Sent: Thursday, June 30, 2005 9:10 AM
Subject: Possible to delay index writes until server is less busy?
We've been benchmarking a database that in real
Hello all,
I have a file where the data looks like this:
"1","23","345","45";
"34","4","444","1er";
I am then trying to load that data using the load data local infile
and this statement:
Load data local infile '/httpd/htdocs/sql/loader.sql' into table
vehicles fields terminated by ',' enclosed
[EMAIL PROTECTED] wrote on 06/30/2005 11:59:43 AM:
> news <[EMAIL PROTECTED]> wrote on 30/06/2005 16:47:43:
>
>
> > I'm designing a simple family tree db which is at present just a flat
> table
> > In which each record everyone has a father & mother, a variable
> > number of wives,and variable
news <[EMAIL PROTECTED]> wrote on 30/06/2005 16:47:43:
> I'm designing a simple family tree db which is at present just a flat
table
> In which each record everyone has a father & mother, a variable
> number of wives,and variable number
> of children.
> The links to other family tree members is
Hi,
I'm designing a simple family tree db which is at present just a flat table
In which each record everyone has a father & mother, a variable number of
wives,and variable number
of children.
The links to other family tree members is always the record_id of another
record.
At present I'm manual
We've been benchmarking a database that in real-life will have a huge
write load (max peak load 1 inserts/second) to the same table (MyISAM).
We will need about 4 indexes for that table. However, from our benchmark
tests, it is clear that writing indexes takes too many resources and
impede
Hello.
See:
http://dev.mysql.com/doc/mysql/en/how-to-avoid-table-scan.html
David Kagiri <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 8bit, charset: iso-8859-1, 15 lines --]
>
> Hi
> I our database there is one table that will grow into tetrabytes within a
> short time.
Hello.
Please examine your master's binary and slave's relay logs with
mysqlbinlog utility to find if sent and received SQL statements are
different. Sent your MySQL versions on master and slave. Include complete
output of 'SHOW SLAVE STATUS'. If your version is rather old, check if the
prob
Hello.
You should include table name on which you had created the trigger:
mysql> delimiter $$
mysql> create trigger t1 after insert on ta for each row begin set
@a=1; end $$
Query OK, 0 rows affected (0.17 sec)
mysql> drop trigger ta.t1$$
Query OK, 0 rows affected (0.00 sec)
P
Hello.
perror 152
MySQL error code 152: Cannot delete a parent row
Something prevents your query from deleting a parent row. In my opinion,
it could be some lock from another transaction or query.
root <[EMAIL PROTECTED]> wrote:
>
> Hi List ,
>
> what does error no 152 mean , cou
Hello.
If you want wildcards you could use something like this:
grant all privileges on `%samhain%`.* to [EMAIL PROTECTED] identified
by 'passwd' with grant option;
Mark Sargent <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> trying to create a new user with the below,
>
> GRANT
Ashok Kumar wrote:
Dear Friends,
I'm Ashok here. first i'll tell my sys configuration.
1.Redhat-Linux 9
2.Intel Pentium chipset
3.MySQL 4.1 with Development Libraries
For this i've downloaded the MySQL4.1 under the
specification "Linux x86 RPM downloads" from the site.
In my system, the MySQ
On Thu, 30 Jun 2005, Jigal van Hemert wrote:
> MySQL is correct here: the syntax is
> drop trigger .;
> http://dev.mysql.com/doc/mysql/en/drop-trigger.html
Ah, that explains a lot. I just read tablename as database because of
all the other syntax. Works now.
Does anybody now when MySQL plans
Mark Sargent wrote:
Hi All,
trying to create a new user with the below,
GRANT ALL PRIVILEGES ON *samhain* TO 'samhain'@'localhost' IDENTIFIED BY
'passwd' WITH GRANT OPTION;
but, it gives a syntax error message. mysql version is 4.1.12. What is
wrong with the syntax.? Cheers.
Mark Sargent
Mysql,
I have table structure like this:
CREATE TABLE `promo_2003_1` (
`k1` char(17) NOT NULL default '',
`fname` char(3) default '',
`lname` char(6) default '',
`sndx_lname` char(6) default '',
`suffix` char(5) default '',
`zip5` char(5) default '',
`zip4` char(4) default '',
`firstname` char(30
From: "Patrik Wallstrom"
> Using 5.0.7-beta the "drop trigger" functions in a very mysterious
> way:
>
> mysql> use testdb;
> mysql> drop trigger foo;
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax
You could leave your separate tables by region and create a MERGE
table over them. Your application only needs to reference the MERGE
table name, eliminating the need for your recompiles and MySql will
Handle the underlying tables. You can add or remove tables from the
MERGE at any time. I did noti
On Thursday 30 June 2005 06:47 am, Patrik Wallstrom wrote:
> mysql> use testdb;
> mysql> drop trigger foo;
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near '' at line 1
> mysql> drop trigg
Hi List ,
what does error no 152 mean , could not find anything useful from the
manual , was trying to drop a foreign key from an innodb table which has
its corresponding P Key in another table.
Table T_Dropdown (Foreign Key ) references Table T_Questionnaire
( T_QID )
> mysql >alter table T_Dr
Ok, I get it...
Thanx everybody..
_
Qbit
Γατσής Νίκος - Gatsis Nikos
Web developer
tel.: 2108256721 - 2108256722
fax: 2108256712
email: [EMAIL PROTECTED]
http://www.qbit.gr
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 30, 2005 2:44 P
Hi Prashanth,
I'm happy to help u. i attached one 'C' code in the
previous mail. just use that code for in vc++. Follow
the procedure,
1.Create the new "win32 Console App." as a empty
project and add the attached 'C' file to the project.
2.goto "Tools->options->Directories(tab)" and in that
add
That's usually an I/O error, if memory serves me right.
Try dumping the data, drop table, recreate it, and re-insert the data
back-in.
MarkP
On Jun 30, 2005, at 14:34 , nikos wrote:
Hello list
Can somebody infor me what is the "Got error 127 when reading table
cat"?
Thank you
Nikos
--
M
that means you are running out of space on your machine or some specific
partition
Peter
nikos wrote:
Hello list
Can somebody infor me what is the "Got error 127 when reading table
cat"?
Thank you
Nikos
--
Best regards,
Peter
http://AboutSupport.com
--
MySQL General Mailing List
For lis
Using 5.0.7-beta the "drop trigger" functions in a very mysterious
way:
mysql> use testdb;
mysql> drop trigger foo;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '' at line 1
mysql> drop tri
[snip]
Can somebody infor me what is the "Got error 127 when reading table
cat"?
[/snip]
It means the table is crashed. See
http://dev.mysql.com/doc/mysql/en/repair.html for how to repair the
table.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
Hello list
Can somebody infor me what is the "Got error 127 when reading table
cat"?
Thank you
Nikos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hereby:
http://www.phprojekt.com/ --> we have used this ourself
http://www.dotproject.net
more can be found here:
http://www.hotscripts.com/PHP/Scripts_and_Programs/Groupware_Tools/index.html
Greetings
Reinhart
Citeren David Ziggy Lubowa <[EMAIL PROTECTED]>:
>
> Good Afternoon,
>
>
>
Good Afternoon,
I was wondering if anyone could point me in the right direction on
this one, i need to setup a sort of project management interface which can
be connected to from different parts of the world for update/write/read and
offcourse enforce specific rules on particular d
Hi
Iam using SCO OpenServer 5.0.7 with MySQL version 4.0.20 ,sometimes (very
rarely) get this error while running some queries on MySQL, any ideas why?
We're using semaphores for protecting the database, so it is not a
concurrent access problem.
(136376800) pthread_cancel_timed_sigwait: thr
Dear Friends,
I'm Ashok here. first i'll tell my sys configuration.
1.Redhat-Linux 9
2.Intel Pentium chipset
3.MySQL 4.1 with Development Libraries
For this i've downloaded the MySQL4.1 under the
specification "Linux x86 RPM downloads" from the site.
In my system, the MySQL Server is working w
Hi,
> trying to create a new user with the below,
>
> GRANT ALL PRIVILEGES ON *samhain* TO 'samhain'@'localhost'
> IDENTIFIED BY 'passwd' WITH GRANT OPTION;
That should be 'samhain.*', not '*samhain*'.
Regards,
Martijn
--
The information contained in this communication and any attachments
David Kagiri <[EMAIL PROTECTED]> wrote on 30/06/2005 09:44:11:
> Hi
> I our database there is one table that will grow into tetrabytes
> within a short time.
>
> I would like to know how i can reduce full table scans.
>
> I have used separate tables as per region for now but the problem is
> if
Hi All,
trying to create a new user with the below,
GRANT ALL PRIVILEGES ON *samhain* TO 'samhain'@'localhost' IDENTIFIED BY
'passwd' WITH GRANT OPTION;
but, it gives a syntax error message. mysql version is 4.1.12. What is
wrong with the syntax.? Cheers.
Mark Sargent.
--
MySQL General Ma
i was asking for things like these..
look for the thread with this subject:
"mysql and limitations and hardware features support"
for aswer to particular question read this:
http://dev.mysql.com/doc/mysql/en/table-size.html
regards
d2clon
Arcangelo Casavola wrote:
Hi,
i've MySQL 4.0.18 and 1
Hi all,
I am getting duplicate entry error while inserting data in the table.
My table name is TEMP and it contains only one field which is primary key ,nt
null as well as auto increment .
050628 16:05:00 Slave: Error 'Duplicate entry '77' for key 1' on query
'INSERT INTO TEMP VALUES ()'. Defau
Hi
I our database there is one table that will grow into tetrabytes within a short
time.
I would like to know how i can reduce full table scans.
I have used separate tables as per region for now but the problem is if i
create a new table i am forced to recompile the application.
I can easil
Hi,
i've MySQL 4.0.18
and 1 table type Myisam with many record (1.900.000)
Is there a limit of number of record for this table?
thank's
Arcangelo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Jocelyn,
you're right of course. I didn't read the original post
closely enough (it's early in the morning here...).
I missed that SELECT wasn't used.
Regards,
/Johan
[EMAIL PROTECTED] wrote:
Hi Johan,
I don't think it's its problem, since MySQL returns a "You have an error
in your
Hi,
Luckily I already found the solution, may be it'll be usefull for someone
else. All that was needed was adding the following line to my.cnf file:
[mysqld]
init-connect="SET NAMES koi8r"
Regards
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)718-3322, 718-3115(fax)
Hi Siegfried,
I think you've run into bug #8732:
...
Description:
if you do a INSERT INTO table (col_list) SELECT ... ON DUPLICATE KEY
UPDATE and
refer to the same column in the col_list and in the UPDATE clause, it
will bail
out, doesn't seem like it should, since not listing the column in the
46 matches
Mail list logo
