Try it with an absolute file path instead of a relative one. For
instance,
/usr/local/mysql/bin/mysqld_safe --user=mysql --datadir
= /usr/local/mysql/tmp
On Thu, 2005-06-16 at 15:20 -0400, Paul Mitchell wrote:
>
> ./mysqld_safe --user=mysql --datadir=/usr/local/mysql/tmp
--
MySQL General Ma
Views are supported, however, starting with MySQL version 5.0.1. See
this page of the on-line documentation to read more about it:
http://dev.mysql.com/doc/mysql/en/views.html
On Thu, 2005-06-02 at 14:31 -0400, Jerry Swanson wrote:
> Does Mysql 4 supports "views"?
--
MySQL General Mailing Li
Check out "MySQL Tutorial" by Luke Welling (MySQL Press). It's easy to
understand and not overwhelming.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Eric,
I'm glad that last answer worked, but I'm wondering what exactly you did
to resolve the problem? I see the bug report and work around. But what
specifically did you do, what did you type to fix it? By the way, what
operating system are you using for your servers?
--
MySQL General Mail
The mysql_pconnect() is a persistent connection and won't close even
with mysql_close(). Try to avoid it if you can.
On Wed, 2004-11-24 at 00:54, TM wrote:
> Do you know what is differnet between command mysql_connect and
> mysql_pconnect
>
> Thankx
>
--
MySQL General Mailing List
For list a
I dug around the archives for this list and I found the message below
from September (http://lists.mysql.com/mysql/172458)
...here is what Marko Makela told me about your situation:
It's probably from innobase_mysql_tmpfile(), which is called two or
three> times at startup. That function relies
llo Spenser
> Actually, I did the following command:
> mysqld_safe --user=mysql --tmpdir=/tmp
> and still got that error message. My understanding is that mysqld_safe
> is just a wrapper
> for mysqld.
> Gail
>
> Spenser wrote:
> > Definitely don'
Definitely don't give others permission to the /root directory. Try
starting the server like this:
mysqld --tmpdir=/tmp
If that works, then maybe you're putting you tmpdir line under the wrong
group in the my.cnf file or it's being replaced elsewhere.
On Fri, 2004-11-19 at 16:21, Gail Lange wr
I had the same problem. It just won't seem to upgrade. You need to
uninstall mysql-3.23.58-9 and mysql-server-3.23.58-9 first. Enter
something like this:
rpm -ev mysql-3.23.58-9 mysql-server-3.23.58-9
When it's done, then install version 4.x
On Tue, 2004-11-16 at 15:43, [EMAIL PROTECTED] wr
Did the system just reject Monty Widenius' posting? That can't be
right.
On Tue, 2004-11-16 at 02:14, [EMAIL PROTECTED] wrote:
> The original message was received at Tue, 16 Nov 2004 09:14:51 +0100 from
> mysql.com [173.126.215.252]
>
> - The following addresses had permanent fatal errors
You could just add a column to the beginning of your table called rowid
and index it.
On Thu, 2004-11-04 at 18:07, Raj Batra wrote:
> Is there any way of identifying each row in a table? I know in Oracble we have rowid
> which remains fixed as long as the table exists. I am trying to search all t
The attachment describing your tables didn't come through. However,
here's roughly how your SELECT statement might look:
SELECT Order.id_order, Employee.name_employee,
ItemsOrder.date_order, Unit.name_unit, ItemsOrder.status_order
FROM Order, Employee, ItemsOrder, Unit
WHERE Order.id_order=ItemsO
ing
chance.
On Wed, 2004-11-03 at 01:07, Spenser wrote:
> I'm trying to use the C++ API (a.k.a. MySQL++). The on-line manual and
> some of the books that I have say to include the file sqlplus.hh for
> connecting to MySQL. However, when I downloaded the latest version of
> MyS
I'm trying to use the C++ API (a.k.a. MySQL++). The on-line manual and
some of the books that I have say to include the file sqlplus.hh for
connecting to MySQL. However, when I downloaded the latest version of
MySQL++ (1.7.19-1 for RedHat 9) from mysql.com, it didn't seem to
include sqlplus.hh in
It should already by enabled for you unless you have the line
no-auto-rehash in your my.cnf configuration file. Or you could be
starting mysql with --no-auto-rehash or -a.
On Mon, 2004-11-01 at 20:27, Ginger Cheng wrote:
> Hello, MySQL gurus,
>I am just wondering if there is a way to set
You could write a bash script like this:
#!/bin/bash
mysql -u username -ppassword --exec="SELECT...;" > textfile.txt
There's no space after -p and before the password. This will export the
results to a simple text file. It might not be in format you want
though. But, it gives you an idea of
Well that wasn't a very nice thing to say.
On Mon, 2004-10-25 at 11:56, none none wrote:
> Like so many other people..
>
> No one puts any collective thought into what they are doing..
>
> Instead of moving on and trying to finish the rest yourself, you rely
> on someone else to finish it for yo
Does the user have permission to access the server remotely, from the IP
address of the client? You may have to add an entry in the user table
in the mysql database specifying the IP address from which you're trying
to log in.
--
MySQL General Mailing List
For list archives: http://lists.mysql.
I just tried installing it on my RedHat Linux 8 laptop and it complained
about libXcursor.so. This is the message:
error while loading shared libraries: libXcursor.so.1: cannot open
shared object file: No such file or directory
I downloaded the full tar ball version. I'm using the Gnome 2 deskt
I wish we had thought to have had him benchmark a query before and after
he added an index. It would be interesting to see the difference in
actual time that an index can make on a table with 450,000 records.
On Wed, 2004-10-06 at 15:31, Jason Williard wrote:
> Amit,
>
> You are awesome! Tha
20 matches
Mail list logo
