MySQL's raid function says that it can use multiple drives/directories to
put its database in to get over the 2GB limit. How do I configure MySQL to
make sure that it knows about the drives when its instructed to create a
table as RAID_TYPE = STRIPPED ?
Would I put in my.cnf:
[mysqld]
datadir=/db
Hello Tom,
If you're using Windows 2000 it has junction points. It's almost the
same as symbolic links in UNIX. Except it works only for directories.
Try to find access to Windows 2000 Resource Kit, there should be a
utility called linkd.exe. If you running NT 4.0, you can try to apply
Service P
Hello, wich is the meaning of this message.
I don't have a table named 'SQL521ed_0':
Message: General error: The table 'SQL521ed_0' is full
SQLState: S1000
ErrorCode: 1114
Thanks
Carlos Godoy
-
Before posting, pleas
On Sun, 20 May 2001, Carlos Godoy wrote:
> Hello, wich is the meaning of this message.
> I don't have a table named 'SQL521ed_0':
> Message: General error: The table 'SQL521ed_0' is full
> SQLState: S1000
> ErrorCode: 1114
>From the very fine manual about the SET syntax:
`SQL_BIG_TABLES = 0 |
You can also download Junction from
http://www.sysinternals.com/ntw2k/source/misc.shtml#junction which does the
same thing.
sql
> Hello Tom,
>
> If you're using Windows 2000 it has junction points. It's almost the
> same as symbolic links in UNIX. Except it works only for directories.
>
> Try
At 20:05 19/5/2001 +0100, James Cox wrote:
Hi!
Remove the service first: mysqld-nt --remove
Create /winnt/my.ini file with the following section and keys:
[mysqld]
basedir=G:/mysql
datadir=G:/mysql/data
Install the service: g:\mysql\bin\>mysqld-nt --install
start the server: net start mysql
Hi,
I have HP-UX B.10.20 A 9000/811 2002798330 two-user license
and mysql ./mysqladmin Ver 7.11 Distrib 3.22.23b, for hp-hpux10.20 on
hppa1.1
instald from depot file.
I'd like to upgrade to mysql-3.23.37.
Here begin the problems. I try binary distri
Well I was hoping to be able to do it in SQL, however I do know it can be
accomplished in the middleware. I am seriously considering it as my deadline
is approaching quickly
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-Original Mess
Hi,
while trying to link the DBD::mysql driver on a Win32 machine
I receive the following error message claiming about missing
symbols __pctype and ___mb_cur_max in mysqlclient.lib. As you
can see from the output below, I am linking against all ".lib"
files in the MySQL distribution. The paths a
I have faced the same problem which took me a very long time to solve.
Here are the steps I did hoping it will help you:
1- Install Mysql on d drive and not under c drive. That was clearly stated.
2- In your command line, stop at mysql "cd d:\mysql"
3- mysql>bin\mysqld-shareware --basedire d:\mysq
Hello
Does anybody know if MySQL can be build on the arm architecture?
(This bug was reported against the Debian MySQL packages)
bye,
-christian-
With 3.23.37-3 I'm now seeing a different failure:
gcc -DDEFAULT_CHARSET_HOME=\"/usr\" -DDATADIR=\"/var/lib/mysql\"
-DSHAREDIR=\"/usr/share/mysq
Hi,
've just looked to MySQL++ examples, class names are very poorly named (!)
Thats fine for small exaple but makes a big mess in large projects. "class
Query" for example is SO generic that there is big probability that will
collide with other declaration and classes elsewhere and this small
"c
David Webber writes:
> Hi,
>
> 've just looked to MySQL++ examples, class names are very poorly named (!)
> Thats fine for small exaple but makes a big mess in large projects. "class
> Query" for example is SO generic that there is big probability that will
> collide with other declaration and cl
Hello,
I did the following query against my indexed table:
select * from indexed_table where match(indexed_col)
against ('oracle +sybase +london')
It returned 16 rows of which only 4 rows included all words.
I then did:
select * from indexed_table where match(indexed_col)
against ('+oracle
I have a column "LastUpdated" in a table which uses TIMESTAMP to record the
date and time of entries. The format of the column is:
mysql> select LastUpdated from DriveLeadTimes;
++
| LastUpdated|
++
| 20010519161625 |
As per select * from indexed_table where match(indexed_col)
against ('+oracle +sybase +london -oracle')
> > Nothing was returned.
>
> What did you expect ? This query should return only rows that
> contain the word "oracle" AND did not contain it at the same time.
I expected it to return just r
I have just done this:
select * from indexed_table where match(indexed_col)
against ('"visual basic"')
This returns rows with either visual or basic. I read
phrase searching was allowed in mySQL v4.0? Can someone please advise.
***
On 20-May-01 Scot Robnett wrote:
> I have a column "LastUpdated" in a table which uses TIMESTAMP to record the
> date and time of entries. The format of the column is:
> When I display the result, I would like reformat it so that it reads:
>
>
> May 19, 2001 04:16:25
>
> Anybody o
So sprach Scot Robnett am Sun, May 20, 2001 at 03:03:55PM -0500:
> Anybody out there that can tell me how this is done? Thanks!
Yeah, the manual will tell you. In the section 'Date and Time functions',
look for 'DATE_FORMAT'. Since you don't know where the manual is, it's
online available at ht
So sprach chris am Tue, Apr 02, 2002 at 08:26:01PM -0500:
> Is there a way to store the time and date that a record was added within
> MySQL? I want to show the time and date on some of my records and can't seem
> to figure out an easy way to do it. Thanks!
Either use a TIMESTAMP column, which wi
Hola.
No pertenezco su lista de correo, pero me parece muy
interesante su trabajo. Para efectos de un proyecto de
grado requiero averiguar cuales son las ventajas y
desventajas que ofrece Mysql con respecto de los demás
manejadores de bases de datos como oracle, PosgreSQL,
access, visual fox pro,
Is this ok?
UPDATE table1
SET table1.field1 = table2.field1
SELECT table1.field1, table1.field2, table2.field1, table2.field2,
table2.field3
FROM table1, table2
WHERE table1.field2 BETWEEN table2.field2 AND table2.field3
HAVING table1.field1 IS NULL;
I know there's a lot of rules about the update
Well we now have Apache 1.3.19 and PHP 4.0.5 but still the same problem...
Am about to upgrade MySQL to 3.23.38 to see if this changes things, but
feel this is clutching at straws...
Thanks,
Dave
> On Thursday, May 17, 2001, at 08:59 AM, Matthew P. Marino wrote:
> >
> > > Apache is up to 1.
On 20-May-01 Dave Carter wrote:
> Is this ok?
> UPDATE table1
> SET table1.field1 = table2.field1
> SELECT table1.field1, table1.field2, table2.field1, table2.field2,
> table2.field3
> FROM table1, table2
> WHERE table1.field2 BETWEEN table2.field2 AND table2.field3
> HAVING table1.field1 IS NULL
Using temp table... thanks I don't understand why this isn't legitimate
SQL however. I would think that it should be supported
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-Original Message-
From: Don Read [mailto:[EMAIL PROT
My server application may end up being spread over 200 servers supporting up
to 1 million persistent tcp connections. Each client will have many records
in a database, performing updates and selects. How well does mysql
replication work over 200 servers? Was replication meant for an application
of
Que tal esmeralda.
Primeramente,
visual FoxPro y Access son manejadores de base de datos tipo DBMS y que
opcionalmente pueden accesar a Servidores de Bases de Datos SQL.
MySql, Oracle, Microsoft SQL, DB2 de IBM, Etc, pertenecen a la categoria de
Servidores de Base de datos SQL
Una de las pr
Dear All,
I use mm.mysql.jdbc to access mysql in Java. To get the connection, the
following sentence is writen in my program. But an error occurred.
I guess that the syntax is wrong. Could you please give me the correct
one.
Connection conn =
DriverManager.getConnection(jdbc:mysql://localhost/Re
If that's an exact quote then you left off the opening quote marks.
Cal
http://www.calevans.com
-Original Message-
From: Li Bing [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 19, 2001 4:14 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: The Syntax to Get JDBC Connection
Dear
How can I insert an image file into a blob field? I search the MySQL
Documents but nothing came up specificaly on inserting images from files.
Using the Windows version.
Here's the script
CREATE TABLE sig
(
ItemID INT NOT NULL AUTO_INCREMENT,
FirstNameCHAR
MySQL 3.23.38 made no difference
>
> Well we now have Apache 1.3.19 and PHP 4.0.5 but still the same problem...
>
> Am about to upgrade MySQL to 3.23.38 to see if this changes things, but
feel this is clutching at straws...
>
>
> Thanks,
>
> Dave
> On Thursday, May 17, 2001, at 0
Hmm. Can you be a bit more specific how you upgraded your Apache?
Typically I've had good luck with building the new Apache first, then
building PHP (using the new apxs that it installs). You are installing
these modules as .so, correct? And building everything from source
code? The only
Hi,
> How can I insert an image file into a blob field? I search the MySQL
> Documents but nothing came up specificaly on inserting images from files.
INSERT INTO sig
VALUES (
1,
'Paul',
'Davolio',
LOAD_FILE('d:/signatures/paul.txt')
);
Rgds,
Tfr
--==< [EMAIL PROTECTED]
Hi,
> I have just done this:
> select * from indexed_table where match(indexed_col)
> against ('"visual basic"')
> This returns rows with either visual or basic. I read
> phrase searching was allowed in mySQL v4.0? Can someone please advise.
you're right, phrase and AND searches will be in MySQ
Thank you!!!
-Original Message-
From: indrek siitan [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 20, 2001 9:51 PM
To: Mike; [EMAIL PROTECTED]
Subject: RE: Inserting images into BLOB Fields
Hi,
> How can I insert an image file into a blob field? I search the MySQL
> Documents but nothin
Hi All,
I got a code from a PERL list that inserts a row into a mysql db table.
I changed to my needs, tried, and it worked. Then I decided to install
DBD-Oracle.ppd to see if it would work well with Oracle but it did not.
After that my machine rebooted for no reason and now when I run the same
I installed recent version of mySQL,myODBC,PHP on my W2000 machine
yesterday
I can not access to an access file via ODBC
It gives me
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft
Jet database engine cannot open the file '(unknown)'. It is already opened
exclusively
Well, this really isn't a mysql issue. This is an ActiveState perl
issue, But it sounds like you've clobbered your DBD files some how and
or you're just not initializing them correctly.
Siomara Pantarotto wrote:
>
> Hi All,
>
> I got a code from a PERL list that inserts a row into a mysql db ta
Hello
I treid to access an access file using following code
PHP Test
I gives me
Warning: SQL error: , SQL state 0 in SQLConnect in
c:\inetpub\wwwroot\php\ietest.php on line 7
Warning: Supplied argument is not a valid ODBC-Link resource in
c:\inetpub\wwwroot\php\ietest.php on line
I reinstalled these two packages:
D:\Perl\bin>ppm install DBI.ppd
Installing package 'DBI.ppd'...
Writing D:\Perl\site\lib\auto\DBI\.packlist
D:\Perl\bin>ppm install DBD-Mysql.ppd
Installing package 'DBD-Mysql.ppd'...
Writing D:\Perl\site\lib\auto\DBD\Mysql\.packlist
and now it works again:
mys
Hi,
> I can not access to an access file via ODBC
> It gives me
> Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]
> The Microsoft Jet database engine cannot open the file '(unknown)'.
> It is already opened exclusively by another user, or you need
> permission to view its data., SQ
well I've never really looked into how the PPM app that activestate
works, I'd assume you'd probably just want to go grab the .zip file and
unzip it into your library path your self, Then when you want to play
with it make sure to use the Oracle driver in your DBI connect
statement.
Siomara Pant
Hi,
I have four table that have common fields like: date, destinazione and
price.
I what to create a temporary table with all four fields from four tables,
what would be the correct sql syntax.
TIA
Adrian
-
Be
Hi,
I have been trying this on my localhost and this works
select special.contid, special.cityid, special.curr1, special.catalogo,
special.hf, special.curr2, special.vitofferta, special.fh, special.club,
special.stars, city.city from special,city where
DATE_SUB(special.periodo, INTERVAL 3 DAY)
3.22.32 has known Join issues, the machine running that version should
be upgraded to the 3.23.32 STABLE release.
Adrian D'Costa wrote:
>
> Hi,
>
> I have been trying this on my localhost and this works
>
> select special.contid, special.cityid, special.curr1, special.catalogo,
> special.hf,
Err also, RAND() is a 3.23 feature ;-)
Adrian D'Costa wrote:
>
> Hi,
>
> I have been trying this on my localhost and this works
>
> select special.contid, special.cityid, special.curr1, special.catalogo,
> special.hf, special.curr2, special.vitofferta, special.fh, special.club,
> special.sta
On Mon, May 21, 2001 at 11:32:46AM +0530, Adrian D'Costa wrote:
> Hi,
>
> I have been trying this on my localhost and this works
>
> select special.contid, special.cityid, special.curr1, special.catalogo,
> special.hf, special.curr2, special.vitofferta, special.fh, special.club,
> special.stars
Hi,
> -> DAY) >'$tdate' and city.id=special.cityid order by RAND() limit 1;
> ERROR 1064: You have an error in your SQL syntax near 'RAND() limit 1' at
> line 3
>
> select version();
> +---+
> | version() |
> +---+
> | 3.22.32 |
> +---+
>
> What could be the proble
Hi all,
I would like to try and create a database that can be used for
report/letter generation on both IBM and Macs, and eventually emails. I
have success on the IBM simply using ODBC and Office, and was wondering how
one would go about the same process on the Mac. The advantage of using
Off
I can't manage to have an acces to my database with mysql installed on E: on a windows
Nt server.
What can I do ?
Thanks
50 matches
Mail list logo
