Re: ERROR 1062
It's work thanks On Tue, 2002-08-27 at 14:24, Dan Nelson wrote: > In the last episode (Aug 27), Osman Omar said: > > below is my tables properties, > > and my last record id is 127; > > > > mysql> desc emcs; > > ++-+--+-+++ > > | Field | Type| Null | Key | Default| Extra | > > ++-+--+-+++ > > | id | tinyint(6) | | PRI | NULL | auto_increment | > > > >From the manual: > >`TINYINT[(M)] [UNSIGNED] [ZEROFILL]' > A very small integer. The signed range is `-128' to `127'. The > unsigned range is `0' to `255'. > > What do you think happens with you hit 127? > > Replace that TINYINT with INTEGER. > > -- > Dan Nelson > [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
2 bugs in mysqlaccess
Hello First bug: The contact address is no longer existing: "BUGs can be reported by email to [EMAIL PROTECTED]" Second bug: perl does not substitute the '~' char to the home directory: > --- /tmp/mysqlaccess.orig 2002-08-27 08:25:23.0 +0200 > +++ /usr/bin/mysqlaccess2002-08-27 08:20:40.0 +0200 > @@ -13,7 +13,7 @@ > $script = $1; > $script = 'MySQLAccess' unless $script; > $script_conf = "$script.conf"; > - $script_log = "~/$script.log"; > + $script_log = $ENV{'HOME'}."/$script.log"; > > # > # information on MySQL bye, -christian- Robot: php mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1062
In the last episode (Aug 27), Osman Omar said: > below is my tables properties, > and my last record id is 127; > > mysql> desc emcs; > ++-+--+-+++ > | Field | Type| Null | Key | Default| Extra | > ++-+--+-+++ > | id | tinyint(6) | | PRI | NULL | auto_increment | >From the manual: `TINYINT[(M)] [UNSIGNED] [ZEROFILL]' A very small integer. The signed range is `-128' to `127'. The unsigned range is `0' to `255'. What do you think happens with you hit 127? Replace that TINYINT with INTEGER. -- Dan Nelson [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: ERROR 1062
below is my tables properties, and my last record id is 127; mysql> desc emcs; ++-+--+-+++ | Field | Type| Null | Key | Default| Extra | ++-+--+-+++ | id | tinyint(6) | | PRI | NULL | auto_increment | | insp_date | date| | | -00-00 || | judge_date | date| | | -00-00 || | model | varchar(20) | | ||| | lot_no | varchar(5) | | ||| | remark | text| YES | | NULL || ++-+--+-+++ 6 rows in set (0.02 sec) mysql> On Tue, 2002-08-27 at 13:26, Karthik wrote: > this query in all probability violates some referential integrity... and > this in all probability is a primary key defined in your table. > > So please check whether the query is trying to insert duplicate values in a > primary key field > > - Original Message - > From: "Osman Omar" <[EMAIL PROTECTED]> > To: "MySQL" <[EMAIL PROTECTED]> > Sent: Tuesday, August 27, 2002 10:46 AM > Subject: ERROR 1062 > > > > Hi > > > > I get this error. > > > > any idea? > > > > > > mysql> insert into emcs (insp_date,judge_date,model,lot_no,remark) > > values > > -> (20020816,20020816,'TA-SL5','010',''); > > ERROR 1062: Duplicate entry '127' for key 1 > > mysql> > > > > > > - > > 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 newbie
Hi all, I'm a newbie with mysql. I have a few question and would really appreciate it if you can help me. I'm creating a database for a payroll system. I actually finish with my entity relationship diagram. What should be the next step? I know I should create the database already but while reading the mysql documentation I've been encountering so many questions that I'm getting all confused on where to start. First, where does the priviledges come in? Specifically the alter, drop, select, insert (etc) priviledges come in? Or does this concern the database administrator which is not my concern since I'm only the software developer. Should I create the tables and then what next? Mysql does not a have a feature like access where you link one key to another by dragging one field to another. does this mean that linking the tables in mysql is done manually via the sql statements? Thanks for the advice. lyn _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1062
this query in all probability violates some referential integrity... and this in all probability is a primary key defined in your table. So please check whether the query is trying to insert duplicate values in a primary key field - Original Message - From: "Osman Omar" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Tuesday, August 27, 2002 10:46 AM Subject: ERROR 1062 > Hi > > I get this error. > > any idea? > > > mysql> insert into emcs (insp_date,judge_date,model,lot_no,remark) > values > -> (20020816,20020816,'TA-SL5','010',''); > ERROR 1062: Duplicate entry '127' for key 1 > mysql> > > > - > 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 newbie
Hi all, I'm a newbie with mysql. I have a few question and would really appreciate it if you can help me. I'm creating a database for a payroll system. I actually finish with my entity relationship diagram. What should be the next step? I know I should create the database already but while reading the mysql documentation I've been encountering so many questions that I'm getting all confused on where to start. First, where does the priviledges come in? Specifically the alter, drop, select, insert (etc) priviledges come in? Or does this concern the database administrator which is not my concern since I'm only the software developer. Should I create the tables and then what next? Mysql does not a have a feature like access where you link one key to another by dragging one field to another. does this mean that linking the tables in mysql is done manually via the sql statements? Thanks for the advice. lyn _ Chat with friends online, try MSN Messenger: http://messenger.msn.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
ERROR 1062
Hi I get this error. any idea? mysql> insert into emcs (insp_date,judge_date,model,lot_no,remark) values -> (20020816,20020816,'TA-SL5','010',''); ERROR 1062: Duplicate entry '127' for key 1 mysql> - 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
\T command in 4.0 broken?
is this "tee" or "\T" command supposed to still work in mysql 4.x? the manual says * For logging, you can use the `tee' option. The `tee' can be started with option `--tee=...', or from the command-line interactively with command `tee'. of course there isn't a single example of the syntax in the manual, because we are supposed to just know how to do it i guess. so i can only guess that these commands: pager (\P)Set PAGER [to_pager]. Print the query results via PAGER. [...] tee (\T)Set outfile [to_outfile]. Append everything into given outfile. should work similarly. but this is what happens: mysql> pager less PAGER set to less mysql> tee log.txt No outfile specified! mysql> tee /tmp/log.txt No outfile specified! mysql> tee = /tmp/log.txt No outfile specified! the --tee=filename argument to the mysql client works fwiw... - 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 in making the query to use the index
Hi all, I have a table named expenditure whose create statement is as follows, expenditure | CREATE TABLE `expenditure` ( `expenditureid` int(11) unsigned NOT NULL auto_increment, `expendituredate` date NOT NULL default '-00-00', `artifactid` smallint(5) unsigned NOT NULL default '0', `amount` float default NULL, `userid` int(11) NOT NULL default '0', PRIMARY KEY (`expenditureid`), KEY `searchbydate` (`expendituredate`), KEY `searchbyartifact` (`artifactid`) ) TYPE=MyISAM I have 988 records in this table. My query is select DATE_FORMAT(expendituredate,"%d-%b-%Y") as expendituredate,sum(amount) as amount from expenditure where userid=11 and expendituredate between '2002-8-01' and '2002-8-31' group by expendituredate order by expendituredate; Total number of records that satisfy this date conditon is 283. I have index on the expendituredate but it is not used As my explain outputs the following +-+--+---+--+-+--+--+ -+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+--+--+- + | expenditure | ALL | searchbydate | NULL |NULL | NULL | 988 | where used; Using temporary | +-+--+---+--+-+--+--+- + 1 row in set (0.06 sec) I don't know why the query goes for the full table scan.(As the total no.of rows that satisfy the where condition(date) is less that 30% of the total number of records. Can anyone enlighten me in making the query use the index "searchbydate" with regrads kamesh jayachandran Get your FREE web-based e-mail and newsgroup access at: http://MailAndNews.com Create a new mailbox, or access your existing IMAP4 or POP3 mailbox from anywhere with just a web browser. - 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: max_allowed_packet size!
This is the query i run first - select user.userid, user.name, plan.duration, plan.hour, plan.minute, plan.status, plan.date, project.projectname,project.projectid from user, plan, project where user.userid = plan.userid and project.projectid = plan.projectid and plan.date >= '2002-8-13' and plan.date<='2002-12-31' and user.userid in ('abhijitg','anand','anil_m','gopal','gouri','leena','maheshg','nitin','pras ad','ramesh','rohit','samir_more','sarita','sunilp','uday','vijay','shubhada ','abhilash','aditi','ajayg','deepali','denise','nilanjana','nilashree','pra jakta_p','priya','savio','shilpak','sindhu','usha','valiollah','geetanjalih' ,'saroop') group by plan.userid,plan.date,plan.hour The abover returns around 13000 records When i run the below query it only returns 8000 odd records. The only change is adding of user.designation colum in the query. select user.userid, user.name, user.designation, plan.duration, plan.hour, plan.minute, plan.status, plan.date, project.projectname,project.projectid from user, plan, project where user.userid = plan.userid and project.projectid = plan.projectid and plan.date >= '2002-8-13' and plan.date<='2002-12-31' and user.userid in ('abhijitg','anand','anil_m','gopal','gouri','leena','maheshg','nitin','pras ad','ramesh','rohit','samir_more','sarita','sunilp','uday','vijay','shubhada ','abhilash','aditi','ajayg','deepali','denise','nilanjana','nilashree','pra jakta_p','priya','savio','shilpak','sindhu','usha','valiollah','geetanjalih' ,'saroop') group by plan.userid,plan.date,plan.hour Thanks, Karthik. - Original Message - From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]> To: "Karthik" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, August 27, 2002 10:07 AM Subject: Re: max_allowed_packet size! > Pada Tue, 27 Aug 2002 10:03:59 +0530 > "Karthik" <[EMAIL PROTECTED]> menulis : > > > Hi, > > > > Does the mysql max_allowed_packet restrict the amount of data that a query > > can fetch ? > > > > I am facing a problem wherein my query specifies all the 13000 odd records > > if i specify only a few columns. If i run the same join query with lots of > > columns, it only fetches 8000 odd records. > > could u show us both of the queries ? :D > > -- > Let's call it an accidental feature. > -- Larry Wall > > MySQL 3.23.51 : up 67 days, Queries : 357.150 per second (avg). > > -- > Dicky Wahyu Purnomo - System Administrator > PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790 > Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.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: max_allowed_packet size!
Pada Tue, 27 Aug 2002 10:03:59 +0530 "Karthik" <[EMAIL PROTECTED]> menulis : > Hi, > > Does the mysql max_allowed_packet restrict the amount of data that a query > can fetch ? > > I am facing a problem wherein my query specifies all the 13000 odd records > if i specify only a few columns. If i run the same join query with lots of > columns, it only fetches 8000 odd records. could u show us both of the queries ? :D -- Let's call it an accidental feature. -- Larry Wall MySQL 3.23.51 : up 67 days, Queries : 357.150 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790 Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.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
max_allowed_packet size!
Hi, Does the mysql max_allowed_packet restrict the amount of data that a query can fetch ? I am facing a problem wherein my query specifies all the 13000 odd records if i specify only a few columns. If i run the same join query with lots of columns, it only fetches 8000 odd records. What restriction is it because of ? Thanks, Karthik. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: backup script
Mark Stringham : i think that you can use task plan on windows.such as, backup.bat: mysqldump -uroot -pmysql databasename tablename > tablename.sql move tablename.sql d:\where you want store it\ and add a tast plan in control panel, set the time to 3 o'lock, set the execute application to backup.bat. english not my mother tongue,so i am sorry for my english. >Anyone done it on widows? > >Thanks > >Mark >- Original Message - >From: "Ilyas Keser" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Monday, August 26, 2002 4:26 PM >Subject: backup script > > >> Has anyone a shell script example to backup all mysql databases at 3 >> o'clock at the night? >> >> Thanks... >> ilyas >> Regards conquer [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: NULL ?
Pada Tue, 27 Aug 2002 01:09:32 + "Will K." <[EMAIL PROTECTED]> menulis : > hello, > > Please dont tell me to RTFM on this one (cause I am already doing that), but > for clarity's sake... can someone tell me what it means when you use NULL > and NOT NULL in a query (specifically CREATE TABLE)? Also, when should I > use them? NULL mean empty value ... it's different if you insert value with "" ... for example, you don't want to allow any record which doesn't have anything in firstname field. then you can define the field on table creation : firstname varchar not null try to : insert into (firstname) values (NULL); select * from where firstname is NULL; -- Write clearly - don't be too clever. - The Elements of Programming Style (Kernighan & Plaugher) MySQL 3.23.51 : up 66 days, Queries : 356.880 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790 Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.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 script
Pada Mon, 26 Aug 2002 20:37:46 -0600 "Mark Stringham" <[EMAIL PROTECTED]> menulis : > Anyone done it on widows? > > Thanks > > Mark for dumping, the syntax is same ... mysqldump bla bla bla ;-) but for the time, you have to use scheduler application to run the mysqldump :D -- Write clearly - don't be too clever. - The Elements of Programming Style (Kernighan & Plaugher) MySQL 3.23.51 : up 66 days, Queries : 356.856 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790 Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.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 script
Anyone done it on widows? Thanks Mark - Original Message - From: "Ilyas Keser" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 26, 2002 4:26 PM Subject: backup script > Has anyone a shell script example to backup all mysql databases at 3 > o'clock at the night? > > Thanks... > ilyas > > - > 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: Continuing LOAD LOCAL INFILE issues..
>Stuart Low wrote: > > Have had continuing issues with trying to actually get LOAD LOCAL INFILE > > commands working >At 11:45 26/08/02 +0300, Victoria Reznichenko wrote: >Did you specified local-infile=1 for client, too? Hi, I'm a MySQL newbie and I've got a question on this too. I can't get MySQL to load a txt file, I'm using the latest Windows version. This may be a dumb question, but where exactly do I enter the local-infile=1 command? Do I add it into the my.ini file or does this have to be entered every time I start MySQL? Regards, Andrew McPhee - 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
NULL ?
hello, Please dont tell me to RTFM on this one (cause I am already doing that), but for clarity's sake... can someone tell me what it means when you use NULL and NOT NULL in a query (specifically CREATE TABLE)? Also, when should I use them? Will K. _ Send and receive Hotmail on your mobile device: http://mobile.msn.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
Help to join 5 tables
Hi guys I would like to have a SQL query to couple five tables to accomplish my need. This is a search page and the user will be searching using the don_id Presently I am using a simple equi join which works fine if all the five tables contain data for user_id But if any of the tables have no value for that particular don_id, it is obvious that nothing is being displayed. I think that a left join will be better but can't get one to display results from all the five tables And the don_id is not unique in the claim table. So claim table can have same don_id any number of times, I would like to display all the claim details for that particular don_id with unique values from other tables also. Here are the tables 1.CREATE TABLE don(don_id char(20) primary key , buy_date date not null) ; 2.CREATE TABLE enduser( user_id char(20) primary key, user_name varchar(50) not null, user_addr_str varchar(150), don_id char(20) unique not null, pro_pd char(20) unique not null, maker varchar(150), cpu varchar(150)) ; 3.CREATE TABLE usersale(user_sale_id varchar(20) primary key, user_id varchar(20) not null, don_id varchar(20) unique not null, pro_pd varchar(16) unique not null) ; 4.CREATE TABLE ssale(shit_sale_id varchar(20) primary key, s_id varchar(20) not null, don_id varchar(20) unique not null , pro_pd varchar(16) unique not null); 5.CREATE TABLE claim(claim_id int auto_increment primary key, user_id varchar(20) not null, don_id varchar(20) not null, pro_pd varchar(20) not null, claim_date date not null, claim_det text not null) ; Note: Also I may include more tables in the future.I am writing the sql query during the runtime by getting field values from the user input through check boxes and so I would prefer to have a single query to do this. Hope that some of you can help me and thanks in advance Kayamboo suresh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling mysql under MacOS X v10.2 (Jaguar)
On Monday, August 26, 2002, at 06:33 PM, [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text of it > in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to > do > with MySQL. Just typing the word MySQL once will be sufficient, for > example. > > You have written the following: > > If you don't want to use someone else's binary, here is a fix for > building your own from source (posted to MacOSXHints.com): > > http://www.macosxhints.com/article.php?story=20020824083101804 > > > Derek > - 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 script
I use a shell script and set up a cron job. Here's the shell script (I call it mydbbak.sh) # #!/bin/sh # # Create /dbbakup directory # $1 = Unix/MySQL Username # $2 = Unix/MySQL Password if [ ! -e /dbbakup ] then mkdir /dbbakup chmod 777 /dbbakup -R fi mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs --databases database1>/dbbakup/database1.sql mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs --databases database2>/dbbakup/database2.sql mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs --databases database3>/dbbakup/database3.sql # And here's the line from the crontab ... # Make backups of databases at 3am daily 0 3 * * * /usr/local/bin/mydbbak.sh Gerald Jensen - Original Message - From: "Ilyas Keser" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 26, 2002 5:26 PM Subject: backup script Has anyone a shell script example to backup all mysql databases at 3 o'clock at the night? Thanks... ilyas - 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 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
backup script
Has anyone a shell script example to backup all mysql databases at 3 o'clock at the night? Thanks... ilyas - 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: Inserting a text or Word file into mysql
On 26 Aug 2002, at 15:32, Donald J Miller wrote: > CREATE TABLE filetest(fileid int(5) not null, file BLOB null); > > I 've created the table and have used LOAD DATA in order to populate the > database however I get numerous errors. Can someone shed some light as > to how to do this correctly? What would be the proper query to retrieve > this file out of mysql? You're not giving us much to go on. How exactly did you use "LOAD DATA"? How did you escape the data? What do the "numerous errors" say? Retrieving the data works the same as retrieving any other data from MySQL: you use "SELECT column_name FROM ...". -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org - 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
Binary Package
I'm running SuSE 7.3 Professional with dual AMD 1.2GHz CPUs. I'm fairly confident that the binary package MySQL 3.23.52 Linux (Intel libc6 systems) (9.1M) will work, but I'm not 100 percent sure - it's the only logical option considering what's available. Can someone confirm? Michael - 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's wrong with this code?
Hi everyone, In the following code: sub DATEJOINED{ my %arg = @_; if (! $arg{USER}) {return undef} return $arg{USER}->get(field=>'RegistrationDate'); } The field Registration date is returned from the mysql table for the user who is currently logged in in the following format: Thu, Mar 1st, 2001 What I would like to do is change this date to the raw format (i.e. 20010801) Can anyone please tell me how I can do this? I tried the following, but get a bunch of errors! sub DATEJOINEDRAW { my %arg = @_; if (! $arg{USER}) {return undef} return $arg{USER}->get(field=>'DATE_FORMAT(RegistrationDate, '%M %e, %Y')'); Thanks so much. - 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: Allowing a whole class C to access mysql server?
If you don't want to do any username checking (just checking a password) you can use a blank username. Easiest way to do this is probably something along the lines of: GRANT SELECT ON db.* TO temp@'192.168.1.0/255.255.255.0' IDENTIFIED BY 'mypass'; UPDATE mysql.user SET user = '' WHERE user ='temp' AND host = '192.168.1.0/255.255.255.0'; FLUSH PRIVILEGES; Then anyone coming from the 192.168.1.* C-class will be able to access by just specifying a password. You may have to be a little careful that using a blank username doesn't kill any other perms you have set up: read the docs about the order in which things are matched to determine appropriate user perms. -Chris On Mon, 2002-08-26 at 16:15, Adam Ryan wrote: > > How can I get this to allow access from any user with the correct passwd > to the main mysql server? Any user for the 192.168.1% class with a > correct passwd. > It seems I can't have a wildcard for the user statement below? > > > Thanks > > -Original Message- > From: Chris Tucker [mailto:[EMAIL PROTECTED]] > Sent: Sunday, August 25, 2002 6:58 PM > To: Adam Ryan > Cc: [EMAIL PROTECTED] > Subject: Re: Allowing a whole class C to access mysql server? > > > GRANT SELECT ON db.* TO user@'192.168.1.0/255.255.255.0' > should do the trick: you just specify the IP you want to allow and the > netmask to apply to it after the /. You could also use: GRANT SELECT ON > db.* TO user@'192.168.1.%' as documented in the manual > (http://www.mysql.com/doc/en/GRANT.html). Documentation on the netmask > method can be found at > http://www.mysql.com/doc/en/Connection_access.html > > -Chris > > On Sun, 2002-08-25 at 14:25, Adam Ryan wrote: > > > > > > Hi, > > > > I am trying to have a whole class C access the mysql server on the > > network. The class C needs to access many different database names. > > So adding an entry for each Ip address wouldn't work. Does anyone > > know how I can go about this? > > > > Thanks, > > > > Adam > > > > > > - > > 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 > > > - 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: Allowing a whole class C to access mysql server?
How can I get this to allow access from any user with the correct passwd to the main mysql server? Any user for the 192.168.1% class with a correct passwd. It seems I can't have a wildcard for the user statement below? Thanks -Original Message- From: Chris Tucker [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 25, 2002 6:58 PM To: Adam Ryan Cc: [EMAIL PROTECTED] Subject: Re: Allowing a whole class C to access mysql server? GRANT SELECT ON db.* TO user@'192.168.1.0/255.255.255.0' should do the trick: you just specify the IP you want to allow and the netmask to apply to it after the /. You could also use: GRANT SELECT ON db.* TO user@'192.168.1.%' as documented in the manual (http://www.mysql.com/doc/en/GRANT.html). Documentation on the netmask method can be found at http://www.mysql.com/doc/en/Connection_access.html -Chris On Sun, 2002-08-25 at 14:25, Adam Ryan wrote: > > > Hi, > > I am trying to have a whole class C access the mysql server on the > network. The class C needs to access many different database names. > So adding an entry for each Ip address wouldn't work. Does anyone > know how I can go about this? > > Thanks, > > Adam > > > - > 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
GMT?
Hi, Is there a way convert result of SELECT NOW() or SELECT SYSDATE() or SELECT CURRENT_TIMESTAMP to GMT, in a query? Thanks, Pekka - 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 basics
Please checks the documentation that comes with mysql. It is an excellent source to learn MySQL. -Original Message- From: Robert McKerlie [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 12:27 PM To: [EMAIL PROTECTED] Subject: mysql basics Can anyone suggest a good tutorial for someone just starting out with MYSql? Regards Robert - 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
Inserting a text or Word file into mysql
Hello everyone, I am trying to create a mysql table to hold either the entire contents of text or WordPerfect files. I've read about BLOB or TEXT type columns so I've tried creating a table such as: CREATE TABLE filetest(fileid int(5) not null, file BLOB null); I 've created the table and have used LOAD DATA in order to populate the database however I get numerous errors. Can someone shed some light as to how to do this correctly? What would be the proper query to retrieve this file out of mysql? Thanks! Don - 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 basics
Can anyone suggest a good tutorial for someone just starting out with MYSql? Regards Robert - 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
error on self join
I need to run the following query: SELECT WRK_ImplDisp_1.Livello, WRK_ImplDisp_1.Origine, WRK_ImplDisp.Padre, WRK_ImplDisp_1.Figlio, WRK_ImplDisp.QUnit*WRK_ImplDisp_1.QUnit AS Espr1, WRK_ImplDisp_1.DaAggregare, -1 AS Espr2 FROM WRK_ImplDisp INNER JOIN WRK_ImplDisp AS WRK_ImplDisp_1 ON WRK_ImplDisp.Figlio = WRK_ImplDisp_1.Padre WHERE (((WRK_ImplDisp_1.Origine)='SA1539T' And ((WRK_ImplDisp_1.Origine)=[WRK_ImplDisp].[Origine] Or (WRK_ImplDisp_1.Origine) Is Null)) AND ((WRK_ImplDisp.DaAggregare)=True) AND ((WRK_ImplDisp.Livello)=2)); but I receive an ODBC error : can't reopen table : wrk_ImplDisp1 error #1137 The table is temporary; the table is created with : CREATE TEMPORARY TABLE WRK_ImplDisp(IDIMPL INT(11) NOT NULL auto_increment,Origine CHAR(19) NOT NULL,Livello smallint NOT NULL, Padre char(19) NOT NULL,Figlio char(19) NOT NULL,QUnit REAL NOT NULL,DaAggregare tinyint NULL,FlagCompat smallint NULL,Nord int NULL, PRIMARY KEY (IDIMPL), KEY Origine (Origine), KEY Padre (Padre), KEY Figlio (Figlio), KEY OrigineLivello (Origine,Livello), KEY DaAggregare (DaAggregare),KEY FlagCompact (FlagCompat)); MySQL 3,23,52 -max ODBC 3.51 How I can solve this problem ? Today a query like this is running under MSAccess97 ; the only difference is about the "temporary", which is impossible on MSAccess. Tks in advance Massimo Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [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: Re: Still trying to build libmysqld.a on Tru64
Randall, Saturday, August 24, 2002, 12:54:30 AM, you wrote: RS> At 02:09 PM 8/23/2002 -0500, Dan Nelson wrote: >>It looks like a mysql developer will have to look at vio_read and >>figure out why the assert's failing. RS> Dan, RS> I was afraid it would be something like that. Thanks for all of your RS> help in tracking it down at least this far! I assume that the MySQL RS> developers at least monitor this list, or should I contact a different list RS> or address directly? RS> Just for grins, since I noticed that the assert macro does nothing in RS> non-debug mode, I rebuilt everything without the debug options to see if RS> 4.0.2 reacted differently than the previous tests I had done with RS> 4.0.1. Although the stack trace was pretty useless, this time I got the RS> following text written to stdout or stderr before the core dump: RS> exception system: exiting due to multiple internal errors: RS> handler returned invalid disposition RS> handler returned invalid disposition RS> exception system: exiting due to multiple internal errors: RS> handler returned invalid disposition RS> exception dispatch or unwind stuck in infinite loop RS> Abort process (core dumped) RS> None of that means anything to me, but it might to someone else. Randall, it's a known issue and it fixed in 4.0.3 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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: Re: mysql_com.h header name space pollution
Daniel, Monday, August 26, 2002, 12:53:26 AM, you wrote: DN> some time ago I submitted the bug report below (see DN> http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:116815:200208:nnjofboiddhkghnpfljl DN> for the full report). There was no feedback and I now have a better DN> understanding of the problem: DN> The bug means that you cannot compile a KDE3 program with embedded MySQL DN> support. KDE cannot do anything about this, as its API is frozen. The DN> MySQL API shouldn't be frozen (as 4.0 is still alpha), and on the other DN> hand, the error is trivial to fix for MySQL (just rename "NET"). So DN> please, apply a fix so that KDE programs can use embedded MySQL. In 3.23. there is the same NET and 3.23 is stable. You can just do #include #undef NET DN> Regards DN> Daniel >>Description: >>"NET" is defined on line 135 in myslq_com.h. When I include >>mysql.h (for embedded mysql) I cannot compile a program which also >> includes netwm_def.h, which defines a completely different "NET". >>Fix: >>Please rename "NET" to something like "MySQL_NET" -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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: spanish books about mysql?
Well, I bought "MySQL", EdiciĆ³n Especial from Paul DuBois. The editor is Prentice Hall. Maybe you can buy it at www.pearsoneducacion.com... jeje I found one about MySQL and Perl there. - Original Message - From: "Markus Jais" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 24, 2002 5:01 AM Subject: spanish books about mysql? > hello > I searched amazon.com for spanish books about mysql or postgresql > but I couldn't find anything. and there is no amazon.es. > does anybody know if there is a online shop where I can search > for spanish books about mysql??? > thanks in advance > markus - 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
Can't download 4.0.2 for Solaris...:(
Hi, I'd like to download 4.0.2 for SPARC from http://www.mysql.com/Downloads/MySQL-4.0/mysql-4.0.2-alpha-sun-solaris2.8-sp arc.tar.gz but I can't and I don't know why... Could you help me please, where should I look for a downloadable version? Thanks in advance! Regards; Istvan - 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: Continuing LOAD LOCAL INFILE issues..
SL> working. Basically, no matter what I specify with LOCAL LOCAL INFILE mysql SL> refuses to let my user (setup via Plesk) do a thing. >Did you specified local-infile=1 for client, too? Yes. Although it is in phpMyAdmin the original issue is occuring (although I can replicate it with the console client). SL> Anyone have any suggestions? I get the feeling this is more of a MySQL Dev SL> team screw up more than anything (at least judging by the comments posted on SL> the LOAD LOCAL INFILE section of the doc pages). > What version of MySQL do you use? There were some bugs in 3.23.49 in > both client and server. It was 3.23.49, however, I downloaded and recompiled from sources 3.23.52 thinking it might be a plesk specific issue. I basically, specified the prefix to be the original MySQL location (/usr/local/psa/mysql) then moved the old version out and copied over the var directory to maintain my original DBs. Basically, what I am looking for is a LOAD LOCAL INFILE ability for Plesk users without granting the File_priv flag. Any ideas? Stuart - 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
numeric type, get count of decimals
I am writing a library which is using mysql. I need to know the count of the *maximum* decimals of a NUMERIC column before issuing a mysql_fetch_row(). I get the width of the field by: MYSQL_FIELD *fields = mysql_fetch_fields (MYResult); printf ("Width: %d\n", fields[i].length); Doing a "DESCRIBE TABLE" is not an option since another query would have to be executed for every select statement. Thanx in advance, Stefan __ WEB.DE Club - jetzt testen fur 1 Euro! Nutzen Sie Ihre Chance unter https://digitaledienste.web.de/Club/formular/?mc=021105 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: full text search problems
On Sun, 25 Aug 2002, andy wrote: > Hi there, > > I am trying to write a php script to perform a full text search on a mysql > db. I do a match against... and it digs out some results out of the db. > > There are 2 problems: > > 1. > 2. Is it possible with php to underline the keyword inside the search > results. This might be more tricky. Andy, I am working on the same problem. So far I figured out that it must be handled outside MySQL. My application (a bash script) creates a sed script on the fly and pipes the result through sed. Code fragment looks like: cat /dev/null > $SEDSCR for wrd in $MARK ; do echo "s|$wrd|&|Ig" \ >> $SEDSCR done and then echo "$QUERY" | mysql $MYOPTS | sed -f $SEDSCR The problem is to eliminate unused keywords the same way as MySQL does. I have quite an extensive stopword list ft_static.c. Good ideas how to handle this are welcome. The biggest problem is the way ft search handles ignored words. This is hard to repeat outside MySQL. Thomas Spahni -- filter: sql query - 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
perl's DBD::mysql on Cygwin
hello robert, you might want to try it without any options to Makefile.pl. if you installed mysql on cygwin, put the mysql bin dir on your path so mysql_config can be found, then the correct flags should be there. even with flags, you should write --libs='...' instead of "--libs=" make was ok then for me, still some tests failed ... regards, tom -- - 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: Continuing LOAD LOCAL INFILE issues..
Stuart, Monday, August 26, 2002, 4:28:13 AM, you wrote: SL> Have had continuing issues with trying to actually get LOAD LOCAL INFILE SL> commands working. Even after a MySQL recompile it doesn't appear to be SL> working. Basically, no matter what I specify with LOCAL LOCAL INFILE mysql SL> refuses to let my user (setup via Plesk) do a thing. Did you specified local-infile=1 for client, too? SL> Anyone have any suggestions? I get the feeling this is more of a MySQL Dev SL> team screw up more than anything (at least judging by the comments posted on SL> the LOAD LOCAL INFILE section of the doc pages). What version of MySQL do you use? There were some bugs in 3.23.49 in both client and server. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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: missing records
Dave, Saturday, August 24, 2002, 2:53:59 AM, you wrote: DR> I upgraded my server and seem to have lost some MySql records. Is there a way to recover lost records? DR> Or could it be a index problem? If you check tables with CHECK TABLE clause, do you get any error or warning? If so, repair table. You can also re-create indexes with myisamchk utility. If it doesn't help, check the following section of the manual: http://www.mysql.com/doc/en/No_matching_rows.html and at the end send a bug report. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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