oracle from mysql

Hi, Please I need help. I am a new to the Mysql, and want to know if is it possible to get or update database managed with oracle. In our dept (of University institute) we want to use Mysql for many reason, one of them we use linux system, Unfortunatley we need to get some informations from

Re: Multiples instances of MySQL

Hello all, I'm in a spot, I'm managing to successfully run several instances of MySQL, say on port=3306 and port=3308. When I use shutdown, the instance which started first shuts down. To shutdown the instance started on port 3306, I use; mysqladmin -P 3306 -u root -p2000 shutdown And to

Re: Multiples instances of MySQL

On Mon, 2001-12-31 at 10:08, Emmanuel van der Meulen wrote: Hello all, I'm in a spot, I'm managing to successfully run several instances of MySQL, say on port=3306 and port=3308. When I use shutdown, the instance which started first shuts down. To shutdown the instance started on port

Re: Multiples instances of MySQL

use --socket instead of -P would solve your problem. without -h, socket file is used for connection. since you've not specified the socket file, the default socket file path is used (in some case, /tmp/mysql.sock). that's why you're always shutting down the first one. Happy new year. On Mon,

Re: Multiples instances of MySQL

Hello Sammy Martin, Thank you for your notes and assistance. ** Martin; Try using the -S option to select the instance via the Unix domain socket rather than the port number (assuming this is a Unix installation). ** Sammy; use --socket instead of -P would solve your problem. without

Re: OleDB

Thanks, now I got that working... When I used MyODBC I had to use option=16386; in the connectionstring to set the change bigint to int option when i use count(*) and Group By queryes. How do I set this in MyOLEDb??? - Original Message - From: Fredrick Bartlett [EMAIL PROTECTED] To:

Somewhat simple question on tables.

Hello, I have a relatively simple question to ask. Any help is great appreciated. Let us say that I want to create a classic table that would have columns for a persons name, eye color, age, etc. However, I also want to store a list (somewhere) of that particular persons favorite foods

FullText Query

Dear members, Wish you a Happy New Year 2002 I created FullText Index and in the sql using 'where match(...,,) against ('searchstring')'. It is working fine for exact full words. How to operate for pharses i.e. The query should fetch even if the search string is substring of a column

What's the behaviour of mysql when no room on filesystem for databases

Hi, Can anybody help me ? It seems that INSERT is blocking my process when there is no more free space in the file system that contains my databases. Can anybody clarify this point, and tell me how to prevent this blocking point ? Thanks

RE: UNIQUE in InnoDB

Hi Heikki, I have proven this in MySQL 3.23.47 and I have found a problem with CHECK TABLE, that reports error - corrupted table if there are several NULL's in a UNIQUE index. Happy end of year to all!, José Ceferino Ortega -Mensaje original- Hi! I will change InnoDB so that it allows

RE: UNIQUE in InnoDB

Jose, thank you for the bug report. You are right: if there are several NULLs in a unique secondary index, CHECK TABLE will report table corruption because of a duplicate key in the index. I forgot to ease the check in CHECK TABLE. I have now fixed this for 3.23.48. Regards, Heikki Innobase

Re: MySQL RPM Install Problem - Ignorance

Trevor, Thanks for the tip...This is probably what I should have done in the first place. I can't now though, at least not at the moment, this is a Cobalt RAQ4 web server set up at a hosting service in Atlanta, GA. I went ahead and used a symlink at the compiled data directotry pointing back

Re: What's the behaviour of mysql when no room on filesystem for databases

Didier Brisebourg writes: It seems that INSERT is blocking my process when there is no more free space in the file system that contains my databases. Can anybody clarify this point, and tell me how to prevent this blocking point ? For info on full disks, see the manual:

When to upgrade?

Hi! I want to solute a hanging problem and I want to upgrade to a newer version. Actually I'm using the 3.23.39 on a SunOS 5.6 sparc Ultra-5_10 Should I wait to the 4.x version? How long will a stable version take to be published? Or should I upgrade to 3.23.47? Thank you!!

Problem with LOAD DATA INFILE

HI ALL: Happy New Year ;) I have a text file generated from MSAccess database, one of the fields (Long Text) have Carriage returns within the text, So the data of some records falls in more than one line in the text file, when I'm using the SQL statement LOAD DATA INFILE... I have only the

Re: Multiples instances of MySQL

On Mon, 2001-12-31 at 10:50, Emmanuel van der Meulen wrote: As suggested, I used -S instead of -P, but still the first instance shuts down. I'm running on Win2K Pro. Is there a different way for Windows? Please advise any further pointers? Ok. Try to explicitly set the host on the

RE: Multiples instances of MySQL

Hello Martin, [snip] Ok. Try to explicitly set the host on the command line: eg: mysqladmin -h 127.0.0.1 -P 2000 . Note that you should use the ip address of your host or its network name. Using 'localhost' won't do what you want. I include commands of two instances which I

Re: Somewhat simple question on tables.

James -- You haven't done enough book work this is basic db design stuff, covered in Dubois book and evey other, the short answer is: Primary Key - foriegn Keys i.e People table: person_id, # Primary key, unique and auto increment fname lname ... Food person_id # pulled from People table via

Re: Problem with LOAD DATA INFILE

Are you using mysqlimport utility? If not that may be you answer? If so what flags are you setting? david HI ALL: Happy New Year ;) I have a text file generated from MSAccess database, one of the fields (Long Text) have Carriage returns within the text, So the data of some records

RE: Multiples instances of MySQL

On Mon, 2001-12-31 at 14:01, Emmanuel van der Meulen wrote: Hello Martin, [snip] Ok. Try to explicitly set the host on the command line: eg: mysqladmin -h 127.0.0.1 -P 2000 . Note that you should use the ip address of your host or its network name. Using 'localhost' won't

Re: date_format

Thanks this works the difference was the 'AS datefield' what is this bit doing? I searched for AS (in the SELECT description in my book) but it does not mention it; though I have seen it in examples. I like to understand why I use the code I do... I looked at http://www.mysql.com/ but can

Re: date_format

Julian, The as field is just setting the name of the field or column. For example in PHP, if you don´t use the as somename, you must use array[2] (I just use 2 as an example) instead of array['datefield'] to get the information. Regards, Ingvar G Web accounting CRM us.logiledger.com -

Re: InnoDB in MySQL-4.0.1

Hi! Sorry, I think there is no row-level privilege setting in MySQL. You have to code the logic in your application. Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB

Access Denied

I get this error when trying to connect to a mysql database DBI-connect(database=baggs) failed: Access denied for user: 'baggs@localhost' (Using password: YES) I added the user 'baggs' to the user table and to the db privilege table and used mysqladmin reload to refresh the tables. Any Ideas.

unique problem?

I have a table shpr_rcvr that stores info about locations where things are shipped to and from. Each record has a text field called DIRECTIONS that contains directions on how to get to the location. Often in the directions column the # sign is used to help describe and exit number off the

RE: unique problem?

SELECT REPLACE(DIRECTIONS, '#', 'No.') FROM shpr_rcvr WHERE etc. -- Greg Johnson -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED]] Sent: Monday, December 31, 2001 1:23 PM To: [EMAIL PROTECTED] Subject: unique problem? I have a table shpr_rcvr that stores info about

Backup Question.

I am running mysql on a linux box RH 6.2. I backup all the filesytems with: /sbin/dump 0ubf 800 /dev/npt0 to a COLORADO 8gig. travan tape drive. Is this sort of backup regimen a good one -- compatible with MySQL -- or should I instead be backing up with FLUSH and (or) mysqldump? Any

Re: Access Denied

Clinton -- It's saying you password is incorrect or wasn't entered. I believe. Did you set username and password in script? Also http://www.perlmonks.org have some tutorials on DBI/DBD, you would find helpfull. -- david I get this error when trying to connect to a mysql database

Re: Backup Question.

Richard -- You could do both, I would be a lot quicker to import data than restore from tape. Say do an incremental dump back to your last level 0. Which would be helpfull to developers as well as youself. You could also use a seperate partition for the data directory and back that up. The

MYSQL Database - DBI::db

i'm using DBI (use DBI;) but I still get this error. Any Ideas. Can't locate object method execute via package DBI::db (perhaps you forgot to load DBI::db?) - Original Message - From: [EMAIL PROTECTED] To: Clinton Hesse [EMAIL PROTECTED] Sent: Monday, December 31, 2001 2:04 PM Subject:

MySQL,sql my unscribe info appears in mail

database,sql,query,table 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: database,sql,query,table If you just reply to this message, and include the

mysql - root/user - passwords?

Hello All, I am using Linux, with Apache, mysql among other things. I am root, user, owner, etc. Other than getting up there in age, I can't seem to remember the mysql passwords that I set up for root, users, etc. is there a way to remove/recover the password I set up for mysql for root and

how can I see man about c-api ?

where can I find man pages about c api functions? MySQL-client-3.23.41 MySQL-devel-3.23.41 MySQL-shared-3.23.41 MySQL-3.23.41 but I can't man to mysqlfunctions!! === ¿ì¸® ÀÎÅͳÝ, Daum http://www.daum.net - 2002

Execute Error

It's funny, i can call method prepare on the database object but not execute, error on line 3. 1. my $query = SELECT UserID,Name FROM test; 2. my $sdb = $dbobj-prepare($query); 3. $dbobj-execute; where $dbobj is a reference to the database object I get error Can't locate object method execute

Re: Execute Error

try $sdb-execute() Clinton Hesse wrote: It's funny, i can call method prepare on the database object but not execute, error on line 3. 1. my $query = SELECT UserID,Name FROM test; 2. my $sdb = $dbobj-prepare($query); 3. $dbobj-execute; where $dbobj is a reference to the database object I get

Sorry Guys

Good old copy and paste an error. Thanks, will make sure the next time i have a problem, not to waste your time for something silly. It's funny, i can call method prepare on the database object but not execute, error on line 3. 1. my $query = SELECT UserID,Name FROM test; 2. my

LOCK TABLES issue

I have an application with fairly typical locking requirements: 99% of the requests are read-only (with an exception that I will specify). Update requests are relatively rare. There's a half-dozen tables, and since the inter-relationships are a little complex. I found it easiest, given the

TEXT field: How many characters does it hold

Hello All! Can anyone tell me how many characters a MySQL TEXT field can hold? What's the limit? Thank you, Carlos Fernando. Linux User #207984 - Before posting, please check: http://www.mysql.com/manual.php (the

Re: TEXT field: How many characters does it hold

http://www.mysql.com/doc/n/o/node_365.html Can anyone tell me how many characters a MySQL TEXT field can hold? What's the limit? -- Steve Rapaport World Citizen - Before posting, please check:

Perl problem

I've decided to graduate to the next step and access my mySQL databases with Perl. I am attempting this on a Win2000 machine. Here's my code... #!C:/perl/bin/perl.exe -w use strict; use CGI qw(:standard); use DBI; my $dbh = DBI-connect('Radio', 'root', ''); I get this error message...

(WOT) Re: Perl problem

From the DBI manual: $dbh = DBI-connect($data_source, $username, $auth, \%attr); You're not telling DBI what the DSN is (Data source name) John Mayson wrote: I've decided to graduate to the next step and access my mySQL databases with Perl. I am attempting this on a Win2000

unable call database

hi everyone, I have problem call database.Its unable to call database below, but rest of database can be call.Can anybody help me. mysql_connect($host,$user,$passwd) or die (Can't connect to server); $db = mysql_select_db(dictionary) or die(unable to call db) ; thanks in advance

Re: InnoDB in MySQL-4.0.1

Hi Heikki, Thanks for the response. I assume that the row level privileges can not be implemented in application only. There is some dependency involved in masking direct mysql database access (using mysql client tools). Please let me know if there is any the default alternative