configuring MySQL for raid tables

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]

RE: Symbolic Links under Windows

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

Error: 1114

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,

Re: Error: 1114

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 | 1'

RE: Symbolic Links under Windows

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 to

Re: Running mySQL on a drive other than root

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

MySQL compile/install problems

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

RE: Advice needed....

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

Missing symbols in mysqlclient.lib in Win32

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

Re: NT installation / port issues

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- mysqlbin\mysqld-shareware --basedire d:\mysql

fails to build on ARM architecture

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/mysql\

MySQL++ has WEAK class prototyping

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

Re: MySQL++ has WEAK class prototyping

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 classes

Fulltext Strange Results...

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

Reformatting a DATESTAMP out of a table into a readable display date with SELECT

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 |

Fulltext and phrases

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.

RE: Reformatting a DATESTAMP out of a table into a readable disp

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: random snips When I display the result, I would like reformat it so that it reads: May 19, 2001 04:16:25

Re: Reformatting a DATESTAMP out of a table into a readable display date with SELECT

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

Re: time and date

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 will

necesito ayuda urgente

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

UPDATE

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

Re: AIX segmentation fault with PHP, Apache and MySQL

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.3.17

RE: UPDATE

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;

RE: UPDATE

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

replication

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

Re: necesito ayuda urgente

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

The Syntax to Get JDBC Connection

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 =

RE: The Syntax to Get JDBC Connection

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

Re: AIX segmentation fault with PHP, Apache and MySQL

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 08:59 AM,

Re: AIX segmentation fault with PHP, Apache and MySQL

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

RE: Inserting images into BLOB Fields

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]

RE: Fulltext and phrases

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 MySQL

RE: Inserting images into BLOB Fields

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 nothing

Error when connecting mysql or oracle

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

I have a question

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

Re: Error when connecting mysql or oracle

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

I have a question (2)

Hello I treid to access an access file using following code htmlheadtitlePHP Test/title/head body ?php //connect to database $connectionstring = odbc_connect(video,,); //disconnect from database odbc_close($connectionstring); ? /body/html I gives me Warning: SQL error: , SQL

Re: Error when connecting mysql or oracle

I reinstalled these two packages: D:\Perl\binppm install DBI.ppd Installing package 'DBI.ppd'... Writing D:\Perl\site\lib\auto\DBI\.packlist D:\Perl\binppm install DBD-Mysql.ppd Installing package 'DBD-Mysql.ppd'... Writing D:\Perl\site\lib\auto\DBD\Mysql\.packlist and now it works again:

RE: I have a question

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., SQL

Re: Error when connecting mysql or oracle

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

Re: how can I do this?

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 -

why does it not work

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