Thanks, worked nicely.
--- Paul DuBois [EMAIL PROTECTED] wrote: At 14:52
+1000 6/8/03, JeRRy wrote:
Hi,
I have a text file with all my database information
to
create databases to setting up tables. I have
looked
throught the mysql docs onto how to load these on
from
the mysql prompt.
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 file
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 tables to
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, 2003
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
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 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 time
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
between
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,
because
-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
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
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 =
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
--
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
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 have been a few
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 the
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
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
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 the
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
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 (localhost, my_db,
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
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 the bug. If we
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
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
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'
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
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
-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.12-max
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).
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
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
On 07-Jun-2003 Andre wrote:
snip
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.
snip
1) Any ideas where I might begin to
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
34 matches
Mail list logo
