I use MySQL in both a Unix real C/S config and then on my laptop standalone. The
documentation on the Web site showing how to take commands from a file is simple
enough. source file_name_containing_commands; and this works just fine in Windows,
but in UNIX, no matter how I try to resolve the
G'day Sam
I am upgrading to Panther and I need to install MySQL. Does anybody
know if the Mac OS X Installer Package v10.2 (Standard) works with
10.3? If it doesn't then what would be the best installation method on
a clean 10.3 installation?
FWIW, I upgraded to Panther on the weekend
My bad, I should have been more precise. I am not upgrading - I have
done a clean install. So, now I need to re-install MySQL.
-Thanks
On Tuesday, October 28, 2003, at 11:00 PM, Kim Kohen wrote:
I am upgrading to Panther
--
MySQL General Mailing List
For list archives:
Hello,
I've reinstalled my system (Mac OS 10.3 Server).
In trying to get MySQL going again. I can run mysql_install_db, but I
can't access the mysql db and I can not set a root user password.
If I try to login: mysql -u root
it says access denied to [EMAIL PROTECTED]
If I simply type mysql (no
Hi,
For decades, people have debated in comp.databases.theory and elsewhere
how
a 'relational database' should be defined.
Codd's original 1970 paper sketches the relational algebra as a query
language of a relational database, though Codd is not very precise about
what the query language
Begging to differ, no vendor that I'm aware of claims to be compliant with
a
paper or textbook. They tend to comply with an adopted standard such as:
ANSI/ISO/IEC 9075-1(through 5):1999
ISO/IEC 9075-1(through 5):1999
Yes, a strange thing too IMHO. The SQL standard defines a so-called
That sooo cool... It was the very perfection of beauty.
but i didnt' know.why my index (ClassID, Auditing, CreatedTime) are
slowly as matt's (ClassID, Auditing, CreatedTime, ArticleID)
could matt explain why?
Thx matt..
On Tue, 28 Oct 2003 02:06:16 -0600
Matt W [EMAIL PROTECTED] wrote:
Hi,
hi,
the MySQL syntax said:
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)]
VALUES ((expression | DEFAULT),...),(...),...
[ ON DUPLICATE KEY UPDATE col_name=expression, ... ]
or INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name
Hi Matt,
I'm sorry to say that even after upgrading to MySQL-4.0.16, our server
is still suffering from the exact same symptoms, albeit on a Linux
system.
We have recently done some serious testing to rule out hardware failure,
but the error persists. Tables corrupt and mysqld restarts with a
Thanks.
Whith InnoDB tables I have to do something similar or it's not necessary?
Iago.
-Mensaje original-
De: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Enviado el: martes, 28 de octubre de 2003 19:49
Para: 'Iago Sineiro'; 'MySql Mail List'
Asunto: RE: Howto reduce size of
Ok, I've set my root password and have found (by creating a db) that
the databases are stored (Mac OSX Server 10.3) in /private/var/mysql.
I have my old system on a separate hard disk; however, mysql is not
functioning there, but I do have my databases there. Can I copy these
database to
Hello all,
Default optimizer behavior has changed in 4.0.16 (since 4.0.14)
for this simple question:
select state_id, orderdata_id from order_delivery where
orderdata_id in
(3193340,3193343,3193346,3193349,3193352,3193355)
and is_deleted=0 order by xtime desc
CREATE TABLE `order_delivery` (
that will be recognized very well, just check the file ownership after
copying directory and files. all the data directory and files should be
owned by mysql only
Nitin
- Original Message -
From: [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 2:23
Steve Buehler [EMAIL PROTECTED] wrote:
I have upgraded my mysql version to 3.23.58 and am coming up with a couple
of errors using phpmyadmin to Insert data from a textfile into table I
didn't get this on the previous versions of mysql. Here are the errors:
SQL-query :
LOAD DATA
I use this syntax but I have privilege problem.
Thenk you anyway
- Original Message -
From: Nitin [EMAIL PROTECTED]
To: IEEIO AAOOCO [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, October 27, 2003 5:20 PM
Subject: Re: Insert ... Select question
of course, the syntax is:
insert
Hi,
Does anyone knowns SAP DB and can tell me if it's a good database?
Thanks!
Catia Crepaldi
System developer
Catho Online
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What is the trick for writing a SQL that gives me running totals of some
values? For example, I have a table with values like this:
Field1
1
2
3
4
and I want a SQL to return something like this:
1
3
6
10
TIA,
Ivo Karindi
--
MySQL General Mailing List
For list archives:
Ivo [EMAIL PROTECTED] wrote:
What is the trick for writing a SQL that gives me running totals of some
values? For example, I have a table with values like this:
Field1
1
2
3
4
and I want a SQL to return something like this:
1
3
6
10
You can do something like:
SELECT
Thanks for the new MySQL server.
My MySQLcc works fine now.
But..
My PHP cann't connect anymore to the server.
The lib is not there i think. Because i get an error mysql_connect() doesnot exist.
What to do ??
I need my server with PHP and MySQL for a demostration.
Help
With regards,
Rob J
In a message dated 10/29/03 4:18:28 AM Eastern Standard Time,
[EMAIL PROTECTED] writes:
Ok, I've set my root password and have found (by creating a db) that
the databases are stored (Mac OSX Server 10.3) in /private/var/mysql.
I have my old system on a separate hard disk; however, mysql
Hi there,
Does anyone have some tips or advice for creating backups of all the tables
and data contained therein? Do you use custom solutions or perhaps
open-source projects?
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hassan Schroeder [EMAIL PROTECTED] wrote:
If this is documented anywhere, I sure can't find it, so --
The query log fields are headed: Time, Id, Command, Argument.
What is 'Id'?
It's a process id. You can see it in the output of SHOW PROCESSLIST.
--
For technical support contracts,
mysqldump...lots and lots of options
http://www.mysql.com/doc/en/mysqldump.html
hth
Jeff
Erich C.
Read the manual at the section:
Disaster Prevention and Recovery
Database Backups
with mysqldump you can dump a whole database.
hans
At 09:03 29-10-03 -0500, you wrote:
Hi there,
Does anyone have some tips or advice for creating backups of all the tables
and
[EMAIL PROTECTED] wrote:
mysql LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO
TABLE quantis_mkr;
Query OK, 271392 rows affected (4 min 2.95 sec)
Records: 271392 Deleted: 0 Skipped: 0 Warnings: 61
How can I see those warnings?
I checked the error log but nothing shows up
Over the last two days, we have upgraded the OS on our two database
servers. We have one that handles the database for our content and the
other handles the database for our forums.
For completeness sake, they were both running RH 7.1 with kernels
patched for ReiserFS. The data was stored on
Rob Wierenga wrote:
Thanks for the new MySQL server.
My MySQLcc works fine now.
But..
My PHP cann't connect anymore to the server.
The lib is not there i think. Because i get an error mysql_connect() doesnot exist.
What to do ??
snip
If php gives you the error that mysql_connect is a call to
Hello,
I'm trying to upgrade to version 4.1.0-alpha of MySQL from version 3.23.51
on a Windows 2000 platform.
I've downloaded the binary distribution of 4.1.0-alpha and followed the
install process(README.1st) for an upgrade install.
At the step :
* Execute the
'mysql -A sampdb' hangs as does every other mysql command. There are no
recent entries in hostname.err.
-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 5:52 PM
To: Anderson, James H [IT]; [EMAIL PROTECTED]
Subject: RE: problem
I'm experiencing the same problem. Everytime when I shut down mysql and use
myisamchk to do the maintenance, I'll get a few tables crashed. In
phpmyadmin they showed a status of in use. I have to repair them to get
the db working.
Rainer
- Original Message -
From: Brian Moon [EMAIL
Being real new to MySQL I am having difficulty finding information on how to
retrieve data from the last record in a database.
I have tried using the SELECT LAST_INSERT_ID() statement but that only works
on a per connection basis and doesn't help all the times.
Basically I want to goto the end
Hi Jess,
Being real new to MySQL I am having difficulty finding information on how
to
retrieve data from the last record in a database.
Mind you - the last record doesn't have to be the last record if you're
running an application with multiple users.
That said, the last record in any table
this should work
SELECT sku from [table] order by [key] desc limit 1
hth
Jeff
Hunter, Jess
Hi everyone. I'm using MySQL 4.0.16 with W2K/SP4 on a 512KB RAM/1.2GHz
Athlon machine (my dev workstation).
I'm having a strange problem: when I execute a query via the MySQL Control
Center, it takes 10 seconds to return. About three seconds into the query,
I issue a mysqladmin processlist and see
I should add that I can access the database via a java program, just not
using the mysql command.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks for the tip. Before I sent my message I tried different my.cnf
files. The basedir made the trick for the pid-file.
Now, how do I connect to mysql in the other port? When I use mysql -umysql
-p --port 10441 it takes me to it but is finding the data for 3306. I tried
login to the machine as
There is caching but it is at OS level: on first query, data are
fetched from disk; other queries read directly from file system cache.
Hope this helps
Joseph Bueno
[EMAIL PROTECTED] wrote:
Hi everyone. I'm using MySQL 4.0.16 with W2K/SP4 on a 512KB RAM/1.2GHz
Athlon machine (my dev workstation).
but if my table is sooo big..
eg if large than 1 G. so use the mysqldump is more and more slowly
speed.
Hans van Dalen [EMAIL PROTECTED]
??:[EMAIL PROTECTED]
Read the manual at the section:
Disaster Prevention and Recovery
Database Backups
with
Hi,
This is rather a Perl DBI question than a MySQL one.
I have recently upgraded a MySQL 3.23 server to 4.0. It resulted in some
of my queries (issued using Perl DBI) starting to fail. It turned out to
be that queries like
$sth = $dbh-prepare(SELECT whatever FROM something WHERE anything
Hi,
Im trying to install a newer version of Mysql on our Red Hat 2.1 AS.
I'm still new to Linux Installations. I can't seem to figure out what
im doing wrong.
This is what I have tried, can somebody point me in the right direction
[EMAIL PROTECTED] root]# rpm -i
Thanks Joseph.
I just to another look at the query and it actually takes 65 seconds on the
first run, not 10 seconds, so this is important for me to understand.
So my next questions are:
Is there any way to tune the OS file system cache?
Is there any way to flush it or examine what's in it?
On 29 Oct 2003 at 18:00, Fagyal, Csongor wrote:
Any ideas what causes this behaviour? Maybe I have not upgraded my DBI
DBD packages properly? Or are LIMIT placeholders no longer supported
in DBI with MySQL 4?
I don't think the MySQL version is relevant. The change is in
DBD::mysql 2.9002,
avenger wrote:
but if my table is sooo big..
eg if large than 1 G. so use the mysqldump is more and more slowly
speed.
I don't have one gig tables, but I do have a few that come in at a few
hundred meg. I actually dump them to another machine on my network
(100mbit NIC cards) and it
Michael,
Thanks for informing me on that one. I was not aware of that problem
with multi-row inserts. For the sake of consistency with other DBMS's,
I don't use those, and now I'm quite glad. In fact, this attribute of
mySQL also applies to UPDATE statements, which allow the same columns to
be
[EMAIL PROTECTED] wrote:
Thanks Joseph.
I just to another look at the query and it actually takes 65 seconds on the
first run, not 10 seconds, so this is important for me to understand.
So my next questions are:
Is there any way to tune the OS file system cache?
This is very OS system dependent
* Catia Crepaldi
Does anyone knowns SAP DB and can tell me if it's a good database?
I have never tried it, but just FYI, SAP DB is going to be MaxDB shortly,
here is some more info:
URL: http://www.sapdb.org/
URL: http://www.sapdb.org/7.4/sapdb_mysql.htm
URL:
I am working on some database tables to handle messages on an intranet.
One table looks like this
msg_id | subject | message | date
there is another table used to track senders and recipients that looks like
this
msg_id | sender_id | recipient_id |
Now what I would like to do is delete any
Please help -- by brain is fried...
I have three tables: groups, members, and a link table called group_members.
There is a record in group_members for each member that belongs to a given
group.
A member may belong to several group.
I want to get a results set that shows all members where a
Rainer,
To find out if there is any query that is taking too long to run, enable
the log-slow-queries option and set long_query_time to some
initial value like 5 or 10 (it's in seconds).
Then check your slow queries log file and try to understand why those
queries are taking too much time to
I have a small table that contains company contact information:
Table: Contacts
Key
Name
Address
Phone
Email
Website
etc..
What I need to do is associate the type of industry the business servers
from a list of about 40 industries... My initial thinking was to create
another table that
Egor Egorov wrote:
It's a process id. You can see it in the output of SHOW PROCESSLIST.
So, each Id represents a thread, and each thread represents a
connection? So an entry like this in the query log:
031029 9:56:43 6 Quit
:: would represent a connection returned to the pool through an
I used the MySQL Complete package from Server Logistics and it
installed fine on my clean Panther install. Also, the MySQL Preference
Pane and CocoaSQL work fine as well.
Thanks,
-Sam
On Tuesday, October 28, 2003, at 11:08 PM, Sam Carpenter wrote:
My bad, I should have been more precise. I
I can't get through
I am doing as follow. Is it right or I am doing something wrong?
[EMAIL PROTECTED] parminder]#
/usr/local/mysql/share/mysql/mysql.server stop
Killing mysqld with pid 31796
Wait for mysqld to exit\c
done
I can't use mysqld
you are going to want a 'buster' table... also known as a many-to-many table
so you have:
contacts
Contact_Key
Industries
-
Industry_Key
Contact_Industry_assoc
--
Contact_Key
Industry_Key
-Original Message-
From: DeBerry, Casey [mailto:[EMAIL
Casey,
I would consider, on the most basic level, a method like this:
Contacts (all the company contact info, etc) using primary key contact_id -
IndustrialRelationships table
- industry_id primary key on Industries table (all the different type of
industries)
So, in the IndustrialRelationships
to help the mysqld_safe 'finish' you'll need to append an '' to your
command, which will have the process start in the background and give you
your prompt back.
/usr/local/mysql/bin/mysqld_safe --skip-grant-tables
now you can hit the enter key, and you'll get your prompt back
I have an app that (rapidly) adds items (via individual insert statements as
items are parsed in from a file) into the database. I seem to be randomly
getting got error 22 from table handler on what appears to be perfectly
valid INSERT queries.
perror 22 gave:
Error code 22: Invalid argument
I don't think you really want a LEFT JOIN. (See
http://www.mysql.com/doc/en/JOIN.html). What you do need, I believe, is
a join of group_members with itself to get member IDs on one side whose
group ID matches Jim's group ID on the other side.
Try something like this:
mysql SELECT
I think that mysql_connect is not defined in the MySqlClient lib.
I try to use it in a C proram but I get a link error.
I have to use mysql_real_connect.
Try to install compat library.
Santino
At 9:35 -0600 29-10-2003, John Nichel wrote:
Rob Wierenga wrote:
Thanks for the new MySQL server.
My
Rob Wierenga wrote:
My PHP cann't connect anymore to the server.
The lib is not there i think. Because i get an error mysql_connect() doesnot exist.
PHP is linked to a certain build of the mysql client library.
If you exchanged the mysql server and all of the client stuff, you'll
need to
Thanks
Now I am able to get back the cursor
but I can't change the password
[EMAIL PROTECTED] parminder]# /usr/local/mysql/bin/mysql -u root
mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.16-log
Dear all
I have a table with more than 100'000 records for a single product. At
the end, I will have tables for 26 prodcuts. There is basically no
dependence on other tables.
Somewhere I read that one should avoid a large number of tables in
a database. Is it more recommendable to have a
Hi Group,
Sorry i am posting the same message asking about data modelling tool.
I am looking for the best data modelling tool for the mysql 4.0 dbms. Specifically i
am looking for the generalization/specialization relationship support within the tool.
Thanks in advance.
Hardik
Matt W mailto:[EMAIL PROTECTED]
on Monday, October 27, 2003 5:29 PM said:
As to why mysqldump would create a dump file with a syntax error in
it, that's because *you* (or the application creator) used a reserved
word for a column/index name (bad idea) and mysqldump
I always try to be
On Wed, 2003-10-29 at 14:18, Chris W. Parker wrote:
Matt W mailto:[EMAIL PROTECTED]
on Monday, October 27, 2003 5:29 PM said:
As to why mysqldump would create a dump file with a syntax error in
it, that's because *you* (or the application creator) used a reserved
word for a
Andy Bakun mailto:[EMAIL PROTECTED]
on Wednesday, October 29, 2003 12:27 PM said:
It may be best to always use the --quote-names option to mysqldump,
which would avoid any problems you might encounter with reserved words
being used in column and table names.
Already done. :)
Chris.
--
Dan,
You don't need a LEFT JOIN here. Left join lets you keep all of the rows in
one table in a
join, even when there are no matching rows in the second table.
You do have to use the group_members table twice, once to find all the
groups to which
Jim belongs, and again to find all of the
Dear All,
I've tried searching the web to save me having ask for help.
I'm trying to remove my user's ability to use SHOW DATABASES. In the past, I have
added skip-show-database to /etc/my.cnf. However, on this installation, any user can
see all the database names! Despite my efforts to
The database is working fine, by the mysql command hangs indefinitely. Any thoughts
how I can determine the cause?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Wolfgang,
I'd say it somewhat depends on what data you have and what you really are
going to use the records for. If you never need to retrieve data for more
than one product at a time and there are significant differences in the data
set between the products then maybe you might split it.
In 4.0.2 SHOW DATABASES became a privilege, and if you don't have that privilege then
you can see only 'your own' databases.
Maybe your privileges were changed during the upgrade?
http://www.mysql.com/doc/en/Show_database_info.html
Chris
-Original Message-
From: Dickon Newman
I'm working on an embedded Linux project on the MIPS platform. We have
rather limited space for storing binaries and libs and also limited RAM
so I was trying to trim down libmysqld as small as possible. Currently
the libmysqld.a is about 8MB in size and this is after an objdump
--strip-unneeded
I am doing transfer from MS SQL.
In MS SQL while I connect as USER1 my table will be create as User1.TableName.
This will avoid conlict with other user.
Now, how do I do that in Mysql? Or, maybe there is such system in Mysql. Is there any
Mysql reference talk about this matter?
I'm not familiar with that function in MS SQL, and you're a bit unclear, but it looks
like you might be able to use temporary
tables.
http://www.mysql.com/doc/en/CREATE_TABLE.html
Temporary tables are on a per-connection basis, and are unique per connection (each
connection can have a
Chris said:
I'm not familiar with that function in MS SQL, and you're a bit unclear,
but it looks like you might be able to use temporary tables.
http://www.mysql.com/doc/en/CREATE_TABLE.html
Temporary tables are on a per-connection basis, and are unique per
connection (each connection can
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
I'm not familiar with that function in MS SQL, and you're a bit unclear, but
it looks like you might be able to use temporary
tables.
Looks like he's asking if MySQL supports namespaces. Is there anyway to
simulate
I just upgraded an embedded server application to use 4.0.16 (from 4.0.12)
and now I am quite consistently getting a corrupt table. I am now getting
Got error 127 from table handler returned as the error. Copying the data
directory into a true SQL server and executing a CHECK on the involved
Dear,
We encountered mysql (innodb) crash, and we can't recover the database
after the crash. Could you please help use to investigate the problem.
Thanks in advance for your help.
The following is copied from the mysql error log:
031027 17:16:12 mysqld started
031027 17:16:12 Warning:
Hi;
New subscriber to the list, searched the archives for any thread on this
with no joy so
sorry if it's a re-post.
Can I have 2 bind-addresses in my.cnf ?
Changing ports is not an option.
Dual honed Sun Box running MySQL 4.x
Thnks
Scot Needy
[EMAIL PROTECTED]
757-664-2217
Yahoo.id
Here's a little how to on using cron and scp to do automated backups of
your data:
http://www.spaceprogram.com/knowledge/cron_scp.html
Only thing you need to add is the a mysqldump line to your cron script
before calling the scp.
Travis
A. Clausen wrote:
avenger wrote:
but if my table is
When testing my application code I note that
mysql_query() does not return a non-zero
result when a lock timeout occurs -- the error is detected
when I try to retrieve the result set and get a NULL
value.
However, this finding is not consistent; for example
in one block of code a mysql_query()
Narrowed it down - it doesn't seem to have anything to do with the table
locking. I removed ALL locking/unlocking and it made no difference. Still
getting there error.
What would cause the 127 error? (perror says: 127 = Record-file is crashed)
Adam Clauss
[EMAIL PROTECTED]
-Original
82 matches
Mail list logo
