Hello Mysql list,
I try to create foreign keys in a innodb database. I read through some threats
and the manual, and several online resources, but somehow I am missing
something.
What I try to do is recreate the keys and their functions of the mysql
database (privilege database) as a innodb d
On 07-Jun-2003 Andre wrote:
Please don't hi-jack threads.
By replying to a message and changing the subject, you screw-up the
threading features of most mail clients.
If you want to start a new thread then please start with a new message.
>
> 1) Any ideas where I might begin to look to fi
Having run MySQL successfully for a while in a WAMP environment, I'm trying
to set up on Linux now (and am a real Linux newbie). I'm using the 4.3.1
version that came as an RPM with SuSE 8.2. The problem is - it doesn't work.
Here's where the various elements have installed to:
/usr/bin
vario
OS X (10.1 Client and 10.2 Server).
My 3.23.51 builds seem to have the same problem.
Since PHP access it properly, and the MySQL client can with the
proper variable setting, I guess I'll just leave it alone.
- John
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John May wrote:
The other odd
configuring is only be done on build time procedure.
I supposed (not sure) that your problem is with your precompiled binary. I
dont really know whether the default precompiled binary building with enable
LOAD DATA or not.
so , you can try install it with mysql source .(not precompile binary).
Reg
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John May wrote:
> The other odd thing I find is that the MySQL manual states:
>
>
> By default, all MySQL clients and libraries are compiled with
> --enable-local-infile , to be compatible with MySQL 3.23.48 and before.
>
>
> However, I'm using a 4.0.
The other odd thing I find is that the MySQL manual states:
By default, all MySQL clients and libraries are compiled with
--enable-local-infile , to be compatible with MySQL 3.23.48 and
before.
However, I'm using a 4.0.12-max binary (pre-compiled binary direct
from MySQL's site) on one machine
Can this only be done at build time? Or can I enable it after the
fact? If so, how? I tried enable-local-infile as both a setting in
my.cnf and when calling safe_mysqld both with no luck.
In the meantime, I've found that PHP apparently calls MySQL with the
local-infile option on - once I dow
If you don't configure MySQL with --enable-local-infile, then LOAD DATA
LOCAL will be disabled by all clients, unless one calls mysql_options(...
MYSQL_OPT_LOCAL_INFILE, 0) in the client
Read the mysql manual from msyql.com about
'manual_MySQL_Database_Administration.html#LOAD_DATA_LOCAL'
Regards
Hello:
I was wondering if anyone had any advice to a couple questions.
1) Can I add additional columns to the user and db tables of mysql. These
would be for administrative purposes only.
2) I'm trying to figure out how the privileges effect the system. I
understand what each one does, but h
OK, tearing my hair out here...
I am trying to get a LOAD DATA LOCAL INFILE command to work. It
works when I start the MySQL client with "--local-infile=1", but
never in any other situation. Starting without this option, or
submitting the request through PHP or Lasso results in the "command
On Sun, Jun 08, 2003 at 03:37:17PM +0200, Gunnar Helliesen wrote:
> On Sat, 22 Jun 2002 17:43:12 -0700 Jeremy Zawodny wrote:
> >
> > On Sat, Jun 22, 2002 at 07:26:36PM -0500, mos wrote:
> > >
> > > >We've managed to reproduce this pretty reliably at Yahoo and are
> > > >working to track and fix th
On Sun, Jun 08, 2003 at 01:08:58PM +0100, Gareth Davis wrote:
> I guess that explains alot. Is there any work around with say,
> stunnel/ssh etc?
Yes, you could certainly use something like stunnel or an ssh tunnel to
forward a port between two machines and do replication over that.
Here's a coup
Hi,
On Sun, Jun 08, 2003 at 01:53:24PM -0300, Robson Oliveira wrote:
> I'm trying to send a e-mail with the record register ID from a PHP code query and
> don't show the value.
>
> // Connect to database
> $db = mysql_connect ("localhost", "my_db", "passxx");
>
$db = mysql_connect ("local
Hi,
I'm trying to send a e-mail with the record register ID from a PHP code query and
don't show the value.
// Connect to database
$db = mysql_connect ("localhost", "my_db", "passxx");
// Select the database
mysql_select_db("my_db", $db);
// Select user registration ID from the
Renán,
> I installed the version 4.1.0-alpha of mysql in
> Windows XP. At the beginning and in general everything
> works very well. But I have a problem of
> incompatibility (I guess). When users are created with
> passwords, those users cannot be connected. Mysql
> says: "Client don't support th
Hi,
I have a table (named "text") looking like this, somewhat simplified:
+---++
| id| string |
+---++
| 1 | Here |
| 2 | is |
| 3 | some |
| 4 | text |
| 5 | . |
| 6 | And|
| 7 | it's |
| 8 | in |
| 9 | a
Oh sorry...my bad. :)
I started troubleshooting the code and discovered the problem was the new
register globals which is defaulted to off in PHP 4.22. The PHP wasn't
holding session and wasn't inserting the records into the mySQL database.
I got it working now by switching the register globals
At 14:51 +0300 6/8/03, Dmitry Kosoy wrote:
Hi,
I have a table with 2 fields (among others) with type timestamp ("warndate"
and "date").
I run the following update: update dbowner where warndate = now().
This update affects not only on the field "warndate" but on the field "date"
as well.
After it
On Sat, 22 Jun 2002 17:43:12 -0700 Jeremy Zawodny wrote:
>
> On Sat, Jun 22, 2002 at 07:26:36PM -0500, mos wrote:
> >
> > >We've managed to reproduce this pretty reliably at Yahoo and are
> > >working to track and fix the bug. If we find a resolution, I'll post
> > >a note here.
> >
> > There ha
At 18:40 +1000 6/8/03, JeRRy wrote:
Hi,
I downloaded the Windows version of mysql. And just
set it up but currently it works as root and no
password. Not a real concern as I shut down the mysql
as I finish working as I use it offline. But I would
like to setup the user account and password as I
At 16:59 +1000 6/8/03, JeRRy wrote:
Okay thanks.
One last thing.
From the mysql prompt how can I generate a database
backup? (So I can see the database setup in notepad
so I can backup and transfer easily online.)
Not from the mysql prompt. You want to use the mysqldump
program.
Jerry
--
Paul
Sorry,
Now I understood that this behavior is exactly according to documentation.
-Original Message-
Subject: mysql: bug in update (?)
Hi,
I have a table with 2 fields (among others) with type timestamp ("warndate"
and "date").
I run the following update: update dbowner where warndate =
Hi
Your problem lies in your columns. A timestamp field has the special
property of recording when a record is created or modified. However, only
the first timestamp column in a row is treated this way. I hope this helps.
Mike
- Original Message -
From: "Dmitry Kosoy" <[EMAIL PROT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Karam Chand wrote:
> Greetings
>
> I have MySQL 4.0.13 installed on WinXP machine. From
> the DOCS I read that support for SSL is provided with
> MySQL 4.x. The doc says that I need to install the
> library from openssl.org ( which I did ) and then
>
Carlos,
- Original Message -
From: ""Carlos Proal"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, June 08, 2003 2:14 PM
Subject: Re: start innodb without transactions
>
> Hi Heikki et al.
> I have solve my problem :). The fact about my missed table was my fault,
>
I guess that explains alot. Is there any work around with say,
stunnel/ssh etc?
Gareth
On Wed, 2003-06-04 at 23:38, Jim Winstead wrote:
> Hi Gareth.
>
> On Tue, Jun 03, 2003 at 09:59:52AM +0100, Gareth Davis wrote:
> > I guess this is right place for this. I'm trying to setup replication
> > betw
Hi,
I have a table with 2 fields (among others) with type timestamp ("warndate"
and "date").
I run the following update: update dbowner where warndate = now().
This update affects not only on the field "warndate" but on the field "date"
as well.
After it the both fields got the current date and t
Hi Heikki et al.
I have solve my problem :). The fact about my missed table was my fault,
because indeed those tables doesnt exist anymore (one developer had deleted
them).
Even when my db is up and running im figuring out why there is not an option
to skip commit/rollback pending transactions ?
Hi,
I downloaded the Windows version of mysql. And just
set it up but currently it works as root and no
password. Not a real concern as I shut down the mysql
as I finish working as I use it offline. But I would
like to setup the user account and password as I have
it on my web server so it's ea
So the next step would be to provide us with the code so that we might try to
help you. :)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "ComCity" <[EMAIL PROTECTED]>
To: "Becoming Digital" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, 08 June
John,
- Original Message -
From: ""John A. Sullivan III"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, June 08, 2003 7:58 AM
Subject: Maximum statements per connection problem
> I am having a nightmare of a time getting a single transaction across
> multiple tabl
Okay thanks.
One last thing.
>From the mysql prompt how can I generate a database
backup? (So I can see the database setup in notepad
so I can backup and transfer easily online.)
Jerry
--- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 14:52
+1000 6/8/03, JeRRy wrote:
> >Hi,
> >
> >I have a text
33 matches
Mail list logo
