raid tables

Is there a way to tell MySQL to automatically spread its tables over a number of disks without going through the trouble of symbolic linking the chunks to the different disks? Thanks, Jamie Krasnoo [EMAIL PROTECTED] - Before

Re: FW: FW: FW: HELP! functions don't work...

Dawn H wrote: -Original Message- From: Les Roberts [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 9:06 PM Cc: Dawn H Subject: Fwd: FW: FW: HELP! functions don't work... first I apologize for the bad function name... I had changed it to several and left it at dayname()

mysql++

Solaris8 on a Ultra5 Box, mysql++ 1.7.9: the example and also my own appliacations core dumps if they can not connect to mysql, in other words the try block does not work! I have tried gcc 2.95 (recommended in the manual) and 2.95.3! Does any has experience with this, or am I allone in the dark

RE: HELP! functions don't work...

Fatal error: Call to undefined function: dayname() in /home/ccrb/ccrb-www/index.html on line 8 This indicates that I'm missing most all of the functions. Is there a standard include that I need, or is my php installation not complete? Here is the line of code in question: ?php

RE: .dump files

thank you. that's sort of what i thought. now for the silly question: i know how to do it with 'monitor' (CLI), but where/how do you import using phpMyAdmin, please? (this i'd love to know :) i looked through the manual but didn't see anything for import db. Click a database on the left

RE: Number of Word Matches

Hi there, I'm using select queries like SELECT * FROM table_name WHERE col_name LIKE '%some_word%' to find rows that have col_name match to some_word. But I would also like to find the number of word matches for each row so that I can order these rows according to their relevances and

log event entry exceeded max_allowed_packet error: findings (again)

Today on a slave I got (this actually has occured several times in the past months): Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'xxx-bin.040' at position 47694 010511 10:37:19 Error reading packet from server: log event entry exceeded max_allowed_packet

Aborted connection to db:(got an error reading communication packets)

Sir, We are using mysql-3.23.38 and are using Red Hat Linux 7.0. The linux kernel version is 2.2.16-22.We are using an IBM-PC with 128 Mb RAM,intel PIII processor. We are presently using kannel SMS gateway-1.0.3 and are using Mysql as database. We are using a C API to connect to the

Benchmarks

he development team I am currently with is considering using MySql. However, as part of the we require the actual benchmarks that were used as well as the results. Is it possible to have a set of the SQL queries in the form CREATE TABLE t ( n NOT NULL VARCHAR(100)); INSERT INTO t VALUES

Re: MYSQL++: Any ideas why this code causes the program to crash?

David Ayliffe writes: I wrote this program in VC++ using the MYSQL++ API for VC. I have a generic function (below) which I call numerous times each time with a different query string. It works fine the first time around. But the second time I call this function it causes the program to

Re: mysql++

Stepan Havel writes: Solaris8 on a Ultra5 Box, mysql++ 1.7.9: the example and also my own appliacations core dumps if they can not connect to mysql, in other words the try block does not work! I have tried gcc 2.95 (recommended in the manual) and 2.95.3! Does any has experience with this,

Re: Benchmarks

Roger Norton writes: he development team I am currently with is considering using MySql. However, as part of the we require the actual benchmarks that were used as well as the results. Is it possible to have a set of the SQL queries in the form CREATE TABLE t ( n NOT NULL VARCHAR(100));

Re: raid tables

Isn't this something that RAID O does for you on a larger scale anyway? I would expect that most would have some sort of raid on their mutliple drive system. On Monday 18 June 2001 01:52 am, you wrote: On Sun, Jun 17, 2001 at 11:48:04PM -0700, Jamie Krasnoo wrote: Is there a way to tell

Some question about the MySQL...Akira

Dear : Sir There are a message error display ... Can't connect to database : Can't connect t local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) How and where that I can trouble shooting it ? Best Rgards

mysqld 3.23.36 -- new connections get stuck in Open Tables

I've been experiencing some strange behaviour in which mysqld will get into an odd state. When doing certain long-running operations (see below) on large tables (5-10 million rows; 20-30 columns per row -- mix of varchar and int) with unique indeces mysqld will occasioanlly get into a confused

Re: raid tables

Hi Samuel I would do this in sql. I thinks this would be much more convenient to administrate. It would be great if you would see these informations also in with the command eg: show database storage and you can see as return, where the files are located. Thanks Philip On Mon, 18 Jun

mysqldump bug during regenerate enum field.

mysqldump regenerates a bad sql statement from a bad initial create table. When you create this table for example (ok it's not a really nice definition): CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default 0 ); desc TESTBADDUMP;

Re: mysqldump bug during regenerate enum field.

[EMAIL PROTECTED] writes: mysqldump regenerates a bad sql statement from a bad initial create table. When you create this table for example (ok it's not a really nice definition): CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default 0 ); desc

Re: mysqldump bug during regenerate enum field.

Hi, mysqldump regenerates a bad sql statement from a bad initial create table. When you create this table for example (ok it's not a really nice definition): CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default 0 ); desc TESTBADDUMP;

Re: mysqldump bug during regenerate enum field.

Try quoting (' ') the 0 in your create: CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default '0' ); -^ You should then get the result you want. Have a great day... John On Monday 18 June 2001 08:54, [EMAIL PROTECTED] wrote: mysqldump

Re: how to setup passwords for mysql

how to setup passwords for mysql On Mon, 18 June 2001, [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:

Re: mysqldump bug during regenerate enum field.

Le Mon, Jun 18, 2001 at 04:04:52PM +0300, Sinisa Milivojevic a écrit: [EMAIL PROTECTED] writes: mysqldump regenerates a bad sql statement from a bad initial create table. When you create this table for example (ok it's not a really nice definition): CREATE TABLE TESTBADDUMP (

Re: mysqldump bug during regenerate enum field.

but mysqldump generates an invalid statement. mysql CREATE TABLE TESTBADDUMP ( - e_test enum('0','1') NOT NULL default '' - ); ERROR 1067: Invalid default value for 'e_test' mysql I think that's what the orignator is trying to show. That mysqldump is generating an

Database size limit

Hi, I'm new in this list and new to MySQL also. What I want to know is how to limit the size of a database. Thanks. -- Ali Kemal YURTSEVEN Is Net A.S. Iletisim Uzmani - Before posting, please

my.cnf and tuning

Hi, Could someone please e-mail me a copy of the example cnf files, as they did not come with my distribution. Thanks. For a Sun E450 with a single 300Mhz processor and 256Mb of RAM which .cnf file would you suggest I used? The machine is being used for a MRP server as well as a ODBC mysql

Re: Some question about the MySQL...Akira

Start with the troubleshooting section of the manual. Is the server running? Where did it put the socket file? What program gave you that error? What system are you running? What version of MySQL is this? Where did you get it? How did you install it? So many questions. So few answers. CSHAkira

Re: mysqldump bug during regenerate enum field.

Guillaume Fougnies writes: ok so it's a failure from mysqldump. I know this declaration is not really correct but mysqldump must regenerate a correct sql statement (good when pipe in mysql client i mean at least ;) ). It's not the case. Regards, -- Guillaume FOUGNIES Research

Re: mysqldump bug during regenerate enum field.

Sinisa, A good way to prove that mysqldump is doing what it should, might be to do a describe TESTBADDUMP; I think this will prove that mysqldump is just dumping what is in the table def, which is all you can expect. Have a great day... John On Monday 18 June 2001 09:46, Sinisa Milivojevic

my sql and patter matching ....bug(Urgent)

Hi, I am facing the following problem in pattern matching: I want to check the pattern matching using LIKE on a field that is declared as Binary and also contains back slashes. eg: ID INT, NAME VARCHAR(128) BINARY I am using C-API of mysql to escape the characters like '\' for this field. The

help!

Hi, Fairly new at this so i need all the help i could get. I created a admin page where admin can add/mod/del/view from this page. But now I need to give access to other admins but from diffrent companies where I need to grant diffrent username and passwords to the original admin page. Each

Re: my sql pattern search and support for backslash??

On Mon, Jun 18, 2001 at 04:15:37PM +0100, VVM Ravikumar Sarma Chengalvala wrote: Hi, Did mysql pattern search support a backslash character? Yes. Since it is a special character, make sure it is properly escaped. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk:

Re: my sql pattern search and support for backslash??

It depends on what you mean by pattern search? You probably have to escape the \ character. If you put a \ in front of a character it means this next character is what I say it is not it's MySQL representation. This would allow you to put a ; or ) in your query. Simply put \\ to mean a

Re: my sql pattern search and support for backslash??

It is not working even after escaping it.I am working on WINNT4.0 and mysql 3.23 --Regards, Ravi --- Scott Baker [EMAIL PROTECTED] wrote: It depends on what you mean by pattern search? You probably have to escape the \ character. If you put a \ in front of a character it means this next

gnu tar

I am trying to evaluate mySql. I am told that if I am on Solaris, I must obtain gnu tar because of a bug in Solaris tar. I have downloaded the mySql distribution as well as 2 different versions of gnu tar that available at the site. gtar-solaris-4.1.4-sparc.gz and gtar-sparc.gz The reason I

Re: 3.23.39+InnoDB = slower than 3.23.389InnoDB ?

Alex, did you change any my.cnf parameters? Version .39 should actually be a littel bit faster than .38. What does Unix 'top' say? What are the CPU usage %? The biggest change performance-wise in .39 is that you can now specify the parameter innodb_unix_file_flush_method in my.cnf. You

Connection Timeout Limit.

Title: Blank I currently have several different systems accessing a mysql server 3.23.34 somewhere in there is a process that forgets about connections that it has open. So after a few days I get a "too many connections open error". Is there a way that I can set connections to time out

my sql and pattern search--bug(most urgent)

Hi, Can someone get back to me at the earliest regarding mysql's support for backslash characters in pattern search.I am not able to search based on the string which contains a backslash character even after escaping.. Regards, Ravi Do

Re: my sql pattern search and support for backslash??

On Mon, Jun 18, 2001 at 04:32:54PM +0100, VVM Ravikumar Sarma Chengalvala wrote: Even after escaping mysql just seems to be ignoring it. Odd. I'm seeing something other than what I first expected. Watch this... ---snip--- mysql CREATE TABLE slash_test ( foo VARCHAR(30) ); Query OK, 0 rows

Mysql Problem

Hello I run mysql on a multi proccesoor server and when I run queries from different servers, I see it uses under 100% cpu, even thought it sometimes take 50% from each cpu. how can I get it to use 100% for each query? Thanks Tomer Grassyani. Internet Driver.

Re: my sql pattern search and support for backslash??

try some more then.. try // or / or .. . Hi, I donot even get that with an additional backslash also.In my case it just ignores the backslash and goes ahead with the search . Regards, Ravi --- Jeremy Zawodny [EMAIL PROTECTED] wrote: On Mon, Jun 18, 2001 at 04:32:54PM +0100,

mysql does not start

i have recently installed the red hat 7.1 in my computer, althought i have not installed the mysql durring the os installations, naw i installed the mysql database but its giving me a socket error like this: /etc/rc.d/init.d/mysqld status mysql dead but subsys locked mysql ERROR 2002: Can't

Data

ola como faço p/ mudar a data padrao do mysql?? ele esta como -dd-mm eu gostaria de mudar p/ dd-mm- falow valeu

Re: apache/php/modperl incomp?

Greg wrote: Le jeudi 14 juin 2001, à 08:14, Daniel a écrit : I believe that i've seen this on the list before. Read the php docs before compiling, don't use the builtin mysql support, specify --with-mysql=/path/to/mysqllibs Yes, I've compiled with this option. Is it possible that it

Re: Database size limit

No need to worry.On NT each table can have upto4GB.Database there is predefined limit.It can go even upro 20GB or more also. --- Ali Kemal YURTSEVEN [EMAIL PROTECTED] wrote: Hi, I'm new in this list and new to MySQL also. What I want to know is how to limit the size of a

Oddity with building 3.23.38 on Tru64 4.0f

I recently set about upgrading our MySQL install on a Compaq Tru64 4.0f Alpha box from 3.22.25 to 3.23.38. As in the past, I used the Compaq cc as CC and gcc (2.95.3) as CXX with appropriate flags set. I do not have the GNU binutils installed, so it is the Compaq ld that is used. I am,

problem with mysql_query in C API

hi all, i have a small problem im using mysql_query to access my mysql database. now then, i have 2 queries, 1 just after the other. the first one goes ok, the second one never does. doesnt matter if i switch the queries, the one that is last never works. if i write the query in an xterm

Re: help!

(assuming you're using PHP...) The best idea would probably be to create a column in your users table which indicates which company each user belongs to. Then, using select company_name from users where username EQ .$username; If you're not using PHP, the idea is still the same. Use a MySQL

RE: gnu tar

I have downloaded the mySql distribution as well as 2 different versions of gnu tar that available at the site. gtar-solaris-4.1.4-sparc.gz and gtar-sparc.gz The reason I downloaded 2 different versions of the gnu tar is that I can't get anyone of these to deflate using gzip. I has

Re: mysql does not start

Ricardo, Heh... Watch out, RH 7.x is notorious itself for being the src of a problem. Cheers -v. --EOF Ricardo Striquer Soares wrote: i have recently installed the red hat 7.1 in my computer, althought i have not installed the mysql durring the os installations, naw i

Starting mysql

Hello all, I have mysql 3.23.39 installed on the new Mac OSX Server. The problem I am having is that when I start it from the command line using safe_mysql -u mysql, it says: Starting mysqld daemin with databases from /usr/local/mysql/var It never reports anything else. The database starts,

left outer join query question

Hi, I am having a small formatting problem maybe someone can help with. I have a query that does a left outer join, which generates a table with a few NULL values in some columns. All okay so far. But what I need to do is sort on this column, and I need to put NULL values at the end. Normally

Re: Starting mysql

That's what it's supposed to do. End the command with a so it will spawn into the background. Scott At 11:05 AM 6/18/2001 -0700, Dale Schell wrote: Hello all, I have mysql 3.23.39 installed on the new Mac OSX Server. The problem I am having is that when I start it from the command line

Re: mysql does not start

Ricardo Striquer Soares [EMAIL PROTECTED] writes: i have recently installed the red hat 7.1 in my computer, althought i have not installed the mysql durring the os installations, naw i installed the mysql database but its giving me a socket error like this: From our RPMs, or did you

Re: left outer join query question

You could try using the IFNULL() function on that column before you do the join. http://www.mysql.com/doc/C/o/Control_flow_functions.html --jfarr - Original Message - From: Bryan Coon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 18, 2001 11:12 AM Subject: left outer join

Unknown column in 'where clause' error

Here is the full error I am getting when running the query included: Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239 1054 : Unknown column 'CMET3558539239' in 'where clause' Here's the problem, I know that Customer_No exists. I can see it in the database. This code

Re: problem with mysql_query in C API

Kenneth Johansen ([EMAIL PROTECTED]) writes: hi all, i have a small problem im using mysql_query to access my mysql database. now then, i have 2 queries, 1 just after the other. the first one goes ok, the second one never does. doesnt matter if i switch the queries, the one that is

Starting MySQL on boot

Hello all, I am running the new Mac OSX Server. In the mysql docs, it says to put the mysql.server file in the correct place for your system. Does anyone know what the right place on OSX Server is? I placed it in /Library/Startup/MySQL, as the other databases I am experimenting with have

Design question

I have a design problem I was hoping some of you could help me out with. I am writing a shopping cart system (as if there wasn't enough already) and I have one problem that has me stumped. A person can order more than one item of course. So let's say they order a kite and some string. Both

Re: Unknown column in 'where clause' error

On Mon, Jun 18, 2001 at 02:44:00PM -0400, Shrout, Ryan wrote: Here is the full error I am getting when running the query included: Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239 1054 : Unknown column 'CMET3558539239' in 'where clause' Here's the problem, I know

Re: Unknown column in 'where clause' error

Put quotes around the Customer_No: SELECT * FROM customers WHERE Customer_No = 'CMET3558539239' - TIM Here is the full error I am getting when running the query included: Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239 1054 : Unknown column 'CMET3558539239' in

RE: Unknown column in 'where clause' error

Try SELECT * FROM customers WHERE Customer_No = 'CMET3558539239' Jorge Oliveira [EMAIL PROTECTED] © webfroggie.com - Recursos Online! web: http://www.webfroggie.com wap: http://www.webfroggie.com -Mensagem original- De: Shrout, Ryan

RE: Unknown column in 'where clause' error

Thanks for the suggestions, but this is actually a variable that is passed via a URL. For example: http://localhost/cus-lookup.php?id=CMET3558539239 Then in the code it looks like this: $customer_select=SELECT * FROM customers WHERE Customer_No = $id; How can I 'put quotes around' a

RE: Unknown column in 'where clause' error

Hello, Your field(column) is a CHAR and therefore the parameter to it should be in single quotes: Change your query to: SELECT * FROM customers WHERE Customer_No = 'CMET3558539239' * * Visit http://www.computerstaff.net -

Re: Design question

This looks like an order-lineitem situation, which I would imagine would look like this: ORDERS ORDER_ID CUSTOMER_ID ORDER_DATE LINEITEM ORDER_ID PRODUCT_ID LINEITEM_QUANTITY At 02:00 PM 6/18/2001 -0500, you wrote: I have a design problem I was hoping some of you could help me out with. I

MySQL Crashes

Hi, I am new to MySQL. I downloaded MySQL for Windows version 3.23.38. When I installed in MyISAM mode, mysqld was running fine. Then I uncommented the configure parameters for innoDB in my.cnf. Mysqld initialized the database the folowing messages printed on screen. Can anyone help ? Thanks,

MySQL protocol

Hi there, Where can I get the MySQL protocol? Thanks! Yue - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

RE: Unknown column in 'where clause' error

You are using PHP. Well PHP is not ASP :-) clever and you can enclose your variable in single quotes as in: $customer_select=SELECT * FROM customers WHERE Customer_No = '$id'; Hope this helps. * * Visit

RE: Unknown column in 'where clause' error

Like this: $customer_select=SELECT * FROM customers WHERE Customer_No = '$id'; Jorge Oliveira [EMAIL PROTECTED] --- © webfroggie.com - Recursos Online! web: http://www.webfroggie.com wap: http://www.webfroggie.com -Mensagem original- De:

Articles... (MySQL) - Call for Submission

Hello All, Sorry if this is the wrong place to post this request. I represent ADEMKA and in September we are launching a publication which has both a LIFESTYLE and a TECHNICAL angle to it for Computer Professionals. We are looking for articles relating to MySQL and are paying between £50(GBP)

RE: Unknown column in 'where clause' error

Ok, in your PHP code, do this: $customer_select=SELECT * FROM customers WHERE Customer_No = '$id'; This will add quotes around the variable... -TIM On Mon, 18 Jun 2001, Shrout, Ryan wrote: Thanks for the suggestions, but this is actually a variable that is passed via a URL. For example:

Re: raid tables

On Mon, Jun 18, 2001 at 03:56:32AM -0700, Jamie Krasnoo wrote: [mysqld] datadir=/data1;/data2;/data3 - or - datadir=/data1:/data2:/data3 As it stands now, both will produce an error and MySQL will not start. Other ways could be like: RAID_DIRS=/data1:/data2:/data3 Well, I'll throw

seeking clever php / mySql generic method

Hi All! While this is not a huge problem, it is a recurring one so I thought I would see if someone else has a nice generic way of handling this situation. I often set up database tables with a PHP4 interface to handle insertions. It is always set up on a CGI basis, wherein a form blasts

RE: Data

Ola Ricardo, Não sei ao certo se o formato padrao do MySQL voce consegue mudar. Entretanto voce pode resolver o problema utilizando o DATE_FORMAT no select. Veja o exemplo abaixo: SELECT DATE_FORMAT(NOW(), d/m/Y) AS DATA; []'s Crercio O. Silva -Original Message- From: Ricardo Ferrari

I need to use the Load Data command to load the contents of ate xt file into a table.

The problem is the text file resides on a server that holds the website pages. I am new to UNIX. How do I setup the LOAD DATA INFILE command to specify the text file if it is loaded on another server? This is what I have: LOAD DATA INFILE 'data.txt' INTO TABLE data FIELDS ENCLOSED BY ''

RE: Design question

hi. the easiest way is to have an order table: (orderID, customer, address, etc., etc.) a item table: (itemID, description, price, etc.etc.) and an orderItems table: (orderID, itemID) this way you can select i.description, i.price from order o, item i, orderItems oi, where

Start fails after upgrade to 3.23.32 - no host.ISM file

Description: Upgraded from 3.22.27 to 3.23.32. Built from source. When attempting to start the daemon, it immediately terminates. Log file shows Can't find file: 'host.ISM' (errno: 2). I checked the old data directory (from where I copied the database files) and there never has been a

FW: I need to use the Load Data command to load the contents ofa text file into a table.

Really the question is will the following work: LOAD DATA INFILE 'home/domain name/www/subdirectory/data.txt' INTO TABLE data FIELDS ENCLOSED BY '' TERMINATED BY ',' LINES TERMINATED BY ';'; -Original Message- From: Hamilton, Jay Sent: Monday, June 18, 2001 4:56 PM To: '[EMAIL

Re: Design question

Hi Jeff, If you visit my homepage at: www.geocities.com/hisiomara click Tutorials and select the first item Team5.com an ecommerce sample you will be able to see the ERD diagram that attends your ecommerce demand. Actually will will be able to see much more. The design is there,and I will

Upgrade and start-up failures

I just upgraded from 3.23.27 to 3.23.32 (can't go higher than that - have to sync development with production systems). I copied the /data directory to the new home. When I try to start mySQL, it halts and the log file has the entry Can't find file: 'host.ISM' (errno: 2). I checked the old

MM JDBC driver: Server configuration denies access to data source

Hi, I'm connecting to a MySQL server through the MM JDBC driver on under Red Hat 6.2 using the below code. I keep getting an error message returned that says : Server configuration denies access to data . I'm connecting as the root user and I am definitely passing the correct password etc. in

Re: seeking clever php / mySql generic method

You can. However, in these situations (in other languages) I've written code generators that generate either the entire HTML/PHP page for me or at the very least, the data object that I am talking to, complete with SELECT/INSERT/UPDATE and DELETE statements. That having been said, not trying to

Re: Using mysql_data_seek() is very slow

Hi. On Mon, Jun 18, 2001 at 08:16:45AM +1000, [EMAIL PROTECTED] wrote: What is the current way to move back and forwards and to any position in a recordset without losing performance There is no way. For effiency, the record set is hold in memory as linked list. Searching a position in

Re: SQL query - not too complex?

Hi. On Mon, Jun 18, 2001 at 02:32:13AM +0100, [EMAIL PROTECTED] wrote: I need some help with a query to sum data for each id and write it into a new table. I have a source data table for each calendar month containing i.d.'s (not unique) and a value and I need to sum all the values for

How can I know the version of mysql running on Linux (RedHat 6.2)

How can I know the version of mysql running on Linux (RedHat 6.2) thanks, Augusto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Put mysql data from linux in Win98 mysql

I tried to put the data (.frm, .ISD and .ISM files) of my Linux into windows 98 put I can't use the data. When I open phpadmin2, he show how many registrys I have, but When I try to use/list the table is empty. Can I solve this problem? I need to use mysqldump to put the data into windows 98?

RE: MySQL 3.23.39 released

Steven Now I have a question: Does this also apply to automatic repair inside Steven mysqld? I'd finally use the feature if its true... If you just run CHECK TABLE, it will repair the open count (it should always have done that). myisamchk --fast --force is equal to: run CHECK TABLE on

Re: How can I know the version of mysql running on Linux (RedHat 6.2)

On Mon, 18 Jun 2001 20:19:20 -0300 (EST), Augusto Cesar Castoldi [EMAIL PROTECTED] wrote: SELECT VERSION(); te: Mon, 18 Jun 2001 20:19:20 -0300 (EST) How can I know the version of mysql running on Linux (RedHat 6.2) thanks, Augusto Mike(mickalo)Blezien

Re: How can I know the version of mysql running on Linux (RedHat 6.2)

On Mon, Jun 18, 2001 at 08:19:20PM -0300, Augusto Cesar Castoldi wrote: How can I know the version of mysql running on Linux (RedHat 6.2) mysqladmin version -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408)

transfering data

How can I transfer the data from a MySQL 3.22.32 running on RedHat 6.2 Linux to a MySQL 2.23.37 running on Windows 98? thanks, Augusto - Before posting, please check: http://www.mysql.com/manual.php (the manual)

mysql.sock error

I'm receiving the following error: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/httpd/html/phpadmin2/lib.inc.php on line 119 what could be? thanks, Augusto

Re: How can I know the version of mysql running on Linux (RedHat 6.2)

If you're trying to check a 'remote' system, you can 'telnet' to port 3306 (IF you have remote 'telnet' access to the MySQL service, and IF it's listening on the default port 3306) which will display some garbage containing the version number telnet yubby.dubby.com 3306

Re: Put mysql data from linux in Win98 mysql

In case you're not aware of it yet, Linux (and other UNIX operating systems) are not 'binary file compatible' with Microsoft products (including Windows 98). You should always 'dump' your database contents (using mysqldump) before 'moving' the data to build another database (unless you're

SQL reference.

Hi, Is there a place where I can find a manual (not tutorial) of SQL Reference/Sintax, something like the PHP Manual... It could be about SQL in general, MySQL and/or Oracle. Thanks, Jorge Oliveira [EMAIL PROTECTED] © webfroggie.com -

Re: SQL reference.

At 01:08 AM 6/19/2001 +0100, © webfroggie.com wrote: Hi, Is there a place where I can find a manual (not tutorial) of SQL Reference/Sintax, something like the PHP Manual... It could be about SQL in general, MySQL and/or Oracle. Thanks, Jorge Oliveira [EMAIL PROTECTED] The MySQL manual is

Upgrade and start-up failures

I just upgraded from 3.23.27 to 3.23.32 (can't go higher than that - have to sync development with production systems). I copied the /data directory to the new home. When I try to start mySQL, it halts and the log file has the entry Can't find file: 'host.ISM' (errno: 2). I checked the old

Re: Upgrade and start-up failures

It's looking for the host table (physical files) within the 'mysql' data area (not your own data area). Did you run mysql_install_db after installing the new version ? (or copy the mysql subdirectory from the old version) Guy Smith wrote: I just upgraded from 3.23.27 to 3.23.32 (can't go

please help (dumb permissions thing?)

Access denied for user: '@localhost' to database 'netsloth'Could not drop database netsloth (i asume drop means to drop 'in' in this case?) is what i get back when i try to install the db 'netsloth.dump' from J Greenspan's book and CD. please tell this newcomer what he has to do to fix this

RE: .dump files

i guess that is confusing to me because it says query. i'm really stuck though -see my recent 'please help' post to the mysql list. thanks. At 2:48 AM -0600 6/18/01, Chris Bolt wrote: thank you. that's sort of what i thought. now for the silly question: i know how to do it with

RE: Upgrade and start-up failures

Tried both. 1st copied the data tree (wherein there is a host.frm, host.MYD, and host.MYI files). When that didn't work, I did the mysql_install_db, but that had no effect. I suspect that there is a ./configure option I missed that declares the default data file format to use, and that they

Failed when doing 'make test'

Description: Starting MySQL daemon Loading Standard Test Databases Starting Tests TEST USER SYSTEM ELAPSEDRESULT alias 0.12 0.06

  1   2   >