PROBLEM WORKING WITH MYSQL
I am a student using your mysql 2.23.38 version.My application details are, App-Server = TOMCAT3.2 APPLICATION USED= JAVA AND JSP I have started MYSQLADMIN and I have a green signal of MYSQL in my taskbar. MYSQL is running but it is not responding. It is giving an error like this, java.sql.SQLException: Cannot connect to MySQL server on FORD:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.SocketException) Please help. regards, yatheesh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
complete delete to begin again, instructions please
could someone tell me how to make a clean sweep of MySQL from my system so i can start over? (i need to toss phpMyAdmin temporarily too i get asked for a password at every bend and none of the ones i use' hardly ever' work ;) e. i just don't get the root stuff and winder whay i can't just have ALL the privileges and ownerships under my username. Ted - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bizarre
Aah!! Thanks :-) I didn't know a flush privileges; SQL statement was necessary. I'll be sure to remember that! Thanks! Brian Perhaps the 'replication' of 'user' data (and/or other MySQL 'control' data) doesn't perform the necessary 'refresh' (which occures when you do a flush privileges), but was 'triggered' when you changed the users' password Turtle wrote: Ok.. even more bizarre... IN addition to what I told you in my last posting, I just logged onto the slave server and changed the user's password to what it was already, and now the user can log in. I verified the ENCRYPTED password string before and after the change, and it was IDENTICAL!!! NO CHANGE WAS ACTUALLY MADE to the database, but he can now log into the slave???!?!!?!? Ok (Sorry if I'm sounding a bit loud... I'm very frustrated.) :-) Any ideas? Brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with safe_myslqd
I have installed mysql 3.23.39 on Linux Mandrake 8.0. I have created a database but today I can't execute safe_mysqld. Mysql tell me: The file /usr/local/mysql/libexec/mysqld doesn't exist or not executable. Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/safe_mysqld. The file /usr/local/mysql/libexec/mysqld doesn't exist (only /usr/local/mysql/lib and not libexec), but I have run this daemon before and I can't yet. Please help! Furthermore, how can I execute this daemon when the machine starts (I want that the daemon is running when we can choose a user: what file should I modified: initd,...). Thanks you... _ Le journal des abonnés Caramail - http://www.carazine.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: complete delete to begin again, instructions please
Use http://www.mysql.com/doc/R/e/Resetting_permissions.html to reset your password. could someone tell me how to make a clean sweep of MySQL from my system so i can start over? (i need to toss phpMyAdmin temporarily too i get asked for a password at every bend and none of the ones i use' hardly ever' work ;) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DBD::mysql - connection problem
Hi,
I am a newbie and hope someone can she light on why I can't get the
DBD::mysql connection working in my perl script. The script is a test one
and very simple.
I have the mysql daemon running and mysqladmin works, and DBI is installed
too. I went through the installation process for DBD and have also placed
the /usr/local/mysql path reference in the environment. These are the
errors below:
---
Can't locate DBD/mysql.pm in @INC (@INC contains:
/opt/perl5/lib/5.6.0/PA-RISC1.1 /opt/perl5/lib/5.6.0
/opt/perl5/lib/site_perl/5.6.0/PA-RISC1.1 /opt/perl5/lib/site_perl/5.6.0
/opt/perl5/lib/site_perl .) at create_table.pl line 8.
BEGIN failed--compilation aborted at create_table.pl line 8.
---
Script is as follows:
-
#!/usr/bin/perl
# Creating a table
use warnings;
use strict;
use DBI;
use DBD::mysql;
my $dbh = DBI-connect(DBI:mysql:USERDB, root, , { RaiseError = 1} );
my $string = CREATE TABLE Users (
FirstName VARCHAR( 30 ),
LastName VARCHAR( 30 ),
Email VARCHAR( 30 ),
Phone VARCHAR( 30 ),
Continent ENUM( 'North America',
'South America',
'Europe',
'Asia',
'Africa',
'Australia',
'Antarctica' ),
OpSys ENUM( 'Windows NT',
'Windows 98',
'Macintosh',
'Linux',
'HP-UX',
'Other'),
Hours INT,
RatingINT );
$dbh-do( $string );
$dbh-do( INSERT INTO Users (
FirstName, LastName, Email, Phone, Continent, OpSys, Hours,
Rating )
VALUES ('Harry', 'Varvarigos',
'hvarvari\@test.test.telstra.com.au',
'(555)555-', 'North America', 'HP-UX 10.20', 3, 4)
);
my $sth = $dbh-prepare( SELECT * FROM Users );
$sth-execute();
while ( my $row = $sth-fetchrow_array() ) {
print( @row\n );
}
warn( $DBI::errstr ) if ( $DBI::err );
$dbh-disconnect();
$sth-finish();
--
Thanks for any assistance
Harry
CAUTION - This message may contain privileged and confidential information intended
only for the use of the addressee named above. If you are not the intended recipient
of this message you are hereby notified that any use, distribution or reproduction of
this message is prohibited. If you have received this message in error please notify
Siemens Ltd., ABN 98004347880, or Siemens (NZ) Limited immediately.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
any size limitation as to the size of a query statement?
Hello,
I have a table with approximately 68,000 records. I then get a file
uploaded to the server with approximately 68,000 master_id's listed in it.
If the master_id's in our MySQL table are not one of the master_id's listed
in the file, they need to be deleted from the MySQL table.
Right now, a Perl script reads the master_id's from the uploaded file, and
puts them all into an array in memory. We then loop through all the
master_id's from the MySQL table. If the MySQL master_id is not in the
array of master_id's from the file, then the record is deleted. This works
fine if we are using a small amount of records, but there are over 68,000 of
them. It seems like there should be a better, more efficient way of doing
this.
One thought that I had, was to create one big huge DELETE statement.
Something like this:
$q = DELETE FROM master;
$where = WHERE ( ;
$morethan1 = 0;
foreach (@masteridarray) { #this is our 68,000 valid id's
if ($morethan1) {
$where .= OR master_id != $_ ;
}else{
$where .= master_id != $_ ;
$morethan1 = 1;
}
}
$where .= );
if ($morethan1) {
$q .= $where;
}
my $sth = $dbi_dbh-prepare($q);
$sth-execute;
However, I wasn't sure if MySQL could process something like this. And if
it could, how much bigger could the query statement get (the number of
records in the table will easily exceed 100,000 before the end of the year,
and continue to grow even bigger next year)?
Another thought/question was whether MySQL had some mechanism for searching
through the upload file itself. Something along the lines of, DELETE FROM
master where master_id != [any of the masterid's in file ./id.txt].
The number of records in this table is only going to grow over the coming
months, so, I want to make sure that I have a solution that is scalable.
Any/all suggestions will be greatly appreciated!
Mark
Imagine your own dedicated server, but ...
without all the hassles of managing it yourself!
Managed Dedicated Servers
http://www.ServerPros.com
--
Mark A. Sharkey
PrecisionPros.com Network
6543 East Omega Street
Mesa, Arizona 85215
800 844 4434 toll free
480 461 9765 local
480 461 9312 fax
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: any size limitation as to the size of a query statement?
Why not do something like:
my $q = DELETE FROM master WHERE master_id NOT IN (;
$q .= join(',', @masteridarray);
$q .= ')';
$dbi_dbh-do($q);
Though this will obviously fall into the same size limitations that you were
doing, but it should execute a lot faster, and be a bit smaller than your
example. (I don't have an answer for this, being rather new to the mysql
community myself).
-Chris
Hello,
I have a table with approximately 68,000 records. I then get a file
uploaded to the server with approximately 68,000 master_id's listed in it.
If the master_id's in our MySQL table are not one of the master_id's listed
in the file, they need to be deleted from the MySQL table.
Right now, a Perl script reads the master_id's from the uploaded file, and
puts them all into an array in memory. We then loop through all the
master_id's from the MySQL table. If the MySQL master_id is not in the
array of master_id's from the file, then the record is deleted. This works
fine if we are using a small amount of records, but there are over 68,000 of
them. It seems like there should be a better, more efficient way of doing
this.
One thought that I had, was to create one big huge DELETE statement.
Something like this:
$q = DELETE FROM master;
$where = WHERE ( ;
$morethan1 = 0;
foreach (@masteridarray) { #this is our 68,000 valid id's
if ($morethan1) {
$where .= OR master_id != $_ ;
}else{
$where .= master_id != $_ ;
$morethan1 = 1;
}
}
$where .= );
if ($morethan1) {
$q .= $where;
}
my $sth = $dbi_dbh-prepare($q);
$sth-execute;
However, I wasn't sure if MySQL could process something like this. And if
it could, how much bigger could the query statement get (the number of
records in the table will easily exceed 100,000 before the end of the year,
and continue to grow even bigger next year)?
Another thought/question was whether MySQL had some mechanism for searching
through the upload file itself. Something along the lines of, DELETE FROM
master where master_id != [any of the masterid's in file ./id.txt].
The number of records in this table is only going to grow over the coming
months, so, I want to make sure that I have a solution that is scalable.
Any/all suggestions will be greatly appreciated!
Mark
Imagine your own dedicated server, but ...
without all the hassles of managing it yourself!
Managed Dedicated Servers
http://www.ServerPros.com
--
Mark A. Sharkey
PrecisionPros.com Network
6543 East Omega Street
Mesa, Arizona 85215
800 844 4434 toll free
480 461 9765 local
480 461 9312 fax
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database MySQL: possible errors when using myisamchk andisamchk ?
This is not a good idea I think, because when the check would report errors my backup would be useless ! the idea is to have clean backups, so I want to check before I do any backup and if necessary (when the check reports errors) restore the dammaged tables first. any other idea's ? regards Koen If you back them up before you check them, and the check blows up, you still have your backups. Koen Gogne wrote: hi, I'm trying to automate the back up of my MySQL databases, and before I perform my backup I check my tables using myisamchk and isamchk. When myisamchk and isamchk report errors I would like to catch that and maybe perform a restore operation. hence my question: what could go wrong when running myisamchk and isamchk and what could I get as error / warning messages ? Can I find a list of all the possible error messages ? for know I check the output of both myisamchk and isamchk for lines containing error and warning but I would like to search for more precise errormessages. Who can help me out ?` kind regards Koen Gogne [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL stm
Hi, On Wed, 20 Jun 2001, Benjamin Pflugmann wrote: This is my sql statement: mysql select count(*),travel.nome_hotel,travel.tour_operator, city.city,travel.vitofferta from travel,city where city.id=travel.cityid group by travel.nome_hotel limit 5; The result: +--+---++---++ | count(*) | nome_hotel| tour_operator | city | vitofferta | +--+---++---++ |2 | Abi d'Oru | HELVETIC TOURS | Sardegna Nord | 1995 | |2 | Abou Nawas Djerba | HELVETIC TOURS | Jerba | 899| |9 | Adams Beach | HELVETIC TOURS | Cipro | 1095 | |1 | Aegean Village| HELVETIC TOURS | Cos | 1099 | |2 | Aeneas| HELVETIC TOURS | Cipro | 1211 | +--+---++---++ Perfect! But it the price the last inserted price?? I am not sure. Here I remove the periodo field as it wraps. Can you tell me how to do this to create the hotel table? There is no nice one-query solution to this problem with MySQL, but only a (speed-inefficient) hack. See the tutorial in the manual for more details: http://www.mysql.com/doc/e/x/example-Maximum-column-group-row.html Actually I did something like this mysql select max(id) as id,nome_hotel,tour_operator,max(periodo) as periodo,vitofferta from travel group by nome_hotel limit 10; +--+---++++ | id | nome_hotel| tour_operator | periodo| vitofferta | +--+---++++ | 1331 | Abi d'Oru | HELVETIC TOURS | 2001-07-06 | 1995 | | 1218 | Abou Nawas Djerba | HELVETIC TOURS | 2001-07-04 | 899| | 1252 | Adams Beach | HELVETIC TOURS | 2001-06-30 | 1095 | | 1058 | Aegean Village| HELVETIC TOURS | 2001-07-07 | 1099 | | 1136 | Aegeon| HELVETIC TOURS | 2001-06-27 | 449| | 291 | Aeneas| HELVETIC TOURS | 2001-06-23 | 1211 | | 949 | Aeolos| HELVETIC TOURS | 2001-07-05 | 799| | 986 | Agrilia | HELVETIC TOURS | 2001-06-29 | 349| | 1325 | Airone| HELVETIC TOURS | 2001-07-06 | 995| | 931 | Albatros | HELVETIC TOURS | 2001-07-06 | 399| +--+---++++ 10 rows in set (0.08 sec) But again the vitofferta (price) reflects to the first row when counted. This is wrong I need it to take the price selected from the max(period) or max(id). Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL data_seek performance
I have been bench-marking an in-house higher-level library to access the MySQL database which uses the store_result and data_seek functions to provide random access to records in a selected dataset. This has brought to light that for 'large' result sets over 10,000 records, the data_seek is starting to take up an enormous portion of time, even when sequentially stepping through all the records once. Is this due to a limitation in the data_seek function? In one instance the comparison was: mysql_use_result + mysql_fetch_row (through total result set) = 3 seconds mysql_store_result + mysql_data_seek (through total result set) = 169 seconds This is without even taking into account the required fetch_row in the second case to actually access the data. Is this a known 'problem' with the data_seek function? ... Inspection of system statistics indicated that physical memory was not full yet, but the processor was running at 100%. Any enlightenment would be appreciated, Jerry van Leeuwen Business Analyst - Trans Data Tel: 02 - 9630 3533 Mobile: 0407 - 480 811 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: :mysql - connection problem
Download and install http://www.perl.com/CPAN-local/authors/id/J/JW/JWIED/DBD-mysql-2.0901.tar.gz Hi, I am a newbie and hope someone can she light on why I can't get the DBD::mysql connection working in my perl script. The script is a test one and very simple. I have the mysql daemon running and mysqladmin works, and DBI is installed too. I went through the installation process for DBD and have also placed the /usr/local/mysql path reference in the environment. These are the errors below: --- Can't locate DBD/mysql.pm in @INC (@INC contains: /opt/perl5/lib/5.6.0/PA-RISC1.1 /opt/perl5/lib/5.6.0 /opt/perl5/lib/site_perl/5.6.0/PA-RISC1.1 /opt/perl5/lib/site_perl/5.6.0 /opt/perl5/lib/site_perl .) at create_table.pl line 8. BEGIN failed--compilation aborted at create_table.pl line 8. --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AN AUTOMATED SIMPLE WAY TO EXPORT ACCESS 2K DATA TO MYSQL ?
I have made an Access 2000 application for a real-estate company. My client will be exportign his Access data in a MySql database which will produce dynamic HTML pages (with some scripting) in an ISP server. So, his data will be published at the Internet, this way. My client will need to just click a button (while he is in Internet) and the data be exported from his Access tables to the MySql server (he could also export the data to a local mysql database in his computer and then upload it to the ISP server, maybe a better way). I am trying to find out how to make this for him as simple as possible. I have downloaded DBTools 1.08, MyAccess (an add-in for Access 2000) and MySqlFront. I have tried DBTools and it works ok exporting Access table data to an empty MySql database (the 'MyAccess' add-in gets stuck, and i haven't tried MySqlFront yet). Initially, I set the Import wizard (of DBTools) to export data and structure. It exported all the tables, except some (maybe because of data type mapping inconsistencies, specifically with null date values in Access). I created those tables by hand and then I was able to export all the data to the empty mysql database that i had just created. I need to find an automated way for my client to export his data (probably with DBTools) with a simple click (either from inside Access or from an outside program). Can he just append only the new data to the mysql database, or he will have to re-export all the data (including the new ones), something i dont mind, anyway? I want to avoid to recreate all the tables each time. I would prefer to have an initial empty mysql database and each time export all the Access data (including the new ones) to a copy of this empty database (for the reason i referred before). So this updated mysql database would then be uploaded to the ISP server. Is there any way to do this automated thing? I was thinking about using a sort of automated task program but iam worried that this method will give me some trouble. I will appreciate any help. Vasilis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bad exe file in win32 download
Hi: I have tried several times to download the win32 zip file. When I try to unzip it, winzip says that the exe file is invalid. Any thoughts? Thanks for your help. Ted Chila
Re: Re: any size limitation as to the size of a query statement?
My code generates a large query. I had to increase the size of max_allowed_packet so that this query would work. I have this in my /etc/my.cnf file: set-variable = max_allowed_packet=2097152 -bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Binding to one IP address on a multihomed host
Dear All I want to bind mysqld to one IP address on a multi-homed host. A search of the manual has not revealed anything - have I missed something or is this not an option ? If its not an option can it be added ? Thanks Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
skip-resolve
database Hi there I remember seeing somewhere that there is a way to skip resolution of names when conneting to the DB, can someone tell me how. I can't seem to find it in the manual. Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lock Tables
database Hi there Is there anyway to see what tables are locked and by who? I have a problem where tables are locked but I am not sure who or why they are. Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Sort Thai Language in MySQL.
My name is Thanatip Tantulavanich.I study computer sience Burapha University in Thailand. I do the Project to topic Sort Thai Language in MySQL.I can Sort Thai Language but I don't know module for Sort in MySQL.If I command order by for sort Thai-database. Project for use in Burapha University. Can you help me? Thanatip Tantulavanich 20/06/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling MySQL 3.23.39 on HP-UX 11.00.
Please run mysql-test and sql-bench in order to verify that all is working well. Please let us know the result. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Binding to one IP address on a multihomed host
Greg Cope wrote: Dear All I want to bind mysqld to one IP address on a multi-homed host. A search of the manual has not revealed anything - have I missed something or is this not an option ? If its not an option can it be added ? Thanks Greg Hi, You can do that, look at 'bind-address' option. You will find it at: http://www.mysql.com/doc/C/o/Command-line_options.html Regards -- Joseph Bueno NetClub/Trader.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
convert myxsql types to java types
Hello, Where can I find a table that compares between MySQL data types and java types. Is there a table in the documentation? If there is, where can I find it? Thanks Meital
How to make MySQL selfdeleting old entrys?
How can i set a date or a number of seconds/hours/minutes/days, after the date expired, that mysql deletes the entry. I want a entry that is only shown a week, after the wekk the entry should be deleted. Is there a way?
Fuzzy results from NOW()-... in select statement?
As I tried to find out how many entries are written to a 'log' table in the past 10, 5, 2 and 1 minute(s), I got some odd results. Since I haven't been able to find any reason (NOW()-60) should result in something completely different from (NOW()-120), could somebody clarify what's going on here? 'changed' is a TIMESTAMP(14) field... mysql SELECT COUNT(*) FROM web WHERE changed = (NOW()-60); +--+ | COUNT(*) | +--+ | 363564 | +--+ 1 row in set (7.00 sec) mysql SELECT COUNT(*) FROM web WHERE changed = (NOW()-120); +--+ | COUNT(*) | +--+ | 38 | +--+ 1 row in set (8.27 sec) mysql SELECT COUNT(*) FROM web WHERE changed = NOW()-120; +--+ | COUNT(*) | +--+ | 37 | +--+ 1 row in set (6.40 sec) mysql SELECT COUNT(*) FROM web WHERE changed = NOW()-60; +--+ | COUNT(*) | +--+ | 364119 | +--+ 1 row in set (7.46 sec) Hope someone can shed some light for me ;-) K.R., Sebastiaan Kamp
Re: How to make MySQL selfdeleting old entrys?
Unix: Create a cron job that executes a shell script to do it. Win: Create a scheduler job that runs a batch file. You should be able to write a generic SQL statement that deletes all records older than X time units. Your shell script/batch file should call mySql and pump the script into it. (i.e. mysql myscript.sql ) Don't forget to put a USE statement at the top of your SQL script! :) Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Jemand [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 7:30 AM Subject: How to make MySQL selfdeleting old entrys? How can i set a date or a number of seconds/hours/minutes/days, after the date expired, that mysql deletes the entry. I want a entry that is only shown a week, after the wekk the entry should be deleted. Is there a way? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database MySQL: possible errors when using myisamchk and isamchk ?
The idea is to have backups. Backups of unchecked data are not useless. Backups of truncated data files are. People have lost data when the disk became full during isamchk, or the index had been crashed because it reached filesystem size limits. If you blow the data away with a failed [my]isamchk then backup the truncated files, what are you going to do? If no errors were reported, the backup was clean. If isamchk reports errors, and they were truely fixed, this backup is repairable, and the next one should be clean. The only time it should be an issue is if the check reports an error, and examination of your databases show that data has been lost. If this is the case you have the option to restore the unchecked files, and recheck with different options. Koen Gogne wrote: This is not a good idea I think, because when the check would report errors my backup would be useless ! the idea is to have clean backups, so I want to check before I do any backup and if necessary (when the check reports errors) restore the dammaged tables first. any other idea's ? regards Koen If you back them up before you check them, and the check blows up, you still have your backups. Koen Gogne wrote: hi, I'm trying to automate the back up of my MySQL databases, and before I perform my backup I check my tables using myisamchk and isamchk. When myisamchk and isamchk report errors I would like to catch that and maybe perform a restore operation. hence my question: what could go wrong when running myisamchk and isamchk and what could I get as error / warning messages ? Can I find a list of all the possible error messages ? for know I check the output of both myisamchk and isamchk for lines containing error and warning but I would like to search for more precise errormessages. Who can help me out ?` kind regards Koen Gogne [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Lower Level Visibility
wendorf, pat writes: I'm not entirely familiar with how the daemon stores these values for the entire database, but I'm guessing it's done in memory. Is it not possible to allocate storage for these values in memory for each table that has been opened?(they'd be removed once the table is destroyed, and not stored at all for temporary tables I guess). Another possibility might be to store the values in memory until the table is no longer in an open state (I'm assuming you don't flush and close the tables on every operation) and flush them to disk in the table closing code (hopefully reducing the latency of updating each time they change). I like the idea of having it saved on disk as it would allow for persistent values during outages, so long as the system as a whole doesn't take too much of a performance hit. What exactly is feature sponsoring? - Pat We have users with hundreds of thousands of permanent tables. Temporary tables are not a problem, they can be all in a single vector. Keeping it all just in memory could be memory-expensive, but it could be done that way too, if we give a calculation of how much memory per table would be required Feature sponsoring means that you would pay for this feature to be developed. This is not a feature that is planned in any of the future versions of MySQl, but if you pay for it -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with safe_myslqd
find / -name mysqld -print should tell you where it is. locate mysqld may work also. Guillaume Denizot wrote: I have installed mysql 3.23.39 on Linux Mandrake 8.0. I have created a database but today I can't execute safe_mysqld. Mysql tell me: The file /usr/local/mysql/libexec/mysqld doesn't exist or not executable. Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/safe_mysqld. The file /usr/local/mysql/libexec/mysqld doesn't exist (only /usr/local/mysql/lib and not libexec), but I have run this daemon before and I can't yet. Please help! Furthermore, how can I execute this daemon when the machine starts (I want that the daemon is running when we can choose a user: what file should I modified: initd,...). Thanks you... _ Le journal des abonnés Caramail - http://www.carazine.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php attachment.txt Content-Type: text/plain -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Full Text Search and Japanese
On Wed, 20 Jun 2001 15:22:22 -0700
"Ryan Knopp" [EMAIL PROTECTED] wrote:
I'm trying to use the Full text Search with the japanese language using
either doublebyte or singlebyte character. The problem is it doesn't
seem
to be working at all for any searches. I use a sql statement like this
one
select * from hdwkeywords where match (JAPANESE) against ('japanese
keyword')
Where the japanese keyword is either a singlebyte or doublebyte
character.
Now i can get this to work in english but not in japanese, is there
support
for it? Or did i forget to enable something or am i doing this
completely
wrong?
I installed from RPM. And has no problem in searching 2 bytes Japanese
font.
mysql select jusho from myuser where jusho like "%$BH,2&;R(B%" limit 5;
+--+
| jusho|
+--+
| $BH,2&;R(B |
| $BH,2&;R(B |
| $BH,2&;R(B |
| $BH,2&;R;T(B |
| $BH,2&;R;T(B |
+--+
5 rows in set (0.01 sec)
--bk
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
make install
I am trying to set up a server. When I try to run the file mysql_install_db I get the error message You need to do a 'make install' before exectuing the script. Does anyone know what I should do? Please help. Thanks. -Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compiling MySQL under Windows
Hi. Can anyone tell me how this [viz. compiling MySql on Windows] is done? There doesn't seem to be any documentation on how to do this under Windows, and when I tried running the make_all batch file, it didn't seem to work with my version of nmake. Does anyone have any guidance - what sofware do I need? [I have Visual Studio 6.] = Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: make install
Seems your installing on a Linux / Unix system... In te directory where your mySQL setup (such as mysql_install_db) is, run make install ... just type it at the command line. F.Y.I.: read 'man make' I am trying to set up a server. When I try to run the file mysql_install_db I get the error message You need to do a 'make install' before exectuing the script. Does anyone know what I should do? Please help. Thanks. -Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling MySQL 3.23.39 on HP-UX 11.00.
ok, good call :) Ran the mysql-test (it failed some), details below: FAILURES: $./mysql-test-run --force 2/dev/null | grep \[ fail \] rpl01 [ fail ] rpl04 [ fail ] rpl07 [ fail ] SKIPPED: $./mysql-test-run --force 2/dev/null | grep \[ skipped \] bdb [ skipped ] gemini [ skipped ] innodb [ skipped ] isolation [ skipped ] raid [ skipped ] sql-bench seems to require the Msql-MySQL modules - something I'm having trouble compiling at the moment due to (what seems like) a variation of the very well-known libgcc.a error. I'll continue banging my head against that wall, though. jack Sinisa Milivojevic wrote: Please run mysql-test and sql-bench in order to verify that all is working well. Please let us know the result. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems setting up
when using gui passes my whole address = '[EMAIL PROTECTED]' and I only need the user name sti to be sent therefore I get the message shown below. Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
MySQLDAC v.1.3.3
Hello Delphi/C++Builder developers, 1. MySQLDAC v.1.3.3 (MySQL Direct Access Components for Delphi/C++Builder) just released. Download: http://www.microolap.com/trials/md.zip 2. Support mail lists: http://www.microolap.com/newsletter.htm You are welcome! --- Best regards, Edward Smirnov microOLAP Technologies LLC mailto:[EMAIL PROTECTED] Delphi/C++ Builder DB Connectivity components for: mySQL- http://www.microolap.com/mysqldac.htm Sybase ASA - http://www.microolap.com/asadac.htm Sybase ASE - http://www.microolap.com/asedac.htm MS SQL - Coming soon! MySQLCentral - Coming soon! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug in Windows version 3.23.37
show tables returns only small letters tab1 , tab2 but in the database all tables are wir big letter Tab1, Tab2 the linux version works all right... but this ist a realy problem. that the reasan ,i think, that the revoke not works correkly If i set a Col - Right or a Tab Right , it doesn't hat any effect... so it do not work the same script with a linux server works perfektly.. in which Version is the problem done??
Creating the correct SQL statement
Hello, I am a little stumped on how to create the select statement that I need. I have a table of items, with a column called price, which contains a price in Spainish Pesetas. I have another table, with 1 record, that contains an 'exchange rate' to convert Pesetas to Pound Stirling. ( divide by approx 250) I want to select an item from my database and return the price in pounds, but I am getting stuck. My select statement needs to: Select an item from the 'items' table, select the price, divide the price by the number in the 'exchange' table. Can someone possibly give me any ideas?? (if I haven't confused you already!) ;-) Thanks in Advance Craig Atkins Web Developer Sire Technology Ltd. +44 (0) 1344 758700 http://www.sire.co.uk * This e-mail and its contents are confidential and are for the use of the intended recipient only. If you are not the intended recipient, please notify the sender immediately. The opinions, statements and thoughts expressed in this email are only those of the individual sender. *
password peculiarities
Lately, I have been suffering the winds of misfortune with respect to user AND root password acceptance. It seems I have granted the root password correctly finally, but to date, though the SQL syntax gets accepted for changing the user password, the user can not log in WITH the -p switch; she CAN, however, log in without a password. I don't like that, even if she is the ONLY person using that build and its host. None of this means anything without specifics, so here we go: I use mysqladmin shutdown to bring down the daemon and run safe_mysqld --skip-grant-tables then at the mysql prompt, I use set password for some-user@localhost = PASSWORD(some-new-password); and get an ok. But when root does a 'su - some-user' and tries to log in with the user's password, an access-denied error results. The last time I did this, it worked just fine, for some reason, but I have no confidence in the process because I have successfully done this three times, but at some point, the user calls me and says she can not get into the database, did I change anything? In each case, I have not. To date, the command 'mysqladmin -u some-user password foo' has yet to work, either. HELP? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Creating the correct SQL statement
Hi If I am right you can not do this in one move.. You can use temp tables to help thow Hope this helps a bit Simon -Original Message- From: Craig Atkins [mailto:[EMAIL PROTECTED]] Sent: 21 June 2001 15:48 To: '[EMAIL PROTECTED]' Subject: Creating the correct SQL statement Hello, I am a little stumped on how to create the select statement that I need. I have a table of items, with a column called price, which contains a price in Spainish Pesetas. I have another table, with 1 record, that contains an 'exchange rate' to convert Pesetas to Pound Stirling. ( divide by approx 250) I want to select an item from my database and return the price in pounds, but I am getting stuck. My select statement needs to: Select an item from the 'items' table, select the price, divide the price by the number in the 'exchange' table. Can someone possibly give me any ideas?? (if I haven't confused you already!) ;-) Thanks in Advance Craig Atkins Web Developer Sire Technology Ltd. +44 (0) 1344 758700 http://www.sire.co.uk * This e-mail and its contents are confidential and are for the use of the intended recipient only. If you are not the intended recipient, please notify the sender immediately. The opinions, statements and thoughts expressed in this email are only those of the individual sender. * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication doesn't maintain logs?
I hope I've merely misread instructions. I've successfully set up replication, a master to one slave. However, even though the slave was comfigured to maintain both a 'classic' update log, as well as a binary log, none of the stuff it's replicating are reflected in the logs. Said logs are created: slave1# ls -ld * -rw-r--r-- 1 mysqld mysqld 73 Jun 18 18:53 slave1-bin.001 -rw-r--r-- 1 mysqld mysqld 31 Jun 18 18:53 slave1-bin.index -rw-r--r-- 1 mysqld mysqld 69 Jun 18 18:53 slave1.001 But, this is after I imported an entire database via replication. Does anyone have any advice? My environment: slave1# uname -r -s FreeBSD 4.2-RELEASE slave1# /usr/local/libexec/mysqld -v /usr/local/libexec/mysqld Ver 3.23.36 for unknown-freebsdelf4.2 on i386 slave1# ps auxwwe -p `cat /var/mysqld/db/mysqld.pid` USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND mysqld 55910 0.0 2.5 26976 25644 p0 SMon06PM 26:31.02 MYSQL_TCP_PORT=3306 OLDPWD=/var/mysqld log_dir=/var/mysqld/log TMPDIR=/var/tmp PATH=/usr/local/bin:/usr/bin:/bin:/usr/sbin MYSQLD_DB=/var/mysqld/db UMASK=0644 DBI_HOST=localhost MYSQL_BASE_DIR=/usr/local PWD=/var/mysqld/supervise UMASK_DIR=0777 /usr/local/libexec/mysqld --language=/usr/local/share/mysql/english --port=3306 --pid-file=/var/mysqld/db/mysqld.pid --datadir=/var/mysqld/db --basedir=/var/mysqld/db/mysql --tmpdir=/var/tmp --exit-info --set-variable=max_connections=1000 --master-host=bmdb1.ops.about.com --master-user=repl --master-password=* --server-id=2 --log-bin=/var/mysqld/log/slave1-bin --log-update=/var/mysqld/log/slave1 -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Creating the correct SQL statement
Is there a way to relate the items table to the exchange table? i.e. does your item have an excahngeID? (probably not) Does you item have a FK relationship into a Vendor/Mfgr who has a FK into exchange? (this would make more sense.) If so, we can probably figure it out, If there is no way to relate item to exchange then you will need to either use @variables or temp tables. (I'd try @variables first, they are faster) HTH, Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Craig Atkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 9:48 AM Subject: Creating the correct SQL statement Hello, I am a little stumped on how to create the select statement that I need. I have a table of items, with a column called price, which contains a price in Spainish Pesetas. I have another table, with 1 record, that contains an 'exchange rate' to convert Pesetas to Pound Stirling. ( divide by approx 250) I want to select an item from my database and return the price in pounds, but I am getting stuck. My select statement needs to: Select an item from the 'items' table, select the price, divide the price by the number in the 'exchange' table. Can someone possibly give me any ideas?? (if I haven't confused you already!) ;-) Thanks in Advance Craig Atkins Web Developer Sire Technology Ltd. +44 (0) 1344 758700 http://www.sire.co.uk * This e-mail and its contents are confidential and are for the use of the intended recipient only. If you are not the intended recipient, please notify the sender immediately. The opinions, statements and thoughts expressed in this email are only those of the individual sender. * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: make install
That did not work. I am doing a clean install by following the instructions from http://www.mysql.com/doc/I/n/Installing_binary.html. Did I miss something? -Mike -Original Message- From: Sebastiaan J.A. Kamp [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 10:13 AM To: Michael Kirschenbaum; [EMAIL PROTECTED] Subject: Re: make install Seems your installing on a Linux / Unix system... In te directory where your mySQL setup (such as mysql_install_db) is, run make install ... just type it at the command line. F.Y.I.: read 'man make' I am trying to set up a server. When I try to run the file mysql_install_db I get the error message You need to do a 'make install' before exectuing the script. Does anyone know what I should do? Please help. Thanks. -Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: password peculiarities
At 10:54 AM -0400 6/21/01, Peter H. Burris wrote: Lately, I have been suffering the winds of misfortune with respect to user AND root password acceptance. It seems I have granted the root password correctly finally, but to date, though the SQL syntax gets accepted for changing the user password, the user can not log in WITH the -p switch; she CAN, however, log in without a password. I don't like that, even if Delete the entries in the user table that have an empty password, FLUSH PRIVILEGES, and try again. Also look for entries with a blank user name and a host value of %. Delete those, too, and FLUSH PRIVILEGES. she is the ONLY person using that build and its host. None of this means anything without specifics, so here we go: I use mysqladmin shutdown to bring down the daemon and run safe_mysqld --skip-grant-tables then at the mysql prompt, I use set password for some-user@localhost = PASSWORD(some-new-password); and get an ok. But when root does a 'su - some-user' and tries to log in with the user's password, an access-denied error results. The last time I did this, it worked just fine, for some reason, but I have no confidence in the process because I have successfully done this three times, but at some point, the user calls me and says she can not get into the database, did I change anything? In each case, I have not. To date, the command 'mysqladmin -u some-user password foo' has yet to work, either. HELP? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: any size limitation as to the size of a query statement?
On 21-Jun-01 Chris Petersen wrote:
Why not do something like:
my $q = DELETE FROM master WHERE master_id NOT IN (;
$q .= join(',', @masteridarray);
$q .= ')';
$dbi_dbh-do($q);
Though this will obviously fall into the same size limitations that you were
doing, but it should execute a lot faster, and be a bit smaller than your
example. (I don't have an answer for this, being rather new to the mysql
community myself).
here, @ids is the array, delete in chunks of 64:
while ( my(@id)= splice(@ids,0,64)) {
$qry=DELETE FROM master WHERE master_id in (.join(',',@id).);
SQLQuery($qry);
}
Adjust '64' as needed..
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How can I build a sequence table, please help!
Hello, We are using mysql 2.22.32 (yes antique, but ISPs) I need an sequence table. Every time a client reads, the value shall be incremented. A single row, integer value would be an ideal sequencen I think. CREATE TABLE sequence( id int4; ); now, is this the correct way to emulate a sequence in mysql? LOCK TABLES sequence WRITE; UPDATE sequence SET id=id+1; SELECT id FROM sequence; UNLOCK TABLES; This seems a bit clumsy to me. I already checked the manual but found no recommendat example. Thanks for any help Gunnar von Boehn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: replication doesn't maintain logs?
You need to have log-slave-updates in my.cnf On Thu, Jun 21, 2001 at 11:14:54AM -0400, Brian Reichert wrote: I hope I've merely misread instructions. I've successfully set up replication, a master to one slave. However, even though the slave was comfigured to maintain both a 'classic' update log, as well as a binary log, none of the stuff it's replicating are reflected in the logs. Said logs are created: slave1# ls -ld * -rw-r--r-- 1 mysqld mysqld 73 Jun 18 18:53 slave1-bin.001 -rw-r--r-- 1 mysqld mysqld 31 Jun 18 18:53 slave1-bin.index -rw-r--r-- 1 mysqld mysqld 69 Jun 18 18:53 slave1.001 But, this is after I imported an entire database via replication. Does anyone have any advice? My environment: slave1# uname -r -s FreeBSD 4.2-RELEASE slave1# /usr/local/libexec/mysqld -v /usr/local/libexec/mysqld Ver 3.23.36 for unknown-freebsdelf4.2 on i386 slave1# ps auxwwe -p `cat /var/mysqld/db/mysqld.pid` USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND mysqld 55910 0.0 2.5 26976 25644 p0 SMon06PM 26:31.02 MYSQL_TCP_PORT=3306 OLDPWD=/var/mysqld log_dir=/var/mysqld/log TMPDIR=/var/tmp PATH=/usr/local/bin:/usr/bin:/bin:/usr/sbin MYSQLD_DB=/var/mysqld/db UMASK=0644 DBI_HOST=localhost MYSQL_BASE_DIR=/usr/local PWD=/var/mysqld/supervise UMASK_DIR=0777 /usr/local/libexec/mysqld --language=/usr/local/share/mysql/english --port=3306 --pid-file=/var/mysqld/db/mysqld.pid --datadir=/var/mysqld/db --basedir=/var/mysqld/db/mysql --tmpdir=/var/tmp --exit-info --set-variable=max_connections=1000 --master-host=bmdb1.ops.about.com --master-user=repl --master-password=* --server-id=2 --log-bin=/var/mysqld/log/slave1-bin --log-update=/var/mysqld/log/slave1 -- Brian 'you Bastard' Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- My pid is Inigo Montoya. You killed -9 my parent process. Prepare to vi. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Fuzzy results from NOW()-... in select statement?
On 21-Jun-01 Sebastiaan J.A. Kamp wrote: As I tried to find out how many entries are written to a 'log' table in the past 10, 5, 2 and 1 minute(s), I got some odd results. Since I haven't been able to find any reason (NOW()-60) should result in something completely different from (NOW()-120), could somebody clarify what's going on here? 'changed' is a TIMESTAMP(14) field... mysql SELECT COUNT(*) FROM web WHERE changed = (NOW()-60); +--+ | COUNT(*) | +--+ | 363564 | +--+ 1 row in set (7.00 sec) mysql SELECT COUNT(*) FROM web WHERE changed = (NOW()-120); +--+ | COUNT(*) | +--+ | 38 | +--+ 1 row in set (8.27 sec) mysql SELECT COUNT(*) FROM web WHERE changed = NOW()-120; +--+ | COUNT(*) | +--+ | 37 | +--+ 1 row in set (6.40 sec) mysql SELECT COUNT(*) FROM web WHERE changed = NOW()-60; +--+ | COUNT(*) | +--+ | 364119 | +--+ 1 row in set (7.46 sec) Hope someone can shed some light for me ;-) run 'select NOW() -60' a couple of times become enlightend. Hint: DATE_SUB(NOW(), INTERVAL 1 MINUTE) Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Creating the correct SQL statement
On 21-Jun-01 Craig Atkins wrote: Hello, _ I am a little stumped on how to create the select statement that I need. _ I have a_table of items, with a column called price, which contains a price in Spainish Pesetas. I have another table, with 1 record, that contains an 'exchange rate' to convert Pesetas to Pound Stirling. ( divide by approx 250) I want to select an item from my database and return the price in pounds, but I am getting stuck. _ My select statement needs to: _ Select an item from the 'items' table, select the price, divide the price by the number in the 'exchange' table. _ Can someone possibly give me any ideas?? (if I haven't confused you already!) ;-) The classic conversion table (exchange): e_from e_to factor SPt UKL0.004 UKL SPt250.0 select (p.price * e.factor) from product as p, exchange as e where p.id='phoo' and e.e_from='Spt' and e.e_to='UKL' ; Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can I build a sequence table, please help!
Hallo Jason, my problem is that the mysql 'auto_increment' behaviour will increase the 'sequence' always to the maxnumber +1. We now have p.e. a table with customers. Every new customer will of course get a customer_id. We now have 2 different id_ranges. Some customers should get their id range a) 1-9 But some will get their id from range b) 100-999 The 'auto_increment' field is no help here. regards Gunnar On Don, 21 Jun 2001, Jason Burfield wrote: I'm not sure about a version that old, buy why not just do this: create table sequence( id int unsigned not null auto_increment primary key ); Then, just do: insert into sequence values(null); That will increment the number each time. -- Jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Upgrade
I currently have MySQL-3.23.38-1.i386.rpm installed and I want to upgrade to the new version 3.23.39 what steps or precautions should I take when doing this. Do I just download the new RPM and run a rpm -i MySQL-3.23.39-1.i386.rpm and thats it or is there more to it? Thanks Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: make install
I don't recall you identifying the file you are installing from, but it sounds like a source file, not a binary file. Michael Kirschenbaum wrote: That did not work. I am doing a clean install by following the instructions from http://www.mysql.com/doc/I/n/Installing_binary.html. Did I miss something? -Mike -Original Message- From: Sebastiaan J.A. Kamp [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 10:13 AM To: Michael Kirschenbaum; [EMAIL PROTECTED] Subject: Re: make install Seems your installing on a Linux / Unix system... In te directory where your mySQL setup (such as mysql_install_db) is, run make install ... just type it at the command line. F.Y.I.: read 'man make' I am trying to set up a server. When I try to run the file mysql_install_db I get the error message You need to do a 'make install' before exectuing the script. Does anyone know what I should do? Please help. Thanks. -Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: skip-resolve
Hello. This is (only) changeable when starting the server: /usr/sbin/mysqld --help [...] --skip-name-resolve Don't resolve hostnames. All hostnames are IP's or 'localhost' [...] Bye, Benjamin. On Thu, Jun 21, 2001 at 12:52:30PM +0200, [EMAIL PROTECTED] wrote: database Hi there I remember seeing somewhere that there is a way to skip resolution of names when conneting to the DB, can someone tell me how. I can't seem to find it in the manual. k - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: any size limitation as to the size of a query statement?
Thanks, Don. However, this is sort of the opposite of what we need. We
need to delete from master where master_id NOT IN the array. If we do that
in chunks, after the first chunk, we would have wiped out all of the records
outside the array.
It seems like with Chris's suggestion, along with Bill's suggestion about
the max_allowed_packet setting, we should be okay. However, if there are
still more ideas out there, I'd love to hear them!
Mark
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 8:46 AM
To: Chris Petersen
Cc: [EMAIL PROTECTED]; Mark A. Sharkey
Subject: Re: any size limitation as to the size of a query statement?
On 21-Jun-01 Chris Petersen wrote:
Why not do something like:
my $q = DELETE FROM master WHERE master_id NOT IN (;
$q .= join(',', @masteridarray);
$q .= ')';
$dbi_dbh-do($q);
Though this will obviously fall into the same size limitations
that you were
doing, but it should execute a lot faster, and be a bit smaller
than your
example. (I don't have an answer for this, being rather new to
the mysql
community myself).
here, @ids is the array, delete in chunks of 64:
while ( my(@id)= splice(@ids,0,64)) {
$qry=DELETE FROM master WHERE master_id in (.join(',',@id).);
SQLQuery($qry);
}
Adjust '64' as needed..
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrade
Mike Jimenez [EMAIL PROTECTED] writes: Do I just download the new RPM and run a rpm -i MySQL-3.23.39-1.i386.rpm and thats it or is there more to it? rpm -Uvh should be used instead of rpm -i, as this is an upgrade, not install (the vh is added to be more verbose). -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrade
On Thu, 21 Jun 2001, you wrote: I currently have MySQL-3.23.38-1.i386.rpm installed and I want to upgrade to the new version 3.23.39 what steps or precautions should I take when doing this. Do I just download the new RPM and run a rpm -i MySQL-3.23.39-1.i386.rpm and thats it or is there more to it? Try rpm -Uvh instead of rpm -i - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
constraint question
hi I am using mysql 3.23.29 under windows 2000.I have a table: create table raries( libID bigint NOT NULL AUTO_INCREMENT , lib_datsvrID bigint null, primary key (libID), constraint FK_LIBRAR_REF_584_DATASE foreign key (lib_datsvrID) references DataServers (datsvrID)) I want to know how to view the constraints defined for libraries. I have another question: i want to do a backup of my database using mysqldump. what's the syntax of mysqldump database (under windows) thanks for help cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connect mySQL with HTML or something
I need to know if there is a way to create a searchable database that returns results as a web page... As you can see, I'm just begining, so I would really apreciate an answer, even if it's short. Thanks! Laura Lía Marcello Web Development www.editorialargenta.com www.marketaxa.com www.newsbookonline.com Avda. Corrientes 1250 Piso 3º oficina F tel. 4382-9085 (rot) 1043 Capital Casilla Postal 233 suc. 12 (1412) Buenos Aires - Argentina - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Somebody kindly get me off this list
I have tried numerous methods as instructed in the mySQL listerserv e-mail to get off this list but am still on it. Can somebody help me out? I got 779 e-mails today. Thanks, Angela Gerald Clark wrote: I don't recall you identifying the file you are installing from, but it sounds like a source file, not a binary file. Michael Kirschenbaum wrote: That did not work. I am doing a clean install by following the instructions from http://www.mysql.com/doc/I/n/Installing_binary.html. Did I miss something? -Mike -Original Message- From: Sebastiaan J.A. Kamp [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 10:13 AM To: Michael Kirschenbaum; [EMAIL PROTECTED] Subject: Re: make install Seems your installing on a Linux / Unix system... In te directory where your mySQL setup (such as mysql_install_db) is, run make install ... just type it at the command line. F.Y.I.: read 'man make' I am trying to set up a server. When I try to run the file mysql_install_db I get the error message You need to do a 'make install' before exectuing the script. Does anyone know what I should do? Please help. Thanks. -Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: constraint question
just do: mysqldump options db_name db_name.sql Your database tables and contents will be dumped into db_name.sql Tylre - Original Message - From: ah [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 12:19 PM Subject: constraint question hi I am using mysql 3.23.29 under windows 2000.I have a table: create table ies( libID bigint NOT NULL AUTO_INCREMENT , lib_datsvrID bigint null, primary key (libID), constraint FK_LIBRAR_REF_584_DATASE foreign key (lib_datsvrID) references DataServers (datsvrID)) I want to know how to view the constraints defined for libraries. I have another question: i want to do a backup of my database using mysqldump. what's the syntax of mysqldump database (under windows) thanks for help cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connect mySQL with HTML or something
You'd probably be interested in PHP: www.php.net Tyler - Original Message - From: Laura Lía Marcello [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 12:03 PM Subject: Connect mySQL with HTML or something I need to know if there is a way to create a searchable database that returns results as a web page... As you can see, I'm just begining, so I would really apreciate an answer, even if it's short. Thanks! Laura Lía Marcello Web Development www.editorialargenta.com www.marketaxa.com www.newsbookonline.com Avda. Corrientes 1250 Piso 3º oficina F tel. 4382-9085 (rot) 1043 Capital Casilla Postal 233 suc. 12 (1412) Buenos Aires - Argentina - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: any size limitation as to the size of a query statement?
here, @ids is the array, delete in chunks of 64:
while ( my(@id)= splice(@ids,0,64)) {
$qry=DELETE FROM master WHERE master_id in (.join(',',@id).);
SQLQuery($qry);
}
I thought about this, too.. But Mark said that he needed to delete from the
table where the ID's don't match. If you break it into chunks, then you'd
end up deleting everything that doesn't match that first chunk, which kills
pretty much the entire table.
The other option would be to create a new field in the table, something like
dontdeleteme TinyInt Unsigned Not Null Default 0... Then use your splice
technique to do something like:
$dbh-do('UPDATE master SET dontdeleteme=0');
while ( my(@id)= splice(@ids,0,64)) {
$dbh-do(UPDATE master SET dontdeleteme=1 WHERE master_id in
(.join(',',@id).));
}
$dbh-do('DELETE FROM master WHERE dontdeleteme=1');
I have no idea if this is slower or not, but I do use a similar technique on
a client's database. Granted, that one is about 6800 records, not 68000.
But it's still another thought.
-Chris
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connect mySQL with HTML or something
On Thu, 21 Jun 2001, Laura La Marcello wrote: I need to know if there is a way to create a searchable database that returns results as a web page... As you can see, I'm just begining, so I would really apreciate an answer, even if it's short. Thanks! Yes, but the web page will more than likely be created by a second language, such as PHP or ASP. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AIX Compile with GCC
I am trying to get MySQL version 3.23.3x running on my AIX 4.3.3 system. I have tried the following: 1. Binary distributions from bull and mysql sites. I get problems with the readline shared libs on these distributions. I have the GCC versions of readline install. 2. Source compiled with GCC 2.95.3/G++ 2.95.2.1. I have tried all the configure options recommend in the docs but the server restarts every time I start a connection. Any suggestions? This E-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended only for the use of the Individual(s) named above. If you are not the intended recipient of this E-mail, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination or copying of this E-mail is strictly prohibited. If you have received this E-mail in error, please immediately notify us at (865) 374-4900 or notify us by E-mail at [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Startup Question
I have just installed Suse Linux 7.1 and I am trying to configure the mysql database on it. I new that I was going to be using mysql on this system so I set it up with its own filesystem. By default it is installed in /var/lib/mysql. in this directory is the ./mustang-bin.index and also ./mysql/most.frm however I am getting the error messages below when I try and start it. I have never had this problem before. Does anyone have any ideas. Thank you. Jason 010620 14:01:57 mysqld started ^G/usr/sbin/mysqld: File './mustang-bin.index' not found (Errcode: 13) 010620 14:01:57 Could not use mustang-bin for logging (error 13) 010620 14:01:57 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010620 14:01:57 mysqld ended 010620 14:08:45 mysqld started ^G/usr/sbin/mysqld: File './mustang-bin.index' not found (Errcode: 13) 010620 14:08:45 Could not use mustang-bin for logging (error 13) 010620 14:08:45 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010620 14:08:45 mysqld ended - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL MAX HPUX 11x depot file????
Hi I have installed/configured Oracle under HPUX, but thinking of moving to mySQL. But finding that a little difficult. First of all, document talks about (including throughout the Internet) a depot file (i.e. mysql.full) to be run with swinstall utility. But I have yet to find it. I want to install mySQL Max with support for BDB, but where's a hpuX binary? Secondly, documentation do not go to specific, but very generic. I strongly recommend working on OS specific documentation. I wouldn't mind working on HPUX specific doc (with right assistance from mySQL folks) Regards I __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Backing up raid tables
Well, I successfully solved our 2 gig file limit problem with RAID tables without too much hassle, despite a dearth of documentation. However, it has introduced another significant problem. It would seem mysqldump isn't smart enough to look for raided tables. Taking the server down to do nightly backups is a very unfavorable solutions with orders coming in globally at all times. Is there a) a way to get mysqldump to work with raided tables or b) another way to do tape backups while retaining file integrity and not taking mysqld down? Thanks, Age --- Adriano Age Manocchia [EMAIL PROTECTED] Cornell University AIM/Yahoo: BigRedWhat http://www.hockey.cornell.edu/age ICQ: 5962736 --- The capacity to blunder slightly is the real marvel of DNA. Without this special attribute, we would still be anaerobic bacteria, and there would be no music. -Lewis Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: any size limitation as to the size of a query statement?
On 21-Jun-01 Chris Petersen wrote:
here, @ids is the array, delete in chunks of 64:
while ( my(@id)= splice(@ids,0,64)) {
$qry=DELETE FROM master WHERE master_id in (.join(',',@id).);
SQLQuery($qry);
}
I thought about this, too.. But Mark said that he needed to delete from the
table where the ID's don't match. If you break it into chunks, then you'd
end up deleting everything that doesn't match that first chunk, which kills
pretty much the entire table.
I prolly wasn't too clear: @ids is the array of all non-matches.
i.e the list you want to delete ( i'm assuming id is the primary key).
@ids=GetArray(SELECT a.id
FROM master as a LEFT JOIN new_tbl as b ON a.id=b.id
WHERE b.id IS NULL);
The other option would be to create a new field in the table, something like
dontdeleteme TinyInt Unsigned Not Null Default 0... Then use your splice
technique to do something like:
$dbh-do('UPDATE master SET dontdeleteme=0');
while ( my(@id)= splice(@ids,0,64)) {
$dbh-do(UPDATE master SET dontdeleteme=1 WHERE master_id in
(.join(',',@id).));
}
;
Which is _exactly_ how i use it :
# Mark all active webmasters (traffic in the last month)
# without busting max_packet_size
my @ids=GetArray(SELECT distinct id from hits
WHERE hitdate = DATE_SUB(current_date, INTERVAL 1 MONTH));
SQLQuery(UPDATE webmaster set active=0);
while ( my(@id)= splice (@ids,0,64)) {
$qry=UPDATE webmaster set active=1
WHERE wmid in ( .join(',',@id).);
SQLQuery($qry);
}
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql installation from source
Hi, I have been trying to install mysql on my server for way too long now! my system specs are: intel i686, with linux 6.2 loaded. I think i once did get the installation to work almost correctly, or at least more correctly than it does now... the problem: when i compile/make etc., i get no errors at all, so...you may think...this is good! BUT, unfortunately every time i do this, there is no mysql.sock file in the /tmp/ directory...infact, it's nowhere on the system!!! why would this be the case? where is it? and why doesn't the setup create it? can someone PLEASE suggest what i can do...i'm out of ideas as to what could be causing this problem! Thanks in advance, Aditya Dhekney [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql installation from source
I think mysql.sock gets created once you start the server. Have you tried starting it and then looking in /tmp? Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Aditya Dhekney [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 2:19 PM Subject: mysql installation from source Hi, I have been trying to install mysql on my server for way too long now! my system specs are: intel i686, with linux 6.2 loaded. I think i once did get the installation to work almost correctly, or at least more correctly than it does now... the problem: when i compile/make etc., i get no errors at all, so...you may think...this is good! BUT, unfortunately every time i do this, there is no mysql.sock file in the /tmp/ directory...infact, it's nowhere on the system!!! why would this be the case? where is it? and why doesn't the setup create it? can someone PLEASE suggest what i can do...i'm out of ideas as to what could be causing this problem! Thanks in advance, Aditya Dhekney [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql installation from source
Could you list (exactly) what commands you are using to 'unpack', 'configure', 'build', and 'install' the distribution (which package have you downloaded ?) ?? - Original Message - From: Aditya Dhekney [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 12:19 PM Subject: mysql installation from source Hi, I have been trying to install mysql on my server for way too long now! my system specs are: intel i686, with linux 6.2 loaded. I think i once did get the installation to work almost correctly, or at least more correctly than it does now... the problem: when i compile/make etc., i get no errors at all, so...you may think...this is good! BUT, unfortunately every time i do this, there is no mysql.sock file in the /tmp/ directory...infact, it's nowhere on the system!!! why would this be the case? where is it? and why doesn't the setup create it? can someone PLEASE suggest what i can do...i'm out of ideas as to what could be causing this problem! Thanks in advance, Aditya Dhekney [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:Error/crash with InnoDB if table name = database name
Heikki, when you try to create the table test with type = innodb, does the server print into the error log or to the screen: Innobase: error: table test/test already exists in Innobase data dictionary Yes, indeed. I missed that line between all the stack backtrace output. If so, then you have probably created the table already in the InnoDB format and deleted the .frm file. But deleting the .frm file does not remove the table from the internal data dictionary of InnoDB. I don't think I ever deleted a single .frm file, but it's possible I deleted the whole database directory at some point. (Now if you have lost the .frm file you may have to create a new database and create an InnoDB table with the same name there so that you get an .frm file you can copy to your old database's 'test' directory. DROP TABLE looks first that the .frm file exists.) This doesn't seem to work for me: mysql create database dummy; Query OK, 1 row affected (0.00 sec) mysql create table dummy.test (x int) type=innodb; Query OK, 0 rows affected (0.00 sec) shell cp dummy/test.frm test mysql drop table test.test; Query OK, 0 rows affected (0.01 sec) mysql create table test.test (x int) type=innodb; ERROR 1005: Can't create table './test/test.frm' (errno: 2) Since there probably were other zombie entries left anyway, I decided to just re-create the InnoDB files. Good thing converting between table types is so easy. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql installation from source
-Original Message- From: Steve Brazill [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 3:38 PM To: Aditya Dhekney Cc: [EMAIL PROTECTED] Subject: Re: mysql installation from source Could you list (exactly) what commands you are using to 'unpack', 'configure', 'build', and 'install' the distribution (which package have you downloaded ?) ?? i'm using mysql-3.23.39.tar.gz these are the EXACT commands i used: tar -zxvf mysql-3.23.39.tar.gz cd mysql-3.23.39 CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -f no-exceptions -fno-rtti ./configure --prefix=/apps/mysql --enable-assembler -- with-mysqld-ldflags=-all-static make make install scripts/mysql_install_db chown -R root /apps/mysql/ chown -R mysql /apps/mysql/var chgrp -R mysql /apps/mysql/ /apps/mysql/bin/safe_mysqld --user=mysql (this is where i get the first error (mysqld ended) in my host.err file, i get this: 010621 15:11:40 mysqld started 010621 15:11:40 Can't start server: Bind on TCP/IP port: Address already in use 010621 15:11:40 Do you already have another mysqld server running on port: 3306 ? 010621 15:11:40 Aborting 010621 15:11:40 /apps/mysql/libexec/mysqld: Shutdown Complete 010621 15:11:40 mysqld ended BUT, when i run ps, mysqld is NOT listed...:( I get the check if tmp/mysql.sock exists error when i try to use mysqladmin tool. should i be concerned about the message that says to check tmp/mysql.sock? Thanks, Aditya - Original Message - From: Aditya Dhekney [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 12:19 PM Subject: mysql installation from source Hi, I have been trying to install mysql on my server for way too long now! my system specs are: intel i686, with linux 6.2 loaded. I think i once did get the installation to work almost correctly, or at least more correctly than it does now... the problem: when i compile/make etc., i get no errors at all, so...you may think...this is good! BUT, unfortunately every time i do this, there is no mysql.sock file in the /tmp/ directory...infact, it's nowhere on the system!!! why would this be the case? where is it? and why doesn't the setup create it? can someone PLEASE suggest what i can do...i'm out of ideas as to what could be causing this problem! Thanks in advance, Aditya Dhekney [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql installation from source
-Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 3:31 PM To: Aditya Dhekney; [EMAIL PROTECTED] Subject: Re: mysql installation from source I think mysql.sock gets created once you start the server. Have you tried starting it and then looking in /tmp? Cal yes, i've tried that...i think.. when i run: bin/safe_mysqld i get: [root@oddjob mysql]# Starting mysqld daemon with databases from /apps/mysql/var 010621 15:53:49 mysqld ended thanks again, aditya * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Aditya Dhekney [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 2:19 PM Subject: mysql installation from source Hi, I have been trying to install mysql on my server for way too long now! my system specs are: intel i686, with linux 6.2 loaded. I think i once did get the installation to work almost correctly, or at least more correctly than it does now... the problem: when i compile/make etc., i get no errors at all, so...you may think...this is good! BUT, unfortunately every time i do this, there is no mysql.sock file in the /tmp/ directory...infact, it's nowhere on the system!!! why would this be the case? where is it? and why doesn't the setup create it? can someone PLEASE suggest what i can do...i'm out of ideas as to what could be causing this problem! Thanks in advance, Aditya Dhekney [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql crashing under 100 user loads
I am having a problem with mysql. I am running a php web site that uses a (mysql Ver 11.15 Disturb 3.23.39 for pc-linux-gnu (i686))database. Whenever i get a load of about 100 simultaneous users, mysql begins to spawn D stat processes and the site dies. Everything works very well with smaller loads. I am running this on a Quad Proc HP LH4 with 1GB Ram (which isn't being touched much) running Slack ware 7.1 upgraded to kernel 2.4-efs Apache http/https any help would be greatly appreciated. here is a small sample of the spawned processes. root 104 0.0 0.0 1600 800 ?S12:04 0:00 /bin/sh ./bin/safe_mysqld -u mysql mysql 129 0.0 1.1 51632 10208 ? S12:04 0:00 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/mysq mysql 131 0.0 1.1 51632 10208 ? S12:04 0:00 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/ mysql 132 0.0 1.1 51632 10208 ? S12:04 0:00 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 133 0.0 1.1 51632 10208 ? S12:04 0:00 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 149 0.0 1.1 51632 10208 ? S12:05 0:11 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 152 0.0 1.1 51632 10208 ? S12:06 0:09 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 153 0.0 1.1 51632 10208 ? S12:06 0:11 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 154 0.0 1.1 51632 10208 ? S12:06 0:10 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 155 0.0 1.1 51632 10208 ? S12:06 0:10 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 156 0.0 1.1 51632 10208 ? D12:06 0:10 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 157 0.0 1.1 51632 10208 ? S12:06 0:11 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 158 0.0 1.1 51632 10208 ? S12:06 0:10 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 159 0.0 1.1 51632 10208 ? D12:06 0:11 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
gui
does enyone knows a GUI to use with mysql wich is verry friendly one? thanks advanced. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Somebody kindly get me off this list
Angela Neff wrote: I have tried numerous methods as instructed in the mySQL listerserv e-mail to get off this list but am still on it. Can somebody help me out? I got 779 e-mails today. Thanks, Angela Angela: It's not: Date: Thu, 11 Aug 1904 15:17:05 -0700 Might want to check on that. Van -- = Linux rocks!!! http://www.dedserius.com/ = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: gui
I like webmin. http://www.webmin.com phpMyAdmin is another good one, but I'm not sure where you can go to download it. alan On Thu, 21 Jun 2001 16:55:22 -0400, Ricardo Striquer Soares [EMAIL PROTECTED] wrote: does enyone knows a GUI to use with mysql wich is verry friendly one? thanks advanced. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Appalachian Technologies 240 Shadowline Drive Suite AA2 Boone, NC 28607 (p) 828.262.5598 (f) 828.262.5138 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: gui
For the Windows platform, have a look at urSQL -- http:/www.urbanresearch.com/ursql You might also want to have a look at the MySQL documentation (very friendly is a subjective and vague requirement): http://www.mysql.com/doc/n/o/node_17.html http://www.mysql.com/doc/S/E/SEC592.html On Thu, 21 Jun 2001, Ricardo Striquer Soares wrote: does enyone knows a GUI to use with mysql wich is verry friendly one? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql installation from source
You have some 'odd' options in your configuration line...Have you tried using a 'simple' configuration to see if it will buildproperly ? ./configure --prefix=/apps/mysqlAre you in the "/apps/mysql" directory when you run "mysql_install_db" ??(you should actually be typing "./bin/mysql_install_db" )If you're getting the message "Can't start server: Bind on TCP/IP port:Address already in use, Do you already have another mysqld server running onport: 3306" did you check to see if you DO have it running already ? (type"ps -ef | grep mysql" )I have attached my 'build' and 'configure' webdocs for MySQL. Thedirectory 'paths' will be different than yours, but the rest should coverwhat you should be doing... (I've never had a problembuilding/installing/running MySQL on any RedHat 6.2 system). Look closelyat the permission settings I use.- Original Message -From: "Aditya Dhekney" [EMAIL PROTECTED]To: "'Steve Brazill'" [EMAIL PROTECTED]; ,[EMAIL PROTECTED]Sent: Thursday, June 21, 2001 12:50 PMSubject: RE: mysql installation from source -Original Message- From: Steve Brazill [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 3:38 PM To: Aditya Dhekney Cc: [EMAIL PROTECTED] Subject: Re: mysql installation from source Could you list (exactly) what commands you are using to 'unpack', 'configure', 'build', and 'install' the distribution (which package haveyou downloaded ?) ?? i'm using mysql-3.23.39.tar.gz these are the EXACT commands i used: tar -zxvf mysql-3.23.39.tar.gz cd mysql-3.23.39 CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -f no-exceptions -fno-rtti"./configure --prefix=/apps/mysql --enable-assembler -- with-mysqld-ldflags=-all-static make make install scripts/mysql_install_db chown -R root /apps/mysql/ chown -R mysql /apps/mysql/var chgrp -R mysql /apps/mysql/ /apps/mysql/bin/safe_mysqld --user=mysql (this is where i get the first error (mysqld ended) in my host.err file, i get this: 010621 15:11:40 mysqld started 010621 15:11:40 Can't start server: Bind on TCP/IP port: Address alreadyin use 010621 15:11:40 Do you already have another mysqld server running onport: 3306 ? 010621 15:11:40 Aborting 010621 15:11:40 /apps/mysql/libexec/mysqld: Shutdown Complete 010621 15:11:40 mysqld ended BUT, when i run ps, mysqld is NOT listed...:( I get the "check if tmp/mysql.sock exists" error when i try to use mysqladmin tool. should i be concerned about the message that says to check tmp/mysql.sock? Thanks, Aditya - Original Message - From: "Aditya Dhekney" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 12:19 PM Subject: mysql installation from source Hi, I have been trying to install mysql on my server for way too long now!my system specs are: intel i686, with linux 6.2 loaded. I think i once did get the installation to work almost correctly, or at least more correctly than it does now... the problem: when i compile/make etc., i get no errors at all, so...you may think...this is good! BUT, unfortunately every time i do this, there isno mysql.sock file in the /tmp/ directory...infact, it's nowhere on the system!!! why would this be the case? where is it? and why doesn't the setup create it? can someone PLEASE suggest what i can do...i'm out of ideas as to what could be causing this problem! Thanks in advance, Aditya Dhekney [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: multiple indexes
Just a couple of questions regarding indexes... Can I have multiple indexes on the same column? Yes, but it's kind of pointless. Will this decrease performance when inserting? Yes. Can you create and remove indexes after the creation of the table? Yes. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: gui
check out mysqlfront. You can download it from download.com and it kicks some major ass.. Matt TrollBoy Wiseman Webmaster: Shoggoth.net Site Designer: phpslash.org The oldest and strongest emotion of mankind is fear, and the oldest and strongest kind of fear is fear of the unknown. -H.P. Lovecraft - Please do not resell my e-mail address to anyone or send me unsolicited e-mail - - Original Message - From: Ricardo Striquer Soares [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 4:55 PM Subject: gui does enyone knows a GUI to use with mysql wich is verry friendly one? thanks advanced. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: gui
Nope. On Thu, 21 Jun 2001 16:04:03 -0400, md [EMAIL PROTECTED] wrote: Is this the same alan cox who has been involved with the linux kernel for the last 5 years? Just checking... Mark Diener Alan Cox wrote: I like webmin. http://www.webmin.com phpMyAdmin is another good one, but I'm not sure where you can go to download it. alan On Thu, 21 Jun 2001 16:55:22 -0400, Ricardo Striquer Soares [EMAIL PROTECTED] wrote: does enyone knows a GUI to use with mysql wich is verry friendly one? thanks advanced. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Appalachian Technologies 240 Shadowline Drive Suite AA2 Boone, NC 28607 (p) 828.262.5598 (f) 828.262.5138 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Appalachian Technologies 240 Shadowline Drive Suite AA2 Boone, NC 28607 (p) 828.262.5598 (f) 828.262.5138 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(anonther) user permission problem
Hi fellow mysql'ers Here my simple problem I can connect to the mysql server host from any other host, but I cannot from the host with the mysql server. More detail Mysql 3.23.30-gamma (yea I know I need to update it) Example user is foo, password is bar Columns_priv, func, and host are empty In table user Hostuser password localhost foo7c9e0a41222752fa all priv's are Y % foo7c9e0a41222752fa '' %.mydomain.com foo7c9e0a41222752fa '' table db has in it hostdb user % test (empty) all priv's are Y % test\_% (empty)'' Database of interest is widget (not in the db table) From the same host the mysql server is on mysql -u foo -h localhost --password=bar widget ERROR 1045: Access denied for user: 'foo@localhost' (Using password: YES) From any other host (with the mysql client) I can connect -pete Pete Lancashire Unix Systems Administration Columbia Sportswear Co. Inc. [EMAIL PROTECTED] (503) 978-4713 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
CRASH with BDB Tables and replace into
Description: MySQL Crashes with BDB Tables and replace into in some cases How-To-Repeat: mysql create table test (sessionid varchar(80) not null primary key, sessionval blob, lastopen timestamp not null) type=bdb; Query OK, 0 rows affected (0.88 sec) mysql alter table test add index(lastopen); Query OK, 0 rows affected (1.50 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql replace into test values (asdf,asdf,now()); Query OK, 1 row affected (0.06 sec) mysql replace into test values (asdf,asdf,now()); ERROR 2013: Lost connection to MySQL server during query Problem persists with MySQL 3.23.39. Fix: When Using MyISAM instead there is no such problem Submitter-Id: submitter ID Originator:Thomas Stinner Organization: billiton internet services GmbH MySQL support: none Synopsis: MySQL CRASH with BDB - Tables and replace into Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.36 (Source distribution) Server: ./mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.36-log Protocol version10 Connection roedgen2.stinnux.de via TCP/IP TCP port3306 Uptime: 15 min 5 sec Threads: 1 Questions: 2 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.002 Environment: System: Linux krusty 2.4.3 #3 SMP Sat May 12 21:28:15 CEST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rwxr-xr-x 1 root root 4070406 Jul 30 2000 /lib/libc.so.6 -rw-r--r-- 1 root root 19185232 Jul 30 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jul 30 2000 /usr/lib/libc.so -rw-r--r-- 1 root root 2032004 Jul 29 2000 /usr/lib/libc-client.a lrwxrwxrwx 1 root root 20 Feb 19 2000 /usr/lib/libc-client.so - ./libc-client.so.4.7 -rwxr-xr-x 1 root root 668784 Jul 29 2000 /usr/lib/libc-client.so.4.7 Configure command: ./configure --prefix=/opt/mysql --without-bench --without-docs --with-extra-charsets=latin1,german1 --with-charset=german1 --with-berkeley-db --with-innobase --enable-assembler --with-mysqld-user=mysql --enable-thread-safe-client Perl: This is perl, version 5.005_03 built for i586-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql mod for apache
on my box, apache is compiled with dso support (and php many other mods). is there any way to bring in mysql support with out having to recompile apache or php. normally, i would just recompile php and everyone would be happy, but i'm running a cobalt xtr, and recompiling php breaks some of sun's proprietary software. thanks in advance. alan cox -- Appalachian Technologies 240 Shadowline Drive Suite AA2 Boone, NC 28607 (p) 828.262.5598 (f) 828.262.5138 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: gui
there is also a programme called JSPerm (JSP Enterprise relational manager) search for it on google... it's very good -Original Message- From: j.urban [mailto:[EMAIL PROTECTED]] Sent: 21 June 2001 10:36 To: Ricardo Striquer Soares Cc: mysql Subject: Re: gui For the Windows platform, have a look at urSQL -- http:/www.urbanresearch.com/ursql You might also want to have a look at the MySQL documentation (very friendly is a subjective and vague requirement): http://www.mysql.com/doc/n/o/node_17.html http://www.mysql.com/doc/S/E/SEC592.html On Thu, 21 Jun 2001, Ricardo Striquer Soares wrote: does enyone knows a GUI to use with mysql wich is verry friendly one? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: UPDATE with values from another table?
is it possible to update fields of a table with values taken from another table? Like this (illegal) command would do: UPDATE b SET b.v = a.v WHERE b.id = a.id; Not yet. Multi-table deletes/updates are planned for MySQL 4.0, AFAIK. Then I have to stick to the method I am currently using: Create a new table with the definition from b and use INSERT ... SELECT. Thanks for your answer, Jens - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AN AUTOMATED SIMPLE WAY TO EXPORT ACCESS 2K DATA TO MYSQL ?
I have made an Access 2000 application for a real-estate company. My client will be exportign his Access data in a MySql database which will produce dynamic HTML pages (with some scripting) in an ISP server. So, his data will be published at the Internet, this way. My client will need to just click a button (while he is in Internet) and the data be exported from his Access tables to the MySql server (he could also export the data to a local mysql database in his computer and then upload it to the ISP server, maybe a better way). I am trying to find out how to make this for him as simple as possible. I have downloaded DBTools 1.08, MyAccess (an add-in for Access 2000) and MySqlFront. I have tried DBTools and it works ok exporting Access table data to an empty MySql database (the 'MyAccess' add-in gets stuck, and i haven't tried MySqlFront yet). Initially, I set the Import wizard (of DBTools) to export data and structure. It exported all the tables, except some (maybe because of data type mapping inconsistencies, specifically with null date values in Access). I created those tables by hand and then I was able to export all the data to the empty mysql database that i had just created. I need to find an automated way for my client to export his data (probably with DBTools) with a simple click (either from inside Access or from an outside program). Can he just append only the new data to the mysql database, or he will have to re-export all the data (including the new ones), something i dont mind, anyway? I want to avoid to recreate all the tables each time. I would prefer to have an initial empty mysql database and each time export all the Access data (including the new ones) to a copy of this empty database (for the reason i referred before). So this updated mysql database would then be uploaded to the ISP server. Is there any way to do this automated thing? I was thinking about using a sort of automated task program but iam worried that this method will give me some trouble. I will appreciate any help. Vasilis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Upgrading MySQL on Windows Platform
Hi everyone, I'm kinda new with MySQL and I have a question about upgrading MySQL to a newer version on Windows 2000 OS. Is there any special command that I should run or should I just re-install the latest version 3.23.39. Will it overwrite the old version automatically while preserving all the tables and databases? Please help. Thanks. Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Somebody kindly get me off this list
on 6/21/01 16:04, Van at [EMAIL PROTECTED] wrote: Angela Neff wrote: I have tried numerous methods as instructed in the mySQL listerserv e-mail to get off this list but am still on it. Can somebody help me out? I got 779 e-mails today. Thanks, Angela Angela: It's not: Date: Thu, 11 Aug 1904 15:17:05 -0700 Might want to check on that. Van Angela, You may want to investigate these possible issues: *Are you sending your unsubscribe request from an email client that does not have the same email address that you are subscribed to the list under as its reply address? *Is your account on your email server one with several smtp aliases for your account, such as [EMAIL PROTECTED], [EMAIL PROTECTED], etc.? Servers like Exchange set a default reply address that may be causing your issue. Hope this helps, -- Barry C. Hawkins Systems Consultant, MCSE 4.0 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: (anonther) user permission problem -- hit send to fast
Forgot to add Can connect from a different host by using both the hostname and FQN, For example the name of the host with the mysql server is sparky. From sparky -h localhost -h sparky -h [EMAIL PROTECTED] All fail From another host both sparky and [EMAIL PROTECTED] let me in, and Of course, -h localhost fails. -pete Hi fellow mysql'ers Here my simple problem I can connect to the mysql server host from any other host, but I cannot from the host with the mysql server. More detail Mysql 3.23.30-gamma (yea I know I need to update it) Example user is foo, password is bar Columns_priv, func, and host are empty In table user Hostuser password localhost foo7c9e0a41222752fa all priv's are Y % foo7c9e0a41222752fa '' %.mydomain.com foo7c9e0a41222752fa '' table db has in it hostdb user % test (empty) all priv's are Y % test\_% (empty)'' Database of interest is widget (not in the db table) From the same host the mysql server is on mysql -u foo -h localhost --password=bar widget ERROR 1045: Access denied for user: 'foo@localhost' (Using password: YES) From any other host (with the mysql client) I can connect -pete Pete Lancashire Unix Systems Administration Columbia Sportswear Co. Inc. [EMAIL PROTECTED] (503) 978-4713 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: replication doesn't maintain logs?
No, this isn't spam. I was publicly thanking someone for advice given. :/ On Thu, Jun 21, 2001 at 08:25:37PM -, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: On Thu, Jun 21, 2001 at 08:53:31AM -0700, Ben Curtis wrote: You need to have log-slave-updates in my.cnf Ah! Thanks for the pointer; let me try that out... -- My pid is Inigo Montoya. You killed -9 my parent process. Prepare to vi. Cute .sig. :) -- Brian 'you Bastard' Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql
I am running mysql-3.23.39 and I can't get it to use the tmpdir I specify. Is there a minimum size it needs to be? - Gabe E. Nydick Project Manager ClubPhoto, Inc. P - 408.423.6611 F - 408.557.6799 - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Upgrading MySQL on Windows Platform
Yes, just stop the mysql service before you begin installation by running something like net stop mysql from a command prompt. Hi everyone, I'm kinda new with MySQL and I have a question about upgrading MySQL to a newer version on Windows 2000 OS. Is there any special command that I should run or should I just re-install the latest version 3.23.39. Will it overwrite the old version automatically while preserving all the tables and databases? Please help. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading MySQL on Windows Platform
At 14:32 21/06/2001 -0700, Martin Tunggorono wrote: Hi! Hi everyone, I'm kinda new with MySQL and I have a question about upgrading MySQL to a newer version on Windows 2000 OS. Is there any special command that I should run or should I just re-install the latest version 3.23.39. Will it overwrite the old version automatically while preserving all the tables and databases? Please help. Thanks. The databases aren't overwrite. However before to run the setup, in the today distribution delete the older share directory for the err files to be updated. This distribution should be changed by one identify by the mysql-3.23.39a-win.zip. However, is always a good safe to make the backup of the databases, to avoid problem outside of the setup program. Regards, Miguel Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Large Replace/Inserts Truncating.
Hi! We have started doing some rather large replace intos and inserts (~3MB) using a client written in C. However, these queries are truncating at around 100k. There is no error returend by the connection, but, the error log does have errors such as these: 010323 11:15:19 Aborted connection 45 to db: 'unconnected' user: 'root' host: `localhost' (Got timeout reading communication packets) The same occurs if I pipe the query directly to mysql from the command line. No error, but the data field only has about 100k of the data there before it just stops. The table looks like this: # MySQL dump 8.13 # # Host: localhostDatabase: reflectivity # # Server version3.23.35 # # Table structure for table 'measurement_extended_data' # CREATE TABLE measurement_extended_data ( content_typeID tinyint(3) unsigned NOT NULL default '0', contentID int(10) unsigned NOT NULL default '0', arrayID smallint(5) unsigned NOT NULL default '0', positionID mediumint(8) unsigned NOT NULL default '0', testID smallint(5) unsigned NOT NULL default '0', iteration smallint(5) unsigned NOT NULL default '0', test_locationID smallint(5) unsigned NOT NULL default '0', date_added int(10) unsigned NOT NULL default '0', added_by mediumint(8) unsigned NOT NULL default '0', data blob NOT NULL, PRIMARY KEY (content_typeID,contentID,arrayID,positionID,testID,iteration), KEY test_locationID (test_locationID), KEY testID (testID) ) TYPE=MyISAM; Smaller queries work fine. It's just when they seem to be over 1 or 2MB. /etc/my.cnf looks like this: # MySQL Configuration File # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] port= 3306 socket = /tmp/mysql.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=256M set-variable= max_allowed_packet=7096128 set-variable= thread_stack=128K set-variable= back_log=50 set-variable= max_connections=512 set-variable= tmp_table_size=15M set-variable= table_cache=6000 set-variable= sort_buffer=3584K set-variable= join_buffer=512K set-variable= connect_timeout=2 set-variable= record_buffer=1M set-variable= flush_time=900 set-variable= wait_timeout=300 [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [myisamchk] set-variable= key_buffer=32M set-variable= sort_buffer_size=48M As you can see we bumped up the max_allowed_packet because we were getting server has gone away errors. - Box is a 1Ghz XEON /w Redhat 7.2 and 1GB RAM - MySQL version is: 3.23.35 - Query is a fairly straight forward insert or replace into and is verified as clean. Am I missing a configuration directive? Is something else up? Thanks! Seth - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
what is the difference between, MDB and MySQL
Re: what is the difference between, MDB and MySQL
MySQL is a database just like others: Oracle (Oracle) SQL Server (Microsoft - for large systems) Access (Microsoft - for small systems) DB2(IBM) etc... MDB, as I know, is the termination (extension) given to a database generated by MS Access. For example: NorthWind.mdb (example provided by Microsoft when you install Access) Siomara From: Colin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: what is the difference between, MDB and MySQL Date: Wed, 20 Jun 2001 22:47:15 -0500 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GUI - again
Someone was asking about GUI's for mysql and I saw a number of responses. Unfortunately, in my case, mysql (on *nix) is limited to listening to requests only on localhost (security), so I can't use any of the windows clients. Are there any gnome front ends to mysql? I'm looking for something that I can run select queries with that don't wrap at column 80, with a spreadsheet like result list. Also, I'd like to be able to e-mail the occasional query result. Thank you. Regards, Rich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Database Schema
Hi, Can I generate my Database Schema from mySQL? How? TIA, Juan. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
