Hi,
greetings to the list.
I'm in process of compiling MySQL 4.1.9 using BerkeleyDB 4.3.27.
When i start make, after configuring i get the following
error-message :
--snipp--
ha_berkeley.cc:103: error: type specifier omitted for parameter `db_notices'
ha_berkeley.cc:103: error: syntax error before
Hello, we're about to start using MySQL as our main database server for
our web-based applications, so I started looking at the commercial
licencing.
My question is this: Are we allowed to upgrade from 4.0 to 4.1 or 5.0
free of charge? Or do we have to purchase another licence when moving
HI,
Currently 16 records in a table slow down the search alot.
Most of the queries are based on the date field. so I m adding index on
it at the moment.
I m wondering how much speed I can gain after finshed the index.
Apart from indexing, what other alternativies I can use to speed up the
Hi,
sometimes I run a query with LEFT JOIN on a big table and that causes 100%
CPU usage on our windows 2003 server. during that nobody has access to the
server (very very very slow), even when I wanted to kill MySQL process, it
took about 5 min.s just to show the task manager window. after 20
Hi,
I get very nervous when I log onto my database via SSH and type in queries
manually. Take the following query for example:
Delete FROM Users WHERE User_ID = 5;
If I hit return before I start typing WHERE then things would be
disastorous! Is there any type of undo function with MySQL?
Hello,
I get very nervous when I log onto my database via SSH and type in queries
manually. Take the following query for example:
Delete FROM Users WHERE User_ID = 5;
If I hit return before I start typing WHERE then things would be
disastorous! Is there any type of undo function with
Hi,
I am using egroupware and in the calendar on a specific day and event I
click on the link but MySQL gives me the following error
Database error: Invalid SQL: SELECT * FROM phpgw_links WHERE (link_app1 =
'calendar' AND link_id1 = '5') OR (link_app2 = 'calendar' AND link_id2 =
'5') ORDER BY
On Thursday 20 January 2005 13:47, Shahzad, Saleem might have typed:
Hi,
I am using egroupware and in the calendar on a specific day and event I
click on the link but MySQL gives me the following error
Database error: Invalid SQL: SELECT * FROM phpgw_links WHERE (link_app1 =
'calendar'
Hi,
Thank you. Could you please help me in writing an equvivalent
query in mysql for the following oracle subquery?.
update macvm set embedded='Y' where vm_server in
(select a.vm_server from macvm a, component b, element c where
a.vm_server = b.name (+)
and b.id
Database error: Invalid SQL: SELECT * FROM phpgw_links WHERE (link_app1 =
'calendar' AND link_id1 = '5') OR (link_app2 = 'calendar' AND link_id2 =
'5') ORDER BY link_lastmod DESC
mysql Error: 1146 (Table 'egroupware.phpgw_links' doesn't exist)
That would indicate to me 2 possibilities:
1)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am trying to compile this version for myself, but am having problems,
as there is a complaint that sql_functions, get_hash_symbol and symbols
are undeclared.
Is there any plan to make a binary for solaris 8 for mysql 5.0.2?
Thank you.
- --
Love is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I would like to set one column to point to the auto-incrementing index
of the last comment in the database for my application, but I am getting
an error when I run my test, and so I wonder if what I am trying to do
is possible.
I am using mysql 5.0.1,
According to phpMyAdmin I have:
user 'root' on 'localhost'
with no password
with Global privileges set to 'All privileges'.
If I do a SELECT user(), I get '[EMAIL PROTECTED]'. Yet
there is a database that doesn't now allow me to
Browse. How can that be? Don't I have sufficient
rights?
[snip]
I get very nervous when I log onto my database via SSH and type in
queries
manually. Take the following query for example:
Delete FROM Users WHERE User_ID = 5;
If I hit return before I start typing WHERE then things would be
disastorous! Is there any type of undo function with MySQL?
James Black wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I would like to set one column to point to the auto-incrementing index
of the last comment in the database for my application, but I am getting
an error when I run my test, and so I wonder if what I am trying to do
is possible.
My
On Thu, Jan 20, 2005 at 08:58:18AM -0600, Jay Blanchard wrote:
[snip]
I get very nervous when I log onto my database via SSH and type in
queries
manually. Take the following query for example:
Delete FROM Users WHERE User_ID = 5;
If I hit return before I start typing WHERE then things
Paul Wallace [EMAIL PROTECTED] wrote on 01/19/2005 06:50:48 PM:
Was there a reply to this post? If so, I could have (did) missed it. Can
you please resend?
Rgds
Paul.
Sorry, but I never said (woops!)
Which language I use depends on where I want to run the script and how
often,
Hello,
If you define table type as InnoDB, you can use transactions (see the link
below). You will need set AUTOCOMMIT=0, and after you can issue COMMIT or
ROLLBACK at the end of query or session to submit or cancel a transaction. I
don't think you can use transactions for mysql system tables
Hi,
I don't know what is wrong with running indexing on this table. It have
been last for nearly 3 hours.
here is the command I run at the prompt of mysql :
alter table inventory add index(basename);
Because it is running indexing, all operation seems hang up.
As far as I can remember I only
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Philippe Poelvoorde wrote:
| James Black wrote:
|
| -BEGIN PGP SIGNED MESSAGE-
| Hash: SHA1
|
| I would like to set one column to point to the auto-incrementing index
| of the last comment in the database for my application, but I am getting
|
Hi,
sometimes I run a query with LEFT JOIN on a big table and that causes 100%
CPU usage on our windows 2003 server. during that nobody has access to the
server (very very very slow), even when I wanted to kill MySQL process, it
took about 5 min.s just to show the task manager window. after 20
Hi,
sometimes I run a query with LEFT JOIN on a big table and that causes 100%
CPU usage on our windows 2003 server. during that nobody has access to the
server (very very very slow), even when I wanted to kill MySQL process, it
took about 5 min.s just to show the task manager window. after 20
Hi,
Could you please help me in writing an equvivalent query in mysql 4.0.21
for the following oracle subquery?.
update macvm set embedded='Y' where vm_server in
(select a.vm_server from macvm a, component b, element c where
a.vm_server = b.name (+) and b.id = c.id (+) and c.sxvariant =
Backups are good too :-)
Andy
-Original Message-
From: Artem Koltsov [mailto:[EMAIL PROTECTED]
Sent: 20 January 2005 15:06
To: mysql@lists.mysql.com
Subject: RE: Undo function?
Hello,
If you define table type as InnoDB, you can use transactions (see the link
below). You will
Hello,
some weeks ago we switched from mysql 4.0.20 to 4.18 and later to 4.1.9.
A customer now told us, that he can't access his old InnoDB-tables. He gets
#1016 - Can't open file: 'Autor.ibd' (errno: 1)
if he tries to access the table Autor. This happens to other
InnoDB-tables created with
[EMAIL PROTECTED] wrote on 01/20/2005 08:59:15 AM:
Hi,
Thank you. Could you please help me in writing an equvivalent
query in mysql for the following oracle subquery?.
update macvm set embedded='Y' where vm_server in
(select a.vm_server from macvm a, component b,
hai,
am using sqlyog for mysql
i have taken back up in batch ie .sql
i want to restore automatically can it be possible to restore by writing a code
in vb using sqlyog
i have written a programme in vb for taking back up automatically
need help to restore the same automatically
regards
~ I want to store the parent comment to the comment being added, so I
can ensure the comments are printed out in the correct order.
Then, see the post earlier called SQL schema, where there is
child-parent relationship with comments.
But you now when a user post a comment which is the parent
I have the following query which will get me all of the emails for my
current membership:
SELECT email.email_address
FROM member, email
WHERE
member.member_primary_email_id = email.email_id
AND member.member_standing != Dropped
ORDER BY email.email_address
I also have a query which will get me
You should *ALWAYS* indicate which version of MySQL you are using when you
ask this sort of question; the answers is almost always it depends: if you
are using 3.x, do X, if you are using 4.0.x do Y, if you are using 4.1.x do
Z. It's a lot of work to list all of those options and most people won't
Hello.
What is in error log? Usually it is located in the data directory or
in the place which was specified in config file. More information you
may find at:
http://dev.mysql.com/doc/mysql/en/Symbolic_links.html
kaustubh shinde [EMAIL PROTECTED] wrote:
Hi all
I recently installed
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Problems_with_character_sets.html
Manish [EMAIL PROTECTED] wrote:
How can I set character set as UTF-8 for mysqldump command?
When I try this, I get an error -
mysqldump --default-character-set=UTF-8 -uNAME -pXXX mydb
Hello.
The complete answer on your question you can receive at [EMAIL PROTECTED]
Mat [EMAIL PROTECTED] wrote:
Hello, we're about to start using MySQL as our main database server for
our web-based applications, so I started looking at the commercial
licencing.
My question is this:
You're not serious are you? You don't really mean that you want a restore to
be automatic do you?
I don't think I've ever met a DBA who would trust a fully-automatic restore:
most DBAs want to have some control over the restore process so that they
can at least *initiate* it when they want it.
On 1/20/05 11:16 AM, Rhino [EMAIL PROTECTED] wrote:
You should *ALWAYS* indicate which version of MySQL you are using when you
ask this sort of question; the answers is almost always it depends: if you
are using 3.x, do X, if you are using 4.0.x do Y, if you are using 4.1.x do
Z. It's a lot
Hello,
I have trouble with setting mysql database quota per user at my server.
I`m using MySQL 4.0.22 on Linux with kernel 2.4.29.
I`m using group quota on my server and all user`s files, mails and databases
are with group $user (user`s mysql database directory is with setgid bit
enabled to
Mike Zornek [EMAIL PROTECTED] wrote on 01/20/2005 11:01:38 AM:
I have the following query which will get me all of the emails for my
current membership:
SELECT email.email_address
FROM member, email
WHERE
member.member_primary_email_id = email.email_id
AND member.member_standing !=
[EMAIL PROTECTED] wrote:
SELECT DISTINCT i.basename
FROM inventory i
INNER JOIN transaction t
ON i.prodcode = t.prodcode
AND t.date = '2004-01-01'
AND t.date = '2004-01-31'
INNER JOIN transaction tt
ON i.prodcode = tt.prodcode
AND tt.date = '2005-01-01'
That's a great start but you haven't shown the Member table. It would also
be very useful if you included a few sample rows from each table. For
example, I'm looking at the member_id_edited and member_id_editor columns so
that I can create tiny sample tables like yours and I have no idea what
Also a good practice for shakey hands is to start mysql with the
--safe-updates option. This will not allow a delete or update to be
executed without a where clause.
On Thu, 20 Jan 2005 10:55 am, Andy Eastham wrote:
Backups are good too :-)
Andy
-Original Message-
From: Artem Koltsov
Hi!
If you have put:
innodb_file_per_table
in your my.cnf or my.ini in Windows, and try to run MySQL-4.1.9, the mysqld
server exits and prints:
050117 3:07:59 InnoDB: Operating system error number 87 in a file
operation.
to the .err log.
You can work around the bug in 4.1.9 by putting:
sam wun [EMAIL PROTECTED] wrote on 01/20/2005 11:45:40 AM:
[EMAIL PROTECTED] wrote:
SELECT DISTINCT i.basename
FROM inventory i
INNER JOIN transaction t
ON i.prodcode = t.prodcode
AND t.date = '2004-01-01'
AND t.date = '2004-01-31'
INNER JOIN
Hello.
What is the output of the following statement:
show grants for 'root'@'localhost';
J C [EMAIL PROTECTED] wrote:
According to phpMyAdmin I have:
user 'root' on 'localhost'
with no password
with Global privileges set to 'All privileges'.
If I do a SELECT user(), I
Okay, with the good help I was getting, and looking at the all clues MySQL
was giving me, like Table 'mysql.host' doesn't exist and Can't find file:
'./mysql/host.frm', I concluded that the 4.1.9 installation conflicts with
the default 4.0.18 installation. For instance, 4.0.18 expects files in
Howdy,
I'm looking for ways to better enforce user password security through
MySQL. Currently, it does not appear that there are any restrictions on
minimum length, password expiration times or strong password checking.
Other than educating the users directly, is there a way to enforce any
or
I am using mysql 3.23. I want to know if it is possible to setup different
size quotas for different databases?
Emil Diego
Website Administrator
University of Miami School of Business
305.284.5449
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
Hello,
I don't have any chance with this topic :-) I usually follow that list with
my professional email, and there are often good advices on normalization or
sql design. Do you need any more details ?
Thanks for your help
[EMAIL PROTECTED] écrit:
Hello,
I've got a DB design issue
snip
You're not serious are you? You don't really mean that you want a
restore to
be automatic do you?
snip
If you really do mean that you want to completely automate the
restore, what
event is going to trigger the restore?
Rhino
I believe what the OP is after is restoring a database
How long until we'll see an Intel icc compile of 4.1.9 on the downloads site?
Thanks.
Jeremiah Gowdy
Senior Software Engineer
FreedomVOICE Systems
You must be having a problem with your email client as this is about the
ninth time I have seen this same request today. Please check your client
for problems. I know because I have responded once already.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Philippe Poelvoorde wrote:
|
| Insert into comments(list of you fields here )
| select 0,1,null,'testuser','testcomment',max(idx) from comments
| where sourceid=1;
|
| but querying max(idx) is a bad idea. you could get the last inserted id
| with
What is the output of the following statement:
show grants for 'root'@'localhost';
Grants for '[EMAIL PROTECTED]'
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH
GRANT OPTION
It turns out that the database that I was trying to
decipher, appears to have nothing but empty tables. I
James Black [EMAIL PROTECTED] wrote on 01/20/2005 02:44:41 PM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Philippe Poelvoorde wrote:
|
| Insert into comments(list of you fields here )
| select 0,1,null,'testuser','testcomment',max(idx) from comments
| where sourceid=1;
|
| but
We are in the process of upgrading from 3.23.x to 4.0.x via compiling
(can't use rpms). I've read through old forum posts and the documentation
and I see there is this requirement for libmysqlclient.so.10 while the new
4.0.x comes with libmysqlclient.so.12. I also see that many people are
using
James Black [EMAIL PROTECTED] wrote on 01/20/2005 03:08:33 PM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
| You should already KNOW the parent comment of a comment when you
create
| it. Don't you? Imagine the following thread:
~ I am trying to not have to
I am not sure what I am noticing is the intended behavior of MySql. I created
my table with CHAR(15) data types. When I describe the table, it appears as
VARCHAR(15) ..
Here are the statements -
alter table mytable add (loc char(15));
Query OK, 1 row affected, 1 warning (0.02 sec)
Records: 1
This is documented in the manual
http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html.
Michael
Nupur Jain wrote:
I am not sure what I am noticing is the intended behavior of MySql. I created
my table with CHAR(15) data types. When I describe the table, it appears as
VARCHAR(15) ..
We are building an application for myths of the world. It started out in
Access, but when we decided to distribute it via CD to attendees at an
art retrospective (about myths of the world), we began looking for an
alternative db, since not everyone has Access on their computer. There
will be
Try this:
Setup a database server, with MySQL 4.1, with query cache turned on
Setup a client machine with MySQL 4.0
Setup a client machine with MySQL 4.1 (libmysqlclient14)
Create very simple table
: CREATE TABLE woepwoep (CNT int NOT NULL);
Insert single row
: INSERT INTO woepwoep SET CNT=10;
Hi Again,
You have to optimize a large database (2 Million records).
since I have a huge amount of 'static' records (2 million and more)
which will not change any more, and on the other hand at about 2.ooo
(growing) records which are updated regulary, I wonder if its useful
having those static
Marten,
- Original Message -
From: Marten Lehmann [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, January 20, 2005 5:47 PM
Subject: 4.0.20 - 4.1.9 Can't open file: 'Autor.ibd'
Hello,
some weeks ago we switched from mysql 4.0.20 to 4.18 and later to 4.1.9.
A
I was uninstall server version 3.23 (or something like this), then install
4.1.7 (with some troubles), and than uninstall 4.1.7 and try to install
4.1.9. version.
Everything looks fine, except installation procedure can't install MySQL
like Windows service (Win XP pro).
I was trying to install
SHOW TABLE TYPES became available in MYSQL 4.1.
What is the equivalent for MYSQL 3.23.49?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, 19 Jan 2005 21:28:05 -0800, elizabeth baker
[EMAIL PROTECTED] said:
We are building an application for myths of the world. It started out in
Access, but when we decided to distribute it via CD to attendees at an
art retrospective (about myths of the world), we began looking for an
elizabeth baker wrote:
We are building an application for myths of the world. It started out
in Access, but when we decided to distribute it via CD to attendees at
an art retrospective (about myths of the world), we began looking for
an alternative db, since not everyone has Access on their
Hi there,
I'm running Freebsd 5.3 and just installed
mysql-standard-4.1.9-unknown-freebsd4.7-i386. I'm able to run mysqld and
mysql, etc. I used to run Freebsd 2.2 and I think it was mysql 3.21.33b...
I'm not sure. My old system faded away rather abruptly and I didn't get a
chance to do database
At 22:46 -0600 1/20/05, Bagus wrote:
Hi there,
I'm running Freebsd 5.3 and just installed
mysql-standard-4.1.9-unknown-freebsd4.7-i386. I'm able to run mysqld and
mysql, etc. I used to run Freebsd 2.2 and I think it was mysql 3.21.33b...
I'm not sure. My old system faded away rather abruptly and I
I did try
--type='myisam'
--type='isam'
--type=myisam
--type=isam
--type='MYISAM'
--type=MYISAM
--type='ISAM'
--type=ISAM
All produced identical errors.
Specifying the individual tables didn't change the error note. Any other
ideas?
Is this the right way to go about changing these ISD, ISM,
Hi Iavor,
On Fri, 2005-01-21 at 02:33, Iavor Stoev wrote:
I have trouble with setting mysql database quota per user at my
server.
I`m using MySQL 4.0.22 on Linux with kernel 2.4.29.
I`m using group quota on my server and all user`s files, mails and
databases are with group $user (user`s
69 matches
Mail list logo