12/11/2001 05:32:28, "PI Xu" <[EMAIL PROTECTED]> wrote:
>Hi, Buddies:
>
>I used perl to run sql commands from a Text file, it always can't finish
>totally and report error in unstable lines .
>The error report that sql syntax error, but the syntax is same, just same,
>and many sql lines;
>Would y
Hi
At 10:46 12/11/2001 +, Syed Ali Dost wrote:
>Hi...
>
>I'm new to MySQL. I can play it by ODBC connectivity using JDBC-ODBC bridge.
>But I want to write code in C using MySQL native C-APIs. One reason for me
>to switch to MySQL is its C-APIs. I've been using Borland Turbo C/C++ 3.0
>for
Hi...
I'm new to MySQL. I can play it by ODBC connectivity using JDBC-ODBC bridge.
But I want to write code in C using MySQL native C-APIs. One reason for me
to switch to MySQL is its C-APIs. I've been using Borland Turbo C/C++ 3.0
for a long time on DOS/Windows OS. When I try to include MySQ
I am sending this mail in order to get things straight
about table corruption which I am experiencing with
4.0(as well as previous versions).
1)System specs: PIII x1000MHz, 1GB RAM, HD 37GB SCSI,
AHA29160N SCSI controller
2) Database MyISam tables, BUT 21000 tables in the
database(this is
Steve,
>Date: Mon, 12 Nov 2001 08:52:54
>To: [EMAIL PROTECTED]
>From: Heikki Tuuri <[EMAIL PROTECTED]>
>Subject: Re: Cannot add blob data to innodb table
>
>Stephen,
>
>>Hi,
>>
>>I have an Access97 table containing binary fields (gifs) that I would like
>>to migrate to an innodb format via MyODBC
Stephen,
>Hi,
>
>I have an Access97 table containing binary fields (gifs) that I would like
>to migrate to an innodb format via MyODBC (2.50.39) and MySQL-Max (3.23.44).
>The MySQL query log shows binary-like characters being received but there
>never seems to be progression to the next record. A
Does anyone know of any well-known Benchmarking tools for MYSQL database?
Thanks
S.M.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Hi, Buddies:
I used perl to run sql commands from a Text file, it always can't finish
totally and report error in unstable lines .
The error report that sql syntax error, but the syntax is same, just same,
and many sql lines;
Would you please tell me what this happen and how to resolve it?
Thank
-- Forwarded Message --
Subject: [PHP] might be bugs on PHP 4.06 or mySQL 4.0
Date: Fri, 9 Nov 2001 13:37:32 -0500
From: Yamin Prabudy <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>, PHP
<[EMAIL PROTECTED]>
Hi there,
I just try to install mySQL 4.0 then i in
Hi!
> "DownloadFAST" == DownloadFAST com <[EMAIL PROTECTED]> writes:
DownloadFAST> I have not read the MySQL license in detail.
DownloadFAST> Does it allow someone or a group to start another fork of the source that
DownloadFAST> is independent from the current developers?
Yes, you are all
Hi!
> "Paul" == Paul Chilson <[EMAIL PROTECTED]> writes:
Paul> I am setting up a replication slave.
Paul> Master is server-id = 1
Paul> Slave is server-id = 2
Paul> Relevant section of /etc/my.cnf from the slave
Paul> My guess as to the problem:
Paul> ./mysqladmin variables reports the
I've read over the section in the manual that covers grant/revoke but I
still have a question. I want to make sure I'm not assuming anything before
I start messing with 12000 user accounts.
If I create a user by issuing:
GRANT select, insert, update, delete, index, alter, create, drop
ON someda
Hi!
>Andrew wrote:
>>
>> I an running Slackware with the 2.4.5 kernel on a Dual PII system. I
>> have run mySQL versions from 3.20.something to 3.23.29 (or so) under
>> kernels from 2.0x-2.2.19 with no real problems. I always compile from
>> source when possible.
>>
>> I have down;oaded the mys
mbb writes:
> When you design a couple of tables to be related to one another via keys do
> you have to manually enter in the key value from the other table?
[...]
> so that I can relate the tables... when I'm entering data into Table2, do I
> have to enter in the corresponding value from Table1
[EMAIL PROTECTED] writes:
> mysqladmin: error while loading shared libraries: libgcc_s.so.1:
> cannot load shared object file: No such file or directory
Make sure /usr/local/lib is in your /etc/ld.so.conf, and
then run ldconfig. Another solution is to have LD_LIBRARY_PATH
include that director
Hi
This is not really a problem for me now, because I have my own server, and
control who has access. This is a problem on virtual hosting, because
anybody could be on there.
It seems to be standard practice for ISPs to set up php as an Apache module
and leave it to run. I played around and cou
Andrew wrote:
>
> I an running Slackware with the 2.4.5 kernel on a Dual PII system. I
> have run mySQL versions from 3.20.something to 3.23.29 (or so) under
> kernels from 2.0x-2.2.19 with no real problems. I always compile from
> source when possible.
>
> I have down;oaded the mysql source tar
When you design a couple of tables to be related to one another via keys do
you have to manually enter in the key value from the other table?
If I have 2 tables, say Table1 and Table2.
Table1:
Table1_ID
Table1_value
Table2:
Table2_ID
Table2_value
Table1_ID
so that I can relate the tables... wh
Hi everybody!
I just install mysql-3.23.44 from the source and compiled with gcc-
3.0.2 compiled from the source too. mysql engine works fine but
mysqladmin looks like can't find libgcc_s.so.1 , I checked and is
right there at '/usr/local/lib/' with all the others.
** This the output message
m
Thanks very much Ashley!
It works ..
Thanks again.
Jose Albert
>[EMAIL PROTECTED] wrote:
>
>> I got this result before and compile gcc direct from the source
>> thinking that could be anithing wrong on the rpm gcc that came
with
>> redhat but he result is the same. Please anybody has an idea
a
Aaron Williams wrote :
>
> > Joseph Bueno wrote:
> >
> >Hi,
> >
> >If you run a single query, MySQL will use only one processor.
> >MySQL multithreading allows you to run multiple queries in parallel,
> >one query per thread.
>
> Right, that I understand. Even while running up to 30 queries it
Quanta Gold is a the Web developer's dream tool. Use its simple
point-and-click interface to quickly and easily create powerful websites,
even using the latest scripting languages like PHP. Keep an eye on the
growth and structure of your site with its special tree view. Take
advantage of its s
Peter Lovatt writes:
> I don't think there is a secure way of running php on a shared server.
If by 'shared' you mean that you have users, then there is a very
good way of doing it. Assuming that you use apache, have a look
at the suexec wrapper.
> I looked at ways of securing it but, fundame
Hello!
I install MySQL 3.23.43 on SCO Open Server 3.2 v5.0.4
Other software: FSU Pthreads 3.5, gcc 98q2, GNU Make 3.78.1
Output of make execution:
gcc -03 -DDBUG_OFF -DSCO -O conf_to_src conf_tosrc.o -lcrypt -lsocket -lm
Undefined first referenced symbol in file
main /usr/ccs/lib/crt1.o
conf_to
I don't think there is a secure way of running php on a shared server.
I have a dedicated server which uses this 'property' to have a single shared
php codebase for about 20 domains and subdomains.
I looked at ways of securing it but, fundamentally, php under apache runs
the same user for everyo
Hi!
>> Can you rename a database? If so, how does it handle all the
>> tables inside it?
>
>By shutting down the server, renaming the directory
>of that database and restarting the server.
>
>The server will be able to handle the change just fine.
Sorry, but InnoDB tables do not get renamed
I an running Slackware with the 2.4.5 kernel on a Dual PII system. I
have run mySQL versions from 3.20.something to 3.23.29 (or so) under
kernels from 2.0x-2.2.19 with no real problems. I always compile from
source when possible.
I have down;oaded the mysql source tarballs for 3.23.44 and 4.0 alp
> i want to convert my access database to mysql. and then it will run
> on a
> linux server if i ever figure out how to run these darn scripts
> though
> i downloaded mysql for windows 98. i have tried for a week to run
> these
> scripts and even reinstalled mysql and even tried it on anot
[EMAIL PROTECTED] wrote:
> I got this result before and compile gcc direct from the source
> thinking that could be anithing wrong on the rpm gcc that came with
> redhat but he result is the same. Please anybody has an idea about
> this error. Any help will be hightly appreciated
>
> *last ou
Hi everybody there!
I'm trying to compile mysql-3.23.44 on redhat linyx 7.1 box
I got this result before and compile gcc direct from the source
thinking that could be anithing wrong on the rpm gcc that came with
redhat but he result is the same. Please anybody has an idea about
this error. Any
Hi,
If you type mysql at the prompt you must interactively type commands at the
mysql> prompt and type quit to exit. However I think it's generally better
in cases like yours to run in batch mode.
Type: mysql pets.out.
In batch mode by default a concise format is used, but if you want tables to
31 matches
Mail list logo
