Re: 1 billion row

Interesting subject ;-) Can you provide some more information; Like exactly what failed, any errors you received, if it crashed, how big the database files got before the failure happened etc. Magyari Istvan wrote: > > > Hi, > > I have been trying to build a 1 billion row database, in mysql

1 billion row

Hi, I have been trying to build a 1 billion row database, in mysql version 3.23.47, under Suse 7.3, but failed a several times, i reached around 600.000.000 rows... The table has an int(10) unsigned and a bigint(20) field, indexed by the bigint(20) field. The hardisk is 26GB SCSI, the compu

What is MySQL-MAX.

Hi , I am already using MySQL 3.23.26, which is available by Redhat LINUX 7.1 If I would like to update to newer version I found the following What is MySQL-MAX. RedHat packages (rpm) MySQL 3.23.47 Server (i386) (1.4M) where as ordinary MySQL RedHat packages (rpm) MySQL 3.23.47 Server (i386)

Re: Starting Server

Hi Chris, I suppose that gumby , is your machine name . It seems from the messages that /usr/local/var does not permits mysql daemon to create file. you can chnage mode to 777 to the directory, and for host.frm , you have to run /usr/local/mysql/scripts/mysql_install_d

monitor will not start

Hi All, Does anyone know if a hard disk that is mostly full will stop the mysql monitor from starting? When I try to start it up all I get is a hung cursor, and I'm sure that the daemon has been properly started. MySQL isn't logging disk full errors to the .err file, so it seems like maybe

Re: Slow Inner Join Help

Hi Butch Bean, What if you use a temporary table . Issue the following queries. Create temporary table tmptable as select sent_id,count(*) cnt from tbl_sent group by sent_id; Select sum(if(sent_id < idvar,1,0)) as lessthan, sum(if(sent_id >idvar,1,0)) as greaterthan from tmptable; Let us kn

Re: Tweaking MySQL on a RaQ (or any server) Help please.

From: James Riordon <[EMAIL PROTECTED]> > ...and I have not come up with a way to make our machine more efficient. Hi James, I'm not a MySQL expert, and I don't have a lot of experience with finite optimizations of the programs you are using. However, I do have a little bit of experience with

Re: Tweaking MySQL on a RaQ (or any server) Help please.

At 20:54 -0500 02/04/2002, I whispered: >Hi all, > > A couple of weeks back you may remember that I was asking >about setting up a new client on our server that ran around 35GB in >bandwidth per month mostly from MySQL queries. Well, we have put >them on our server and have good and bad

Re: Resolved: mysql_insert_id error

At 14:07 -0700 2/6/02, Nathan Bank wrote: >Though this is a PHP issue, for those that use PHP here's what was >wrong: mysql_insert_id() requires >your connection link identifier, which is what is returned from >mysql_connect and mysql_pconnect. >This is contrary to almost all other mysql_ functi

Re: Load_File issue

At 4:22 +0800 2/7/02, yue cheng wrote: >Hi, > >Now I am puzzled by the filepath,Load_file, I install >MySQL in Windows98, the file which i want to insert to >table is c:\P1.bmp > >when I run load_file in mysql command line,it succeeds >mysql> insert into blobtable (load_file("/P1.bmp")) >but i don

Re: triming white space from a TEXT column

At 16:17 -0800 2/6/02, Richard Reina wrote: >I am trying to trim both leading and trailing whitespace from a TEXT >column in my SELECT query. I found the TRIM() command in the >manual, however, I can't get it to act upon a column name instead of >an actual string. Can anyone help? If you jus

give me a sample to print out to printer

when i click the icon client1(in end client, it's show up from php application) that the icon has link to mysql and the result directly print the out put to printer (share or local printer) by coulomb. there's anyone knows about this, please help me. Rgds, Franky Aniversarius ---

fatal: libncurses.so.5

// michael.s, Wednesday, February 06, 2002, 12:22:15 PM, you wrote: Hi, I just installed mysql in my Solaris (Sparc) box, but when I run mysql ( mysqld running ), I get the following err, ld.so.1: bin/mysql: fatal: lib

Re: PostgreSQL

Alok K. Dhir wrote: > That said, depending on your requirements, there are still compelling > reasons to choose PostgreSQL - subselects, triggers, user defined types, > etc. And one big reason not: no native Windows port. Or Mac port (though that has probably changed with OS/X - anyone working

Query advice, please

Hi: I'd like to store user preferences in one table, such that there are default values but a user can override the preference. Default preferences are stored as user 0. This is trivial to do with two queries, but I'd like to compress it to one. Here's an example of what I mean: +--+--+

Starting Server

Greetings: I recently upgraded my MySQL server on a Linux box. When I try to start the server, it says started, then immediately it stops. The log file reports: -- 020206 14:38:35 mysqld started /usr/local/libexec/mysqld: File './gumby-bin.1' not found (Errcode: 13) 020206 14:38:36 Could not

Re: Extracting fields from a table

On Wednesday 06 February 2002 3:35 pm, Claire Forchheimer wrote: > I want to select all entries in my table that in a column with given > dates findes all dates inbetween $from_date - $to_date. (These are > vars that the user supplies from the HTML-page). I don't know how to set > up the SELECT

Extracting fields from a table

I want to select all entries in my table that in a column with given dates findes all dates inbetween $from_date - $to_date. (These are vars that the user supplies from the HTML-page). I don't know how to set up the SELECT query. I tried the following way but it didn't work: SELECT * FROM table

RE: PostgreSQL

Whether or not the default table type is changed to InnoDB, in the spirit of the original poster's question, and what I think Sinisa is trying to get you to admit, transaction support is no longer one of the issues to consider when comparing MySQL to PostgreSQL. MySQL supports transactions *now*

triming white space from a TEXT column

I am trying to trim both leading and trailing whitespace from a TEXT column in my SELECT query. I found the TRIM() command in the manual, however, I can't get it to act upon a column name instead of an actual string. Can anyone help? Thanks, Richard --

Re: Problem: mysqld restarts automatically

On Wednesday 06 February 2002 12:15 am, you wrote: > I am trying to find the problem but, error file shows stack trace > ? which I could not understand. Bharat: Please follow the instructions in the manual section that the stack trace message is referring you to. This will tell you how to reso

Re: having trouble killing mysqld to restart and change root pass word

> Ye, that did the trick. I was able to get the daemon restarted using the > --skip-grant-tables & option, however now I can't connect to the > monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try > using /usr/bin/mysql -h hostname mysql > > Anyone know why I can't get

RE: having trouble killing mysqld to restart and change root pass word

Amendment to that last post I don't think the daemon is starting properly, because I can't run a mysqladmin version - I just get a hung cursor. Does anyone know if there's something that would be stopping mysqld from loading with the --skip-grant-tables option? When I do a ps I can see th

RE: having trouble killing mysqld to restart and change root pass word

Ye, that did the trick. I was able to get the daemon restarted using the --skip-grant-tables & option, however now I can't connect to the monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try using /usr/bin/mysql -h hostname mysql Anyone know why I can't get the monitor

Re: Columns

On Wed, Feb 06, 2002 at 04:10:33PM -0500, Max Mouse wrote: > Hey all, > > Is it possible to copy the contents of one column to another column > using mySQL? I just changed my table structure by adding a few more > columns and I need to be able to move the data from the original > column to 4 new

RE: having trouble killing mysqld to restart and change root password

If you need to, use the "kill -9 -9 is a definite kill and it will work -Original Message- From: JP Audette [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:52 PM To: [EMAIL PROTECTED] Subject: having trouble killing mysqld to restart and change root password Howdy, I

Columns

Hey all, Is it possible to copy the contents of one column to another column using mySQL? I just changed my table structure by adding a few more columns and I need to be able to move the data from the original column to 4 new columns and then drop the orginial. I know that the proper query for sq

Resolved: mysql_insert_id error

Though this is a PHP issue, for those that use PHP here's what was wrong: mysql_insert_id() requires your connection link identifier, which is what is returned from mysql_connect and mysql_pconnect. This is contrary to almost all other mysql_ functions, which want the result resource returned f

RE: Load_File issue

First off, you trying to insert the image into the database or just its path? -Original Message- From: yue cheng [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:23 PM To: [EMAIL PROTECTED] Subject: Load_File issue Hi, Now I am puzzled by the filepath,Load_file, I inst

having trouble killing mysqld to restart and change root password

Howdy, I'm trying to reset a forgotten password for a MySQL server, and I can't kill mysqld via the method mentioned in the documentation (or by any method for that matter). When I try using the command... kill 'cat /var/lib/mysql/mysqld.pid' ...I get a message saying that there is no such p

InnoDB File Size

I'm using MySQL 4.0, trying to set up some innodb tables with several 20GB data files, but mysql is telling me that the files must be <= 4096MB This is on a RedHat 7.2 box with redhat's 2.4.9-13 enterprise kernel on a reiserfs filesystem... I don't think there should be such a low limit...I acci

Load_File issue

Hi, Now I am puzzled by the filepath,Load_file, I install MySQL in Windows98, the file which i want to insert to table is c:\P1.bmp when I run load_file in mysql command line,it succeeds mysql> insert into blobtable (load_file("/P1.bmp")) but i don't know why i should use slash instead of backsl

Re: PostgreSQL

Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > Trond Eivind Glomsrød writes: > > Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > > > > There is a slight difference between advanced, non-standardized > > tuning/backup/load-balancing like that and core SQL functionality not > > being present. >

Re: Cannot connect to MySQL server with a java application

thnx for answering, but if i use your suggestion, i get the same errormessage. who can help me? - Original Message - From: "Lee, Andrew" <[EMAIL PROTECTED]> To: "'debian'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, February 06, 2002 8:23 PM Subject: RE: Cannot connect to M

Re: load data local ... security issue

But you could already read any file that the web server can read, if you can execute scripts which are run as the webserver. Only way to prevent that is suEXEC. How is this specific to MySQL? > 1) Webserver must be able to read HTML files of every WebUsers > 2) MySQL functions are called with u

Re: PostgreSQL

Trond Eivind Glomsrød writes: > Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > > There is a slight difference between advanced, non-standardized > tuning/backup/load-balancing like that and core SQL functionality not > being present. > > -- > Trond Eivind Glomsrød > Red Hat, Inc. > This dep

Re: PostgreSQL

Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > Trond Eivind Glomsrød writes: > > On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: > > > > It's enabled in the MySQL rpms we distribute as part of RHL as well, but > > it's not the default type for created tables. Thus, most people won't be > > usi

RE: Cannot connect to MySQL server with a java application

Almost, but not exactly the same . DriverManager.getConnection(dburl, dbuser, dbpasswd) <-- note, 3 arguments here > -Original Message- > From: debian [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, February 06, 2002 1:59 PM > To: [EMAIL PROTECTED] > Subject: Cannot connect to MyS

Re: Memory limit issue with 64 bit mysql.3.23.46

Albert Chin writes: > > Ok. Guess we'll wait for a fix. Any idea when a fix for MySQL will be > available? > > -- > albert chin ([EMAIL PROTECTED]) > Just look into Changelog's of the versions that come out. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa M

Cannot connect to MySQL server with a java application

hello, i tried to connect my MySQL-Server with a short java application. The application can't connect to the server, obviously the server is running on localhost:3306. I append the SourceCode (roughly the same: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80228:200107:popciohjmlbbolpak ) and th

Re: mysql_insert_id error

Hi Andrea, > I am really new at PHP & MySQL, so please bear with me. welcome to our happy band... > I am using the mysql_insert_id function but continually receive an error, > and hoping someone can point me in the right direction to resolve this. > > My error: > Warning: Supplied argument is n

Re: Memory limit issue with 64 bit mysql.3.23.46

On Wed, Feb 06, 2002 at 08:04:23PM +0200, Sinisa Milivojevic wrote: > Albert Chin writes: > > On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote: > > Yes, SIZEOF_INT is 4: > > $ grep SIZEOF_INT config.h > > #define SIZEOF_INT 4 > > $ grep SIZEOF_INT include/my_config.h > >

Re: Mysql 3.23.47 table

[EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text

Re: Memory limit issue with 64 bit mysql.3.23.46

On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote: > Albert Chin writes: > > > > $ grep SIZEOF_LONG config.h > > #define SIZEOF_LONG 8 > > #define SIZEOF_LONG_LONG 8 > > > > $ grep SIZEOF_LONG incldue/my_config.h > > #define SIZEOF_LONG 8 > > #define SIZEOF_LONG_LONG 8 > > > >

Re: blob field

Venu wrote: > Its possible with MyODBC Drivers to 'n' size. You can > supply BLOB/CLOB data in pieces to desired size by > making use of SQLParamData and SQLPutData APIs. Does the MySQL wire protocol support this? Or is MyODBC emulating this by reading and updating the entire blob after each p

Re: Memory limit issue with 64 bit mysql.3.23.46

Albert Chin writes: > On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote: > Yes, SIZEOF_INT is 4: > $ grep SIZEOF_INT config.h > #define SIZEOF_INT 4 > $ grep SIZEOF_INT include/my_config.h > #define SIZEOF_INT 4 > > However, according to > >http://docs.sun.com/ab2/coll.4

Re: PostgreSQL

Trond Eivind Glomsrød writes: > On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: > > It's enabled in the MySQL rpms we distribute as part of RHL as well, but > it's not the default type for created tables. Thus, most people won't be > using it. If memory serves, you need to set various options in

mysql_insert_id error

Hi there, I am really new at PHP & MySQL, so please bear with me. I am using the mysql_insert_id function but continually receive an error, and hoping someone can point me in the right direction to resolve this. My error: Warning: Supplied argument is not a valid MySQL-Link resource on line 44

MySQL and Arabic

Hello All I am new to MySQL 3.23.42 and I installed it on a Windows 2000 system. I need a database with both English and Arabic records (the fields name not necessarily in Arabic). I searched the archive of the list and the manual and although I found some messages about Arabic, I could not figur

Re: Memory limit issue with 64 bit mysql.3.23.46

Albert Chin writes: > On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote: > > Yes, SIZEOF_INT is 4: > $ grep SIZEOF_INT config.h > #define SIZEOF_INT 4 > $ grep SIZEOF_INT include/my_config.h > #define SIZEOF_INT 4 > > -- > albert chin ([EMAIL PROTECTED]) > We shall ha

RE: blob field

Hi, > -Original Message- > From: Shankar Unni [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 06, 2002 9:29 AM > To: Yoram Naim > Cc: '[EMAIL PROTECTED]' > Subject: Re: blob field > > > [redirecting to mysql list because of general interest] > > Yoram Naim wrote: > > > Can some one

Re: PostgreSQL

On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: > Trond Eivind Glomsrød writes: > > On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: > > > > I said "everywhere" - you need to use Innobase to get foreign keys, and > > innobase/db3 to get transactions. > > As EVERY binary and source we distribute ha

RE: Error in myodbc 3.51.01.00

Hi, > -Original Message- > From: Peter Klinge [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 06, 2002 5:33 AM > To: [EMAIL PROTECTED] > Subject: Error in myodbc 3.51.01.00 > > > Dear all, > > today I have switched from myodbc 2.50.39.00 to 3.51.01.00, > because I had a proble

Re: how to setup mysqlgui in Win2000

Jorge Guerra writes: > I have MySQL running on my FreeBSD server and I want to connect to it from > my Windows 2000 workstation using mysqlgui. > I put the ip address of the FreeBSD server in the my.cnf file under host, > but it keeps trying to connect to the Win2000 machine instead of the FreeBSD

Re: PostgreSQL

Trond Eivind Glomsrød writes: > On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: > > I said "everywhere" - you need to use Innobase to get foreign keys, and > innobase/db3 to get transactions. > > -- > Trond Eivind Glomsrød > Red Hat, Inc. > > As EVERY binary and source we distribute has Inno

Re: blob field

[redirecting to mysql list because of general interest] Yoram Naim wrote: > Can some one send me a code sample (C , CPP ) > How can I copy file data to MYSQL BLOB field > but not in one piece . Is this even possible? If so, I'm sure that the JDBC driver could use such a feature to stream lar

RE: PostgreSQL

The way I look at it, MySQL gives you a choice of table types, so you can pick the one best suited to the task at hand. For raw speed where you can do without transactions, you can go with MyISAM. Otherwise you have Innobase. I'm not sure where/why db3 fits in, haven't been bothered to look int

Re: Memory limit issue with 64 bit mysql.3.23.46

Albert Chin writes: > > $ grep SIZEOF_LONG config.h > #define SIZEOF_LONG 8 > #define SIZEOF_LONG_LONG 8 > > $ grep SIZEOF_LONG incldue/my_config.h > #define SIZEOF_LONG 8 > #define SIZEOF_LONG_LONG 8 > > -- > albert chin ([EMAIL PROTECTED]) > If SIZEOF_INT is 4, then it could be our bug. P

Re: Get hash of MySQL row

On Wed, Feb 06, 2002 at 01:57:21PM +, Wiliam Stephens wrote: > Hi > > I want to retrieve a row of MySQL data using Perl and DBI, so I do it like > this: > > [code] > my $sqlquery = qq|SELECT * FROM ata_members WHERE id=$id|; > $sth = $dbh->prepare($sqlquery); > $s

Re: PostgreSQL

On Wed, Feb 06, 2002 at 06:49:02PM +0200, Sinisa Milivojevic wrote: > Trond Eivind Glomsrød writes: > > "Vernon A Webb" <[EMAIL PROTECTED]> writes: > > > > > Anyone know the difference between MySQL and PostgreSQL? > > > > PostgreSQL has a lot of features MySQL don't have yet (transactions > >

compression

Sommai, Wednesday, February 06, 2002, 8:01:13 AM, you wrote: SF> Hi, SF> I need to know that MySQL has any compression method when it store SF> data? If the answer is Yes, How the different compression between MySQL SF> and other tools (zip, gzip)? I asked this question because I nee

Re: PostgreSQL

On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: > Trond Eivind Glomsrød writes: > > "Vernon A Webb" <[EMAIL PROTECTED]> writes: > > > > > Anyone know the difference between MySQL and PostgreSQL? > > > > PostgreSQL has a lot of features MySQL don't have yet (transactions > > everywhere, foreign k

how to setup mysqlgui in Win2000

I have MySQL running on my FreeBSD server and I want to connect to it from my Windows 2000 workstation using mysqlgui. I put the ip address of the FreeBSD server in the my.cnf file under host, but it keeps trying to connect to the Win2000 machine instead of the FreeBSD box. Am I doing something wr

Re: PostgreSQL

Trond Eivind Glomsrød writes: > "Vernon A Webb" <[EMAIL PROTECTED]> writes: > > > Anyone know the difference between MySQL and PostgreSQL? > > PostgreSQL has a lot of features MySQL don't have yet (transactions > everywhere, foreign keys, subselects, stored procedures, triggers, > etc), while M

Slow Inner Join Help

I have a table with 2.9 mil records which represents 197k sentences stored vertically. I do this because I need to know information about each word and its relationship to other tables. I want to know how many words have a particular word-group ID before and a particular word-group ID after the

Re: Memory limit issue with 64 bit mysql.3.23.46

On Wed, Feb 06, 2002 at 06:12:22PM +0200, Sinisa Milivojevic wrote: > Albert Chin writes: > > > > MySQL 3.23.46 was built with the Sun C++ compiler: > > $ CC -V > > CC: Sun WorkShop 6 update 2 C++ 5.3 Patch 111685-03 2001/10/19 > > > > It was built as follows: > > CC=cc CFLAGS="-mr -Qn -xs

Re: PostgreSQL

"Vernon A Webb" <[EMAIL PROTECTED]> writes: > Anyone know the difference between MySQL and PostgreSQL? PostgreSQL has a lot of features MySQL don't have yet (transactions everywhere, foreign keys, subselects, stored procedures, triggers, etc), while MySQL is heavily optimized for handling big l

Win32 support

I am looking for a way to use MySQL on a Windows 98 platform with the gnu tool set. The binaries that came with the Win32 version of MySQL seem to be for Microsoft. The function names have an '@n' appended to them with the 'n' being the number of bytes for the arguments. Therefore, even though the

Re: bug report: mysql_install_db hangs on execution.

Legault, Alain writes: > SEND-PR: -*- send-pr -*- > SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as > SEND-PR: will all comments (text enclosed in `<' and `>'). > SEND-PR: > Subject: Mysqld hangs on initialization with mysql_install_db. Hi! A usual cause for the above be

log count

i have a log file in which i record every visit of my site, although some times a visitant came by the morning and by the night or something alike, so i am trying to create a select command which count the ip every since he came back a hour afther of his last visit, the command is just like this:

Re: Memory limit issue with 64 bit mysql.3.23.46

Albert Chin writes: > > MySQL 3.23.46 was built with the Sun C++ compiler: > $ CC -V > CC: Sun WorkShop 6 update 2 C++ 5.3 Patch 111685-03 2001/10/19 > > It was built as follows: > CC=cc CFLAGS="-mr -Qn -xstrconst -xO2 -xtarget=generic -xarch=v9" \ > CXX=CC CXXFLAGS="-xO2 -xtarget=generi

mysql command dumps core.

Hello, I am relatively new to Mysql. I am have a strange problem that is preventing me from setting up my database to test out mysql as a backend to an IDS system. When I start the mysql command I get the following output. srsids01# ./mysql Welcome to the MySQL monitor. Commands end with ; or \

bug report: mysql_install_db hangs on execution.

SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: Subject: Mysqld hangs on initialization with mysql_install_db. >Description: when running the databse installation script,

Re: Problems with SQLGetInfo and SQLColumnPrivileges

Can you send exact message as this one to [EMAIL PROTECTED] ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <__

RE: mysql-3.23.47 Compile Error on Linux

> -I/usr/include -I./../include > > -I./../regex-I. -I../include -I.. -I. > mysqld.cc:1767: implicit declaration of function `int regex_init(...)' A carefull look reveals that the commandline above is seeing /usr/include/regex.h instead of /

Re: visualizing my queries

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then DL Neil declared > > > > > > > > > > My question is: If I enter a 'tip' and put myself as the author, when > > > > > /I/ come to write another tip how do I make my query avoid putting > > > > > another entry in author? I'll be using P

replicate-ignore-table

Hi everyone, When using replicate-ignore-table in mysql, does filtering happen before or after transmission from the master to the slave? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manu

Problem with database

I have a site using PHP & Mysql. About a month ago to now one of the tables gets corrupted with the message Got Error 127... I fix it and everything works OK, except every time I loose 1 record. Today I could obtain mysql.err from the machine and I could see whenever an error is produced by date,

Problems with SQLGetInfo and SQLColumnPrivileges

Dear all, today I have switched from myodbc 2.50.39.00 to 3.51.01.00, because I had a problem using SQLColumnPrivileges (see below) After that I couldn't use my application because of the ConnectionHandle was destroyed. After logging the application I have found, that there is an problem insi

Re: PostgreSQL

On Wed, 2002-02-06 at 07:59, Vernon A Webb wrote: > Hey All! > > Anyone know the difference between MySQL and PostgreSQL? > Are the both pretty much the same? So far I like MySQL, but > find that MS SQL is far greater, but only because it has > much more. Anyone have any comments on the matter

Re: MySQL / PHP Augmenting Variables For UPDATE

On Wed, 2002-02-06 at 07:51, Matt Rudderham wrote: > Hi, > I am making a form for editing the rows in a table. It displays each row > as a row in a table(structure id tinyiny,name varchar(30) ), with the > value inside a textbox so it can be changed. When doing the $submit to > MySQL, I need do

fatal: libncurses.so.5

michael.s, Wednesday, February 06, 2002, 12:22:15 PM, you wrote: msÉ> Hi, msÉ> I just installed mysql in my Solaris (Sparc) box, but msÉ> when I run mysql ( mysqld running ), I get the following msÉ> err, ld.so.1: bin/mysql: fatal: libncurses.so.5: open msÉ> failed: No such file or dire

RE: PostgreSQL

Hi. No, Postgres has much more. The biggest point is, that it has Subselects ! But mySQL seems to be much faster in some points. That´s all I want to tell :) Greetz Daniel -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 3:59 PM To:

Storing Binary data in MySQL

Hello, I'm new to Unix and MySQL. I would like to store binary data in MySQL, but cannot find any sample code on how to go about doing this in C. The binary data is variable size ranging from 3k to 10k. I want to store it in a row along with a User ID so I can retrieve it by doing a query on this

resetting a password

jeremy, Tuesday, February 05, 2002, 8:32:23 PM, you wrote: jr> following the instructions for resetting a password ( jr> http://www.mysql.com/doc/R/e/Resetting_permissions.html ), jr> i was not able to find the .pid file. is it possible to continue the process jr> without killing it? If you hav

PostgreSQL

Hey All! Anyone know the difference between MySQL and PostgreSQL? Are the both pretty much the same? So far I like MySQL, but find that MS SQL is far greater, but only because it has much more. Anyone have any comments on the matter? -

Re: BEGIN/COMMIT statements not written to the binary log : may it cause problems with replication ?

Hi! > "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes: Heikki> Guilhem, Heikki> this is a known problem and mentioned in the Restrictions section of the Heikki> InnoDB online manual. Heikki> It is not the correct way to run SQL statements in the autocommit mode on Heikki> the slave ser

MySQL / PHP Augmenting Variables For UPDATE

Hi, I am making a form for editing the rows in a table. It displays each row as a row in a table(structure id tinyiny,name varchar(30) ), with the value inside a textbox so it can be changed. When doing the $submit to MySQL, I need do this: for($count=0;$count<=$i;$count++) { $cur

Re: visualizing my queries

Nick, > Well I /hadn't/ tested as I wasn't sure that my DB design wasn't flawed, > I was expecting someone to say 'well if you want to do that you need to > design like this..' No matter. Again: if you use the native-MySQL/command line, or an administration/management package, you will be able

Get hash of MySQL row

Hi I want to retrieve a row of MySQL data using Perl and DBI, so I do it like this: [code] my $sqlquery = qq|SELECT * FROM ata_members WHERE id=$id|; $sth = $dbh->prepare($sqlquery); $sth->execute or die("Can't execute SQL query. [$DBI::err] $DBI::errstr");

Re: Macintosh

Jan Eskilsson wrote: > > Hi > > Is it possible to connect to a MySQL Database running on a Linux server from > an workstation running Mac OS 9.0 using ODBC ? i.e. does it exist any ODBC > drivers for MySql to use from Mac ? I myself use and beta test MacSQL: http://www.rtlabs.com/macsql/ It is

Tables keeps crashing...

hello, we are using mysql on a windows98 machine. But a lot of times the tables in the database keep crashing. When checking it says: 1 client did not close connection... table marked as crashed (not always this line) with different tables does anyone had this problem also? Willem ---

Macintosh

Hi Is it possible to connect to a MySQL Database running on a Linux server from an workstation running Mac OS 9.0 using ODBC ? i.e. does it exist any ODBC drivers for MySql to use from Mac ? Best Regards Jan Eskilsson - Before

Re: Memory limit issue with 64 bit mysql.3.23.46

On Wed, Feb 06, 2002 at 02:57:51PM +0200, Sinisa Milivojevic wrote: > Franklin, Kevin writes: > > We are running an extremely large instance of mysql version 3.23.46 on > > Solaris 2.8. We are attempting to use a software version compiled 64 bit > > and have been experiencing memory related serve

Re: Re: visualizing my queries

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then [EMAIL PROTECTED] declared > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query >

Re: Memory limit issue with 64 bit mysql.3.23.46

Franklin, Kevin writes: > We are running an extremely large instance of mysql version 3.23.46 on > Solaris 2.8. We are attempting to use a software version compiled 64 bit > and have been experiencing memory related server crashes. > > The behavior suggests that we are still unable to use more

Re: visualizing my queries

Nick, > I don't think ... > Am I talking rubbish? An admission and then an invitation??? Boy you must some masochist! You asked a question, it was answered (and there's usually more than one way to skin the proverbial cat); and then you appear to argue. "Thinking" is not as good as "testing":

Re: visualizing my queries

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Diana Soares declared > No. You're right! > Unless you generate your own AuthId (with date, not auto-incremented), i > think you will have to do a SELECT in the "author" table to get his ID > /you will need it to insert a new tip in t

Re: visualizing my queries

On Wed, 2002-02-06 at 11:52, Nick Wilson wrote: > > You can always use INSERT for the "content" table and REPLACE for the > > "author" table. > > I don't think that would work as it will change the AuthId and effect > any other 'tips' I've written. > Each author should have one entry in 'author'

Arcserve

Hi guys, Has anyone successfully used MySQL as the backend database for tape/file cataloguing on ArcServe 2000/Brightstor ? I can get Arcserve to work fine with MS SQL (runs for cover) but it wont work with MySQL. To be honest I dont have much indepth knowledge of MySQL, so any help is grateful

  1   2   >