Re: Parsing text file into mysql database.
I'll give you an example, step-by-step.
I didn't do that kind of thing myself yet, so I had a look at the
manual. First, I discovered that mysql can take all kinds of
separators (I read that before, but forgot about it), so you
don't have to convert at all, as you can signal different
separators and delimiters to mysql.
To get a text file in the first place, I issued the following
command:
SELECT * INTO OUTFILE result.txt
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY ''
LINES TERMINATED BY \\n
FROM autoren;
Here you see already that you can specify exactly how you want
the records to be written. The result looked like this:
1,Werner Stürenburg,[EMAIL PROTECTED]
2,Priv. Doz. Dr. med. Th. Rommel,
3,Regina Steinkrauss,[EMAIL PROTECTED]
4,Uta Over,[EMAIL PROTECTED]
5,Paula da Silva,[EMAIL PROTECTED]
6,Friedhelm Splett,[EMAIL PROTECTED]
7,Kathrin und Eva Astl,[EMAIL PROTECTED]
8,Heidi Grieder Ulrich,[EMAIL PROTECTED]
9,Lena Scherling,[EMAIL PROTECTED]
10,Hardy Oelke,[EMAIL PROTECTED]
11,Elizabeth Wener,
12,Marianne Schwöbel,
13,Merten-Melching,
14,Dr. Otto Marré,
15,Taschen Verlag,[EMAIL PROTECTED]
Now let's reverse the process. I used phpMyAdmin to copy the
table autoren to autoren2, structure only (enter name + click).
Now I issued the command
LOAD DATA INFILE 'result3.txt' INTO TABLE autoren2
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY ''
LINES TERMINATED BY \\n;
again from phpMyAdmin. This populated the new table with those
values. Both tables are identical.
I did all this on my local Win system. If you do it on your
server, there are differences in syntax regarding the location of
your text file, residing either on your local machine or the
server. The latter is faster, as the data doesn't have to travel
across the phone line (it had to earlier to get there in the first
place), but you need the FILE priviledge in the user table to be
able to do that.
So if your text file is very large, I'd suggest you compress it,
transfer it to the server, decompress it and load from there -
make sure you have the file priviledge or else give it to
yourself in this case.
The advantage of this approach is that it is straightforward and
as fast as can be.
Kit Kerbel schrieb am Sonntag, 29. Juli 2001, 23:57:26:
I'm sorry, I'm kind of a newbie at what you are discussing about converting
to csv files. Could you explain the advantage of doing this as opposed to
other ways, if any. Thanks.
Original Message Follows
From: Werner Stuerenburg [EMAIL PROTECTED]
Reply-To: Werner Stuerenburg [EMAIL PROTECTED]
To: Kit Kerbel [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Parsing text file into mysql database.
Date: Sun, 29 Jul 2001 22:49:45 +0200
filter: mysql
I don't have the original post any more, but you will have some
kind of file where the records are lines and the fileds in the
record are separated by some kind of character, say tab or blank
or anything else, but you will know what.
So let's say the filename is $filename and the separator is $sep.
Then you read the content of the file into an array with
$content = file($filename);
Now the elements of the array are the records. You will have to
convert the separator into , to get csv style. There are several
styles to do that, for example
while(list($key, $val) = each($comment)) {
$content[$key] = str_replace($sep, ',', $val);
}
Now $content should be written to a file to feed to mysql. Well,
this is a common task, and there isn't a handy php function as
far as I know, so I wrote it myself (see below). With that
function, I don't have to think about all that mumbo jumbo and
get it right nevertheless:
stringToFile(implode(\n, $content), $filename_csv);
The implode function transforms the array to a string which can
be written to the file, glueing the rows together with \n (new
line) in this case.
function stringToFile($str, $filename, $mode=a){
$fp = fopen($filename,$mode);
$res = fwrite($fp, $str);
fclose($fp);
return $res;
}
Of course, I have written the reverse function, too:
function fileToString($filename, $sep=' ') {
return @implode($sep, @file($filename));
}
The @ insures that no error messages are shown. So this function
will return nothing if the file does not exist.
Kit Kerbel schrieb am Sonntag, 29. Juli 2001, 21:33:16:
I'm the original poster of the parsing text file into mysql database
note.
I am in need of some extra assistance on this topic. I kinda know
what's
going on here, but just need to see it to understand it, you know? So if
you could, extra assistance would be greatly appreciated.
Thanks,
Kit
Original Message Follows
From: Werner Stuerenburg [EMAIL PROTECTED]
Reply-To: Werner Stuerenburg [EMAIL PROTECTED]
To: Kit Kerbel [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Parsing text file into mysql
Re: Managing user db's (quotas)
On Sun, Jul 29, 2001 at 03:42:41PM -0600, Chris Cameron wrote: I sent this before, but it never made it.. Does anyone here have any advice on controlling the size of user databases? There's not a lot you can do about it today, short of (1) symlinks onto a filesystem with user quotas where the user owns the files, or (2) some program that actively monitors the size of the files and takes some action if/when it needs to. I've heard talk of symlinks before, anyone had any luck with that? The problem is that when a user goes over quota, they also stand a good chance of ending up with corrupt MySQL data or index files. The best solution would be to get some support built right into MySQL for doing it. But I don't think it's high on the priority list, and nobody has tried to sponsor such development. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 43 days, processed 340,219,856 queries (89/sec. avg) - 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: reindexing tables
What about issueing first drop index, then add index? Should do the job. Or repair table. What does check table or myisamchk say? shawn reed schrieb am Montag, 30. Juli 2001, 07:44:15: hi all, i apologize for the utterly newbie-ish question, but i've yet to find an answer to it after having spent quite some time searching mysql's web site (especially since half the links i click on now seem to be giving me 404 errors...) how does one reindex a table containing fulltext indexes? the reason i ask this is... a table that i had set up w/ fulltext indexes suddenly returns no rows when i perform a search on it... and it used to work just fine. everything i have read seems to be telling me to reindex the table.. and quite frankly that's the only thing i can think of doing since nothing else has changed that should be causing the searches to no longer function properly. any help would be appreciated. ~shawn - 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 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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: reindexing tables
i've tried simply re-creating the index as you suggested ... no luck. here's a brief summary of my situation: i developed an application on one server, after it was developed and ready to go live we started to move it to another server. after moving it i noticed my search function wasn't working... i fiddled around with the database quite a bit, with no luck. then i realized that the search function wasn't working on the development server either, and it had been working fine all along. that's what makes no sense to me at all. :( output from myisamchk on the development server is as follows: *** Checking MyISAM file: inventory Data records: 2 Deleted blocks: 5 myisamchk: warning: 1 clients is using or hasn't closed the table properly - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 - check data record references index: 4 - check data record references index: 5 - check data record references index: 6 - check data record references index: 7 - check data record references index: 8 - check data record references index: 9 - check data record references index: 10 - check data record references index: 11 - check data record references index: 12 - check record links MyISAM-table 'inventory' is usable but should be fixed *** i'm not real familiar with myisamchk so i'm not sure exactly what i need to do to repair this table, since it said it should be fixed. i also still have no clue why this search suddenly stopped working. =/ frustrated, ~shawn On Mon, 30 Jul 2001, Werner Stuerenburg wrote: What about issueing first drop index, then add index? Should do the job. Or repair table. What does check table or myisamchk say? shawn reed schrieb am Montag, 30. Juli 2001, 07:44:15: hi all, i apologize for the utterly newbie-ish question, but i've yet to find an answer to it after having spent quite some time searching mysql's web site (especially since half the links i click on now seem to be giving me 404 errors...) how does one reindex a table containing fulltext indexes? the reason i ask this is... a table that i had set up w/ fulltext indexes suddenly returns no rows when i perform a search on it... and it used to work just fine. everything i have read seems to be telling me to reindex the table.. and quite frankly that's the only thing i can think of doing since nothing else has changed that should be causing the searches to no longer function properly. any help would be appreciated. ~shawn - 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
Update with WHERE from multiple tables
Here are some table definitions:
CREATE TABLE x10_device_types
(
device_typename VARCHAR(20) NOT NULL,
respondstoalloff enum('TRUE','FALSE') NOT NULL,
respondstoalllightson enum('TRUE','FALSE') NOT NULL,
respondstoalllightsoff enum('TRUE','FALSE') NOT NULL,
respondstoallunitsoff enum('TRUE','FALSE') NOT NULL,
dimmable enum('TRUE','FALSE') NOT NULL,
device_category VARCHAR(20) NOT NULL
);
CREATE TABLE x10_devices
(
device_name VARCHAR(25) NOT NULL,
device_typename VARCHAR(20) NOT NULL,
location_name VARCHAR(25) NOT NULL,
x10_housecode CHAR(1) NOT NULL,
x10_unitcode TINYINT unsigned NOT NULL,
x10_dev_description VARCHAR(75),
lastknownstate TINYINT unsigned
);
What I'm trying to do is to set the lastknownstate to 0 for all devices in
x10_housecode='A' where they respond to
respondstoallunitsoff and have a device_category='Module'.
I can't figure out how to do this because the update criteria spans 2 tables and
I don't have views. I tried the following, but it doesn't like my listing of
2 tables after the update. Any ideas?
mysql update x10_devices,x10_devicetypes set lastknownstate=16 where
x10_devices.device_typename=x10_device_types.device_typename and
x10_device_types.respondstoalloff and x10_device_types.device_category='Module'
and x10_housecode='A';
Steve
-
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 problems
Hi, A simple fix for this is to search for -lmysqlclient in PHP_DIR/config_vars.mk and replace it with -lmysqlclient -lz After that, you will need to run make again make install. Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Tom Cruickshank [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 29, 2001 5:21 PM To: [EMAIL PROTECTED] Subject: make problems Hello, I am not sure if this is the right mailing list but since it's a mysql related problem, I thought I'd give it a shot.. I am installing apache on my linux box with php4 capabilities. When I configured php4 I added the mysql option...in short..something like this... gunzip apache_1.3.x.tar.gz tar xvf apache_1.3.x.tar gunzip php-x.x.x.tar.gz tar xvf php-x.x.x.tar cd apache_1.3.x ./configure --prefix=/www cd ../php-x.x.x ./configure --with-mysql=../mysql --with-apache=../apache_1.3.x --enable-track-vars make make install cd ../apache_1.3.x ./configure --activate-module=src/modules/php4/libphp4.a make unfortunately, when I try make in apache, I get to this error gcc -c -I./os/unix -I./include -DLINUX=22 -I/usr/share/apps/php-4.0.6 -I/usr/share/apps/php-4.0.6/main -I/usr/share/apps/php-4.0.6/main -I/usr/share/apps/php-4.0.6/Zend -I/usr/share/apps/php-4.0.6/Zend -I/usr/share/apps/php-4.0.6/TSRM -I/usr/share/apps/php-4.0.6/TSRM -I/usr/share/apps/php-4.0.6 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` modules.c gcc -c -I./os/unix -I./include -DLINUX=22 -I/usr/share/apps/php-4.0.6 -I/usr/share/apps/php-4.0.6/main -I/usr/share/apps/php-4.0.6/main -I/usr/share/apps/php-4.0.6/Zend -I/usr/share/apps/php-4.0.6/Zend -I/usr/share/apps/php-4.0.6/TSRM -I/usr/share/apps/php-4.0.6/TSRM -I/usr/share/apps/php-4.0.6 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` buildmark.c gcc -DLINUX=22 -I/usr/share/apps/php-4.0.6 -I/usr/share/apps/php-4.0.6/main -I/usr/share/apps/php-4.0.6/main -I/usr/share/apps/php-4.0.6/Zend -I/usr/share/apps/php-4.0.6/Zend -I/usr/share/apps/php-4.0.6/TSRM -I/usr/share/apps/php-4.0.6/TSRM -I/usr/share/apps/php-4.0.6 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci`\ -o httpd buildmark.o modules.o modules/standard/libstandard.a modules/php4/libphp4.a main/libmain.a ./os/unix/libos.a ap/libap.a lib/expat-lite/libexpat.a -Wl,-rpath,/usr/share/apps/mysql/lib -rdynamic -L/usr/share/apps/mysql/lib -Lmodules/php4 -L../modules/php4 -L../../modules/php4 -lmodphp4 -lpam -ldl -lmysqlclient -lcrypt -lresolv -lm -ldl -lnsl -lresolv -lm -lcrypt /usr/share/apps/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x9a): undefined reference to `uncompress' /usr/share/apps/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12a): undefined reference to `compress' collect2: ld returned 1 exit status make[2]: *** [target_static] Error 1 make[2]: Leaving directory `/usr/share/apps/apache_1.3.20/src' make[1]: *** [build-std] Error 2 make[1]: Leaving directory `/usr/share/apps/apache_1.3.20' make: *** [build] Error 2 [root@test apache_1.3.20]# Would anyone have any ideas! Thanks! Sincerely, Tom Cruickshank - 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
push subscription with MS SQL and mySQL?
Hello, I spent the last days with searching a solution for the following problem: We have to synchronise an MS SQL database in the USA with a mySQL database in germany. The programmer who supports the database in the USA likes to do that via a push-Subscription, which is an MS SQL feature (not a very save feature I read!?). So, my question is: Is there a way to do that with these different Databases? And if not: Is there another way to connect an MS SQL- to a mySQL database to Publish a Database from one server to another? I've searched Tutorials, Newsgroups and Mailinglist-Archives for many hours without finding a solution, so this list is my last chance. Please help, if you can. Best regards, Sebastian Frost Schulz interaktiv GmbH | Wandsbeker Allee 1 | 22041 Hamburg Fon +49 (40) 236 106 - 13 | Fax +49 (40) 236 106 - 15 Mail [EMAIL PROTECTED]
addition for manual section 24.5.1
I don't know where to send this to, so someone who knows please forward it to the appropriate address. 24.5.1 Common Problems with MySQL and PHP Error: Maximum Execution Time Exceeded You can alter this value on a per script basis as well by inserting the following statement: set_time_limit(800);//e.g., 800= number of seconds This is handy if the user isn't allowed to change php.ini directly, mostly the case on multiple user-machines, or when occasional long jobs have to be performed. The same holds true to the ram allowed per script figure: ini_set(memory_limit, 16M); -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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
howto insert an image as blob?
hello, plz can someone tell me howto insert an image as blob into a table. i have created a table with a blob column, but i dont know how to fill it with binary data like pictures e.g.. thx bastian - 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
howto insert an image as blob?
hello, plz can someone tell me howto insert an image as blob into a table. i have created a table with a blob column, but i dont know how to fill it with binary data like pictures e.g.. thx bastian - 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: driver problem
Uwe Heldt writes: Hi Venu, it ' s hard to send you sample code. The database access is coded over more then one class which dynamicly build sql statements. The only thing i know is, that first a simple select is performed. After that one update on the same table row and then a select again. Could id be that there is a lock on this row if the statements appear to quickly? What does means Communication Link failure in this context? Thanks Uwe To answer you shortly : No, it is not possible that there is a lock on the row. If you use MyISAM tables, then you should know that there are no row locks in MyISAM. Second, we need a full test case, including tables and code in order to fix a bug, if there is any. Communication ... error may come up if there was an incongruency in code sequence. This can happen if all rows from result set have not been fetched and you have issued another query. In that case that is an error in application code. -- 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: Unable to use shortcut keys
Oh Junhui writes: Hi, Many many thanks to all who had replied. I tried using mysqlc.exe but windows complained that a .dll file was required, CYGWINB19.dll file not found. Thanks in advance. JH cygwin.dll is packaged with our Win32 distro. All you have to do is to place it in DLL directory. -- 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: Parsing text file into mysql database.
Well, you can't do that with LOAD DATA INFILE.
You will have to write some piece of code for that. Like so...
$content = file($filename);
while(list($key, $val) = each($content)) {//sorry,
//I had a typo in here in my prev. post
$content[$key] = do_some_error_checking($val);
}
with some do_some_error_checking function
or
while(list($key, $val) = each($content)) {
if (do_some_error_checking($val)){
$correct_content[] = $val;
}
}
and then work with $correct_content. Once you are at it, why
don't you
while(list($key, $val) = each($content)) {
if (do_some_error_checking($val)){
insert_my_data_into_table($val);
}
}
with the appropriate insert_my_data_into_table function, where
your do_some_error_checking will return true or false only.
You would get faster and better answers if you would provide as
much info on your problem as possible. Don't hesitate to provide
sample code and/or data - it is easy to skip text but impossible
to imagine missing information.
Kit Kerbel schrieb am Montag, 30. Juli 2001, 09:58:49:
Sorry, last time. I previously was using the LOAD DATA INFILE... line of
code. My problem consists of having to cycle through each individual entry
into the table to do error checking to check for existing users, etc.
Thanks,
Kit
Original Message Follows
From: Werner Stuerenburg [EMAIL PROTECTED]
Reply-To: Werner Stuerenburg [EMAIL PROTECTED]
To: Kit Kerbel [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Parsing text file into mysql database.
Date: Mon, 30 Jul 2001 08:56:47 +0200
I'll give you an example, step-by-step.
I didn't do that kind of thing myself yet, so I had a look at the
manual. First, I discovered that mysql can take all kinds of
separators (I read that before, but forgot about it), so you
don't have to convert at all, as you can signal different
separators and delimiters to mysql.
To get a text file in the first place, I issued the following
command:
SELECT * INTO OUTFILE result.txt
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY ''
LINES TERMINATED BY \\n
FROM autoren;
Here you see already that you can specify exactly how you want
the records to be written. The result looked like this:
1,Werner Stürenburg,[EMAIL PROTECTED]
2,Priv. Doz. Dr. med. Th. Rommel,
3,Regina Steinkrauss,[EMAIL PROTECTED]
4,Uta Over,[EMAIL PROTECTED]
5,Paula da Silva,[EMAIL PROTECTED]
6,Friedhelm Splett,[EMAIL PROTECTED]
7,Kathrin und Eva Astl,[EMAIL PROTECTED]
8,Heidi Grieder Ulrich,[EMAIL PROTECTED]
9,Lena Scherling,[EMAIL PROTECTED]
10,Hardy Oelke,[EMAIL PROTECTED]
11,Elizabeth Wener,
12,Marianne Schwöbel,
13,Merten-Melching,
14,Dr. Otto Marré,
15,Taschen Verlag,[EMAIL PROTECTED]
Now let's reverse the process. I used phpMyAdmin to copy the
table autoren to autoren2, structure only (enter name + click).
Now I issued the command
LOAD DATA INFILE 'result3.txt' INTO TABLE autoren2
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY ''
LINES TERMINATED BY \\n;
again from phpMyAdmin. This populated the new table with those
values. Both tables are identical.
I did all this on my local Win system. If you do it on your
server, there are differences in syntax regarding the location of
your text file, residing either on your local machine or the
server. The latter is faster, as the data doesn't have to travel
across the phone line (it had to earlier to get there in the first
place), but you need the FILE priviledge in the user table to be
able to do that.
So if your text file is very large, I'd suggest you compress it,
transfer it to the server, decompress it and load from there -
make sure you have the file priviledge or else give it to
yourself in this case.
The advantage of this approach is that it is straightforward and
as fast as can be.
Kit Kerbel schrieb am Sonntag, 29. Juli 2001, 23:57:26:
I'm sorry, I'm kind of a newbie at what you are discussing about
converting
to csv files. Could you explain the advantage of doing this as opposed
to
other ways, if any. Thanks.
Original Message Follows
From: Werner Stuerenburg [EMAIL PROTECTED]
Reply-To: Werner Stuerenburg [EMAIL PROTECTED]
To: Kit Kerbel [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Parsing text file into mysql database.
Date: Sun, 29 Jul 2001 22:49:45 +0200
filter: mysql
I don't have the original post any more, but you will have some
kind of file where the records are lines and the fileds in the
record are separated by some kind of character, say tab or blank
or anything else, but you will know what.
So let's say the filename is $filename and the separator is $sep.
Then you read the content of the file into an array with
$content = file($filename);
Now the elements of the array are the records. You will have to
convert the separator into , to get csv style. There are several
Re: howto insert an image as blob?
Do it like any other insert, but care for special characters. In php, you would wrap data with addSlashes() and remove them on retrieval with stripSlashes(). But... you better not insert images into a table. Yes, you can do it, but it is generally considered a bad idea. Read about it at http://www.bitbybit.dk/mysqlfaq/ - if the images have to be provided by users, use the upload functions of your system. php for example has upload support built in. Next you have to care for the appropriate write rights for those files. These can be handled safely without compromising system security. Store all data associated with the pictures in a table except the picture itself, which should be taken care of by the file sytem. [EMAIL PROTECTED] schrieb am Montag, 30. Juli 2001, 11:35:42: hello, plz can someone tell me howto insert an image as blob into a table. i have created a table with a blob column, but i dont know how to fill it with binary data like pictures e.g.. thx bastian - 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 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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
Antwort: Re: howto insert an image as blob?
first i would like to do it as you said. store the pictures outside the database. i develop jsp sites and my problem is that i dont know how to upload a file per jsp. i thought storing the pictures in mysql is the easier way to solve my problem. but if its not good to store binary data in the database directly if have to learn how to upload pictures via jsp : -) plz tell me if the following statement is correct (just for the fact i cant find a solution for the problem in jsp at once) insert into pictures (picturename,picturedata) values (testpicture, c: \temp\testpicture.gif); picturename is defined as char(50) - picturedatea is defined as blob thx for help bastian -- Externe MailWerner Stuerenburg [EMAIL PROTECTED] 30.07.200112:02 -- An: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Thema:Re: howto insert an image as blob? Do it like any other insert, but care for special characters. In php, you would wrap data with addSlashes() and remove them on retrieval with stripSlashes(). But... you better not insert images into a table. Yes, you can do it, but it is generally considered a bad idea. Read about it at http://www.bitbybit.dk/mysqlfaq/ - if the images have to be provided by users, use the upload functions of your system. php for example has upload support built in. Next you have to care for the appropriate write rights for those files. These can be handled safely without compromising system security. Store all data associated with the pictures in a table except the picture itself, which should be taken care of by the file sytem. [EMAIL PROTECTED] schrieb am Montag, 30. Juli 2001, 11:35:42: hello, plz can someone tell me howto insert an image as blob into a table. i have created a table with a blob column, but i dont know how to fill it with binary data like pictures e.g.. thx bastian - 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 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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
MySQLGUI for X
Dear Sir, Does a graphical sql client for MySQL exist that runs under X-Windows ? Many thanks, == Geoff Davis [EMAIL PROTECTED] (work) [ PGP key available on request ] [EMAIL PROTECTED] (home) +27-82-8705586 (mobile) +27-12-667-3622 (home) - 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: Antwort: Re: howto insert an image as blob?
On Mon, Jul 30, 2001 at 12:30:34PM +0200, [EMAIL PROTECTED] wrote: plz tell me if the following statement is correct (just for the fact i cant find a solution for the problem in jsp at once) insert into pictures (picturename,picturedata) values (testpicture, c: \temp\testpicture.gif); picturename is defined as char(50) - picturedatea is defined as blob No, you're just inserting the string c:\temp\testpicture.gif into the blob column. MySQL won't go out to the disk and fetch the image for you. You'll need to read it from disk yourself. -- Maurice Aubrey [EMAIL PROTECTED] Watch the costs and the profits will follow. - Andrew Carnegie MySQL 3.22.32: up 11.1 days, processed 766,672,358 queries (797/sec. avg.) - 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
MYISAMCHK
Hi, can someone clarify the myisamchk -R (to re-sort the table) parameters for me.. $ myisamchk -R shop_registration The value of the sort key is bigger than max key: 32. $ myisamchk -R shop_registration -O sort_key=31M The value of the sort key is bigger than max key: 32. I have tried several combinations or the following parameters, but cannot get it quite right Possible variables for option --set-variable (-O) are: key_buffer_size current value: 134213632 read_buffer_size current value: 2097144 write_buffer_size current value: 2097144 sort_buffer_size current value: 134217720 sort_key_blocks current value: 16 decode_bits current value: 9 thanks Andy - 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
ADO/ODBC question
Hi all quick question if I use a query such as the one below INSERT INTO usq (usq_id,usq_querystring) VALUES(NULL,'test'); SELECT LAST_INSERT_ID(); how do I push this two part query through an ADO command object and how do I get the variable back from the select part of the query... alternatively should I do it as a recordset update? code samples and/or advice would be gratefully received... cheers all and thanks for a lovely stable database Monty and the team Chris Dr Christopher Thorpe Information Architect GenomeBiology - biology for the post-genomic era w http://www.genomebiology.com t +44 (0) 20 7631 9184 (direct) - 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: MySQLGUI for X
[EMAIL PROTECTED] writes: Dear Sir, Does a graphical sql client for MySQL exist that runs under X-Windows ? Many thanks, == Geoff Davis [EMAIL PROTECTED] (work) [ PGP key available on request ] [EMAIL PROTECTED] (home) +27-82-8705586 (mobile) +27-12-667-3622 (home) Yes, there is such a version. Link to mysqlgui page is found on www.mysql.com. There are binaries for various Unix dialects. Choose the one that suits your workstation OS. As I see that you use Windows, you can download, install and use Windows binary too . -- 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
Special Deal This Week Only !!!
(This safeguard is not inserted when using the registered version) (This safeguard is not inserted when using the registered version)
Valuable information
Dear Friend: AS SEEN ON NATIONAL TV : ''Making over half million dollars every 4 to 5 months from your home for an investment of only $25 US Dollars expense one time'' THANKS TO THE COMPUTER AGE AND THE INTERNET! = BE A MILLIONAIRE LIKE OTHERS WITHIN A YEAR!!! Before you say ''Bull'', please read the following. This is the letter you have been hearing about on the news lately. Due to the popularity of this letter on the internet, a national weekly news program recently devoted an entire show to the investigation of this program described below, to see if it really can make people money. The show also investigated whether or not the program was legal. Their findings proved once and for all that there are ''absolutely NO laws prohibiting the participation in the program and if people can follow the simple instructions, they are bound to make some mega bucks with only $25 out of pocket cost''. DUE TO THE RECENT INCREASE OF POPULARITY RESPECT THIS PROGRAM HAS ATTAINED, IT IS CURRENTLY WORKING BETTER THAN EVER. This is what one had to say: ''Thanks to this profitable opportunity. I was approached many times before but each time I passed on it. I am so glad I finally joined just to see what one could expect in return for the minimal effort and money required. To my astonishment, I received total $ 610,470.00 in 21 weeks, with money still coming in''. Pam Hedland, Fort Lee, New Jersey. - Here is another testimonial: ''This program has been around for a long time but I never believed in it. But one day when I received this again in the mail I decided to gamble my $25 on it. I followed the simple instructions and viola' - 3 weeks later the money started to come in. First month I only made $240.00 but the next 2 months after that I made a total of $290,000.00. So far, in the past 8 months by re-entering the program, I have made over $710,000.00 and I am playing it again. The key to success in this program is to follow the simple steps and NOT change anything'' More testimonials later but first, PRINT THIS NOW FOR YOUR FUTURE REFERENCE $$$ If you would like to make at least $500,000 every 4 to 5 months easily and comfortably, please read the following...THEN READ IT AGAIN and AGAIN!!! $$$ FOLLOW THE SIMPLE INSTRUCTION BELOW AND YOUR FINANCIAL DREAMS WILL COME TRUE, GUARANTEED! INSTRUCTIONS: Order all 5 reports shown on the list below. For each report, send $5 CASH, THE NAME NUMBER OF THE REPORT YOU ARE ORDERING and YOUR E-MAIL ADDRESS to the person whose name appears ON THAT LIST next to the report. MAKE SURE YOUR RETURN ADDRESS IS ON YOUR ENVELOPE TOP LEFT CORNER in case of any mail problems. When you place your order, make sure you order each of the 5 reports.You will need all 5 reports so that you can save them on your computer and resell them. YOUR TOTAL COST $5 X 5 = $25.00. Within a few days you will receive, vie e-mail, each of the 5 reports from these 5 different individuals. Save them on your computer so they will be accessible for you to send to the 1,000's of people who will order them from you. Also make a floppy of these reports and keep it on your desk in case something happen to your computer. IMPORTANT __ DO NOT alter the names of the people who are listed next to each report, or their sequence on the list, in any way other than what is instructed below in step '' 1 through 6 '' or you will loose out on majority of your profits. Once you understand the way this works, you will also see how it does not work if you change it. Remember, this method has been tested, and if you alter, it will NOT work!!! People have tried to put their friends/relatives names on all five thinking they could get all the money. But it does not work this way. Believe us, we all have tried to be greedy and then nothing happened. So Do Not try to change anything other than what is instructed. Because if you do, it will not work for you. Remember, honesty reaps the reward!!! 1After you have ordered all 5 reports, take this advertisement and REMOVE the name address of the person in REPORT #5. This person has made it through the cycle and is no doubt counting their fortune. 2Move the name address in REPORT #4 down TO REPORT #5. 3Move the name address in REPORT #3 down TO REPORT #4. 4Move the name address in REPORT #2 down TO REPORT #3. 5Move the name address in REPORT #1 down TO REPORT #2 6Insert YOUR name address in the REPORT #1 Position. PLEASE MAKE SURE you copy every name address ACCURATELY! = Take this entire letter, with the modified list of names, and save it on your computer. DO NOT MAKE ANY OTHER CHANGES. Save this on a disk
Mysql Driver
Hi, I am trying to install a package in free bsd. and that package come with a perl file which checks the configuration.. when i run the perl file, it gives mysql driver not found. but i have installed mysql and am abel to login etc etc. what could be the problem? -- K.S.Selva Prakash Tachyon Technologies Pvt Ltd. - 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
strange myodbc problem
Hey there, Sorry for posting to this list, but I'm not so sure it's a myodbc problem exclusively. I am currently trying to get a mysql database to work with lotus approach. The plan is to port a current .dbf database over to mysql, and so far I have not had many problems. Until now. I am not sure if this is a myodbc problem or if it is a lotus approach ptoblem, but when i attempt to select all records from the database, a worksheet in approach will only display 80 records. I then change the MyODBC settings so that it will allow BIG results, with this set it will now display 240 records, but there are approx 890 records in the database, there seems to be some sort of limit on the number of records returned. This is very odd, and annoying, as I need to be able to view all records. Any help would be much appreciated. Conor - 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 Driver
Hi, I am trying to install a package in free bsd. and that package come with a perl file which checks the configuration.. when i run the perl file, it gives mysql driver not found. but i have installed mysql and am abel to login etc etc. what could be the problem? -- K.S.Selva Prakash Tachyon Technologies Pvt Ltd. - 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: space
ln -s /home/dbname /var/lib/mysql/dbname chown mysql:mysql /home/dbname -Original Message- From: Brian Thompson [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 29, 2001 4:55 PM To: [EMAIL PROTECTED] Subject: space I have my /var/ partition set to 400mb, but I need about 4 gigs for a mysql database im setting up how can I relocate the data files in the users /home directory, or how can I fix this? - 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
Security problem with 3.23.38
I've got a wierd problem with 3.23.38, built from source, running on RedHat v6.2 (Intel). Put simply the wildcard character for user access doesn't work. From my reading of the docs any of the following: grant all on mtdb.* to user1 identified by bozo1; grant all on mtdb.* to user2@% identified by bozo2; should allow the specified users access to the mtdb database from any host (assuming that they can input the password correctly!). Well - it doesn't work. Unless I GRANT for each user on each system that they are likely to use they can't get in and get error 1045 - access denied. Am I doing something terminally stupid, is there something wrong with my build, or is it a bug? Ta Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - 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-nt, missing files in the intel/windows distrib
Hello, I am working on a windows 2000 server, SP 1. Until now, I used mysql 3.23. 2? with no problem I just downloaded 3.23.39 max, I stop the mysql service, then I installed it in the same directory: c:\mysql Last, I tried to start again the service (so mysqld-nt.exe) But it doesn't want to start, with no error message Then, I used winmysqdadmin to change it to mysqld-max-nt. I tried also the mysqld-max-nt --remove mysqld-max-nt --install -- that works well but mysqld-max-nt doesn't show me anything, and mysql is not running. finally, I tried: mysqld-max-nt --standalone And I got: mysqld-max-nt: Fatal error: Error message file 'c:\mysql\share\english\errmsg.sy s' had only 198 error messages, but it should have at least 208 error messages. Check that the above file is the right version for this program! I checked the last time this file has been changed, and it was 6 months ago, so it seems that these files are missing in the binary? By the way, in the binary distribution, there is no mysqlbug program I would appreciate your help Stephane - 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: Security problem with 3.23.38
Robert Cross writes: I've got a wierd problem with 3.23.38, built from source, running on RedHat v6.2 (Intel). Put simply the wildcard character for user access doesn't work. From my reading of the docs any of the following: grant all on mtdb.* to user1 identified by bozo1; grant all on mtdb.* to user2@% identified by bozo2; should allow the specified users access to the mtdb database from any host (assuming that they can input the password correctly!). Well - it doesn't work. Unless I GRANT for each user on each system that they are likely to use they can't get in and get error 1045 - access denied. Am I doing something terminally stupid, is there something wrong with my build, or is it a bug? Ta Bob Cross. Hi! Try first granting USAGE on *.* to both users with 'identified by ...' and then try granting database rights. -- 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: Help required for OLEDB on win32 for MySQL(linux)
Asit, Did you ever solve your problem? - I have the same... Bruce -Original Message- From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]] Sent: Thu, 07 June 2001 21:42 To: asit; [EMAIL PROTECTED] Subject: Re: Help required for OLEDB on win32 for MySQL(linux) At 20:56 07/06/2001 +0530, asit wrote: Hi, Please take a look on the help file, where you should find that your connection string is wrong. You find the instructions of the connection string just below of Overview item. server=192.168.100.101 ? Regards, Miguel Hi, I am facing problem while connecting to MYSQL server (linux) from Win32 VB client through OLEDB provider from MYSQL. I am successfully connecting to server through MyODBC using DSN but unable to connect to through OLEDB provider ( downloaded from www.MYSQL.com) Following is the script in VB MySQL server is on 192.168.100.101 and database is Test . This is allowed to be connected from any IP and any user Private Sub Form_Load() Dim dcncentral As ADODB.Connection Set dcncentral = New ADODB.Connection Dim str1$ str1 = Provider=MySQLProv;Data Source=192.168.100.101;DB=Test dcncentral.Open str1- Giving Catastrophic Error End Sub This function is not opening the database and giving Catastrophic Error. What should be the connection string for database ? Please help. Kindly note that I want to connect to MYSQL database without a DSN Thanks in Advance Asit Saha -- 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 - 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: myvbql dll, help please!
Hi Stephen, I see no one answered this and I was away. Please check www.icarz.com/mysql/index.html for more documentation examples and an address to ask for help. Ken - Original Message - From: Stephen Sherlock [EMAIL PROTECTED] To: mySQL List [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 9:38 PM Subject: myvbql dll, help please! I've got the myvbql DLL for accessing a mySQL database directly from Visual Basic (6), however, after reading the documentation I'm still at a loss as to how to use this file since I've not had much experience with API. If anyone can help me learn how to run a simple mySQL query, displaying the result in a text box, I'd be very appreciative. Thanks in advance, Stephen Sherlock - 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: Security problem with 3.23.38
I wrote: I've got a wierd problem with 3.23.38, built from source, running on RedHat v6.2 (Intel). Put simply the wildcard character for user access doesn't work. From my reading of the docs any of the following: grant all on mtdb.* to user1 identified by bozo1; grant all on mtdb.* to user2@% identified by bozo2; should allow the specified users access to the mtdb database from any host (assuming that they can input the password correctly!). Well - it doesn't work. Unless I GRANT for each user on each system that they are likely to use they can't get in and get error 1045 - access denied. Mr. Sinisa Milivojevic replied: Try first granting USAGE on *.* to both users with 'identified by ...' and then try granting database rights. Thanks Sinisa, that works perfectly. I've now got a wonderful small and fast database that I can let the users into! Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - 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 3.23.40-Solaris8-Gcc3.0 error compiling with gemini
I'm trying to intall mysql 3.23.40 on Solaris 8 ( GCC 3.0 ) but I'm having a little difficulty. Whenever it gets to the gemini directory it errors out with the following: /usr/local/bin/gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../incl -I../msgs-O3 -DDBUG_OFF -O6 -DHAVE_CURSES_H -I/export/home6/temp/mysql-3.23.40/include -DHAVE_RWLOCK_T -c tmdoundo.c ../ctstset ctstset: Compile tstset.cc -- tstset.[c|s] -- tstset.o tstset.s: Assembler messages: tstset.s:43: Error: Unknown segment type tstset.s:43: Error: Rest of line ignored. First ignored character is `'. tstset.s:63: Error: Unknown segment type tstset.s:63: Error: Rest of line ignored. First ignored character is `'. -rw-r--r-- 1 root other 2252 Jul 27 13:39 tstset.c -rwxr-xr-x 1 root other 32426 Jul 27 13:39 tstset.cc -rw-r--r-- 1 root other897 Jul 30 08:42 tstset.s rm -f libdb.a ar cru libdb.a bkcheck.o bkcrashtest.o bkio.o bkiolk.o bkiotop.o bklog.o bkopen.o bkrec.o bkrepl.o bksubs.o bmapw.o bmbuf.o cx.o cxaux.o cxblock.o cxcompact.o cxdo.o cxfil.o cxgen.o cxkill.o cxky.o cxkyut.o cxmove.o cxnxt.o cxtag.o cxundo.o cxvsi.o db.o dbarea.o dbblob.o dbclose.o dbindex.o dblang.o dblksch.o dbobject.o dbopen.o dbquiet.o dbrecord.o dbtable.o dbuser.o dbwdog.o geminifromkey.o geminikey.o keysvc.o keyut.o ky.o kyut.o latctl.o lkmu.o lkrecd.o om.o omundo.o rec.o recformt.o recget.o recput.o rlai.o rlaiovl.o rlaoff.o rlcl.o rlmem.o rlnote.o rlrej.o rlrw.o rlset.o rltl.o rm.o rmdoundo.o semadm.o semmgr.o seqdundo.o seqgen.o shm.o shmatt.o shmcr.o shmdel.o shmpid.o shmptoq.o shmsiz.o stm.o tm.o tmdoundo.o tstset.o ar: tstset.o: No such file or directory make[4]: *** [libdb.a] Error 1 make[4]: Leaving directory `/export/home6/temp/mysql-3.23.40/gemini/db' make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory `/export/home6/temp/mysql-3.23.40/gemini' make[2]: *** [all-recursive-am] Error 2 make[2]: Leaving directory `/export/home6/temp/mysql-3.23.40/gemini' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/export/home6/temp/mysql-3.23.40' make: *** [all-recursive-am] Error 2 My config looks like this: ./configure \ --enable-static \ --disable-shared \ --with-raid \ --with-libwrap \ --without-debug \ --with-mysqld-ldflags=-all-static \ --without-docs \ --without-bench \ --with-charset=latin1 \ --with-berkeley-db \ --with-innodb \ --with-gemini Anyone know how to fix this? Thanks, -Mark - 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 Security
Hello. How can I made a Database secure by using an PHP Interface ? I Mean .If I use a PHP interface there are passwords included in the PHP config files in the directory that must be readable for all (755). If a user get access to the directory (FTP) he/she will read the password and then get access to the MySQL Databases. Is there a good way to protect the passwords ? Regards Claudemir F. Martins - 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 Security
Hi, You can 1. set the permissions to 700. 2. chown of the script to nobody/wwwuser or whoever is the user used for the daemon httpd. You need root access to do this. Petr Svacek - |[EMAIL PROTECTED] tel. +420606/422384 | |http://marian.fsik.cvut.cz/~svacek+4202/24357215 | |[EMAIL PROTECTED]| | | - On Mon, 30 Jul 2001, Claudemir F. Martins wrote: Hello. How can I made a Database secure by using an PHP Interface ? I Mean .If I use a PHP interface there are passwords included in the PHP config files in the directory that must be readable for all (755). If a user get access to the directory (FTP) he/she will read the password and then get access to the MySQL Databases. Is there a good way to protect the passwords ? Regards Claudemir F. Martins - 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
Innodb table size
Hello, I was wondering if someone could help me; When I load about 6Gb of raw data into a innodb table the size used by the table is about 14G. I noticed in preleminary tests that the sized used depends a lot on the number of rows in the case described above the data has about 180 millions rows, 4 columns and three keys on the first three columns. Does anyone know how to get a better ratio, something closer to 6-9Gb use. Thanks in advance. Xavier - 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
double quotes and single quotes
Hi, I have a problem with double quotes and single quotes in mysql command, if I let my user input the form data and it contains double quotes, the values cut off at the double quote. How to override the problem ?? Thank you Eric Chan - 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: Innodb table size
Lose (some of) the keys!? Keys, especially on small rows (where a key introduces a lot of overhead), can take a significant percentage of space. Turn on key compression? (dunno if innodb supports that) Other then that I wouldn't know. But live with the fact that keys introduce overhead. It will be like that on any database system. -Original Message- From: Xavier Leoncini [mailto:[EMAIL PROTECTED]] Sent: 30 July 2001 04:34 To: [EMAIL PROTECTED] Subject: Innodb table size Hello, I was wondering if someone could help me; When I load about 6Gb of raw data into a innodb table the size used by the table is about 14G. I noticed in preleminary tests that the sized used depends a lot on the number of rows in the case described above the data has about 180 millions rows, 4 columns and three keys on the first three columns. Does anyone know how to get a better ratio, something closer to 6-9Gb use. Thanks in advance. Xavier - 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
mysqld daemon ended on first connection
Hi, My server just crashed yesterday nite. After I got it up and running again, I couldn't get connection to MySQL database. Mysqld processes are checked and verified running upon booting up. But it just went dead after I tried to get a connection thru mysqladmin!! It just says error connecting to server at localhost. /etc/hosts has been checked and the entry for localhost is found in it MySQL version is 3.22.32 and is currently running on Redhat 6.2. What could be the possible reason? Could it be permission problems? I have already carried out a repairing and reindexing of the database tables but to no avail! Please help... Thanks, Darren
Building an application for accessing mysql
I'm new to mysql and I have to implement an app for accessing a mysql database. What works best, Java or Visual Basic ??? Thanks for any info Rui Mauro __ http://www.IOL.pt Todo o mundo passa por aqui! - 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: Innodb table size
Sander Pilon wrote: Lose (some of) the keys!? Keys, especially on small rows (where a key introduces a lot of overhead), can take a significant percentage of space. Turn on key compression? (dunno if innodb supports that) Other then that I wouldn't know. But live with the fact that keys introduce overhead. It will be like that on any database system. -Original Message- From: Xavier Leoncini [mailto:[EMAIL PROTECTED]] Sent: 30 July 2001 04:34 To: [EMAIL PROTECTED] Subject: Innodb table size Hello, I was wondering if someone could help me; When I load about 6Gb of raw data into a innodb table the size used by the table is about 14G. I noticed in preleminary tests that the sized used depends a lot on the number of rows in the case described above the data has about 180 millions rows, 4 columns and three keys on the first three columns. Does anyone know how to get a better ratio, something closer to 6-9Gb use. Thanks in advance. Xavier - 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 . To be more precise, I have a primary key defined on the first three columns, and I kind of do not have much choice on that. I am surprised by the overhead as innodb has clustered indexing defined on the primary key. A typical row is about 35 bytes. - 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 Security
On Mon, 30 Jul 2001, Claudemir F. Martins wrote: How can I made a Database secure by using an PHP Interface ? I Mean .If I use a PHP interface there are passwords included in the PHP config files in the directory that must be readable for all (755). snip Is there a good way to protect the passwords ? Somebody already suggested one way. Another way is to store your passwords in an included file which lives somewhere outside your www directory, such as $HOME/inc Another way is to use php-cgiwrap and chmod your scripts to 700. HTH David Mintz Spanish Interpreter US District Court, Southern District of New York Web Design Hosting http://www.dmintzweb.com/ Personal http://www.panix.com/~dmintz/ - 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
Availability of mysql/pam authentication module
Hello I would like to know what I need to do in order to have my passwd/shadow files in a Mysql database? Thanks Sachin - 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: [Compiler error for MySQL 3.23.40 - Forte C++ and Solaris X86]
Hi! [EMAIL PROTECTED] writes: Description: I'm comiling with GNU make and tar, and Forte C++ v6 r2. The compiler is current, as is the Solaris. My configuration line looks like: ./configure --prefix=/usr/local/mysql --with-innodb I'm getting the following errors when running the make command: cc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DUNDEF_THREADS_HACK -I./../includ e -I../include -I./.. -I.. -I.. -O -DDBUG_OFF -DHAVE_CURSES_H -I/usr/local/utili ties/mysql/v3.23.40/mysql-3.23.40/include -DHAVE_RWLOCK_T -c hash.c -KPIC -DPIC -o hash.o hash.c, line 186: reference to static variable hash_key in inline extern fun ction hash.c, line 226: cannot recover from previous errors The above is a bug in the Forte C++ compiler. A temporary workaround is to replace all 'inline' words to '' in mysys/hash.c Regards, Monty - 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: Rare crash
Hi! Sasha == Sasha Pachev [EMAIL PROTECTED] writes: cut 2) select bigblob where optimized_index_clause order by optimized_index_clause limit 6650,50 Problem: I used to think that since the start number is high in the limit, that it was slow because the data was not often used and therefore not cached (the second try at the query is fast). I think that is part right -- I think the problem is that MySQL starts using the data file (with the big blob) before it needs to. Ideally (and maybe MySQL does this) it should use the index file only until the where _and_ limit clauses are satisfied, then go get data from the data file. My gut tells be that MySQL is causing lots of the blob data to be read from disk even though it is not needed. I have the EXPLAIN below. Sasha I think you are right. The first workaround that comes to my head is to Sasha select all the matching values of the primary key into temp table, and then Sasha just perform a join. Monty may have some additional comments. Yes, Steven is right here Using a temporary table is also a workaround for this. To do a general solution for this is however not trivial for the general case. For example, if the 'optimized_index_clause' contains any column that is not part of the index, MySQL would have to retrieve the row (and the blob) from the data file anyway. In principle it would be possible to run with 'index only' until we have found 6550 rows from the table, but this would only work when you are not joining with another table with any join type other than 'eq_ref' (as in this case we have a hard time knowing when to switch on reading of rows). cut Regards, Monty - 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: Availability of mysql/pam authentication module
On Mon, Jul 30, 2001 at 11:19:42AM -0400, sachin shetty wrote: Hello I would like to know what I need to do in order to have my passwd/shadow files in a Mysql database? What did Google say? http://www.google.com/search?q=mysql+pam+authentication Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 44 days, processed 344,155,383 queries (89/sec. avg) - 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: double quotes and single quotes
On 7/30/01 7:38 AM, Mark Lo [EMAIL PROTECTED] wrote: Hi, I have a problem with double quotes and single quotes in mysql command, if I let my user input the form data and it contains double quotes, the values cut off at the double quote. How to override the problem ?? Thank you Eric Chan You could escape the the double quotes before sending them to mysql like so: $formdata =~ s//\/sg; #this is valid for perl Hope that helps. Hannes - 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_locking
I am working on Linux (Intel, SuSE 7.2 Pro.) And that's the question: Is it save to set skip_locking to OFF in order to make my cron job work (it is executing myisamchk on some tables)? With skip_locking set to ON I would have to make sure none is working on my tables (making some calls or using LOCK TABLE). Thanx for any suggestions, Luke - 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
FW: *** HELP *** mySQL connectivity problems
-Original Message-
From: SIMONIN Alexandre
Sent: Monday, July 30, 2001 2:41 PM
To: '[EMAIL PROTECTED]'
Subject: *** HELP *** mySQL connectivity problems
Hi,
I'm running mySQL 2.0.4 and Tomcat 4.0 on Cobalt/Linux. I'm using mm 2.0.4
When trying to get a connection to the database, I got the following error
(the code is provided below - exact id and password replaced for
confidentiality).
Step 1 : Class.forName(org.gjt.mm.mysql.Driver); OK
Step 2 :
getConnection(jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?
user=myIDpassword=myPwd); ***
FAILURE ***
SQLException: Cannot connect to MySQL server on
sherweb7.sherweb.com:3306.
Is there a MySQL server running on the machine/port you are
trying to connect to?
(java.security.AccessControlException)
SQLState: 08S01
VendorError: 0
Few comments:
1/ the mySQL server's site address is OK (not the localhost)
2/ the mySQL server's port is OK
3/ the table name is OK
4/ the userID is OK
5/ the password is OK
6/ the connection looks fine through phpMyAdmin
7/ I get the same java.security.AccessControlException when doing the same
request without the userID and password
8/ I got a java.net.ConnectException (which seems normal to me) when
trying to call the server as if it was local to my machine, i.e.:
jdbc:mysql:///myDatabase?user=myIDpassword=myPwd
9/ granting my id with all the privileges in mySQL doesn't do any good: I
can view all the tables through phpMyAdmin, but still cannot get a
connection.
Any suggestion?
The code:
try {
Class.forName(org.gjt.mm.mysql.Driver); // this or the
same.newInstance() does the same
System.out.println(Step1:
Class.forName(\org.gjt.mm.mysql.Driver\): OK);
}
catch (Exception e) {
System.out.println(Class.forName(\org.gjt.mm.mysql.Driver\): ***
FAILURE ***);
}
Connection myConn = null;
try {
myConn =
DriverManager.getConnection(jdbc:mysql://sherweb7.sherweb.com:3306/myData
base?user=myIDpassword=myPwd);
System.out.println(Step 2:
getConnection(\jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myI
Dpassword=myPwd\): OK);
}
catch (SQLException e) {
System.out.println(Step 2:
getConnection(\jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myI
Dpassword=myPwd\): *** FAILURE ***);
System.out.println( SQLException: +e.getMessage());
System.out.println( SQLState: +e.getSQLState());
System.out.println( VendorError: +e.getErrorCode());
}
-
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
Backup / Import Questions
Hi, I have built a database with 7 tables in it, the time has come when I need to create a suitable backup system so off I went to my manuals. I read through the mysqldump command and everything seemed straight forward. I ran the following... mysqldump -uroot -ppassword --opt Database file.mysql And it exported fine, I read through the file.mysql and everything was in there, all the tables and all the test data. I was happy but then I thought, well I better check I know how to use the data if something does go wrong. So I created a new database called 'testing' I read up on the mysqlimport and was suprised to see it tell me that all the tables need to be present before importing, I did try importing my file anyway just to double check and it did fail. So I have a couple of questions. Why does mysqldump allow you to dump all the table create data with the actual data if the import function doesnt allow you to use it? Because of this I assume the best method for backing up will be to dump all the table create commands and save the file somewhere and then back up each individual table's data regularly. Then if something did go wrong I can copy n paste my table create commands into SHH/Telnet and then run import on each of the table files. ??? Or am I just stupid and there is a much easier way to do all of this??? :-) TIA __ -Ade ~~Good things come to those who wait~~ - 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: *** HELP *** mySQL connectivity problems
Check the following link, which has the simple MyJDBC sample to connect to
MySQL server and to do some basic operations.
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80228:200107:popciohjmlbbolpak
ege
If you need any further assistance, please let us know.
Thanks in advance
venu
-Original Message-
From: SIMONIN Alexandre [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 9:33 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: FW: *** HELP *** mySQL connectivity problems
-Original Message-
From: SIMONIN Alexandre
Sent: Monday, July 30, 2001 2:41 PM
To: '[EMAIL PROTECTED]'
Subject:*** HELP *** mySQL connectivity problems
Hi,
I'm running mySQL 2.0.4 and Tomcat 4.0 on Cobalt/Linux. I'm
using mm 2.0.4
When trying to get a connection to the database, I got the
following error
(the code is provided below - exact id and password replaced for
confidentiality).
Step 1 : Class.forName(org.gjt.mm.mysql.Driver); OK
Step 2 :
getConnection(jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?
user=myIDpassword=myPwd); ***
FAILURE ***
SQLException: Cannot connect to MySQL server on
sherweb7.sherweb.com:3306.
Is there a MySQL server running on the machine/port you are
trying to connect to?
(java.security.AccessControlException)
SQLState: 08S01
VendorError: 0
Few comments:
1/ the mySQL server's site address is OK (not the localhost)
2/ the mySQL server's port is OK
3/ the table name is OK
4/ the userID is OK
5/ the password is OK
6/ the connection looks fine through phpMyAdmin
7/ I get the same java.security.AccessControlException when
doing the same
request without the userID and password
8/ I got a java.net.ConnectException (which seems normal to me) when
trying to call the server as if it was local to my machine, i.e.:
jdbc:mysql:///myDatabase?user=myIDpassword=myPwd
9/ granting my id with all the privileges in mySQL doesn't do
any good: I
can view all the tables through phpMyAdmin, but still cannot get a
connection.
Any suggestion?
The code:
try {
Class.forName(org.gjt.mm.mysql.Driver); // this or the
same.newInstance() does the same
System.out.println(Step1:
Class.forName(\org.gjt.mm.mysql.Driver\): OK);
}
catch (Exception e) {
System.out.println(Class.forName(\org.gjt.mm.mysql.Driver\): ***
FAILURE ***);
}
Connection myConn = null;
try {
myConn =
DriverManager.getConnection(jdbc:mysql://sherweb7.sherweb.com:3306/myData
base?user=myIDpassword=myPwd);
System.out.println(Step 2:
getConnection(\jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myI
Dpassword=myPwd\): OK);
}
catch (SQLException e) {
System.out.println(Step 2:
getConnection(\jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myI
Dpassword=myPwd\): *** FAILURE ***);
System.out.println( SQLException: +e.getMessage());
System.out.println( SQLState: +e.getSQLState());
System.out.println( VendorError: +e.getErrorCode());
}
-
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: Backup / Import Questions
mysqldump creates an 'SQL' script, which you 'run' to recreate the tables and data within them. Something like this should do the trick... mysql -u root -p password NewDataBaseName file.mysql - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 30, 2001 9:39 AM Subject: Backup / Import Questions Hi, I have built a database with 7 tables in it, the time has come when I need to create a suitable backup system so off I went to my manuals. I read through the mysqldump command and everything seemed straight forward. I ran the following... mysqldump -uroot -ppassword --opt Database file.mysql And it exported fine, I read through the file.mysql and everything was in there, all the tables and all the test data. I was happy but then I thought, well I better check I know how to use the data if something does go wrong. So I created a new database called 'testing' I read up on the mysqlimport and was suprised to see it tell me that all the tables need to be present before importing, I did try importing my file anyway just to double check and it did fail. So I have a couple of questions. Why does mysqldump allow you to dump all the table create data with the actual data if the import function doesnt allow you to use it? Because of this I assume the best method for backing up will be to dump all the table create commands and save the file somewhere and then back up each individual table's data regularly. Then if something did go wrong I can copy n paste my table create commands into SHH/Telnet and then run import on each of the table files. ??? Or am I just stupid and there is a much easier way to do all of this??? :-) TIA __ -Ade ~~Good things come to those who wait~~ - 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: *** HELP *** mySQL connectivity problems
Thanks,
But it doesn't help me finding out what the problem is (have a look at the
code below: it basically does the same as your example).
Let me just clarify: the application works all OK when mySQL runs on WinNT
and when I access to my files locally. The problem comes up when porting my
application to a Linux-based web server. The odd thing is that every
parameters seems to be OK (hostname, port, userID, password, etc.).
Another odd thing too is that I get a different exception (i.e.:
java.net.ConnectException) when trying to access the server as if it were
running on the same station as my java servlet (which is not the case): see
item 8/ below. I think I understand the exception I get in the case
describded in item 8/. I also understand why I get a different exception
when contacting the proper server on the proper port
(java.security.AccessControlException): so it seems that the code is going a
little further. But it also seems that it is a mySQL server error. What I
don't understand is why I get my connection refused when every parameters
are OK (and actually: I get the very same error when trying to access a
table wich doesn't exist, or a table which exists but for which I don't have
the proper rights, or the table to which I want to have access to (which
exists) but without providing the user or password).
I'm still looking for ideas...
-Original Message-
From: Venu A [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 6:46 PM
To: SIMONIN Alexandre; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Mysql. Com Java@Lists.
Subject: RE: *** HELP *** mySQL connectivity problems
Check the following link, which has the simple MyJDBC sample to connect to
MySQL server and to do some basic operations.
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80228:200107:popciohjmlbbolpak
ege
If you need any further assistance, please let us know.
Thanks in advance
venu
-Original Message-
From: SIMONIN Alexandre [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 9:33 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: FW: *** HELP *** mySQL connectivity problems
-Original Message-
From: SIMONIN Alexandre
Sent: Monday, July 30, 2001 2:41 PM
To: '[EMAIL PROTECTED]'
Subject:*** HELP *** mySQL connectivity problems
Hi,
I'm running mySQL 2.0.4 and Tomcat 4.0 on Cobalt/Linux. I'm
using mm 2.0.4
When trying to get a connection to the database, I got the
following error
(the code is provided below - exact id and password replaced for
confidentiality).
Step 1 : Class.forName(org.gjt.mm.mysql.Driver); OK
Step 2 :
getConnection(jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?
user=myIDpassword=myPwd); ***
FAILURE ***
SQLException: Cannot connect to MySQL server on
sherweb7.sherweb.com:3306.
Is there a MySQL server running on the machine/port you are
trying to connect to?
(java.security.AccessControlException)
SQLState: 08S01
VendorError: 0
Few comments:
1/ the mySQL server's site address is OK (not the localhost)
2/ the mySQL server's port is OK
3/ the table name is OK
4/ the userID is OK
5/ the password is OK
6/ the connection looks fine through phpMyAdmin
7/ I get the same java.security.AccessControlException when
doing the same
request without the userID and password
8/ I got a java.net.ConnectException (which seems normal to me) when
trying to call the server as if it was local to my machine, i.e.:
jdbc:mysql:///myDatabase?user=myIDpassword=myPwd
9/ granting my id with all the privileges in mySQL doesn't do
any good: I
can view all the tables through phpMyAdmin, but still cannot get a
connection.
Any suggestion?
The code:
try {
Class.forName(org.gjt.mm.mysql.Driver); // this or the
same.newInstance() does the same
System.out.println(Step1:
Class.forName(\org.gjt.mm.mysql.Driver\): OK);
}
catch (Exception e) {
System.out.println(Class.forName(\org.gjt.mm.mysql.Driver\): ***
FAILURE ***);
}
Connection myConn = null;
try {
myConn =
DriverManager.getConnection(jdbc:mysql://sherweb7.sherweb.com:3306/myData
base?user=myIDpassword=myPwd);
System.out.println(Step 2:
getConnection(\jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myI
Dpassword=myPwd\): OK);
}
catch (SQLException e) {
System.out.println(Step 2:
getConnection(\jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myI
Dpassword=myPwd\): *** FAILURE ***);
System.out.println( SQLException: +e.getMessage());
System.out.println( SQLState: +e.getSQLState());
System.out.println( VendorError: +e.getErrorCode());
}
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Re: Backup / Import Questions
Because the --opt option builds an output script of SQL commands that can be run to CREATE TABLES and INSERT data. You're on the right track, but using mysqlimport only makes sense based on the options that were used with mysqldump... Based on what you've done, you can re-create the entire database by running the 'file.mysql' as a script (you don't need mysqlimport in this case): mysql -uroot -ppassword TestDatabase file.mysql On Mon, 30 Jul 2001 [EMAIL PROTECTED] wrote: mysqldump -uroot -ppassword --opt Database file.mysql Why does mysqldump allow you to dump all the table create data with the actual data if the import function doesnt allow you to use 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
Help!!
Hello!! I need help to know where configure the users and passwords that can accesar to my databases, this in a Linux Net Hat 6.1 Thank you - 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
Privilege settings
Hi all, trying to figure out the relationship of the mysql User and db tables. Now when a database is created and privileges are assigned to the new db, the db table is updated and the user table is updated, but in the privilege columns of the user table, all are set to 'N' but the appropriate privileges are set to 'Y' in the db table for that particular database. Is there something I'm missing or doing wrong?? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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: Security problem with 3.23.38
Robert Cross writes: I wrote: Try first granting USAGE on *.* to both users with 'identified by ...' and then try granting database rights. Thanks Sinisa, that works perfectly. I've now got a wonderful small and fast database that I can let the users into! Bob Cross. You are welcome. -- 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: mysql 3.23.40-Solaris8-Gcc3.0 error compiling with gemini
Faine, Mark writes: I'm trying to intall mysql 3.23.40 on Solaris 8 ( GCC 3.0 ) but I'm having a little difficulty. Whenever it gets to the gemini directory it errors out with the following: /usr/local/bin/gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../incl -I../msgs-O3 -DDBUG_OFF -O6 -DHAVE_CURSES_H -I/export/home6/temp/mysql-3.23.40/include -DHAVE_RWLOCK_T -c tmdoundo.c ../ctstset ctstset: Compile tstset.cc -- tstset.[c|s] -- tstset.o tstset.s: Assembler messages: tstset.s:43: Error: Unknown segment type tstset.s:43: Error: Rest of line ignored. First ignored character is `'. tstset.s:63: Error: Unknown segment type tstset.s:63: Error: Rest of line ignored. First ignored character is `'. -rw-r--r-- 1 root other 2252 Jul 27 13:39 tstset.c -rwxr-xr-x 1 root other 32426 Jul 27 13:39 tstset.cc -rw-r--r-- 1 root other897 Jul 30 08:42 tstset.s Thanks, -Mark You could try disabling assembler, which is MySQL default on SPARC and x86. If that does not help, inform GCC people and try using InnoDB instead. -- 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: Innodb table size
Hi! Sorry, InnoDB does not have key compression. Every row has a 6-byte trx id, a 7-byte roll ptr, and a header of 6 bytes. In addition, every field uses 1 byte as a pointer to it. Calculating: 180 million x (6 + 7 + 6 + 2 + 4) bytes = 4.5 GB Since every page is filled only 15/16 full even if rows are inserted in an ascending order, there will be some additional overhead. Did you insert the rows in the ascending order of the primary key? That is the most space-efficient way, since with random inserts pages will only be about 70 % full. Regards, Heikki http://www.innodb.com Copied message: .. Lose (some of) the keys!? Keys, especially on small rows (where a key introduces a lot of overhead), can take a significant percentage of space. Turn on key compression? (dunno if innodb supports that) Other then that I wouldn't know. But live with the fact that keys introduce overhead. It will be like that on any database system. -Original Message- From: Xavier Leoncini [mailto:[EMAIL PROTECTED]] Sent: 30 July 2001 04:34 To: [EMAIL PROTECTED] Subject: Innodb table size Hello, I was wondering if someone could help me; When I load about 6Gb of raw data into a innodb table the size used by the table is about 14G. I noticed in preleminary tests that the sized used depends a lot on the number of rows in the case described above the data has about 180 millions rows, 4 columns and three keys on the first three columns. Does anyone know how to get a better ratio, something closer to 6-9Gb use. Thanks in advance. Xavier - 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 . To be more precise, I have a primary key defined on the first three columns, and I kind of do not have much choice on that. I am surprised by the overhead as innodb has clustered indexing defined on the primary key. A typical row is about 35 bytes. - 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
Backup of all Databases
Hello I took a look at the discussion of database backup, however I still have a doubt: I have 30 databases and I'd like to backup all databases at a time (including the mysql database). Is there a good way to backup all databases at a time ? To save the directory /var/lib/mysql which contain all databases, is a good idea for a backup ? Regards Claudemir F. Martins - 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: Privilege settings
Mike Blezien writes: Hi all, trying to figure out the relationship of the mysql User and db tables. Now when a database is created and privileges are assigned to the new db, the db table is updated and the user table is updated, but in the privilege columns of the user table, all are set to 'N' but the appropriate privileges are set to 'Y' in the db table for that particular database. Is there something I'm missing or doing wrong?? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Nope, you are not missing anything. There are four level of privileges in MySQL: - global - database - table - column It is important to know that privileges are OR'd not AND'd, so there are no problems with your setup. -- 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: Backup of all Databases
Greetings, If you have the hardware to spare, setup a replication server and run your backups against that server. It's clean, you can shutdown your database completely on the slave and perform backups however you want. I use it both at home and at work and get wonderful results. Hope that helps... Jeremy On Monday 30 July 2001 15:01, Claudemir F. Martins wrote: Hello I took a look at the discussion of database backup, however I still have a doubt: I have 30 databases and I'd like to backup all databases at a time (including the mysql database). Is there a good way to backup all databases at a time ? To save the directory /var/lib/mysql which contain all databases, is a good idea for a backup ? Regards Claudemir F. Martins - 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: Privilege settings
Ok, now I understand, the global would refer to the privileges set in the mysql db user table then,..correct?? :) and the privileges set in the db table are specific to that particular database. Sound right?? thanks trying to figure out the relationship of the mysql User and db tables. Now when a database is created and privileges are assigned to the new db, the db table is updated and the user table is updated, but in the privilege columns of the user table, all are set to 'N' but the appropriate privileges are set to 'Y' in the db table for that particular database. Is there something I'm missing or doing wrong?? On Mon, 30 Jul 2001 21:07:06 +0300, Sinisa Milivojevic [EMAIL PROTECTED] wrote: Nope, you are not missing anything. There are four level of privileges in MySQL: - global - database - table - column It is important to know that privileges are OR'd not AND'd, so there are no problems with your setup. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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 ODBC version to download?
Refer to: http://www.mysql.com/downloads/api-myodbc.html I am running Yellow Dog Linux on a Macintosh Power PC. This means, in practice, that the rpm:s I downloaded for MySQL had suffix *.ppc.rpm Now I am interested in fiddling about with ODBC and C++. Can I use any of the source distros above? Regards Tobias Bohlin - 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: Privilege settings
Mike Blezien writes: Ok, now I understand, the global would refer to the privileges set in the mysql db user table then,..correct?? :) and the privileges set in the db table are specific to that particular database. Sound right?? thanks Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Yes, global privs cover all databases on that server , database privs cover all tables in that database etc. -- 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: Help!!
On Mon, Jul 30, 2001 at 12:13:51PM -0500, Ivan Chavez wrote: I need help to know where configure the users and passwords that can accesar to my databases, this in a Linux Net Hat 6.1 Did you read the documentation or installation notes that came with MySQL? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 44 days, processed 345,277,149 queries (90/sec. avg) - 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-max-nt, missing files in the intel/windows distrib
At 15:09 30/07/2001 -0500, steph wrote: Hi, The 3.23.39 distribution was substituted by 3.23.39a because the setup program doesn't rewrite the share directory. That is the reason for your error message. To fix: stop the server, remove the share directory and run again the setup program. Regards, Miguel Hello, I am working on a windows 2000 server, SP 1. Until now, I used mysql 3.23. 2? with no problem I just downloaded 3.23.39 max, I stop the mysql service, then I installed it in the same directory: c:\mysql Last, I tried to start again the service (so mysqld-nt.exe) But it doesn't want to start, with no error message Then, I used winmysqdadmin to change it to mysqld-max-nt. I tried also the mysqld-max-nt --remove mysqld-max-nt --install -- that works well but mysqld-max-nt doesn't show me anything, and mysql is not running. finally, I tried: mysqld-max-nt --standalone And I got: mysqld-max-nt: Fatal error: Error message file 'c:\mysql\share\english\errmsg.sy s' had only 198 error messages, but it should have at least 208 error messages. Check that the above file is the right version for this program! I checked the last time this file has been changed, and it was 6 months ago, so it seems that these files are missing in the binary? By the way, in the binary distribution, there is no mysqlbug program I would appreciate your help Stephane - 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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /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
Re: Database design question
On Saturday 28 July 2001 15:09, Scott Goldstein wrote: I'm new to MySQL and database design and I have a questions concerning entities with common attributes. Suppose I have two entities, foo and bar with the following attributes: foo: (id, A, B, C, D, F) bar: (id, A, B, C, X, Y) Well, I just played with it here, using an addressbook and Zipcode tables and it seemed to work, should work for you too:-) select * from foo,bar where foo.id=bar.id; You would put 'A,B,C, in one of the tables then based on the id's of the two tables, all the fields would then be displayed:-) Both entities have several attributes in common. Is there any way to take advantage of this? I recall reading the MySQL does not support table inheritance. Is there any other mechanism that I can use? Thanks for the help. Scott - 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: Privilege settings
Dear Mike, read the chapter about the privilege system in the MySQL manual (manual_Privilege_system.html#Privilege_system)! You'd better use the GRANT command to grant rights to users (which are stored in mysql.user) or to users who only have access to special databases and tables (which are stored in mysql.db). If you manipulate these tables manually, you will have to use FLUSH PRIVILEGES afterwards for changes to take effect. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Mike Blezien [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 30, 2001 7:19 PM Subject: Privilege settings Hi all, trying to figure out the relationship of the mysql User and db tables. Now when a database is created and privileges are assigned to the new db, the db table is updated and the user table is updated, but in the privilege columns of the user table, all are set to 'N' but the appropriate privileges are set to 'Y' in the db table for that particular database. Is there something I'm missing or doing wrong?? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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: Help!!
Dear Ivan, read the chapter about the privilege system in the MySQL manual (manual_Privilege_system.html#Privilege_system)! Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Ivan Chavez [EMAIL PROTECTED] To: MySql (E-mail) [EMAIL PROTECTED] Sent: Monday, July 30, 2001 7:13 PM Subject: Help!! Hello!! I need help to know where configure the users and passwords that can accesar to my databases, this in a Linux Net Hat 6.1 Thank you - 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: Backup of all Databases
Dear Claudemir, you can use mysqldump --all-databases my_dump_file.sql which will make restore possible on *any* operating system. It creates quite a big file (because of all the create / insert statements) - which might be slow to transfer to / from an internet machine. It's a bit faster if you use cp /var/lib/mysql/* -R /some/safe/place In this case, make sure you use MyISAM files as this table type is interchangeable and runs on any operating system. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Claudemir F. Martins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 30, 2001 9:01 PM Subject: Backup of all Databases Hello I took a look at the discussion of database backup, however I still have a doubt: I have 30 databases and I'd like to backup all databases at a time (including the mysql database). Is there a good way to backup all databases at a time ? To save the directory /var/lib/mysql which contain all databases, is a good idea for a backup ? Regards Claudemir F. Martins - 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: Innodb table size
Hi, From what I can measure we get only the 70% filling. The data is sorted in ascending order, however there is a catch in the sense that the first colummn consist of all identical variables (this is kept to maintain some consistency with our organization), and thus we have set the primary key to sort on the second column which is in the right ascending order. I guess this is why we get only a 70% filling and not the full 15/16 eventhough the data is well sorted. Thanks, Xavier Heikki Tuuri wrote: Hi! Sorry, InnoDB does not have key compression. Every row has a 6-byte trx id, a 7-byte roll ptr, and a header of 6 bytes. In addition, every field uses 1 byte as a pointer to it. Calculating: 180 million x (6 + 7 + 6 + 2 + 4) bytes = 4.5 GB Since every page is filled only 15/16 full even if rows are inserted in an ascending order, there will be some additional overhead. Did you insert the rows in the ascending order of the primary key? That is the most space-efficient way, since with random inserts pages will only be about 70 % full. Regards, Heikki http://www.innodb.com Copied message: .. Lose (some of) the keys!? Keys, especially on small rows (where a key introduces a lot of overhead), can take a significant percentage of space. Turn on key compression? (dunno if innodb supports that) Other then that I wouldn't know. But live with the fact that keys introduce overhead. It will be like that on any database system. -Original Message- From: Xavier Leoncini [mailto:[EMAIL PROTECTED]] Sent: 30 July 2001 04:34 To: [EMAIL PROTECTED] Subject: Innodb table size Hello, I was wondering if someone could help me; When I load about 6Gb of raw data into a innodb table the size used by the table is about 14G. I noticed in preleminary tests that the sized used depends a lot on the number of rows in the case described above the data has about 180 millions rows, 4 columns and three keys on the first three columns. Does anyone know how to get a better ratio, something closer to 6-9Gb use. Thanks in advance. Xavier - 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 . To be more precise, I have a primary key defined on the first three columns, and I kind of do not have much choice on that. I am surprised by the overhead as innodb has clustered indexing defined on the primary key. A typical row is about 35 bytes. - 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_navigator Script Problems
Hello,
I was doing the mysql data entry via kmysql which allows me to build forms
and then Enter the data according to the script that I create which runs when
I hit the submit problem. I tried to do something similar via
mysql_navigator and it dies. The script (which are valid mysql commands)
goes something like this (I'm using 2 tables, one is an address table and the
other is a property table).
select (@store:=ID) from Address where Company='Wal-Mart';
insert into Property (Bought,Owner,Type,Room,Make,Store,Cost) values
(@store,'Doug','Toys','Office','Digital Camera',@store,39.46);
The field descriptions are as follows:
Bought date
Owner set('comma','deliminated','family','members','Doug')
Type enum('Appliance','Electronic','Tools','Toys')
Room enum('Living','Office','Kitchen','etc')
Make varchar(30)
Store int(10) unsigned
Cost double(10,2)
When I run the same basic script in kmysql, it works fine (except I can do a
bit more as far as introducing new variables). When I try to run it in
mysql_navigator on the other hand, it errors out and won't tell me via log or
any other means I can determine what the errors are.
Can anyone tell me what I'm doing wrong in mysql_navigator?
Thanx Loads!
[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
How to know which row was affected with a querry ???
Hello ! I have a following problem while scripting MySQL with PHP4: Imagine the user may add a record to a table. How can I know precisely what was the number (auto increment primary key) given by MySQL to this new inserted row ??? You may presume there are many simultaneus users adding rows, so I need a accurate information. Thank you for your kind help, Ziggi
Wild-card search problem
-- I have searched through all of the MySQL documentation I can get my hands on, but still have no explanation for the following wild-card search problem. I enter the following query: SELECT name,keywords,description from database_t where 1 and name like p% LIMIT 0, 30; -- or -- SELECT name,keywords,description from database_t where name like p% LIMIT 0, 30; This should return all records where name starts with the letter P. It only returns the first record (since the first record starts with P). When I use any other letter or number no records are returned. The query is being performed on a 7000+ record database and should pull up several hundred records starting with the letter P. I am running MySQL 3.23.40 on BSD UNIX (MAC OSX), but had the identical problem with 3.23.28, 3.23.36 and 3.23.38. Thanks in advance, Brett - 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
Connection error
I am trying to connect mysql with JDBC driver. I am getting error connection failure : Bad handshake. Please let us know the cause of the error and how to solve it. Thanks. Upasana. - 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
Two databases / One Server
Hello, Trying to install two mysql database servers on one Redhat linux machine. The first mysql server is on port 3306 and I am trying to run the second mysql server on port 3307 but whenever I try to access the second mysql server via port 3307, I still end up accessing the first mysql database which is on port 3306. Any help? Thanks, Jeff - 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: best version
Any of the 3.22.xx versions should work fine under FreeBSD 2.2.8. I had several light- and medium-load productions systems running in that configuration and I never had a problem with mySQL. I was even able to get early versions of 3.23.xx running under it, with some minor code changes. I've not tried it in some time, though. I would highly suggest an upgrade to FreeBSD 4.3, as the latest versions of mySQL compile flawlessly on it and it's incredibly fast nowadays. Jeremy Zawodny [EMAIL PROTECTED] wrote: On Sat, Jul 21, 2001 at 06:51:37AM -0700, Donald wrote: Im running FBSD ver 2.2.8 and need to know what version of mysql installs ans runs best on this platform. At this time upgrading in not an option. I never saw a reply, so... I've run a few versions of MySQL 3.22.xx (where xx is probably 30 - 32) on FreeBSD 2.2.8 boxes without much trouble. It was a very light-weight setup, so MySQL was never particularly stressed in the process. - 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 to know which row was affected with a querry ???
look up mysql_insert_id() in the php documentation. Check out the documentation as it appears on the www.php.net site http://www.php.net/manual/en/function.mysql-insert-id.php hope that helps George -Original Message- From: Zbigniew Szczesny [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 3:16 PM To: [EMAIL PROTECTED] Subject: How to know which row was affected with a querry ??? Hello ! I have a following problem while scripting MySQL with PHP4: Imagine the user may add a record to a table. How can I know precisely what was the number (auto increment primary key) given by MySQL to this new inserted row ??? You may presume there are many simultaneus users adding rows, so I need a accurate information. Thank you for your kind help, Ziggi --- This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. Ce courriel est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser immédiatement, par retour de courriel ou par un autre moyen. ==
Re: Two databases / One Server
If you are connecting to localhost, it is using the socket, not the port. You must set up each server to use a different socket, and connect to that socket. [EMAIL PROTECTED] wrote: Hello, Trying to install two mysql database servers on one Redhat linux machine. The first mysql server is on port 3306 and I am trying to run the second mysql server on port 3307 but whenever I try to access the second mysql server via port 3307, I still end up accessing the first mysql database which is on port 3306. Any help? Thanks, Jeff - 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: Wild-card search problem
Is it only pulling up the first record in a script that you are writing (like in a PHP script) or does it also exhibit this behavior if you enter your query from the mysql command line interface? If it is the former, I would imagine there is a problem with your script. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: winnecon [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 3:24 PM To: [EMAIL PROTECTED] Subject:Wild-card search problem -- I have searched through all of the MySQL documentation I can get my hands on, but still have no explanation for the following wild-card search problem. I enter the following query: SELECT name,keywords,description from database_t where 1 and name like p% LIMIT 0, 30; -- or -- SELECT name,keywords,description from database_t where name like p% LIMIT 0, 30; This should return all records where name starts with the letter P. It only returns the first record (since the first record starts with P). When I use any other letter or number no records are returned. The query is being performed on a 7000+ record database and should pull up several hundred records starting with the letter P. I am running MySQL 3.23.40 on BSD UNIX (MAC OSX), but had the identical problem with 3.23.28, 3.23.36 and 3.23.38. Thanks in advance, Brett - 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
Ayuda Urgente
Me baje los archivos fuentes de Mysql ejecuto el .configure y todo bien
cuenado ejecuto make me da el siguiente error:
...
strcont.o strcend.o bchange.o bmove.o bmove_upp.o longlong2str.o
ctype-latin1.o dbug.o
ranlib .libs/libmysqlclient.a
creating libmysqlclient.la
(cd .libs rm -f libmysqlclient.la ln -s ../libmysqlclient.la
libmysqlclient.la)
c++ -DUNDEF_THREADS_HACK -I./../include -I../include
-I./.. -I.. -I..-O -fno-implicit-templates -DDBUG_OFF
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -c mysql.cc
In file included from mysql.cc:54:
/usr/include/term.h:1060: syntax error before `,'
/usr/include/term.h:1081: syntax error before `;'
/usr/include/term.h:1082: syntax error before `;'
/usr/include/term.h:1101: syntax error before `['
/usr/include/term.h:1108: syntax error before `*'
/usr/include/term.h:: syntax error before `;'
/usr/include/term.h:1115: syntax error before `;'
/usr/include/term.h:1116: syntax error before `;'
/usr/include/term.h:1207: `chtype' was not declared in this scope
/usr/include/term.h:1207: parse error before `('
*** Error code 1
make: Fatal error: Command failed for target `mysql.o'
Current working directory /tmp/mysql-3.22.26a/client
*** Error code 1
make: Fatal error: Command failed for target `all-recursive'
Current working directory /tmp/mysql-3.22.26a
*** Error code 1
make: Fatal error: Command failed for target `all-recursive-am'
Por favor necesito ayuda urgentemente, tengo 5 dias tratando de configurar
mi maquina
-
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
Ayuda Urgente
Me baje los archivos fuentes de Mysql ejecuto el .configure y todo bien
cuenado ejecuto make me da el siguiente error:
...
strcont.o strcend.o bchange.o bmove.o bmove_upp.o longlong2str.o
ctype-latin1.o dbug.o
ranlib .libs/libmysqlclient.a
creating libmysqlclient.la
(cd .libs rm -f libmysqlclient.la ln -s ../libmysqlclient.la
libmysqlclient.la)
c++ -DUNDEF_THREADS_HACK -I./../include -I../include
-I./.. -I.. -I..-O -fno-implicit-templates -DDBUG_OFF
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -c mysql.cc
In file included from mysql.cc:54:
/usr/include/term.h:1060: syntax error before `,'
/usr/include/term.h:1081: syntax error before `;'
/usr/include/term.h:1082: syntax error before `;'
/usr/include/term.h:1101: syntax error before `['
/usr/include/term.h:1108: syntax error before `*'
/usr/include/term.h:: syntax error before `;'
/usr/include/term.h:1115: syntax error before `;'
/usr/include/term.h:1116: syntax error before `;'
/usr/include/term.h:1207: `chtype' was not declared in this scope
/usr/include/term.h:1207: parse error before `('
*** Error code 1
make: Fatal error: Command failed for target `mysql.o'
Current working directory /tmp/mysql-3.22.26a/client
*** Error code 1
make: Fatal error: Command failed for target `all-recursive'
Current working directory /tmp/mysql-3.22.26a
*** Error code 1
make: Fatal error: Command failed for target `all-recursive-am'
Por favor necesito ayuda urgentemente, tengo 5 dias tratando de configurar
mi maquina
Gracias y espero por su respuesta
-
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
Converting an old Foxpro dos database to mysql/php
I have an old database that is running on foxpro that is used for sales and order entry at my work and I was wondering how I would go about porting it to a *nix enviorment. The first step is the port the dbf files I think so I grabbed a copy of dbf2mysql and tried messing around with it and when I do I get an error like this: bash-2.05$ dbf2mysql CAT.DBF Table does not exist! What I would eventually like to do Is have mysql installed on a freebsd box at work and then have all the workstations that run windows be able to enter invoices from netscape or internet explorer over the lan. I would love if someone could point me in the right direction on where to get started and some interesting websites to read about this. I am a newbie with all this database stuff. Please CC a reply to my email address [EMAIL PROTECTED] because I do not subscribe to the mailing list. Thanks in advance for all your help Armando - 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: Wild-card search problem
Unfortunately, the problem is not in any one script. It is a universally repeatable error and happens even when using MySQL in the command line. I tried the suggested SQL query below, but it returned the same result as before. (Only the first record.) SELECT name,keywords,description from database_t where Left(name, 1) ='p' LIMIT 0, 30; Other wildcard searches function perfectly - i.e., a search for '%p%' yields every record containing the letter P. Can anyone think of a way in which this problem might be data-related? I have thought it over and checked the data thoroughly, but perhaps there is something I am missing. Thanks, Brett Is it only pulling up the first record in a script that you are writing (like in a PHP script) or does it also exhibit this behavior if you enter your query from the mysql command line interface? If it is the former, I would imagine there is a problem with your script. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: winnecon [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 3:24 PM To:[EMAIL PROTECTED] Subject: Wild-card search problem -- I have searched through all of the MySQL documentation I can get my hands on, but still have no explanation for the following wild-card search problem. I enter the following query: SELECT name,keywords,description from database_t where 1 and name like p% LIMIT 0, 30; -- or -- SELECT name,keywords,description from database_t where name like p% LIMIT 0, 30; This should return all records where name starts with the letter P. It only returns the first record (since the first record starts with P). When I use any other letter or number no records are returned. The query is being performed on a 7000+ record database and should pull up several hundred records starting with the letter P. I am running MySQL 3.23.40 on BSD UNIX (MAC OSX), but had the identical problem with 3.23.28, 3.23.36 and 3.23.38. Thanks in advance, Brett - 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: Two databases / One Server
Hi, Look at this (Installing Second MySQL Server on Shared Host): http://www.bitmechanic.com/mail-archives/mysql/current/1550.html Sonia On Mon, 30 Jul 2001 [EMAIL PROTECTED] wrote: Date: Mon, 30 Jul 2001 13:07:09 -0700 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Two databases / One Server Hello, Trying to install two mysql database servers on one Redhat linux machine. The first mysql server is on port 3306 and I am trying to run the second mysql server on port 3307 but whenever I try to access the second mysql server via port 3307, I still end up accessing the first mysql database which is on port 3306. Any help? Thanks, Jeff - 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 -- --- --==- Sonia Van TasselSoftware EngineerInterWorking Labs ==--= 4113 Scotts Valley Drive, Suite 200 Scotts Valley, CA 95066 --==- [EMAIL PROTECTED] +1 831 430 3610 x23 +1 831 430 9144 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: permissions - again
- Original Message - From: Carsten H. Pedersen [EMAIL PROTECTED] To: Robert Roberts [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, July 28, 2001 6:31 PM Subject: RE: permissions - again My assumption: mysql GRANT SELECT, INSERT, UPDATE ON client_db.* TO db_user@localhost IDENTIFIED BY 'password'; Now this is where I get a bit confused. It's not clear to me where the client is connecting from. I assume they are connecting from localhost because everything is all on the same server. But: The PHP script will usually connect from/to localhost, yes. ---are they, in actuality, connecting from their own virtual host, [EMAIL PROTECTED] ? I shouldn't think so. But why don't you let them try it out? The error message returned will usually something along the lines of Access denied for [EMAIL PROTECTED] (using password: YES) - that will tell you, how MySQL thinks the user is conecting. ---they are connecting from a remote machine, so are they, then, connecting from some other host? Err... methinks, that's rather obvious: Yes. ---if they are connecting from a remote machine with a dial-up connection, then it is undoubtedly a dynamic IP address, so there would be no consistent host to connect from. No, and while you cannot lock this problem down completely, you can at least limit the size of the opening between the gateposts: MySQL allows you to specify only parts of an IP mask as the host (something like db_user@192.168.%.% -- I forget the exact syntax; it's in the manual). Once you know the possible range of IPs their ISP provides, you can limit the database access to these. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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: Two databases / One Server
Ok clear this up a little for me, Gerald says: If you are connecting to localhost, it is using the socket, not the port. According to Sonia's reference I need to specify both a different socket and a different port, but according to Gerald I must specify one or the other. so which one is it. Jeff - Original Message - From: Sonia Van Tassel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 30, 2001 2:37 PM Subject: Re: Two databases / One Server Hi, Look at this (Installing Second MySQL Server on Shared Host): http://www.bitmechanic.com/mail-archives/mysql/current/1550.html Sonia On Mon, 30 Jul 2001 [EMAIL PROTECTED] wrote: Date: Mon, 30 Jul 2001 13:07:09 -0700 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Two databases / One Server Hello, Trying to install two mysql database servers on one Redhat linux machine. The first mysql server is on port 3306 and I am trying to run the second mysql server on port 3307 but whenever I try to access the second mysql server via port 3307, I still end up accessing the first mysql database which is on port 3306. Any help? Thanks, Jeff - 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 -- --- --==- Sonia Van TasselSoftware EngineerInterWorking Labs ==--= 4113 Scotts Valley Drive, Suite 200 Scotts Valley, CA 95066 --==- [EMAIL PROTECTED] +1 831 430 3610 x23 +1 831 430 9144 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: Converting an old Foxpro dos database to mysql/php
The simplest thing to do is to run the foxpro database and export the records to a text file. Run the SHOW STRUCTURE command to list the table structures and then set up a new mysql database that mimics the foxpro table structure. I have an old database that is running on foxpro that is used for sales and order entry at my work and I was wondering how I would go about porting it to a *nix enviorment. The first step is the port the dbf files I think so I grabbed a copy of dbf2mysql and tried messing around with it and when I do I get an error like this: bash-2.05$ dbf2mysql CAT.DBF Table does not exist! What I would eventually like to do Is have mysql installed on a freebsd box at work and then have all the workstations that run windows be able to enter invoices from netscape or internet explorer over the lan. I would love if someone could point me in the right direction on where to get started and some interesting websites to read about this. I am a newbie with all this database stuff. Please CC a reply to my email address [EMAIL PROTECTED] because I do not subscribe to the mailing list. Thanks in advance for all your help Armando - 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 Christopher R. Jones, P.Eng. 14 Oneida Avenue Toronto, Ontario M5J 2E3 Tel. 416 203-7465 Fax. 416 203-8249 Email [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: Wild-card search problem
I just tested the following on a table I have with a name field (prj_id in my case): select prj_id from master_projects where prj_id like R% LIMIT 0, 30; Works perfectly in the mysql shell; Unfortunately, the problem is not in any one script. It is a universally repeatable error and happens even when using MySQL in the command line. I tried the suggested SQL query below, but it returned the same result as before. (Only the first record.) SELECT name,keywords,description from database_t where Left(name, 1) ='p' LIMIT 0, 30; Other wildcard searches function perfectly - i.e., a search for '%p%' yields every record containing the letter P. Can anyone think of a way in which this problem might be data-related? I have thought it over and checked the data thoroughly, but perhaps there is something I am missing. Thanks, Brett Is it only pulling up the first record in a script that you are writing (like in a PHP script) or does it also exhibit this behavior if you enter your query from the mysql command line interface? If it is the former, I would imagine there is a problem with your script. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: winnecon [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 3:24 PM To: [EMAIL PROTECTED] Subject:Wild-card search problem -- I have searched through all of the MySQL documentation I can get my hands on, but still have no explanation for the following wild-card search problem. I enter the following query: SELECT name,keywords,description from database_t where 1 and name like p% LIMIT 0, 30; -- or -- SELECT name,keywords,description from database_t where name like p% LIMIT 0, 30; This should return all records where name starts with the letter P. It only returns the first record (since the first record starts with P). When I use any other letter or number no records are returned. The query is being performed on a 7000+ record database and should pull up several hundred records starting with the letter P. I am running MySQL 3.23.40 on BSD UNIX (MAC OSX), but had the identical problem with 3.23.28, 3.23.36 and 3.23.38. Thanks in advance, Brett - 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 Christopher R. Jones, P.Eng. 14 Oneida Avenue Toronto, Ontario M5J 2E3 Tel. 416 203-7465 Fax. 416 203-8249 Email [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: Converting an old Foxpro dos database to mysql/php
Do you happen to have a url on how to do this especially the foxpro portion I don't know to much about it On Mon, 30 Jul 2001, Christopher R. Jones wrote: The simplest thing to do is to run the foxpro database and export the records to a text file. Run the SHOW STRUCTURE command to list the table structures and then set up a new mysql database that mimics the foxpro table structure. I have an old database that is running on foxpro that is used for sales and order entry at my work and I was wondering how I would go about porting it to a *nix enviorment. The first step is the port the dbf files I think so I grabbed a copy of dbf2mysql and tried messing around with it and when I do I get an error like this: bash-2.05$ dbf2mysql CAT.DBF Table does not exist! What I would eventually like to do Is have mysql installed on a freebsd box at work and then have all the workstations that run windows be able to enter invoices from netscape or internet explorer over the lan. I would love if someone could point me in the right direction on where to get started and some interesting websites to read about this. I am a newbie with all this database stuff. Please CC a reply to my email address [EMAIL PROTECTED] because I do not subscribe to the mailing list. Thanks in advance for all your help Armando - 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 Christopher R. Jones, P.Eng. 14 Oneida Avenue Toronto, Ontario M5J 2E3 Tel. 416 203-7465 Fax. 416 203-8249 Email [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: Backup of all Databases
Lectori Salutem, as Stefan states here (und natürlich ganz richtig, Stefan) mysqldump is *the* way to backup, and it will create large files. However, since you get clear-text human readable text in the outfile -being all the mySQL commands needed to recreate the database(s)- they're easy to compress with a pretty good ratio. Under linux, it's as easy as: mysqldump --all-databases | gzip -c my_dump_archive.sql.gz To get the SQL-commands back, unzip the archive: gzip -d my_dump_archive.sql.gz To restore the databases, run the console output of gzip through mysql: gzip -cd | mysql -u root -pmypassword Of course, most of this could have been found in the list-archives on http://lists.mysql.com Regards, Sebastiaan J.A. Kamp General Manager VOF Post Zero Hoogstraat 98a 3011 PT Rotterdam tel. +31 1 04199140 fax. +31 1 04111335 @to: [EMAIL PROTECTED] Erasmus University Rotterdam L Information Automation Room L5-040, Woudestein Burgemeester Oudlaan 50 3062 PA Rotterdam tel. 010-4088638 @to: [EMAIL PROTECTED] Executive Officer Safenet BV van Galenstraat 35 2518 EN Den Haag tel. 070-3642968 fax. 070-3454537 @to: [EMAIL PROTECTED] =-Original Message- =From: Stefan Hinz [mailto:[EMAIL PROTECTED]] =Sent: maandag 30 juli 2001 20:51 =To: [EMAIL PROTECTED]; [EMAIL PROTECTED] =Subject: Re: Backup of all Databases = = =Dear Claudemir, = =you can use = =mysqldump --all-databases my_dump_file.sql = =which will make restore possible on *any* operating system. It creates =quite a big file (because of all the create / insert statements) - which =might be slow to transfer to / from an internet machine. It's a bit =faster if you use = =cp /var/lib/mysql/* -R /some/safe/place = =In this case, make sure you use MyISAM files as this table type is =interchangeable and runs on any operating system. = =Regards, = =-- = Stefan Hinz = Geschäftsführer / CEO iConnect e-commerce solutions GmbH = # www.js-webShop.com www.iConnect.de = # Gustav-Meyer-Allee 25, 13355 Berlin = # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - 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 timing out? HELP!!!!
Hi, I have a customer who has a html page containing two frames on server A. The content files for these frames are on server B. He wants to keep his URL which is directed to server A, but server B has mysql and php support so we have to do this to accomodate him. It is working (kind of) but the second frame (php/mysql) is not loading and I think it is because the java navigation script in the first frame is slow so the second frame has to wait to load and it times out. Does this sound reasonable? If so, how can I increase the timeout time for the mysql/php server to get round this please? ANY help would be very much appreciated as I'm against the clock. I've been told that if I don't get it working by tomorrow morning (it's 23:15 here now) I am out of a job. Any advice appreciated. Guess I'll be here all night on this kamikaze mission. best, Graham - 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: Two databases / One Server
Hi Jeff, I think we are both kind of correct. If you are interested in connecting remotely then you need to set up a different port and socket, if you only wish to connect to your localhost then I think you can start the daemon with a --skip-networking option and specify a new location for your socket file (--socket=/...). Then when you start your mysql session set your environment path MYSQL_UNIX_PORT. At least that's my best guess... Sonia On Mon, 30 Jul 2001 [EMAIL PROTECTED] wrote: Date: Mon, 30 Jul 2001 14:55:37 -0700 From: [EMAIL PROTECTED] To: Sonia Van Tassel [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Two databases / One Server Ok clear this up a little for me, Gerald says: If you are connecting to localhost, it is using the socket, not the port. According to Sonia's reference I need to specify both a different socket and a different port, but according to Gerald I must specify one or the other. so which one is it. Jeff - Original Message - From: Sonia Van Tassel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 30, 2001 2:37 PM Subject: Re: Two databases / One Server Hi, Look at this (Installing Second MySQL Server on Shared Host): http://www.bitmechanic.com/mail-archives/mysql/current/1550.html Sonia On Mon, 30 Jul 2001 [EMAIL PROTECTED] wrote: Date: Mon, 30 Jul 2001 13:07:09 -0700 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Two databases / One Server Hello, Trying to install two mysql database servers on one Redhat linux machine. The first mysql server is on port 3306 and I am trying to run the second mysql server on port 3307 but whenever I try to access the second mysql server via port 3307, I still end up accessing the first mysql database which is on port 3306. Any help? Thanks, Jeff - 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 -- --- --==- Sonia Van TasselSoftware EngineerInterWorking Labs ==--= 4113 Scotts Valley Drive, Suite 200 Scotts Valley, CA 95066 --==- [EMAIL PROTECTED] +1 831 430 3610 x23 +1 831 430 9144 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 -- --- --==- Sonia Van TasselSoftware EngineerInterWorking Labs ==--= 4113 Scotts Valley Drive, Suite 200 Scotts Valley, CA 95066 --==- [EMAIL PROTECTED] +1 831 430 3610 x23 +1 831 430 9144 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: Wild-card search problem
Unfortunately, the problem is not in any one script. It is a universally repeatable error and happens even when using MySQL in the command line. I tried the suggested SQL query below, but it returned the same result as before. (Only the first record.) SELECT name,keywords,description from database_t where Left(name, 1) ='p' LIMIT 0, 30; Other wildcard searches function perfectly - i.e., a search for '%p%' yields every record containing the letter P. Can anyone think of a way in which this problem might be data-related? I have thought it over and checked the data thoroughly, but perhaps there is something I am missing. What are the column definitions? Are any of them declared BINARY or are they BLOBs rather than TEXTs? In these cases, MySQL will use a case-sensitive LIKE, which might not be what you expected. Another thing: The first form (p%) will make use of any indexes you might have on the field, while the second form (%p%) will not. You may wish to recreate the indexes just to be sure. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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: mysqld under FreeBSD
What hostname are you providing JSP? If you want to replicate the behaviour of your mysql command, it needs to be localhost or 127.0.0.1, not the network name of your server. If you are using the server name, then you need to use mysql command the same way, too: ./mysql -u root -h servername -p Tom Haapanen [EMAIL PROTECTED] -Original Message- From: gokeeper [mailto:[EMAIL PROTECTED]] Sent: Sunday, 29 July, 2001 10:31 To: [EMAIL PROTECTED] Subject: mysqld under FreeBSD hi all i am running mysql 3.23.40 and tomcat 3.2.3 on FreeBSD when i try to connect to the local mysql server in jsp using mm driver it says: Server configuration denies access to data source the userpass i provide is right i can connect to local mysqld use ./mysql -u root -p also php+mysql works well. BTW:the same script can connect to another Mysql server running under windows2000,so i think this is mysqld's problem - 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: Two databases / One Server
The way I am starting my second mysql server is like this : socket=/tmp/mysqld-new.sock --port=3307 --pid-file=/tmp/rep-mysql I am not sure how the first mysql server is starting, it is the one that comes installed with plesk. Jeff- Original Message - From: Sonia Van Tassel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 30, 2001 3:32 PM Subject: Re: Two databases / One Server Hi Jeff, I think we are both kind of correct. If you are interested in connecting remotely then you need to set up a different port and socket, if you only wish to connect to your localhost then I think you can start the daemon with a --skip-networking option and specify a new location for your socket file (--socket=/...). Then when you start your mysql session set your environment path MYSQL_UNIX_PORT. At least that's my best guess... Sonia On Mon, 30 Jul 2001 [EMAIL PROTECTED] wrote: Date: Mon, 30 Jul 2001 14:55:37 -0700 From: [EMAIL PROTECTED] To: Sonia Van Tassel [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Two databases / One Server Ok clear this up a little for me, Gerald says: If you are connecting to localhost, it is using the socket, not the port. According to Sonia's reference I need to specify both a different socket and a different port, but according to Gerald I must specify one or the other. so which one is it. Jeff - Original Message - From: Sonia Van Tassel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 30, 2001 2:37 PM Subject: Re: Two databases / One Server Hi, Look at this (Installing Second MySQL Server on Shared Host): http://www.bitmechanic.com/mail-archives/mysql/current/1550.html Sonia On Mon, 30 Jul 2001 [EMAIL PROTECTED] wrote: Date: Mon, 30 Jul 2001 13:07:09 -0700 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Two databases / One Server Hello, Trying to install two mysql database servers on one Redhat linux machine. The first mysql server is on port 3306 and I am trying to run the second mysql server on port 3307 but whenever I try to access the second mysql server via port 3307, I still end up accessing the first mysql database which is on port 3306. Any help? Thanks, Jeff - 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 -- --- --==- Sonia Van TasselSoftware EngineerInterWorking Labs ==--= 4113 Scotts Valley Drive, Suite 200 Scotts Valley, CA 95066 --==- [EMAIL PROTECTED] +1 831 430 3610 x23 +1 831 430 9144 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 -- --- --==- Sonia Van TasselSoftware EngineerInterWorking Labs ==--= 4113 Scotts Valley Drive, Suite 200 Scotts Valley, CA 95066 --==- [EMAIL PROTECTED] +1 831 430 3610 x23 +1 831 430 9144 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: Wild-card search problem
Turned out to be a data problem after all - a single, unreadable (at least to me) just after each linefeed character. That explains everything. To all those who helped out, my sincerest thanks. Brett I just tested the following on a table I have with a name field (prj_id in my case): select prj_id from master_projects where prj_id like R% LIMIT 0, 30; Works perfectly in the mysql shell; Unfortunately, the problem is not in any one script. It is a universally repeatable error and happens even when using MySQL in the command line. I tried the suggested SQL query below, but it returned the same result as before. (Only the first record.) SELECT name,keywords,description from database_t where Left(name, 1) ='p' LIMIT 0, 30; Other wildcard searches function perfectly - i.e., a search for '%p%' yields every record containing the letter P. Can anyone think of a way in which this problem might be data-related? I have thought it over and checked the data thoroughly, but perhaps there is something I am missing. Thanks, Brett Is it only pulling up the first record in a script that you are writing (like in a PHP script) or does it also exhibit this behavior if you enter your query from the mysql command line interface? If it is the former, I would imagine there is a problem with your script. HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: winnecon [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 3:24 PM To: [EMAIL PROTECTED] Subject:Wild-card search problem -- I have searched through all of the MySQL documentation I can get my hands on, but still have no explanation for the following wild-card search problem. I enter the following query: SELECT name,keywords,description from database_t where 1 and name like p% LIMIT 0, 30; -- or -- SELECT name,keywords,description from database_t where name like p% LIMIT 0, 30; This should return all records where name starts with the letter P. It only returns the first record (since the first record starts with P). When I use any other letter or number no records are returned. The query is being performed on a 7000+ record database and should pull up several hundred records starting with the letter P. I am running MySQL 3.23.40 on BSD UNIX (MAC OSX), but had the identical problem with 3.23.28, 3.23.36 and 3.23.38. Thanks in advance, Brett - 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 Christopher R. Jones, P.Eng. 14 Oneida Avenue Toronto, Ontario M5J 2E3 Tel. 416 203-7465 Fax. 416 203-8249 Email [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
Clean up datadir
Hi all, we just setup up on a new server and have transferred a bunch of databases and tables to the new server. All is working well... so far - so good! :) My question is, during this process we did a multiple of create/delete many db and and a whole bunch of tables. Do we need to do any sort of clean up due to any fragments left on the server's HD from all the db and table deletions. When a db or table is deleted is there any segments left that need to clean up or removed?? thx's Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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: ADO/ODBC question
On Mon, Jul 30, 2001 at 12:18:02PM +0100, Christopher Thorpe wrote: Hi all quick question if I use a query such as the one below INSERT INTO usq (usq_id,usq_querystring) VALUES(NULL,'test'); SELECT LAST_INSERT_ID(); how do I push this two part query through an ADO command object and how do I get the variable back from the select part of the query... alternatively should I do it as a recordset update? Sir, the answer is yes and no. An ADO command object doesn't return a value from an SQL statement, so you have to use a recordset object to get the return value from the Last_insert_id function. I would do the first through a command object, and the second through a recordset. It would probably work just as well to use them sequentially as the CommandText property of of a command object and execute them by opening a recordset. As you are probably aware, there's rarely only two ways of doing something with ADO. I don't think you can use them simultaneously in a single command object. But there's no need to; Last_insert-id() returns the last insert id for the current connection, regardless of what else has been inserted in the interim. As long as your connection object stays open, you'll get the correct return value. I would never use rs.Update to do something that can be done with an SQL statement. My experience is that recordsets take about three to four times as long as SQL when doing single row inserts over native connections. For code examples, see your friendly neighborhood MS help files. I've devoted more than enough space on a MySQL list to ADO. -- Bob HallHow to invoke the MySQL list daemon: Sql, table, query and database, Distribute this mail and be quick, potato face! - 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
