Thank you!I need your help!

I'm sorry that my English is very week!I come from Chinese ! My computer OS is RedHat Linux 7.2 and the machine is intel celeron 300A 64M memory! the bad command message is : [root@guanqun zsj]# cd /usr/local/src/zsj [root@guanqun zsj]# cd mysql-4.0.1-alpha-pc-linux-gnu-i686 [root@guanqun

Re: Thank you!I need your help!

ÕÅÉƽð wrote: I'm sorry that my English is very week!I come from Chinese ! My computer OS is RedHat Linux 7.2 and the machine is intel celeron 300A 64M memory! the bad command message is : snipped NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it!

cant create tables .....

hi guyz im stuck bad i cant create tables, the tables which had NO foreign keys or they didmt refer to another table were created fine but the ones WITH foreign key ... refferring to fieldz in other table(s) cant be created mysqlcreate table lang ( lang_id int auto_increment primary

installing 2 servers on the same Win 2K machine

Hello, I am planning to install 2 mysql servers on the same box whish runs Win2K. Has anyone experianced this before? Regards Okan - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: get months between two dates

Hi Van, I read that before sending u the query. In that no where is mention to subtract the dates and finding the no months between dates. D K Dubey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Van Sent: Monday, June 24, 2002 11:43 AM To: D.K.Dubey

Re: get months between two dates

select month(current_date)-month(fild_name) from database where your_critteria This should show you the months between the current date and the date contained in the fild_name - Original Message - From: D.K.Dubey [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL

bizzar display .....

guyz all is down now i cant even get my explorer to display the unicode it was displaying till yesterday now its giving me ALL BOXES for the unicode im trying to store till yesterday it gave me boxes only for a few characters but the rest were FINE ! ! ! ! has this somethin to do with

RE: installing 2 servers on the same Win 2K machine

Hi, I have 2 version installed on my win2k machinge (.49 , .50 and .51) As long as you install in different directories , take care of config files and don't try to start 2 server simultaniously, I don't see why this should give problems. (At least, I haven't got any problems ;) ) CB.

Re: get months between two dates

Really? MONTH(date) Returns the month for date, in the range 1 to 12: mysql SELECT MONTH('1998-02-03'); - 2 There're other functions that will also be useful tools for you to achieve what I can only guess is your goal. I can think of 10 ways off-hand to solve your

RE: get months between two dates

That'll only work if the months are in the same year. Here's a more general one: SELECT PERIOD_DIFF( EXTRACT( YEAR_MONTH FROM date1 ), EXTRACT( YEAR_MONTH FROM date2 ) ); Dean Harding. -Original Message- From: Dogaru Dragos [mailto:[EMAIL PROTECTED]] Sent: Monday,

Chinese character error

Dear professional people, When I write a program to store the (Big5) Chinese characters ¯S³\¸gÀç into mysql database through the mysql ODBC driver, the original chinese characters change into another characters ¯S³¸gÀç in mysql database. On the other hand, I have tried the program to

RE: Re-do logging feature with InnoDB: is it possible ?

Hello everybody, I have a small question regarding to the Mysql-InnoDB-tables : Is it possible to use an Oracle-like 're-do logging' feature with InnoDB ? This means more or less taking regular consistent backups of your database, and then in case of corruption, you restore the latest

Re: bizzar display .....

Toby: Beyond off-topic, but try Netscape... If that isn't the cause; check that the web server has been patched for the chunk-encoding vulnerability that existed on Apache before 1.3.26, which was released last week. Otherwise: try and give some more useful details. Van --

ANNOUNCE: moodss-16.3

### CHANGES ### --- version 16.3 --- - thresholds messages are now displayed in the trace module window and tables by default - in preferences, added thresholds trace page so that the user can choose whether thresholds messages are displayed in the trace module window and tables - in

MySQL (InnoDB tables) and HP-UX or Solaris

Hi, Which is the best solution ? I use MySQL (exclusively with large InnoDB tables - 150 to 200 tables, 3 or 4 of them with 200 000 lines per day, approx. 40 to 80 Go of datas). I must switch my system to UNIX. So, what is the best solution, HP-UX or Solaris ? Thank's

I know

I try it over !the question is that i couldn't configure and make the mysql,so i can't install and run it .i don't know why .i try it as book!please give me the oringal software! __ ===

Binary data mysqldump and restore.

Hi all... !! First, can you CC to [EMAIL PROTECTED], as im not on the mailing list. I have a few tables which are storing a few MB of binary data (like jpegs). I can dump the db fine using mysqldump, but on doing a mysql ... dumpfile i get many errors, as it seems mysql isnt accepting the

Re: Load problems with 3.23.51

What about using the skip-name-resolve option rather than skip-grant-tables? I'm using the 3.23.51 binaries, also, and would appreciate knowing if this makes a difference. Debian potato 2.95.2 is a known good compiler, too, isn't it Jeremy? I may have to recompile my own anyway to change

Out of memory on simple question.

Hi After running this simple question I get this error. I have looked at the my.cnf file and all looks fine and the system has 1.256 G of memory. Can some one please tell me where I have gone wrong. select in_names.Username from in_names, in_names2 where in_names.Username !=

Re: MySQL dump/recovery probable bug

On Friday, 21. June 2002 15:43, Stefano Incontri wrote: Hi, I found the following problem, which I consider a bug, but maybe I'm missing something to make it work correctly. This is not a bug. Why do you use a reserved word (LOAD) for an index name?! Rename it and everything should be ok.

file size limit hitting when LOAD DATA INFILE

Hi, all: I use MySQL 3.23.47, RH linux 7.2, file size limit is 4G. When LOAD DATA INFILE to a table whose file size is 4G, it fails and mysql_error(...) reports Lost connection to MySQL server during query. How can I clearly know the failed reason is just hit the 4G file size limit? If

Re: bizzar display .....

thnx van ... its workin now it was no bug ... no mysql problem no explorer problem my mistake i changed the fontdisplay in my t.htm file from unicode to user defined n its workin fine now thnx n im terrabbly sorry all of u a bit better now ... toby ...

RE: Your Mail is being returned

plz give me the oringal software about mysql.when i make it will not successful.i have sent the wrong message twice to u. __ === ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn)

Re: Fw: insert BLOB values

Hytham, Saturday, June 22, 2002, 12:37:21 AM, you wrote: i have a column of type blob, that i wish to store images in it, but how can i right the sql statement to insert the image? i mean : insert into tblImages set imageField = ??? where id=999 It's not a correct statement, use

Re: cant create tables .....

toby, Monday, June 24, 2002, 10:06:57 AM, you wrote: t i cant create tables, the tables which had NO foreign keys or they didmt t refer to another table were created fine t but the ones WITH foreign key ... refferring to fieldz in other table(s) t cant be created t mysqlcreate table lang (

Re: bug in 3.23.51 for windows ?

Brandon, Saturday, June 22, 2002, 9:00:49 PM, you wrote: BM Is there any particular reason that anyone knows of that would prevent BM mysql 3.23.51 for windows from working upon the execution of the SHOW BM STATUS FROM tablename query? BM In Linux it works fine, in windows it crashes mysqld

Re: Re: Permissions are now denied from the mysql client

Ruben, Sunday, June 23, 2002, 10:51:59 AM, you wrote: RIS Of course it's running. I can only get in as the root user RIS of the system Check where your mysql.sock is located and check permissions on the socket file. RIS On 2002.06.23 03:51 Brandon McCombs wrote: Ruben I Safir wrote:

Re: help starting up mysql

tlr7425, Monday, June 24, 2002, 4:01:16 AM, you wrote: t I'm trying to start mysql -I have installed the db. t Now I'm getting the following: t [localhost:~] lloyd% sudo safe_mysqld --user=root t [1] 630 t [localhost:~] lloyd% Starting mysqld daemon with databases from t /usr/local/mysql/data

Re: I know

you can download your binary for installation if there is supported hardware and OS made binary for you http://www.mysql.com/downloads/mysql-3.23.html - Original Message - ±H¥óªÌ: ÕÅÉƽð [EMAIL PROTECTED] ¦¬¥óªÌ: [EMAIL PROTECTED] ¶Ç°e¤é´Á: 2002¦~6¤ë24¤é PM 04:06 ¥D¦®: I know I try

Thank you!I need your help!

please tell what mean the follow: [root@guanqun zsj]# cd /usr/local/src [root@guanqun src]# cd mysql-3.23.44.tar/ [root@guanqun mysql-3.23.44.tar]# ./configure --prefix=/usr/local/mysql bash: ./configure: No such file or directory [root@guanqun mysql-3.23.44.tar]# ls mysql-3.23.44

FW: Binary data mysqldump and restore.

Just for those people who have the same problem: -Original Message- From: Mark Williams (MWP) [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 11:13 To: Bert VdB Subject: Re: Binary data mysqldump and restore. That did it thanks! MWP Hi, Have you tried making a dump with

Re: Thank you!I need your help!

Hi, checking for working aclocal... missing checking for working autoconf... missing checking for working automake... missing checking for working autoheader... missing checking for working makeinfo... missing You need to install automake and autoconf before trying to compile MySQL. (texinfo is

Re: MySQL dump/recovery probable bug

Hi! Georg == Georg Richter [EMAIL PROTECTED] writes: Georg On Friday, 21. June 2002 15:43, Stefano Incontri wrote: Georg Hi, I found the following problem, which I consider a bug, but maybe I'm missing something to make it work correctly. Georg This is not a bug. Why do you use a

Re: get months between two dates

Use the month(date) function. select month(firstDate) - month(secondDate) from someTable where ...; Hope this helps. Frank D.K.Dubey wrote: Hi, Can anybody tell me how i can calculate the months between two dates in mysql. thanks in advance Regards D K Dubey

RE: Out of memory on simple question.

Thanks for this... So I think I need some joins! Simon -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED]] Sent: 24 June 2002 12:19 To: Mysql (E-mail) Cc: Simon Green Subject: Re: Out of memory on simple question. * Simon Green After running this simple question I

Re: Out of memory on simple question.

* Simon Green After running this simple question I get this error. I have looked at the my.cnf file and all looks fine and the system has 1.256 G of memory. Can some one please tell me where I have gone wrong. select in_names.Username from in_names, in_names2 where in_names.Username !=

RE: get months between two dates

Hi Frank, Thanks, but it is fine if the year is same. If years are different then result may comes in -ve value. D K Dubey -Original Message- From: Frank Gates [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 5:09 PM To: D.K.Dubey Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject:

Re: please modify init.d script

Florin, You may put something like # wait until mysql is ready counter=0 while ! mysqladmin \ -h localhost -u user -pPassword ping /dev/null 21 do counter=$((counter+1)) if [ $(($counter)) -gt $((200)) ] then echo mysqld startup

Re: Thank you!I need your help!

I think the problem is that the mysql package is still tarred. You need to tar -xvf mysqlx.tar This will extract the archive into a new folder, and from within that folder you should run the commands as listed in your original mail (./configure .) So in short, the commands you are

RE: Thank you!I need your help!

You need libtermcap. (libtermcap-2.0.8-28.i386.rpm) You are running a Redhat 7.2 box, use binary distribution instead of source package if you're not familiar with building programs. Regards, Sébastien please tell what mean the follow: [root@guanqun zsj]# cd /usr/local/src [root@guanqun

Re: Load problems with 3.23.51

Hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote: Hi all, I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and tried 51. No dice. It does not handle load, CPU and the load average go through

string compare problem with single quote in string

I am comparing songnames from two tables to find a match. My query looks like this: $querymvideo = select movietable.id, movietable.songname from movietable where TRIM(movietable.songname) LIKE '__$foo' ; The above query works fine except when a songname has the single quote symbol: ' or maybe

RE: UDF on win2k??

I know version 4.0.1 does. I use Delphi 6 to write my UDF's for it. mike -Original Message- From: Inandjo Taurel [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 23, 2002 9:20 PM To: [EMAIL PROTECTED] Subject: UDF on win2k?? hi, i checked the manual, but i want a confirmation here:

Re: Load problems with 3.23.51

Jeremy Zawodny writes: On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote: As another data point for you, I've got 3.23.51 running on our master quite well. The difference is that I built it from source (to get a critical InnoDB patch). I don't recall which compiler the MySQL

Problem importing data from SQL server 2000 to mysql

Hi guys, I want to migrate data from SQL Server 2000 to Mysql.I have two problems. First is easy one, First problem is to migrate big fields which had type varchar(7900) or so I tried using Text datatype of mysql, is that the right one or I should have used BLOB. That field doesnt contain any

Re: Chinese character error

Your string contains special characters, and must be properly escaped before storing. Use the appropriate string escaping function in your language ( if it exists ) or write a routine to escape them for you before storing them. The manual lists the special characters. henry lee wrote: Dear

New Manager

Hi, There are a new MySQL Database Manager. Try this site: http://geocities.yahoo.com.br/burbello/ doesn't need to install, just download and execute. Regards Alexander ___ Copa 2002 Yahoo! - Patrocinador oficial da

Netsde Query

Hello everybody! I am using mysql-4.0.1-alpha on windows 2000 professional How to exceute nested query in MySql select aeVcharEventId from alarmescalation where aeDtimeTimeStamp = (select max(aeDtimeTimeStamp) from alarmescalation) This query gives an error you have an in your Sql syntax near

RecordCount

Hi there! I'm using MySQL with Delphi 5. After running a query i get a recordcount of -1. But when I check the result there are records. Can anybody help me? Thanks, peter __ FreeMail in der Premiumversion! Mit mehr

RE: Netsde Query

you don't. Check the manual. Nested queries are not yet supported. (4.1?) =C= -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 1:53 AM To: [EMAIL PROTECTED] Subject: Netsde Query Hello everybody! I am using mysql-4.0.1-alpha on

Thanks for the solution of Chinese character problem

Dear Monty, At the beginning, I missed doing the step of setting default character-set. After I have done what you said about setting default character set, the correct chinese characters are stored in mysql database. Thank you very much! Best regards, Henry. From: Michael

Re: Load problems with 3.23.51

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and tried 51. No dice. It does not handle load, CPU and the load average go through the roof. I'm using Red Hat Linux 7.2 and the official mysql binaries. It appears to be slow

Manual: mis-spelled variable

Hi, I came across this problem: where the manual describes Fulltext Fine-tuning it says: * Minimal length of word to be indexed is defined by MySQL variable `ft_min_word_length'. *Note SHOW VARIABLES::. Change it to the value you prefer, and rebuild your `FULLTEXT' indexes. This

mySQL query help please

Greetings: RE: mySQL query help please INSERT INTO Customer_Equipment SELECT Customer.ID, Server_ID, Configuration, Equipment_Type, Group_ID, Location, Rack_Location, Network_Status_Name, Creator_ID, Primary_IP_Address FROM Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4) =

RE: mySQL query help please

[snip] INSERT INTO Customer_Equipment SELECT Customer.ID, Server_ID, Configuration, Equipment_Type, Group_ID, Location, Rack_Location, Network_Status_Name, Creator_ID, Primary_IP_Address FROM Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4) = Customer.User_ID; The select statement

Can't create FOREIGN KEY restraints on InnoDb tables

Description: In CREATE TABLE, column-spec REFERENCES does nothing, as described in the documentation. If FOREIGN KEY (x) REFERENCES othertable(y) is added to the table, as described in the documentation: http://www.mysql.com/doc/S/E/SEC446.html I always get an error like this: ERROR 1005 at

RE: mySQL query help please

Greetings Jay: RE: mySQL query help please I love rules that don't make sense ;-) So if the end result is to have the records selected appended to the Customer_Equipment table, I have to make a temporary table based on the characteristics of the Customer_Equipment table... then insert from

RE: mySQL query help please

[snip] So if the end result is to have the records selected appended to the Customer_Equipment table, I have to make a temporary table based on the characteristics of the Customer_Equipment table... then insert from that temporary table. Correct? [/snip] BINGO! Goofy rules can be frustrating

mysql php question

Does anyone have some simple sample code using php to access a mySQL database? Could you post it or send someit to me please? Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 Help Wanted. Seeking Telepath... You Know where to apply.

Re: mysql php question

Not really a simplistic one, but simple to set-up and use: http://phpnuke.org Very nice dynamic php/mysql based web site you can download and install. Larry Irwin CCA Medical - Original Message - From: Taylor Lewick [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 2:16

Re: mysql php question

gotcha, thanks, which manual is that? Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 Help Wanted. Seeking Telepath... You Know where to apply. [EMAIL PROTECTED] 06/24/02 01:39PM in the php manual in the section of functions about mysql, it has a few examples. SNIP

RE: Load problems with 3.23.51

I tried 'skip-name-resolve' but it had no impact. :( So it may have nothing to do with name resolution. Here are the results in file RUN-mysql-Linux_2.4.16_0.13smp_i686: I'm going to run the tests on .47 next to see if there is any difference. Sincerely, Steven Roussey

advantages mysqldump -T option

Hi folks, Currently I'm using mysqldump with the --opt option to backup databases. I recently discovered the -T option to output to delimited files. Aside from only being able to run mysqldump on the same machine as the mysql daemon, are there any other disadvantages or advantages of using the

RE: Load problems with 3.23.51

I tried the skip-name-resolve and it had no effect. So there goes my hypothesis. Here are the results from test: Benchmark DBD suite: 2.14 Date of test:2002-06-24 11:19:19 Running tests on:Linux 2.4.16-0.13smp i686 Arguments: Comments: Limits from: Server version: MySQL

my_gui: a gui module for MySQL (using Python) First public release (0.24)

This is the first public release for my_gui. my_gui.py is a simple Grafic User Interface for MySql. It can be used as a Python module to create your own MySQL interface. Sorry, no documentation yet download it at http://www.prosa.it/projects/projects MAS!

Re: Load problems with 3.23.51

I will second this. I attempted an upgrade from 3.23.50 to 3.23.51 and hit immediate performance problems. I tried for about 20 minutes to see what was causing it but to no avail. I reverted to 3.23.50. At first I thought it was my fault so I decided not to report it until I did some further

my_gui: a gui module for MySQL (using Python) First public release(0.24)

D. H. Craig, CSM __ This is the first public release for my_gui. my_gui.py is a simple Grafic User Interface for MySql. It can be used as a Python module to create your own MySQL interface. Sorry, no documentation yet download it at http://www.prosa.it/projects/projects

Re: Load problems with 3.23.51

On Mon, Jun 24, 2002 at 03:11:53PM -0400, Michael Bacarella wrote: I will second this. I attempted an upgrade from 3.23.50 to 3.23.51 and hit immediate performance problems. I tried for about 20 minutes to see what was causing it but to no avail. I reverted to 3.23.50. At first I thought

Re: Load problems with 3.23.51

On Mon, Jun 24, 2002 at 12:43:47PM -0700, Jeremy Zawodny wrote: I will second this. I attempted an upgrade from 3.23.50 to 3.23.51 and hit immediate performance problems. I tried for about 20 minutes to see what was causing it but to no avail. I reverted to 3.23.50. At first I

Re: Re-do logging feature with InnoDB: is it possible ?

Bert, - Original Message - From: Bert VdB [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, June 24, 2002 11:09 AM Subject: RE: Re-do logging feature with InnoDB: is it possible ? Hello everybody, I have a small question regarding to the Mysql-InnoDB-tables : Is

RE: mysql php question

The one at www.php.net -Original Message- From: Taylor Lewick [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 1:50 PM To: [EMAIL PROTECTED] Subject: Re: mysql php question gotcha, thanks, which manual is that? Taylor Lewick Unix System Administrator Fortis Benefits 816 881

Re: Load problems with 3.23.51

Hi! I just ran the standard perl run-all-tests --small-test --small-tables --create-options=type=innodb on 3.23.49a and an in-house prerelease of 3.23.51, on Linux 2.4.16. The times were essentially the same. 3.23.50 and .51 are almost identical in source code. But as we remember, 3.23.51 was

Re: RecordCount

Some database providers implementation always return -1 no matter the amount of records is returned. That happens to ADO too for certain cursors. The best way to go to count records is Count(*), prepare a query like Select count(MyField) from MyTable Where ... and then get the value. I hope it

Re: Binary data mysqldump and restore.

If I remember correctly from the manual, you can dump your data generating the SQL statements (this is what you are doing) and your file will have a bunch of INSERTS. Your problem is that those inserts will have something like SET YourBinaryField = 'a-bunch-of-characters'. The problem is that

copying the structure of a table to a new table

I want to copy the structure of a table to a brand new table, but I don't want to use phpmyadmin or some other program. I'm looking for the command line code. Anyone have a link to where I can find it? Or, anyone wanna send me the code? Thanks!! mysql

Re: bug in 3.23.51 for windows ?

Victoria Reznichenko wrote: Brandon, Saturday, June 22, 2002, 9:00:49 PM, you wrote: BM Is there any particular reason that anyone knows of that would prevent BM mysql 3.23.51 for windows from working upon the execution of the SHOW BM STATUS FROM tablename query? BM In Linux it

RE: copying the structure of a table to a new table

mysqldump -d database table existingTable.sql Then edit existingTable.sql, change the name of the table, save it as newTable.sql mysql database newTable.sql You could do : mysqldump -d database table | sed REGEX to change the table name | mysql database but I'm not an expert on regex. :)

Re: copying the structure of a table to a new table

Hello. On Mon 2002-06-24 at 17:06:19 -0400, [EMAIL PROTECTED] wrote: I want to copy the structure of a table to a brand new table, but I don't want to use phpmyadmin or some other program. I'm looking for the command line code. Anyone have a link to where I can find it? Or, anyone wanna

Re: copying the structure of a table to a new table

From pg 149 of the New Riders Press book MySQL by Paul DuBois (ISBN 0-7357-0921-1): CREATE TABLE new_tbl_name SELECT * FROM tbl_name WHERE 1=0 -- Mark P. Hennessy [EMAIL PROTECTED] On Mon, 24 Jun 2002, Phil Schwarzmann wrote: Date: Mon, 24 Jun

Re: Can't create FOREIGN KEY restraints on InnoDb tables

* [EMAIL PROTECTED] [...] The referred to keys are the same type and are indexed (they are [...] CREATE TABLE genres ( genre_idSMALLINT NOT NULL PRIMARY KEY, [...] genre_idSMALLINT, ...does not look the same to me... ;) -- Roger sql

Re: copying the structure of a table to a new table

Other than all previous comments, you can also do , SHOW CREATE TABLE tablename; and then copy+paste it with a different tablename. Gurhan - Original Message - From: Phil Schwarzmann [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 5:06 PM Subject: copying the

Re: (fwd) sorting question

OK, I determined that at least part of the problem was that I ran out of space in /var/tmp, so I reset TMPDIR to a directory that's 40G in size an am trying again. But I'd still be very interested in any comments on the below select statement given the size of everything involved (eg, an 1800M

RE: Load problems with 3.23.51

I used the mysql builds myself. Funny thing is that I use your tool 'mytop', which is very cool by the way, to watch things and it pauses for about 5-8 seconds when refreshing with .51 and is almost instant with .47 Sincerely, Steven Roussey http://Network54.com/?pp=e -Original

Re: copying the structure of a table to a new table

At 04:06 PM 6/24/2002, you wrote: I want to copy the structure of a table to a brand new table, but I don't want to use phpmyadmin or some other program. I'm looking for the command line code. Anyone have a link to where I can find it? Or, anyone wanna send me the code? Thanks!! mysql Phil,

Re: (fwd) sorting question

* Cindy OK, I determined that at least part of the problem was that I ran out of space in /var/tmp, so I reset TMPDIR to a directory that's 40G in size an am trying again. But I'd still be very interested in any comments on the below select statement given the size of everything involved

Case Sensitivity for CHECK TABLE TABLENAME??

Mac OS X mysql 3.23.47 I have a database with a table named: tname. After several inserts, I run CHECK TABLE tname; No errors are reported. I then run CHECK TABLE TNAME; And errors are reported! Which is it? Errors or no errors? Thanks Mark

Re: Build errors with 3.23.51

After much testing, I have managed to overcome the limits on file descriptors and such on linux; and have a mysql daemon that is fairly lean and able to support several thousand simultaneous connections. I still, though, would like to see what kind of improvment gcc-3.0.4 makes as opposed to

Re: advantages mysqldump -T option

Check this out: http://www.mysql.com/doc/m/y/mysqldump.html According to the above page, -T option creates a table_name.txt file for each given table, with its CREATE TABLE syntax and the data for its content in the file Gurhan - Original Message - From: Rachael LaPorte Taylor

Re: Case Sensitivity for CHECK TABLE TABLENAME??

Mark: Do you have my.ini (or my.cfg) set to ignore case in table names? set-variable = lower_case_table_names=1 Gerald Jensen - Original Message - From: Mark Weiler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 5:56 PM Subject: Case Sensitivity for CHECK TABLE

Re: mysql php question

Taylor ... Check out ... http://hotwired.lycos.com/webmonkey/databases/tutorials/tutorial4.html ... or ... http://vtwebwizard.com/tutorials/mysql/ - Original Message - From: Taylor Lewick [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 1:16 PM Subject: mysql php

Inserting images (not the location of the images)

Hi All, First of all I want to thank you all for all the help that you have given me throughout the last week. I have learnt a great deal, and through your help and the resources on the interenet I have successfully been able to create and connect to a database through

Is mySQL support replication ??

Hi, all, May i know is mySQL support replication regards, alice /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you

file size limit hitting when LOAD DATA INFILE

Hi, all: I use MySQL 3.23.47, RH linux 7.2, file size limit is 4G. When LOAD DATA INFILE to a table whose file size is 4G, it fails and mysql_error(...) reports Lost connection to MySQL server during query. How can I clearly know the failed reason is just hit the 4G file size limit? If

How to access mysqladmin from IE?

Hi guys! Does anyone know how to access mysqladmin from Internet Explorer so I can view and edit my data. Please help, thanks. Aqua - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: How to access mysqladmin from IE?

If you installed correctly and it's running then you likely forgot to add the '/' at the end of the phpmyadmin part i.e. youriphere/phpmyadmin/ not yourip or localhost/phpmyadmin. justin -Original Message- From: Aqua [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 7:42 PM To:

Re: How to access mysqladmin from IE?

At 9:42 +0700 6/25/02, Aqua wrote: Hi guys! Does anyone know how to access mysqladmin from Internet Explorer so I can view and edit my data. Please help, thanks. That's a strange request, given that mysqladmin neither displays table data nor allows it to be edited. What do you mean? Aqua

Re: Inserting images (not the location of the images)

At 18:36 -0700 6/24/02, Emma Grant wrote: Hi All, First of all I want to thank you all for all the help that you have given me throughout the last week. I have learnt a great deal, and through your help and the resources on the interenet I have successfully been able to create

Re: Is mySQL support replication ??

Yes it does. http://www.mysql.com/doc/R/e/Replication_Implementation.html - Original Message - From: Alice [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 6:52 PM Subject: Is mySQL support replication ?? Hi, all, May i know is mySQL support replication

Re: file size limit hitting when LOAD DATA INFILE

Yes, MERGE Tables is useful for getting around the file size limit problem. However, Linux 7.2(Kernel 2.4.x), MySql 3.23.47 supports file sizes greater than 4GB. Mysql 3.23 by defaul will create tables that can grow only upto 4G but these can be altered using ALTER TABLE. You willl need to alter

11G .err file

Hi, My mysql error file (hostname.err) had grown to 11G on Red Hat 7.0, kernel 2.4.3, file system type ext2. As I understand it, file size in Terrabytes can be supported under this kernel version, however, mysql semi-crashed at this point, meaning I could not connect to it remotely (I could

  1   2   >