Sql dreamweaver newbie

when i try to add a database entry to my php page in dreamweaver (using the '+' tab) i keep getting a message "An unidentified error has occurred". This is when i go to select a database , i use the ip of the remote server and i use the correct login,.. help =). this is using mysql Charles

MySQL GUI errors.

Hello: I am using Windows 98. I have a machine with 512K memory and a 1.3meg processor. I am trying to use MySQL Control center, version 0.8.7. It crashes when I try to connect to more than one user at the same time. Worse, it looks like I can only open one connection per session. If I open a con

RE: Can MySQL handle 120 million records?

Jeremy, mySql has no brand recognition compared to Oracle, Sybase, MS, IBM. that is why there is not enough confidence. people buy things because they trust and have confidence in the brand. As long as the brand owner can keep the product performing to the level of expectations embodied in the b

How to enter data in MySQLCC

Please someone email me at [EMAIL PROTECTED] how to do this as well...I am lost on how to ad data to MYSQLCC

Re: Off Topic: What was that Happy email about?

This is not spam. Spam really sucks... that's why i'm commenting on this, i'm afraid of what i noticed being passed around on the mailing-list...read on. I have to bypass the mysql list filter, so i'm going to say mysql a few times. In a Mysql thread, which was had only the following...

Re: MySQL Decimal Column Types Question

>>> For a 10,2 decimal column, should this be a valid number: 1234567890.12? It's easy to test: mysql> CREATE TABLE t (d DECIMAL(10,2)); Query OK, 0 rows affected (0.01 sec) mysql> INSERT INTO t SET d = 1234567890.12; Query OK, 1 row affected (0.01 sec) mysql> SELECT * FROM t; +---

Re: MySQL Decimal Column Types Question

At 21:18 -0500 12/20/02, Michael She wrote: At 06:17 PM 12/20/2002 -0600, Paul DuBois wrote: At 17:21 -0500 12/20/02, Michael She wrote: Hi all, What does a 10,2 decimal definition mean. Is it 10 Digits in total with 2 decimal places OR 10 integer digits with 2 decimal places? The former.

Re: MySQL Decimal Column Types Question

> From: Michael She <[EMAIL PROTECTED]> > Date: Fri, 20 Dec 2002 21:18:44 -0500 > To: Paul DuBois <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: MySQL Decimal Column Types Question > > At 06:17 PM 12/20/2002 -0600, Paul DuBois wrote: >> At 17:21 -0500 12/20/02, Michael She wrote: >>>

Re: (In addition...) mysqldump user prive

On Friday 20 December 2002 08:42 am, Victoria Reznichenko wrote: > On Thursday 19 December 2002 21:29, Arun kumar R wrote: > > I want to run mysqldump through a batch process, in > > order to do that what prive do i need to give to the > > user. It will be running as a cron job, i don't want > > to

happy

Looking for a free email account? Get one now at http://www.freemail.com.au/ - Before posting, please check:

RE: Suitability of mySQL for desktop use?

Frank, That doesn't sound like it will be a problem for MySQL. I am using the Zeos components. The only caveat that I have about these components is that they are very slow in loading large (more than 3-4 lines) SQL query statements. It is much, much faster to create a data module and create persi

Missing -lwrap on mysqld/mysqltest?

>Description: gcc -O3 -DDBUG_OFF -rdynamic -o mysqltest mysqltest.o -lstdc++ ../libmysqld.a -lrt -ldl -lpthread -lz -lcrypt -lnsl -lm -lpthread ../libmysqld.a(lib_sql.o)(.text+0x2736): In function `handle_connections_sockets': : undefined reference to `request_init'

[patch] Error in Makefile prevents complete distclean

>Description: The unpacked source differs from the source tree after a ./configure && make && make distclean. This should be considered as Makefile bug, as e.g. package maintainers like me depends on a souce that cleans up it self so that we can easyly produce diffs

rpm source build problems

Hi, I hope this message is not out of place, but I have not been able to solve this problem. I need to rebuild the latest MySQL rpm's for use on some RedHat 6.1/6.2 machines and have been having quite a few problems. I've made sure I have : autoconf-2.52 automake-1.5 libtool-1.4.3 which I beli

Re: Can MySQL handle 120 million records?

At 03:28 PM 12/20/2002 -0800, Jeremy Zawodny wrote: > I think it will in time...thats why i stick with it. besides, > confidence is often just a synonym for 'knowledge' Really? I tend to see it more like confidence builds with experience (and therefore time). You don't need to know a lot about

Docs make wrong statement about Debians init scripts

>Description: http://www.mysql.com/doc/en/Linux-x86.html says what to do to start MySQL on system boot in "Debian GNU/Linux". I don't know if this holds true for some of your binary packages under Debian, but the official Debian package is configure by debcon

redhat 6.1 / 6.2

Hi, In regard to my previous message - I would also be interested if anyone is aware of a general source for MySQL rpm's built for 6.1/6.2. I would prefer to build my own but if I do not succeed I would also be interested in anyone else's. I assume that there are no MySQL supplied rpm's for 6.1

Re: MySQL Decimal Column Types Question

At 06:17 PM 12/20/2002 -0600, Paul DuBois wrote: At 17:21 -0500 12/20/02, Michael She wrote: Hi all, What does a 10,2 decimal definition mean. Is it 10 Digits in total with 2 decimal places OR 10 integer digits with 2 decimal places? The former. For a 10,2 decimal column, should this be a

Hostname resolve issue?

Hi all, Due to the severe security issue released last week for mysql, we had to upgrade all our 3.22.32 servers to the latest 3.23 release. However, this introduced us to some problems across several of our 80+ DB servers: 1. Weird resolve issues: tries to connect to replies

Need help revising CREATE TABLE

Greetings and happy holidays! This is a query about how to better structure an existing mysql table. I want to make a rather complex SELECT off an opinion poll. Thus: SELECT Those who answered Q3 as "1" SELECT these people's answers for Q4, Q5, Q6… (Any size array of the rest of the questions.

Re: MySQL Decimal Column Types Question

At 17:21 -0500 12/20/02, Michael She wrote: Hi all, What does a 10,2 decimal definition mean. Is it 10 Digits in total with 2 decimal places OR 10 integer digits with 2 decimal places? The former. For a 10,2 decimal column, should this be a valid number: 1234567890.12? It's easy to test:

Re: Can MySQL handle 120 million records?

On Wed, Dec 18, 2002 at 08:05:46PM -0800, JamesD wrote: > > i like mySQL, but it has a long way to go to gain the level of > 'confidence' that oracle, db2 or mssql or sybase have when it comes > to frontline mission critical stuff. Can you explain why? > I think it will in time...thats why i stic

update mysql

I e-mailed the list but haven't received a response. I have win2k w/ 3.23.53 and need to update it to 54. Is there a patch or do I have to do a reinstall or install on top of it? mysql - Before posting, please check: http://

How to convert Varchar data field into a list

After thinking about some, I think I can ask my question in a clean manner. How do I convert a Varchar data field into a list? Can someone tell me what I'm doing wrong? I have a query see below where the value (a varchar) of category.category_common is -> 2,3 I add the ( ) in the query below to

Re: Best Windows MySQL client?

At 03:24 PM 12/20/2002 +, Jeff Snoxell wrote: What's the best MySQL client for windows? I've tried 5 or 10 shareware ones that seem ok but all seem a bit chasty (some more than others). Any recommendations? I've been using EMS HiTech's Trial version of MySQL Manager. http://www.mysqlmanag

MySQL Decimal Column Types Question

Hi all, What does a 10,2 decimal definition mean. Is it 10 Digits in total with 2 decimal places OR 10 integer digits with 2 decimal places? For a 10,2 decimal column, should this be a valid number: 1234567890.12? Thanks. MySQL, SQL -- Michael She : [EMAIL PROTECTED] Mobile : (519)

Mysql versions, disks, speed, FTS, and EXPLAIN feature request (SELECT [CALC_RESOURCES])

Hi all! I wanted to thank the MySQL team for making such a great product! We moved from 3.23 to 4.0.x a couple of months ago and everything works great. Just upgraded to 4.0.6 and glad to see it work out of the box without a rev 4.0.6a. Those glib issues were such a pain! 4.0.5a and 4.0.6 have be

Re: Indexes That Span Columns...

At 14:12 -0500 12/20/02, Andrew Kuebler wrote: I have the following table; I renamed the columns a & b for easy reading: ID INT(9) UNSIGNED AUTO_INCREMENT PRIMARY KEY, aID INT(9), bID MEDIUMINT(7), UNIQUE ab (aID, bID) INDEX b(bID) As far as I understand the UNIQUE INDEX also provides the index

RE: CREATE TABLE issue?

Missing TYPE=INNODB in create table statement. MySQL parses references for type MyISAM but doesn't use them. Adolfo > -Original Message- > From: Jeff Snoxell [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 20, 2002 1:14 PM > To: [EMAIL PROTECTED] > Subject: CREATE TABLE issue? > >

RE: Is it possible to backup a corrupt database without being

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > I can FTP and telnet in to my site as "admin" or a user, but > all the files in > /var are owned by root so cannot be deleted, with the > exception of several > mysql files owned by mysql, which I also cannot

RE: Count and Selects

I am new at this, but if listings and agents are both tables I do not see a reference in the select statement: select name, count(*) as cnt from agents as p1, listings as p2 where p1.name = p2.agent; Or something like that Chuck http://68.43.100.7:81/aa8vs

Re: 4.1 Download

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thomas Spahni wrote: On Fri, 20 Dec 2002, Victoria Reznichenko wrote: On Friday 20 December 2002 15:14, Anthony W. Marino wrote: Where/how can I get a copy of 4.1? You can install it from development tree using BitKeeper: http://www.mysql.com

Re: time of query

I don't think MySQL can give you back the execution time via DBI, but you might be able to calculate something similar from the Perl side by calculating how long the script runs overall. Here's a good thread from perlmonks about how to do it: http://perlmonks.org/index.pl?node_id=35318 -bill

RE: SQL Get access denied when trying to create a database

All is well and yes I find any documentation that I can find..thanks Gay -- Original Message -- From: "Jennifer Goodie" <[EMAIL PROTECTED]> Date: Fri, 20 Dec 2002 11:57:09 -0800 >With the same user? It sounds like you might want to read the documentation

Re: Using PHP to do a MySql Dump

AFAIK, there is no built-in function in PHP for a dump. That's at least what the manual says. An alternative is to use a system call e.g. system() or exec() with mysqldump. Hope that helps, Claudia >From Todd Cary <[EMAIL PROTECTED]> on Fri, Dec 20, 2002 at 08:35:02AM -0800 > Is there a function

RE: MySQL BUG

MsgBox 1 --> Data provider or other service returned an E_FAIL status. Been there, done that (so have a lot of people via my research). Not so much a MySql thing as it is a Microsoft thing - I was seeing similar messages with not only MySql, but also Microsoft SQL (ADO and E_FAIL).

Re: time of query

In the last episode (Dec 20), Vitali Malicky said: > Glad to greet you all, ladies and gentelmen! > > I have written a dynamic web page in Perl to display some kind > of statistical information usefull for my company. > > My question: how can I get the time which MySQL returns after the query? >

Re: CREATE TABLE issue?

At 17:13 + 12/20/02, Jeff Snoxell wrote: Hi again :) I found the following mysql stuff in the MySQL manual in a section explaining how to do relationships. CREATE TABLE persons ( id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, name CHAR(60) NOT NULL, PRIMARY KEY (id) ); CREATE TA

RE: SQL Get access denied when trying to create a database

With the same user? It sounds like you might want to read the documentation on GRANT and permissions. It is always a good idea to try the documentation before asking questions on the list. http://www.mysql.com/doc/en/User_Account_Management.html -Original Message- From: Gary Hostetler

Extracting information from a list contained in Varchar file

I have a question on the following query statement: SELECT content_title, content_category, content_order, content_name1 FROM content INNER JOIN category ON content.content_category = category.category_id WHERE content_category = 'Intbk' Union Select content_title, content_category, content_order,

Extracting information from a list contained in Varchar file

I have a question on the following query statement: SELECT content_title, content_category, content_order, content_name1 FROM content INNER JOIN category ON content.content_category = category.category_id WHERE content_category = 'Intbk' Union Select content_title, content_category, content_order,

i have given up -- bug

I think I'll throw in the towel. Here is the slow performance I'm getting when joining 13 tables. The query simply takes too long. J explain SELECT distinct Medias.pk_media_id, Organisms.common_name, Tissues.type As tiss_type, Cells.type As cell_type, Organelles.type As org_type, Macrom

Re: Badly placed ()'s and also access denied

I got it fixed with using the right username and password in the php file. Being a newbie I was actually trying this from the command line not from a php file. I found this by accident and found it nowhere in documentation etc. thanks to all who have helped. Gary On 12/20/02 2:21 PM, "Jennifer G

RE: Badly placed ()'s and also access denied

Problem is not in the connecting it is in the mysql_select_db as you are denied access to the database, not the server. Your permissions might be off or the php might not be right. It would be helpful if you posted more of your code. -Original Message- From: Gary Hostetler [mailto:[EMAIL

Count and Selects

I'm trying to get a count of records by combining a search from 2 seperate tables. I have both listings and agents as tables. What I need to do is get a agent, ad count for all the agents listed in agents even if they don't have any ads in listings. Here's the query: select name, count(*) as cn

Indexes That Span Columns...

I have the following table; I renamed the columns a & b for easy reading: ID INT(9) UNSIGNED AUTO_INCREMENT PRIMARY KEY, aID INT(9), bID MEDIUMINT(7), UNIQUE ab (aID, bID) INDEX b(bID) As far as I understand the UNIQUE INDEX also provides the index for aID, but not bID. Is there any other way to

Re: Is it possible to backup a corrupt database without being

I can FTP and telnet in to my site as "admin" or a user, but all the files in /var are owned by root so cannot be deleted, with the exception of several mysql files owned by mysql, which I also cannot move or delete :( If I could extract the info in the database I could delete that remotely, t

Re: Using PHP to do a MySql Dump

Upon initial search, does not appear to be. except: exec("mysqldump") or system(), or shell_exec() Maybe the PHP list would render better results? HTH -Brad Todd Cary wrote: > Is there a function that can be implemented with PHP to do the > equivalent of a mysqldump? > > Todd > > -- Ariste Softwa

RE: Using PHP to do a MySql Dump

You could do an SELECT * INTO OUTFILE (the documentation is on mysql's website). --Joe -- Joe Stump <[EMAIL PROTECTED]> http://www.joestump.net -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 8:35 AM To: [EMAIL PROTECTED] Subject: Using PHP

Re: Best Windows MySQL client?

Greetings I prefer SQLyog. You can download it at http://www.webyog.com/sqlyog/download.html Its free, compact and has lot of features. Insane - Original Message - From: "Jeff Snoxell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 20, 2002 8:54 PM Subject: Best Windo

re: INSERT... SELECT Statement fails when...

On Thursday 19 December 2002 19:19, Andrew Kuebler wrote: > When I run an INSERT. SELECT query and I am inserting the records into a > new table that has a UNIQUE key, the statement will fail as soon as it > hits a "Duplicate entry" error. No further entries will be inserted. The > only way I know

send_file() : Failed reading file name ?

Hi all, We got this spurios error message the other day in our .err file and haven't been able to figure out exactly what it is. 021219 14:10:37 failed in send_file() : Failed reading file name we checked the tables and everything seemed fine. anyone have any ideas? mysql Ver 11.18 Distrib 3.

user & password issue help ?!?

Hello ... my name is Brent ..and im using the latest version of mysql on a Freebsd box with apache & php3 & php4. My problem is that ive set a password for the root mysql user by doing: /usr/local/bin/mysqladmin -u root password 'x' then i installed phpMyAdmin ..and set the correct username

CREATE TABLE issue?

Hi again :) I found the following mysql stuff in the MySQL manual in a section explaining how to do relationships. CREATE TABLE persons ( id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, name CHAR(60) NOT NULL, PRIMARY KEY (id) ); CREATE TABLE shirts ( id SMALLINT UNSIGNED NOT NULL

SQL Get access denied when trying to create a database

Now I get an access denied even trying to create a mysql database which is weird because I just created one an hour ago the same way. Thanks Gary - Before posting, please check: http://www.mysql.com/manual.php (the manual)

time of query

Glad to greet you all, ladies and gentelmen! I have written a dynamic web page in Perl to display some kind of statistical information usefull for my company. My question: how can I get the time which MySQL returns after the query? For example: MySQL returns a line like this "870 rows in set (0.

RE: Accessing last_insert_id problem.

Jeff Snoxell wrote: > At 09:46 19/12/02 -0500, you wrote: > >Jeff Snoxell wrote: > > > >>Nope. That doesn't do it either! > >> > >>I go: > >> > >>TRUNCATE TABLE my_table > > > >Are you using InnoDB tables? You'll have to do something akin to ALTER > >TABLE my_table AUTO_INCREMENT=1 ... at least ac

re: 4.1 Download

On Fri, 20 Dec 2002, Victoria Reznichenko wrote: > On Friday 20 December 2002 15:14, Anthony W. Marino wrote: > > > Where/how can I get a copy of 4.1? > > You can install it from development tree using BitKeeper: > http://www.mysql.com/doc/en/Installing_source_tree.html Is it true that the

Re: thread_cache . what is it ? (no newbie question) .

Hi. On Fri 2002-12-20 at 10:13:57 +0200, [EMAIL PROTECTED] wrote: > Hi . > Simple but still tricky question : what mean 'thread' in mysql's server > point of view ? > I've set the thread_cache_size=30 in my.cnf . > > I use Mysql with Php and my aplication's behaviour is like this : > connect

Re: Extracting foreign key info via ODBC (via JDBC)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alan Hodgkinson wrote: Mark Matthews wrote: [snip] First, you need to use InnoDB tables to be able to extract foreign key information. Ah.. thank you. I had though that native tables in the newer MySQL version, stored and we able re-display, the

Badly placed ()'s and also access denied

Being the newbie that I am I get this Badly placed ()'swhen I try to do a mysql_connect(localhost,gary,password); I have a php script that gives me a Access denied for user: 'gary@localhost' to database 'CONTACT'Can't Select CONTACT1046: No Database Selected When the runs. I chan

[ANN] Lasso Professional 6.0.1 Update Contains Updated MySQL

If you're looking for Web application server alternatives that work extremely well with MySQL, Blue World recently announced the Lasso Professional 6.0.1 Update which includes the latest 3.23.54 build of MySQL. If interested, check out the following support article:

Using PHP to do a MySql Dump

Is there a function that can be implemented with PHP to do the equivalent of a mysqldump? Todd -- Ariste Software, Petaluma, CA 94952 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://li

Re: Extracting foreign key info via ODBC (via JDBC)

> Mark Matthews wrote: > > > Alan Hodgkinson wrote: > > > > I would like to extract the meta data describing foreign key > > relationships using ODBC (actually in Java using JDBC). > > > > My current version of mySQl 3.23.49 does not seem to support > > it. That is the methods DatabaseMetaData.get

4.0.6 Standard for Windows.

There does not seem to be a windows download for 4.0.6 Standard on the downloads page. There is a version on the Max page.Is this an oversight or intentional? Which version should I be using with "Classic" commercial licence? The downloads page says that the standard version includes InnoDB, which

Restoring db from mysqldump output problem...

Hello, I've successfully backed up my database to JeffsDB.sql using mysqldump with the -opt option. When I try to restore it using: mysql -h myhost -u myusername -ppassword JeffsDB < JeffsDB.sql I get: ERROR 1065 at line 21: Query was empty Now, line 21 of the SQL file contains: /*!4 AL

Re: 4.1 Download

i wish to know too! thanks --- "Anthony W. Marino" <[EMAIL PROTECTED]> ha scritto: > Where/how can I get a copy of 4.1? > Thanks, > Anthony > > > > > > > > > > > > > > > > > > > > > > > sql,query,queries,smallint > > > -

Best Windows MySQL client?

What's the best MySQL client for windows? I've tried 5 or 10 shareware ones that seem ok but all seem a bit chasty (some more than others). Any recommendations? Thanks, Jeff - Before posting, please check: http://www.mysql

Re: Extracting foreign key info via ODBC (via JDBC)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alan Hodgkinson wrote: Dear All, I would like to extract the meta data describing foreign key relationships using ODBC (actually in Java using JDBC). My current version of mySQl 3.23.49 does not seem to support it. That is the methods DatabaseMetaD

Is innodb still beta in MySQL-Max-3.23.54a?

Is Innodb still beta in MySQL-Max-3.23.54a? If not, I am thinking of making the move. :) Thanks! - Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: mysqlimport access denied errors

At 13:04 + 12/20/02, Imran Khan wrote: Hi, I'm working on SOlaris 8 with MySQL v3.23.54. I'm trying to give a user 'user1' access to one of my databases 'db1', and specifically one table 'table1'. As root I've run: msql> grant all on db1 to user1@localhost -and it appears to work fine. Tr

MySQL BUG

Hi, I am facing strange problem while accessing a LONGTEXT field. I've been using VisualBasic 6.0 & MySQL 4.0.4 via ADO 2.0 by using MyODBC 3.51.04 on WIN2k Server (SP 2). Pls follow the below steps to generate a bug --> '/' 1. Create a Tabl

ANN: EMS MySQL Utils 1.2 released!

EMS HiTech Company is announcing the next version (1.2) of MySQL Utils -- Powerful Windows/Linix Data Management Utilities for MySQL Server. You can download the latest version from http://www.mysqlutils.com/download.phtml. What's new in version 1.2? 1. MySQL Export: export to MS Access added (W

re: mysqldump user prive

On Thursday 19 December 2002 21:29, Arun kumar R wrote: > I want to run mysqldump through a batch process, in > order to do that what prive do i need to give to the > user. It will be running as a cron job, i don't want > to give any creation or deletion authorization. Your > help will be greatly a

re: INSERT INTO from a SELECT does not work?

On Friday 20 December 2002 10:30, Thierry Michalowski wrote: > I'm trying to run the following SQL statement on a table of my MySQL DB: > > insert into MYTABLE(ID, VALUE, SORTKEY) >select T.ID, 'to to', MAX(T.SORTKEY) + 1 from MYTABLE as T group by > T.ID > > This was suggested by a SQL ex

re: Tables read only

On Friday 20 December 2002 04:48, cable at ionbits dot net wrote: > i cant create SQl tables andoso cant del the tables.. it always shows > table is read only.. anyway to solve? Is your table packed with myisampack utility? Check also that MySQL server has permissions to write in these files.

re: minor problem with ALTER TABLE

On Friday 20 December 2002 12:31, Federico Razzoli wrote: > I tried to change a Heap table to BDB. I didn't compile MySQL with BDB, so > I expected to get an error. Instead, the table type has been set to MyISAM, > wich is the default type. I think this is a bug, if it isn't I think this > behavoi

re: DISTINCT on one collum

On Friday 20 December 2002 13:35, Steve Vernon wrote: > MySQL as the filter stupidly does not match SELECT > > Hiya, > How do you get a disctinct value from one collumn only? I am basically > using it to construct a dynamic menu, and need the menu names at a level. > > Items are in one tab

re: 4.1 Download

On Friday 20 December 2002 15:14, Anthony W. Marino wrote: > Where/how can I get a copy of 4.1? You can install it from development tree using BitKeeper: http://www.mysql.com/doc/en/Installing_source_tree.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita

re: mysqladmin access denied error

On Friday 20 December 2002 15:31, Imran Khan wrote: > I'm using solaris 8 with mysql v 3.23.54. > > I want to enable a solaris user - 'user1', to use the mysqlimport command > without using a password. > > I've run, as root, the following sql command: > mysql>grant all on db1.* to user1@localhost

Re: 4.1 Download

http://www.mysql.com/newsletter/2002-10/a79.html - Original Message - From: "Anthony W. Marino" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 20, 2002 1:14 PM Subject: 4.1 Download > Where/how can I get a copy of 4.1? > Thanks, > Anthony -

crash if etc/hosts misconfigured

>Description: I'd a /etc/hosts misconfigured, it told that the machine name was linux200 with IP 192.168.0.3 but eth0 was configured to use IP 192.168.0.16. In this enviroment executing this command "mysql -h 192.168.0.16" cause a mysqld crash. Correcting /etc/hosts to report the correct

Re: /etc/my.cnf does not contain innodb_log_files_in_group.

Hi! For the record, I exchanged email with Kip, and it turned out he had forgotten to add the keyword 'set-variable' to the my.cnf line. It should be set-variable=innodb_log_files_in_group=... Note that the default is 2 if you have not specified this previously in your my.cnf. I read from the 4

Re2: 4.1 Download

oohhh, sorry the corrent page is : http://www.mysql.com/doc/en/Installing_source_tree.html sql,query - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento -

Re: 4.1 Download

Dobrý den, sexta-feira, 20 de dezembro de 2002, 11:14:04, napsal jste: AWM> Where/how can I get a copy of 4.1? AWM> Thanks, AWM> Anthony AWM> sql,query,queries,smallint AWM> - AWM> Before posting, please ch

Re: 4.1 Download

On Friday 20 December 2002 14:14, Anthony W. Marino wrote: > Where/how can I get a copy of 4.1? > Thanks, > Anthony > > http://www.mysql.com/doc/en/Installing_source_tree.html Regards Georg filter: mysql, query - Before posting

Re: add one more innodb_data file when I do have an autoextending one?

Lars, - Original Message - From: "Lars Andersson" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, December 20, 2002 12:17 PM Subject: add one more innodb_data file when I do have an autoextending one? > I have an production MySQL-Max -3.23.54a server running innodb d

Re: Suitability of mySQL for desktop use?

Dan, I don't believe I will be placing stressful demands on the database/PC. I will be querying about a dozen tables varying in size from 100 records up to around 500,000 records each. Do you agree? What are you doing by comparison? Are you using the Zeos components to access mySQL from Delphi? I

mysqladmin access denied error

Hi, I'm using solaris 8 with mysql v 3.23.54. I want to enable a solaris user - 'user1', to use the mysqlimport command without using a password. I've run, as root, the following sql command: mysql>grant all on db1.* to user1@localhost -this appears to work fine. However as user1 in the solari

mysqlbinlog segfaults with host args

$ mysqlbinlog --host=mysqlserver --table=sometable --database=somedb \ --user=someuser --password=somepassword Segmentation fault. $ strace mysqlbinlog --host=mysqlserver --table=sometable \ --database=somedb \ --user=someuser --password=somepassword (...) old_mmap(NULL, 1203040, PROT_READ|PROT_EXE

4.1 Download

Where/how can I get a copy of 4.1? Thanks, Anthony sql,query,queries,smallint - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

mysqlimport access denied errors

Hi, I'm working on SOlaris 8 with MySQL v3.23.54. I'm trying to give a user 'user1' access to one of my databases 'db1', and specifically one table 'table1'. As root I've run: msql> grant all on db1 to user1@localhost -and it appears to work fine. However when as the solaris user 'user1', I ru

Re: minor problem with ALTER TABLE

At 18:31 +0800 12/20/02, Federico Razzoli wrote: I tried to change a Heap table to BDB. I didn't compile MySQL with BDB, so I expected to get an error. Instead, the table type has been set to MyISAM, wich is the default type. I think this is a bug, if it isn't I think this behavoir should be c

Re: INSERT INTO from a SELECT does not work?

At 9:30 +0100 12/20/02, Thierry Michalowski wrote: Hello, I'm trying to run the following SQL statement on a table of my MySQL DB: insert into MYTABLE(ID, VALUE, SORTKEY) select T.ID, 'to to', MAX(T.SORTKEY) + 1 from MYTABLE as T group by T.ID You can't insert into the same table that y

RE: Help w/ Join Query

SELECT * FROM t1,t2,t3 WHERE t1.img_id=t2.img_id AND t2.caption_id=t3.caption_id Adolfo > -Original Message- > From: mike [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 19, 2002 8:15 PM > To: [EMAIL PROTECTED] > Subject: Help w/ Join Query > > > Hello, > > I working on a small

DISTINCT on one collum

MySQL as the filter stupidly does not match SELECT Hiya, How do you get a disctinct value from one collumn only? I am basically using it to construct a dynamic menu, and need the menu names at a level. Items are in one table, like CATEGORY, SUBCATEGORY, SUBSUBCATEGORY, PAGE, ID I cou

MySQL 4.0.6 is released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.0.6, a new version of the world's most popular Open Source Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. T

Re: Compile 3.23.53 error on HPUX 11.11

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 16 Dec 2002, Zengfa Gao wrote: > I just send the one again, hope to find someone to > help me out with MySQL compile. > > I am using HPUX 11.11, gcc 3.1. > > 1. CFLAGS="-fomit-frame-pointer -O3 -fpic" CXX=gcc > CXXFLAGS="-felid-constructors -f

minor problem with ALTER TABLE

I tried to change a Heap table to BDB. I didn't compile MySQL with BDB, so I expected to get an error. Instead, the table type has been set to MyISAM, wich is the default type. I think this is a bug, if it isn't I think this behavoir should be changed. --

add one more innodb_data file when I do have an autoextending one?

I have an production MySQL-Max -3.23.54a server running innodb databases. I've migrated the server and data from an older Linux installation (with max filesize 2GByte). The new server is running Linux 2.4 and can deal with larger files. I have three in innodb_data files and the last one is autoex

  1   2   >