Regarding BLOB

Hello sir, We are using Mysql database for our applications.We are very happy to use this and it's havingvery good features. But one thing i would like to know, in my application i want to store files(like resumes)into the database and i want to open it from browser(IE). while retieving the fi

Re: Help, Root User Password Lost!

zhu cathy wrote: > > Hello Friends: > > My root user password get lost. I just can't get in > the database again. > Anyone know the way to get access to mysql without > password. Or is there a way to change the password? > I get access denied with the Error No. 1044, and 1045. > > Thanks > > C

DBI + mysql

Hello all, Just a simple question. I am using perl DBI to connect to mysql. Its like a daemon, so its always running. But whenever i get a signal it connects to a database( different database each time). So there are 2 ways to do it 1. I disconnect and connect each time 2. I connect and keep the d

How to index Optimization on 20 million record

Hi Brothers and Sisters, I need to know how to optimazion index in MySQL, i was read on the manual, but i did not found solution. My case, i have a 20 million record on the one table, yhe table name TABLE_1 i have a field on TABLE_! as indexed and primary key named FIELD_1 (varchar(64) not null

Help, Root User Password Lost!

Hello Friends: My root user password get lost. I just can't get in the database again. Anyone know the way to get access to mysql without password. Or is there a way to change the password? I get access denied with the Error No. 1044, and 1045. Thanks Cathy ---

MySQL - row,table level locking?

Hello Guru, I am web programmer using PERL, MySQL. I need help from you, could you please clarify my doubt? 1. How many methods or functions in PERL-DBI/DBD module will actually will get communicates with MySQL? I know one that's $sth->fecth() or $sth->fetchArrayref() after $sth->execute(); wh

Jailed MySQL for hosting customers

We are offering our hosting customers MySQL databases. Ideally, I would like to offer everyone unlimited databases. What I would like is an option that when connecting to a database as a user, the MySQL server would access the actual database in the directory of the username. That way users cou

Re: FW: Purchasing MYSQL for multiple platforms

On Mon, Feb 04, 2002 at 04:34:21PM +1300, Ian Collins wrote: > > (I originally sent this to sales@mysql, but got no response - thought I'd > try this way). That's odd. Try [EMAIL PROTECTED] directly. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 3

FW: Purchasing MYSQL for multiple platforms

(I originally sent this to sales@mysql, but got no response - thought I'd try this way). I have nearly completed a port of our companies Unix based software (ISAM based) to use mysql (version 4.0.1). I've been extremely impressed with the performance we are getting from mysql, and are looking to

Re: simple backup methods: how to test for success

On Monday 04 February 2002 03:46, Robert Nagle wrote: > I realize this is a very elementary question and explained somewhat in > the mysql manual. > > The manual describes three different methods for backing up databases > > Copying the files themselves > using mysqldump to dump all the tables int

mysql crash during large insert from MYIASM to INNODB table.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I just started using innodb tables to help with some locking problems. The table I am trying to convert is large (100 Million rows, 23 GigByte). I setup 20 2Gig ibdata files. (I choose a size of 2 Gig as this is the maximum size I can easily trans

simple backup methods: how to test for success

I realize this is a very elementary question and explained somewhat in the mysql manual. The manual describes three different methods for backing up databases Copying the files themselves using mysqldump to dump all the tables into a single file using mysqlhotcopy The most straightforward way

Memory Leaks ?

HI, Firstly I hope this is the right list as the enquiry I have I do not class as a bug due to my uncertainty about where the problem lies. I have been using the C API for MySQL 2.22.32 on Linux 2.2.14 and I have noticed that my program was getting to an unmanageable size in memory, there is a s

Re: Data Logging based on MySQL using serial Interface

Look at LOAD DATA LOCAL INFILE... load data local infile '//BackLog//import_csv//KCV81_standard_sales.csv' into table kcv81_standard_sales fields terminated by ',' enclosed by '"' lines terminated by '\r\n' - Original Message - From: "Peter Samulat" <[EMAIL PROTECTED]> To: <[EMAIL PROTEC

Data Logging based on MySQL using serial Interface

I'm receiving ASCII Data Records (Microsoft CSV Format; Delimiter = ";") through the serial interface of a linux-based pc. Now I'm seraching for a script or program to put this records in a mysql database. Peter - Before pos

Remove source install from configure make make install

Folks, I have installed multiple copies of MySql , MyODBC , unixODBC and need to clean up the system. I have removed the rpm versions , but now need to remove the source versions. How is this done under linux , especialy for Mysql , unixODBC and Myodbc ? __

Re: Edit a MySQL Record

Nick, > How would I go about editing a certain record in a > MySQL database; Items? I want to be able to change a > value that was already inserted into the table. You neglected to mention which tool(s) you have at your disposal. SELECT the pertinent row. View the data. Amend it as required. U

Re: Edit a MySQL Record

Here you go... update MyDB set FIRST_NAME = "JOE", LAST_NAME = "BLO" where RECNO = "" - Original Message - From: "Nick McBride" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, February 03, 2002 8:58 AM Subject: Edit a MySQL Record > How would I go about editing a certain r

Re: Edit a MySQL Record

This topic is covered quite well in the manual. http://www.mysql.com/doc/U/P/UPDATE.html On Sun, 3 Feb 2002 08:58:33 -0800 (PST), Nick McBride wrote: >How would I go about editing a certain record in a >MySQL database; Items? I want to be able to change a >value that was already inserted into

Edit a MySQL Record

How would I go about editing a certain record in a MySQL database; Items? I want to be able to change a value that was already inserted into the table. -Nick McBride __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://aucti

RE: Bandwidth Throttling - a followup

Yes, the other option is to move it to a server with more bandwidth :) Most People that are running it from home either don't know how or don't know that they are running a firewall or have an ISP that won't let them touch the configuration of the modem/router. So you are one of the lucky ones.

Bandwidth Throttling - a followup

A few weeks ago I posted a question regarding bandwidth management for a very busy mysql server that is swamping my cable modem upload bandwidth and impacting the rest of my network. I was seeking a way to manage connections by capping the data transferred and I wondered if this would impact MySQ

Re: Selecting several columns using DISTINCT

Michael Collins a écrit : > > I am trying to normalize some MySQL tables and need to move a few > columns from one table to another while maintaining the relationship > between the two. I realize I cannot do a subselect, but in effect > what I am wanting to do is to select the Distinct rows for t

SQL question regarding JOIN

I have two tables, one contains user account info the other contains active sessions in a web app. In the user account table I have a column that contains each user's 'access level'. I'm somewhat new to relational databases and SQL, and though the following is working for me, I want to find out

Selecting several columns using DISTINCT

I am trying to normalize some MySQL tables and need to move a few columns from one table to another while maintaining the relationship between the two. I realize I cannot do a subselect, but in effect what I am wanting to do is to select the Distinct rows for the column ProductID and then sele

Regarding BLOB class

Hello sir, We are using Mysql database for our applications.We are very happy to use this and it's havingvery good features. But one thing i would like to know, in my application i want to store files(like resumes)into the database and i want to open it from browser(IE). while retieving the fil

Arabic Charset support.

Hi all, When will Arabic charset be included as a supported charset? Anyone solved this problem? sql : this word is needed by the lists filter. Waheed - Before posting, please check: http://www.mysql.com/manual.php (the man

Re: Fulltext problems 4.0.1 part two (fwd)

I found out, that the fulltext engine is misbehaving with less than 5 entries. Seems to me, that this is exactly the same case... Perhaps a flush inside the engine or so isn't made with such less entries? The bug is also in 3.23 gamma. Workaround: Enter more rows to fix it. :) I send this bug

Re: sysctl & process limitations

On Sat, Feb 02, 2002 at 09:14:27PM -0700, Randy Arabie wrote: > I don't think so. I raised the limit for mysqld descriptors to 5000. > > # sysctl -w proc.220.rlimit.descriptors.hard=unlimited > # sysctl -w proc.220.rlimit.descriptors.soft=unlimited > > The kernel maxfiles was already set to 500

Remote APIs

Hey there. Wanted to know what security is built into MySQL with respect to writing SQL to remote tables. I have clients that want reads and writes to their tables, but I don't want to share their information. Any idea what I can do? Any SSL type implementation from rdbms to rdbms? Cheers.