ISAMCHK utility - MySQL server - 3.21.33b

Hello: Can anybody help me out to repair my database tables using ISAMCHK utility. The MySQL server version is 3.21.33b installed on BSD server. Many thanks Sheni Details of the problem that we are facing now: We are facing a serious problem with the MySQL server installed on our web

Please , help !

Hi, I'm developing a web site with PHP and I want to show some information only if I'm able to connect to a mysql database . If I can´t connect , simply I don´t show some parts of the web page. Sounds easy and it works fine in local , but when I install it in the web server ,if it can´t

help me

hi Just to clarify my requirements again: i need to add 2 buttons like ADD COMMENT EDIT COMMENT at the bottom of every page of my site (which uses PN). So that users can enter and edit (their own) comments for each page on the site. for eg look here:

Is there a timeout or similar en MySql?

Hi, I'm developing a web site with PHP and I want to show some information only if I'm able to connect to a mysql database . If I can´t connect , simply I don´t show some parts of the web page. Sounds easy and it works fine in local , but when I install it in the web server , if it can´t

Re: How to change DATETIME format ??

mysql / query -- I have a DATETIME column type with format -MM-DD and I'd like to have format DD-MM- what do I have to do ? _ MSN Photos est le

FW: Simple SQL

-Original Message- From: Sampson, Peter Sent: 16 May 2002 09:35 To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: FW: Simple SQL Roger et al. Thanks for your response in reference to MySQL Query I'm interested to find out more on how to do the following. You say that an

Re: problem with libmysqlclient_r.so

Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: I am not agree. I take _another program_ which work fine during ~2 year with previouse mysql version (mysql-3.23.44 for example). And I send dump from this program. Why I interested libmysqlclient_r? I have a program, which try

Re: How to change DATETIME format ??

Hi, I think you can't. You can create char field type on table (i.e. char(10)) and when you wish to do some date comparison you can use the next mySQL functions:LEFT,MID,RIGHT,TRIM. I.E: mydate-field in a_table:char(10); date on this field: '10.01.2001','30.02.2000',...etc. select * from a_table

Re: problem with libmysqlclient_r.so

Hi! Under FreeBSD gethostbyname is not thread-safe And there is no thread-safe gethostbyname_r (function exist but not thread-safe) Are mysql know about this!!! Just a note about this problem: We will add a wrapper for gethostbyname() in 3.23.51 and the 4.0.2 that will fix things

Re: Bug in fulltext search in latest mysql-4.0.2 source

Hi! On May 15, Jocelyn Fournier wrote: A small question : I have : CANON BCI-11N Cartouche noir ( BJC-70 / BJC-80 / BN-700 ) in the field 'nom' . How could I match BCI-11N for exemple ? (BCI* return nothing :( ) Thanks, Jocelyn Actually, it's a question for [EMAIL PROTECTED],

How to Load a Database to other Server

Dear all I had a mysql Database in one of my Server, now i want to transfer this whole Database to another Server, what should i do? 1. How i can export this Database to a file 2. How i can Load this File into my another Server which create a database exactly same as the old Server? Thx a lot!

Re: How to change DATETIME format ??

mysql,select,query,sql mysql / query -- I have a DATETIME column type with format -MM-DD and I'd like to have format DD-MM- what do I have to do ? Does it matter in what format it is in the database? you can select

RE: How to Load a Database to other Server

not sure about the Linux guys, but if you're using Windows just copy the directory for your database (in the mysql\data directory) to the new server. Restart MySQL Server on new machine Cheers Dave -Original Message- From: Jack [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 10:05 To:

Systems of a high degree of availability

Hi, all Links to the information are necessary. Master/slave the architecture. Implementation of the system of a high degree of availability on a basis master/slave. Implementation of a control master/slave. Examples of the code of implementation of a monitoring system. Who realized

[BUG] CONCAT_WS + GROUP BY display problem

Greetings, While working on a routine to clean out some duplicate entries from our IP management table, I stumbled upon the following errant behavior... Logging to file 'concatbug.txt' mysql \s -- Connection id: 73465 Current database: OBFmtable Current user:

Re: How to Load a Database to other Server

On Thu, 16 May 2002 17:05:25 +0800 Jack [EMAIL PROTECTED] wrote: Dear all I had a mysql Database in one of my Server, now i want to transfer this whole Database to another Server, what should i do? 1. How i can export this Database to a file If your DB server (source) is not running ...

Upgrade

Hello I 've a question, how i can upgrade a MySQL Version 3.23.32-log to MySQL Version 3.23.49a ? I havn'tfound it in the documentation so i hope you could help me Greetings Ed - Before posting, please check:

Newbie JOIN question

Hi all. This may (or may not) be a newbie question. But I've called it a newbie question since I am a newbie to MySQL (and SQL for that matter). Here is what I want to do: I want to join three tables into one, where one specific colomn may have more than one entry for each row. The spesifics

Re: problem with libmysqlclient_r.so

Hi! Michael == Michael Chang [EMAIL PROTECTED] writes: For example, have you called mysql_thread_init() before calling mysql_real_connect() in all your threads ? Michael However, to my understanding, mysql_thread_init() is not needed if Michael only one database connection is used, and

Re: How to Load a Database to other Server

What platform (Win32, Linux, BSD, etc.) are you using? If you have Win32 machine in the mix (doesn't need to be a server), suggest you use the Export tool in MySQL-Front (http://www.anse.de/mysqlfront/). We've replicated databases from Win32 to Linux and Linux to Linux with it many times.

Re: gcc for newer mysql versions - what's needed exactly ?

On Tue, 14 May 2002, j.random.programmer wrote: Can someone (who knows this sort of thing) give a layman's introduction to the interplay between various gcc versions and various mysql versions (3.49, 3.50, 4.01 etc) ? I have some linux boxes and don't really want to have to install/use

Re: problem with libmysqlclient_r.so

Hi! Andrey == Andrey Kotrekhov [EMAIL PROTECTED] writes: Andrey -L .-A Andrey Are mysql know about this!!! Sorry but if your OS doesn't support gethostbyname_r(), then mysql_real_connect() is not thread safe (I have just updated our documentation about this) Andrey Thank you. I have

Can't connect to ....

Hi everybody. Just installed Red Hat Linux on a machine. I included the MySQL packages but cant get it up working. When starting from shell it looks like this: $ mysql ERROR 2002: Can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (2) What have I done wrong? best

RE: Fw: Simple SQL

Gabriel. This works fine and the two tables talk to each other. BUT, My website can have 5 - 10 news stories per month. So in the tblNews I could have nMonth t1 t2 2 I am a line This is one, too. 2

problem inst ...bench... rpm

Hi, I have installed MySQL from rpm's downloaded from mysql.com. All seems ok except when I try to do rpm -i MySQL-bench-3.23.49a-1.i386.rpm I get an error message from rpm saying the I need MySQL-DBI-perl-bin. Where can I find this MySQL-DBI-perl-bin? Thanks in advance! /Curt

Speeding up a huge sql query

Hi there, I have a huge querry which takes for ever on a table containing only 2000 records. Maybe there is a way to reorganize this querry since it contains a join and lots of other stuff I am not really familar with. Let me first show you the sql query: SELECT DISTINCT u.user_id,

automatic server start paramaters

On a mandrake 8.2 machine running the mysql rpm for that linux distro (mysql 3.23.??, I think) I have a testing and programming box, only one user is connecting to the database at a time. Now, the mysqld startup sequence automatically starts 5 occurances of the mysqld server. Id like to

Fwd: NDN: automatic server start paramaters

Dear MySQL list monitors... Please do something about the following address that has apparently joined the list. every time I send a message to the list, I get a bouned message saying that the message is undeliverable. Thanks From: Mailer-Daemon [EMAIL PROTECTED] To: [EMAIL PROTECTED]

mysql index question

Regarding mysql... 1) Are primary keys and foreign keys by default indexes for a table? 2) Do I have to use a special data other than float to allow for negative numbers, i.e. I want to be able to enter -1.76 and be able to later do math against that number... Thanks, Taylor Taylor Lewick

RE: Speeding up a huge sql query

[snip] SELECT DISTINCT u.user_id, u.user_name, max( if(u.sex=2,25,0) + if(u.age=4,25,0) + if(u.country='gm',25,0)+ if(l.language_id='de',25,0) ) AS ranking, c.country_code, c.country, ct.city,

Are this the right column type choices?

Hi there, I have a user table with lots of different column types. Now I do experiance problems filtering out special date. The performance is really bad. So maybe I did just pick the wrong column types?! This is what I picked so far: | Type | Null | Key | Default | Extra |

Re: Newbie asks error 1036 table read only?

Make sure mysql owns the tables and their directorys, and has write privileges to them. I talking about UNIX permissions here, not mysql permissions. Bill Flanagan wrote: Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM tables on which I am unable to do updates or

Re: mysql index question

From my understanding primary keys and foreign keys are indexed. Someone correct me if I'mwrong here. And you shouldn't have to do anything else to field besides make it a float to usenegative numbers. -Nick Regarding mysql... 1) Are primary keys and foreign keys by default indexes for a

Re: INSERT INTO not working

Check your indexes. Daniel Lim wrote: Hi there, I have MySql version: 3.23.36 running on RedHat 7.1, it has been working fine for sometimes until a day ago when the INSERT into for new record appeared to return OK status but upon verifying the record isn't there? This is an example; To

Re: Speeding up a huge sql query

This is the explain select sql query on this table containing 500 records now: | table | type | possible_keys| key | key_len | ref | rows | Extra | +---++--+--+-+--

Re: Solved (Re: 4.0.2 Replication still buggy...)

Hi! Sasha == Sasha Pachev [EMAIL PROTECTED] writes: Sasha On Wednesday 01 May 2002 11:34 pm, Jeremy Zawodny wrote: After even more tracking stuff down, I managed to isolate it to a change made in MySQL 4.0.1. ?The query in question was doing: ? INSERT INTO ... SELECT ... rather than

Re: automatic server start paramaters

Rance, Thursday, May 16, 2002, 4:13:04 PM, you wrote: RH On a mandrake 8.2 machine running the mysql rpm for that linux distro (mysql RH 3.23.??, I think) I have a testing and programming box, only one user is RH connecting to the database at a time. RH Now, the mysqld startup sequence

Re: Can't connect to ....

Jaan, Thursday, May 16, 2002, 5:19:20 PM, you wrote: JJ Just installed Red Hat Linux on a machine. I included the MySQL packages JJ but cant get it up working. JJ When starting from shell it looks like this: JJ $ mysql JJ ERROR 2002: Can't connect to local MySQL server through socket JJ

Re: how to turn off query logging for mysql on redhat linux

Tom, Thursday, May 16, 2002, 4:30:50 AM, you wrote: TB I am trying to turn off the query log in mysql on redhat linux. It generates TB huge log files TB (in /var/lib/mysql/hostname.log) that I dont need, and impacts performance. TB safe_mysqld was run with --log, and it seems like I want to

Re: Very new to windows version - question about host and server

Norris, Wednesday, May 15, 2002, 6:54:46 PM, you wrote: Neoen I have been using (very happily) mysql on unix boxes. I am in a new job and Neoen there is not a unix box in sight!!! ouch! Neoen This is a windows 2000 shop. Here is the situation and I am looking for any Neoen and all

Re: Upgrade

Eigner, Thursday, May 16, 2002, 2:05:01 PM, you wrote: EE I 've a question, how i can upgrade a MySQL Version 3.23.32-log to MySQL EE Version 3.23.49a ? EE I havn'tfound it in the documentation so i hope you could help me What OS do you use? Linux? If you use MySQL from RPM just rpm -Uvh

Re: Newbie asks error 1036 table read only?

Bill, Wednesday, May 15, 2002, 11:42:00 PM, you wrote: BF Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM BF tables on which I am unable to do updates or inserts. I get error BF message #1036 'Table is read only.' I am able to sign on to the database BF through the root,

ERROR 1030: Got error 127 from table handler / Optimize Table

Hello, I am using mysql 3.23.38 on winnt. I have a table already filled with default value, that way we do only updates during our processing. One column is specified as not null in the table definition and it's also an index. everything was working fine, Until we decided to use Optimize

Re: problem inst ...bench... rpm

I have now installed mysql-DBI-perl-bin. But I still get a message about failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.49a-1. Is this because of the spelling of mysql / MySQL? Or is it something else? /Curt torsdagen den 16 maj 2002 14.23 skrev Curt Söderberg: Hi, I

Message

I made a program with delphi and I would like to get the message when is execute any query. eg: select ... 10 rows in set (0.04 sec) . This message is important for me. How can I get it. Alexander A busca mais veloz e precisa da internet. Acesse

Message

I made a program with delphi and I would like to get the message when is execute any query. eg: select ... 10 rows in set (0.04 sec) . This message is important for me. How can I get it. Alexander A busca mais veloz e precisa da internet.

question about perl connection to mysql on another machine

group, Here is the situation. I have to connect to Mysql running on another windows 2000 box. I have never done this before. Do I set this up in the tables as another host and use the -h parm in command shell and the host parm in my perl scripts? or is there another way to do it? Any help

MySQL/InnoDB questions from a MyISAM background

We have just migrated a huge installation to InnoDB from MyISAM. While I can feel the power and potential and appreciate this sophistication of what I have at my disposal, I am having some performance issues that are most likely due to my ignorance. Answers to the following questions should help

Replication creating large number of files

Hi, I don't know what caused it, nor whether it's reproducable, but on an AIX system, I just found out that both of the 4.0.1 masters (typical master=slave_of_master loop using same source tree configuration) have created 100.000+ files of the replication log. I can only think they are

Re: Slave crashes with SEGV on master shutdown

Hi! Going through my email backlog... Just a short update on this. Sasha == Sasha Pachev [EMAIL PROTECTED] writes: Sasha On Monday 29 April 2002 04:39 am, David Harper wrote: Description: I'm running the pre-compiled Compaq Alpha (OSF1) version of MySQL 3.23.49 with master/slave

replication

Hi all, I would like to know how often (delay in sec.) the slave checks the master for new records in the log, and if one can control that . Thanks in advance Vlady (mysql) - Before posting, please check:

Re: problem inst ...bench... rpm

http://rpmfind.net Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com |+ || Curt Söderberg| || curt.soderber| || [EMAIL

Re: [BUG] CONCAT_WS + GROUP BY display problem

Terra wrote: Greetings, cut mysql select *,concat_ws('.',oct1,oct2,oct3,oct4) ip,concat(oct1,'.',oct2,'.',oct3,'.',oct4) test,count(*) c from ips group by oct1,oct2,oct3,oct4 having c1; +--+--+--+--+--+-+---+--++---+ | ID | OCT1

Synchronize only database structures

I have partitioned my data such that each client has its own database (clientdb1, clientdb2, ... clientdbN). All the databases have the same structure (same tables, columns, etc.). This design works great except for one caveat - when I make a change to the database structure I have to make the

MyISAM and innodb

I'm finally getting around to working with InnoDB for real :-) Anyway, is there any reason to still use MyISAM on any tables. Concurrency is my biggest problem (Locked tables, etc.). My theory is that the tables that wouldn't benefit from converting to InnoDB are so small (5-50 rows?) that I

backquotes(`) and mysqldump

I am working with a mySQL database in which some column names contain hyphens. These have to be enclosed in backquotes (`table-name1) within SQL statements. Problem: when generating its own SQL statements, mysqldump does not enclose these names in backquotes -- so when I try to restore a

Re: Message

Alexander, Thursday, May 16, 2002, 5:40:41 PM, you wrote: AB I made a program with delphi and I would like to get the message when is AB execute any query. AB eg: select ... AB 10 rows in set (0.04 sec) . AB This message is important for me. How can I get it. In general you can't get

Disable replication from command line

I want to ignore a database from bin-logging. I know that in my.cnf, I can set binlog-ignore-db=database_name but for various reasons, that's not available to me. How would I pass that option in on the command line via safe_mysqld? Passing it in as an option or a set-variable option causes

Re: question about perl connection to mysql on another machine

Norris, Thursday, May 16, 2002, 5:57:51 PM, you wrote: Neoen Here is the situation. I have to connect to Mysql running on another Neoen windows 2000 box. I have never done this before. Do I set this up in the Neoen tables as another Neoen host and use the -h parm in command shell and the host

Re: Reset Master command ignores max_binlog_size variable

Andre, Wednesday, May 15, 2002, 6:05:16 PM, you wrote: AS Were running replication on our Prod. DB (3.23.42 on SuSE 7.0) since a AS half year. Our way to rotate the binlog files was to stop all software AS inserting data into the Prod. DB and then reset the master and the AS replication server.

Re: mysql index question

Taylor, Thursday, May 16, 2002, 4:22:37 PM, you wrote: TL Regarding mysql... TL 1) Are primary keys and foreign keys by default indexes for a table? Yeah. Primary key is index by default. Foreign key constraints you can create only on indexed column. TL 2) Do I have to use a special data other

Re: [BUG] CONCAT_WS + GROUP BY display problem

Hello Alexander, At 11:25 AM 5/16/2002, Alexander Keremidarski wrote: Terra wrote: Greetings, cut mysql select *,concat_ws('.',oct1,oct2,oct3,oct4) ip,concat(oct1,'.',oct2,'.',oct3,'.',oct4) test,count(*) c from ips group by oct1,oct2,oct3,oct4 having c1;

repication

Hi all, I would like to know how often (delay in sec.) the slave checks the master for new records in the log, and if one can control that . Thanks in advance Vlady (mysql) - Before posting, please check:

Re: Fw: Simple SQL

Sampson, Peter wrote: Gabriel. This works fine and the two tables talk to each other. BUT, My website can have 5 - 10 news stories per month. So in the tblNews I could have [Snip multiple rows] I need to use DISTINCT in the SQL lingo as I bind the recordset's nMonth to a

Re: Alter table

Hello. On Thu, May 16, 2002 at 01:39:59AM +0200, [EMAIL PROTECTED] wrote: [...] It sounds as if you want ALTER TABLE your_table ADD INDEX( message_id ) [...] Well, the FAQ is where I went first, of course. And then I came up with this, ALTER ignore table $table MODIFY message_id

Re: ISAMCHK utility - MySQL server - 3.21.33b

Hi. Well, what's the problem with using isamchk in detail? Shut down the mysql daemon, run isamchk on all tables to find out which are corrupted and run isamchk -r on those. Then restart mysqld. Do not forget to make backup copies of the tables in question beforehand, in case anything

Re: Systems of a high degree of availability

Hi. IMHO you need to do some more digging yourself and present more precise question. At least, if you get no other answers, which I rather doubt. The problem is that the answers depend heavily on information you did not provide (e.g. what are the requirements for the system? high availibility

Re: MySQL/InnoDB questions from a MyISAM background

Hi! Good questions! - Original Message - From: Michael Bacarella [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, May 16, 2002 6:41 PM Subject: MySQL/InnoDB questions from a MyISAM background We have just migrated a huge installation to InnoDB from MyISAM. While

Re: backquotes(`) and mysqldump

T.D., Thursday, May 16, 2002, 6:54:45 PM, you wrote: TDH I am working with a mySQL database in which some column names contain TDH hyphens. These have to be enclosed in backquotes (`table-name1) within TDH SQL statements. TDH Problem: when generating its own SQL statements, mysqldump does not

Re: Message

Unsure exactly what you want but I use message box's in my apps to say if there is an error or whatever. This, as far as I know, has to be done in the program not in the SQL. Alexander, Thursday, May 16, 2002, 5:40:41 PM, you wrote: AB I made a program with delphi and I would like to get

Re: Message

Please stop reposting your question. You should be able to get this information from Delphi. Set up a time object before you execute the query. On Thursday 16 May 2002 10:19 am, Alexander Burbello wrote: I made a program with delphi and I would like to get the message when is execute any

Re: [BUG] CONCAT_WS + GROUP BY display problem

Hello. On Thu, May 16, 2002 at 06:25:42PM +0300, [EMAIL PROTECTED] wrote: [...] mysql select *,concat_ws('.',oct1,oct2,oct3,oct4) ip,concat(oct1,'.',oct2,'.',oct3,'.',oct4) test,count(*) c from ips group by oct1,oct2,oct3,oct4 having c1;

Re: backquotes(`) and mysqldump

Hi. shell mysqldump --help | grep 'quote\|Ver' mysqldump Ver 8.14 Distrib 3.23.38, for pc-linux-gnu (i686) -Q, --quote-names Quote table and column names with ` don't know why it isn't the default, but it seems you can force them this way. Regards, Benjamin. On Thu, May 16,

Re: mysql login question

Can you login to mysql from a perl script by passing it an encrypted password..? Taylor... Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 Help Wanted. Seeking Telepath... You Know where to apply.

Comparing UNSIGNED and INDEXED columns with negative numbers

Hi All, Using MySQL server version 3.23.49-nt I get strange results when running the following very simple test. I am wondering if this is a bug, feature or perhaps a standart SQL behaviour?? CREATE TABLE test(id BIGINT UNSIGNED); CREATE INDEX test_idx on test(id); INSERT INTO test VALUES

Re: [BUG] CONCAT_WS + GROUP BY display problem

Hello. On Thu, May 16, 2002 at 12:10:10PM -0400, [EMAIL PROTECTED] wrote: At 11:25 AM 5/16/2002, Alexander Keremidarski wrote: [...] It is normal to have a difference there. It is not beacuse of how concat() and() concat_ws() work, but how GROUP BY works. Is this 'unpredictable behavior'

Re: [BUG] CONCAT_WS + GROUP BY display problem

Hi, Same bug with MySQL-4.0.2 latest source. Regards, Jocelyn Fournier - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Alexander Keremidarski [EMAIL PROTECTED] Cc: Terra [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 7:49 PM

STRING TO NUMBER

Hi, In Oracle i use TO_NUMBER to convert a String to a Number what Function Do i have to use in Mysql ?? thank´s Marcel. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Message

Peace to All, In Bible said: If a man doing something wrong for the first time or he don't know , give the second chance and show him the right way...and if don't want to follow it , let him ...or something like that. If you use ODBC you have many ways but the short one is to have a

isn't this join equivalent to this LEFT JOIN?

Isn't the following: SELECT * FROM t1, t2 where tl.ID=t2.foreignKey; logically equivalent to: SELECT * FROM t1 LEFT JOIN t2 ON t1.ID=t2.foreignKey WHERE t2.ID IS NOT NULL; Because I had a query in the first format that took about two minutes to run on MySQL, and then I changed it into the

RE: ERROR 1030: Got error 127 from table handler / Optimize Table

restart the MySQL server happened to me this week when I was copying files (and changing the schema) while the server was running HTH Dave -Original Message- From: Frederic Dhorne [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 15:32 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject:

Re: Comparing UNSIGNED and INDEXED columns with negative numbers

Hi. What you observe is the fact that -1 will be converted to the format of the index, else the index could not be used. Converting -1 to an unsigned number give the biggest possible number for the type in question (here BIGINT UNSIGNED). None of your numbers is bigger than this, so you get an

Re: STRING TO NUMBER

i think u dont need to it will automatically deal with it. - Original Message - From: Marcel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 3:26 PM Subject: STRING TO NUMBER Hi, In Oracle i use TO_NUMBER to convert a String to a Number what Function Do i have

Re: Bug in fulltext search in latest mysql-4.0.2 source

Sergei Golubchik wrote: rebuild your indexes (the proper way to do it is to issue REPAIR table_name USE_FRM Sergei, would ALTER TABLE.. DROP INDEX.. ADD FULLTEXT... do the same trick? TIA, Vadim. /* sql, mysql to satisfy the spam police */

table type airline?

From my sql How can I see what the types of tables I have are.. i.e. how do I verify if a table is an ISAM, HEAP, InnoDB... Thanks, Taylor Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 Help Wanted. Seeking Telepath... You Know where to apply.

Mysql Load Data question

I read in the Mysql manual where you can change the default column seperator, but it didnt specify how to do this. So, how can I tell the LOAD DATA command to use commas, or better yet, where can I go to find out about mysql command syntax...? Thanks,. Taylor Lewick Unix System

RE: STRING TO NUMBER

MySQL do it for you:) Quoted from the online documentation is: MySQL automatically converts numbers to strings as necessary, and vice-versa: mysql SELECT 1+1; - 2 mysql SELECT CONCAT(2,' test'); - '2 test' If you want to convert a number to a string explicitly, pass it as the

RE: table type airline?

SHOW CREATE TABLE tablename; or SHOW TABLE STATUS LIKE 'tablename'; gives you what you want... See: http://www.mysql.com/doc/S/H/SHOW_TABLE_STATUS.html http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html Gurhan -Original Message- From: Taylor Lewick [mailto:[EMAIL PROTECTED]] Sent:

RE: Mysql Load Data question

Everytime you have something to ask, first point your browser to : http://www.mysql.com/doc/ Type in the keywords (in this case LOAD DATA) The first url in the resultset will be : http://www.mysql.com/doc/L/O/LOAD_DATA.html which is what you are looking for. Gurhan -Original Message-

Re: Mysql Load Data question

Hi, Look at http://www.mysql.com/doc/L/O/LOAD_DATA.html and you can try this... load data infile 'yourfile' into table your_table fields terminated by '\your_separator_char_for_fields' lines terminated by '\your_separator_char_for_row'; Regards, Gelu

Re: table type airline?

Hi, try : show tables status; _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Taylor Lewick [EMAIL PROTECTED] To: [EMAIL

How to limit database size?

Hello, I like to limit the size of a database (or if possible all databases of a mysql user) to some value. It should work like the disk quota for disk space. Thanks for any hints, Alexander Newald - Before posting, please

What is going on? Performance question

I am running mysql and apache on windows 2000. Everything is running smoothly and then all of the sudden my perl scripts that have been running just find are loading very very slowly. I am not sure if it is mysql, perl, apache or what. These are the same scripts that have been running just fine

Re: What is going on? Performance question

Perhaps memory utilization issues? Does the box start thrashing? Norris, Joseph wrote: I am running mysql and apache on windows 2000. Everything is running smoothly and then all of the sudden my perl scripts that have been running just find are loading very very slowly. I am not sure if

MySQL/InnoDB question

I'm not new to MySQL but have only recently familiarized myself with InnoDB. One question I have so far been able to find an answer on is the datafiles. Let's assume I have 5 GB worth of information, this information changes regularly. Performance wisewould I be better off using a single 5GB

Index X No Index

Hi, Let´s supose that we have a table with this features : - about 7 records; - only a primary index; - about 30 fields; - 50% of SELECTS and 50% of INSERTS/UPDATES. The SELECTS typically uses about 3 or 4 fields in the WHERE clause. Creating indexes, one for each field used on SELECTS,

RE: Index X No Index

* Joao A. Marques Let´s supose that we have a table with this features : - about 7 records; - only a primary index; - about 30 fields; - 50% of SELECTS and 50% of INSERTS/UPDATES. The SELECTS typically uses about 3 or 4 fields in the WHERE clause. None of them beeing the primary key,

Re: What is going on? Performance question

You might try running queries seperately and check performance to see if it Perl or mySQL mike Norris, Joseph wrote: I am running mysql and apache on windows 2000. Everything is running smoothly and then all of the sudden my perl scripts that have been running just find are

Script fails during MySQL access attempt.

Dear MySQL wizards, Perhaps this is more of a Perl question than a mySQL question but I am trying to access a mySQL database. Here is the line of code. if ($q-param('field') eq ) {printform()} else {results()} This gives the reply: Use of unitialized value in string eq at select.cgi

Parsing strings

Hi, What characters should i parse when using an INSERT statement that has string values? So far, i had troubles with single quotes and minus signs. What should i do with them? Is there any others? Thank u very much, Edilson. Edilson Vasconcelos de Melo Junior [EMAIL

  1   2   >