Re: mysq passwords reset !
I find a blank mysql database, all is ok !:) ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysq passwords reset !
Hi, I updrae my windows binaries server, and save my old datadir. I copy it to the new datadir, i already did that it works ! I use to put no password to mysql database, I secure mysql by closing via a firewall the 3306 port, it so annoying to find a password for each of my db ... But now when connecting to my database, I ve got an erro : acces denied for root@localhost : password no , if i translate into english. How can i bypass this. I think that when replacing new mysql database 'mysql' (that contains pass) by the old, i say to not override the new so i lost my old mysql database that says no pass for everybody. I notice that my mysql database dir has the date of yesterday so the newest :( Where can I find one that allow me to connect to my databases, at least mysql, a mysql blank of rights database. Thanks. ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
gemini/acid or innodb ?
Hello, I found an other table type for transaction : "The simplicity of ACID transactions is especially important in a distributed database environment where the transactions are being made simultaneously. Learn more about the Gemini table type that supports ACID Transactions." Find in nusphere site. Is gemini better than innodb ? How can i get gemini table type ? Is gemini a solution of nusphere (corp.) and Innodb a solution of mysql (corp.) ? How beeing objective ? Thanks. ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Tinytext index howto ?
Hi, I have a column that can have 850 chars at max. I think that I can only put this in a tinytext col type. How can I hav an index to this col mysql refuse me to add one ? Thanks. ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How can i store japanese into mysql ?
Hi, I try to store japanese into mysql : PHP seems to works great with japanese strings. $jap=",g,rfR[fhõ^øiZQlj,SO. "; And then it displays kanjies. But I didnt manage to store char into the database ? How can I do ? Thanks. ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error: 7 - Error on rename ... (Errcode: 13)
Hi all, While trying to upgrade a table struture i get the following error : ALTER TABLE Prefixtest_T_Stories ADD COLUMN IndexDisplay char(1) default 'Y' >>> Error: 7 - Error on rename of '.\testbase\Prefixtest_t_stories.MYI' to '.\testbase\#sql2-118-3.MYI' (Errcode: 13) I m running a mysql 401 on windows xp. thanks. ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to retrieve the 2 last char of a string stored in db
how to retrieve the 2 last char of a string stored in db ? : SELECT LENGTH(db) as len , SUBSTRING(db from len-2 ) from nlconfig; NOT WORK .! In php by example, there is a substr with a negative pos that give char at end ! no in mysql ! ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.comm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 last_insert_id and replace ? !
Hello, I ve got mysql 4.0.1 I don't understand what happen. I use to make replace other than insert in order to avoid error in php scripts. I have a table with on primary key : CREATE TABLE `nlconfig` ( `id` tinyint(4) NOT NULL auto_increment, `nomnews` varchar(255) NOT NULL default '', `hebergeur` varchar(255) NOT NULL default '', `fromc` varchar(255) NOT NULL default '[EMAIL PROTECTED]', `fromonline` varchar(255) NOT NULL default 'contact', `limitconf` tinyint(2) NOT NULL default '7', `host` varchar(255) NOT NULL default 'localhost', `user` varchar(255) NOT NULL default 'root', `passwd` varchar(255) NOT NULL default '', `db` varchar(255) NOT NULL default 'newsfr', `tablenews` varchar(255) NOT NULL default 'news', `tabletemp` varchar(255) NOT NULL default 'temp', `tablelog` varchar(255) NOT NULL default 'log', `tableconfig` varchar(255) NOT NULL default 'nlconfig', `admin_pass` varchar(255) NOT NULL default 'pikatchu', `limitlog` tinyint(2) NOT NULL default '10', `url` varchar(255) NOT NULL default '', `pathtopmn` varchar(255) NOT NULL default 'http://www.test.fr/fr/', `langfile` varchar(255) NOT NULL default 'lang-french.php', `welcome_subj` varchar(255) NOT NULL default 'bienvenue', `welcome_msg` text NOT NULL, `sub_msg` text NOT NULL, `pied` tinytext NOT NULL, `validation` tinyint(1) NOT NULL default '1', `description` text, `newstemplate` varchar(100) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; When inserting with mysqlfront windows client : replace into nlconfig values (last_insert_id(),'abc', 'nexen', 'a@', 'a', '', 'localhost', 'root' , '', 'newsfr', 'news', 'temp', 'log', 'nlconfig', 'lucas', '', '', 'http://www.test.fr/fr/', 'lang-french.php', '','','','', '1','','' ); 1st on row affected 2nd 2rows. I get no error. But from a php 4.06 script I get : errno 1062: erromsg : Duplicata du champ '127' pour la clef 1 That means : duplicate value for key 1. That the same error i get with NULL in id with the windows client ?! Could you explain me what happen. I only want to insert a new row when values are different from what is on the table, and to replace the row that there is when there is the same id or when all the data in query is the same ! Is it for that, that replace is for ? Thanks. ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.comm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
full text with union pb
Hi all, I ve got some errors while making a query that managing match (full text) and union, both on boolean mode and the other mode. When I m working with "like" i get no error. I m working with mysql 4.01 4.02. Tables have the sames number of fields ... Indexes seems to have been created ... See what type of query i make : SELECT 'FR' as lang,* FROM `Linux-FR`.Stories WHERE match (Summary,Content,Heading) against ('words' IN BOOLEAN MODE) AND Verified = 'Y' union SELECT 'US' as lang,* FROM `Linux-US`.Stories WHERE match (Summary,Content,Heading) against ('words' IN BOOLEAN MODE) AND Verified = 'Y' I get : Got error -1 from table handler here is the create statement CREATE TABLE `Stories` ( `Rid` varchar(16) NOT NULL default '', `Verified` char(1) default NULL, `Score` int(11) default NULL, `Heading` varchar(96) default NULL, `Summary` text, `Content` text, `Author` varchar(32) default NULL, `AuthorEmail` varchar(96) default NULL, `AuthorURL` varchar(96) default NULL, `Birthstamp` datetime default NULL, PRIMARY KEY (`Rid`), FULLTEXT KEY `Summary` (`Summary`,`Content`,`Heading`,`Author`), FULLTEXT KEY `Summary_2` (`Summary`,`Content`,`Heading`,`Author`), FULLTEXT KEY `Summary_3` (`Summary`,`Content`,`Heading`,`Author`), FULLTEXT KEY `Summary_4` (`Summary`,`Content`,`Heading`,`Author`), FULLTEXT KEY `Summary_5` (`Summary`,`Content`,`Heading`,`Author`) FULLTEXT KEY `Summary_6` (`Summary`,`Content`,`Heading`,`Author`) FULLTEXT KEY `Summary_7` (`Summary`,`Content`,`Heading`,`Author`) ) TYPE=MyISAM; Thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql case sentivity table names
Hi all, You surely take note that a mysql server under windows take the same table when selecting from T_User or t_user, it is case insensitive. Every update into these tables rename all case sensitive table into insensitive one. I have to be carfull to check my tables names before copying datadir file from my windows box to nix one. I found a utility which ca avoid me to do that : http://www.0x00.org/programs/CASElow/index.php It make caseinsentive shell !!! Can we put it in the distrib ? Thanks _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql and order in a query
I think of a little hack I can add in where clause something like : ELT(language,'english','german','french') != 0 to avoid language not in list even if there no normally :) I try this as soon as i can. thanks. > * Paul DuBois > > At 18:03 +0200 4/6/02, David yahoo wrote: > > > Is there any way to put a sort order different than the > > > alpahbetical order in string. > > > > > >A thing like that order "french","german" > > > > > > ORDER BY ELT(language,'english','german','french'),Linkname ASC > > Maybe you meant FIELD(language...? > > From the manual: > > Changes in release 3.20.17 > -- > [...] >* The `ELT()' function is renamed to `FIELD()'. The new `ELT()' > function returns a value based on an index: `FIELD()' is the > inverse of `ELT()' Example: `ELT(2,"A","B","C")' returns `"B"'. > `FIELD("B","A","B","C")' returns `2'. > > The language column is a string containing 'english', 'french' or 'german'. > > The order of the fields in the FIELD() should be the order of what you want > as a result: 'french','german','english' will give you 'french' items > first, 'english' items last. Beware that any item with a language not > existing in the field list will get a zero value, and be sorted first. > > -- > Roger > 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 _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql and order in a query
Hi all, I d like to order some links which are in 2 langauage (French/English). So i make this request in case a visitor select french in language so french links where on top in this case because "f"rench is after "e"nglish in alphabectical order. SELECT * FROM links WHERE Accepter LIKE 1 AND CatID LIKE 43 ORDER BY language DESC,Linkname ASC; And for english selection I make this. SELECT * FROM links WHERE Accepter LIKE 1 AND CatID LIKE 43 ORDER BY language ASC,Linkname ASC; If I like to introduce german by example, what kind of query i have to do to put french links on top asc->english desc->german. french ? Is there any way to put a sort order different than the alpahbetical order in string. A thing like that order "french","german" Thanks. query sql mysql _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
dumps issue
Hi all, I hav a problem while dumoing my data into a mysql server provider. I have some lost connexion during dumping. So I have to delete by hand the lines inserted and then resrtar wuth the other. Do u know a tool that can make this for me. That meens redo with lines which hadnt been treated again. Thnaks. sql query _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
strange multiple delete
Hi all, I make a new delete query (mysql 4.02) delete t1,t2 from t1,t2 i t takes a long it displays 100931 rows affected. i count all the rows into t1 it give the same result before the delete. I make a du -h of the database dir it give the same results ?. So i have some doubt (it seems to not work) I make the queries it again 0 rows affected. it seems to work. And when selecting rows that should be deleted it gives me these rows ? I think there a bug in this new functonnality ! Making three deletes (for my three tables) is very long ! Thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: multiple delete for mysql
I have : mysql> select version(); +---+ | version() | +---+ | 4.0.2-alpha-debug | +---+ 1 row in set (0.00 sec) But an error too : mysql> delete -> from -> externallink as link, -> topic as topic, -> topiclink as joiner -> where -> link.resid = joiner.resid and -> topic.catid = joiner.catid and -> topic.rid like "%Industry%"; ERROR 1064: You have an error in your SQL syntax near 'as link, topic as topic, topiclink as joiner ? thanks. > mysql version 4.x does this > > -Original Message- > From: David yahoo [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 01, 2002 5:28 PM > To: [EMAIL PROTECTED] > Subject: multiple delete for mysql > > > Hi all, > > How can i do a delete from multiple table in mysql? > > Eg : > > I want ot delete record something like that I dont when to select but delete > > delete > from > externallink as link, > topic as topic, > topiclink as joiner > where > link.resid = joiner.resid and > topic.catid = joiner.catid and > topic.rid like "%Industry%"; > > I want to delete row from link joiner and topic too on cascad that > correspond to that. > > Or have i to do 3 delete ? > > delete from topic where rid like "%industry%" > and now how to delete ? where topic.id "not in" joiner ? > and finaly how to delete link that doesnt have their id in joiner ? > > > Thanks. > > > _ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: get difference between two tables
mysql> select table1.* from table1 LEFT JOIN table2 ON table1.column_1=table2.column_2 where table2.column_2 is NULL; try this to select row of table 2 not in table 1, i think. > Hi all, > > I want to get the difference between 2 tables. > > table_1: > column_1 > A > B > C > D > > table_2: > column_2 > B > C > > What is the sql select syntax to get as result A,D or B,C? > > Thanx for your help. > > Regards, > Bernd > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
optimizing table space
Hi all, I d like to now is there any way to optimize mysql table space judging from the data there is in. My table can be read only. I put some arbitrary varchar(x) which ddn t correspond to true max len in table. Is there a free gpl tool to diagnose my tables ? Thanks. query -> sql -> mysql _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
optimizing table space
Hi all, I d like to now is there any way to optimize mysql table space judging from the data there is in. My table can be read only. I put some arbitrary varchar(x) which ddn t correspond to true max len in table. Is there a free gpl tool to diagnose my tables ? Thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
multiple delete for mysql
Hi all, How can i do a delete from multiple table in mysql? Eg : I want ot delete record something like that I dont when to select but delete delete from externallink as link, topic as topic, topiclink as joiner where link.resid = joiner.resid and topic.catid = joiner.catid and topic.rid like "%Industry%"; I want to delete row from link joiner and topic too on cascad that correspond to that. Or have i to do 3 delete ? delete from topic where rid like "%industry%" and now how to delete ? where topic.id "not in" joiner ? and finaly how to delete link that doesnt have their id in joiner ? Thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ib* files and their rules
i run a mysql : mysql> select version(); +---+ | version() | +---+ | 4.0.2-alpha-debug | +---+ 1 row in set (0.00 sec) on a mandrake 8.1 box. on /var/lib/mysql (DATADIR), I have several ib* file note that I have mysql max install. what the rule of this big file about 60Mb gor my ? Is it index for fulltext of MySQL file (ino db) ? I remove mysql max can i remove this files ? I remove Thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
pb while starting mysql
Hi all, I accidently move some database dir temporary (for space pb) but when moving I surely forget something I cant no longer start my server. I put the sock file where it had to be but nothing more. See that www:/var/lib/mysql# ls -ls total 100 4 drwxr-xr-x2 mysqlmysql4096 avr 1 02:04 ddbase/ 4 -rw-rw1 mysqlmysql 0 avr 1 02:58 ibdata1 4 drwxr-xr-x2 mysqlmysql4096 mar 21 00:43 mysql/ 0 srwxrwxrwx1 mysqlmysql 0 avr 1 03:05 mysql.sock= 88 -rwxr-xr-x1 mysqlmysql 84518 avr 1 03:05 www.mydomain.com.err* www:/var/lib/mysql# telnet localhost 3306 Trying 127.0.0.1... telnet: Unable to connect to remote host: Connection refused www:/var/lib/mysql# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m ysql.sock' (111) What can i do ?, I dont know what things i delete or forgot to move again, everythings seem ok. my os : linux mandrake 8.1 ... thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem for starting or connecting ?
Hi all, I accidently move some database dir temporary (for space pb) but when moving I surely forget something I cant no longer start my server. I put the sock file where it had to be but nothing more. See that www:/var/lib/mysql# ls -ls total 100 4 drwxr-xr-x2 mysqlmysql4096 avr 1 02:04 ddbase/ 4 -rw-rw1 mysqlmysql 0 avr 1 02:58 ibdata1 4 drwxr-xr-x2 mysqlmysql4096 mar 21 00:43 mysql/ 0 srwxrwxrwx1 mysqlmysql 0 avr 1 03:05 mysql.sock= 88 -rwxr-xr-x1 mysqlmysql 84518 avr 1 03:05 www.mydomain.com.err* www:/var/lib/mysql# telnet localhost 3306 Trying 127.0.0.1... telnet: Unable to connect to remote host: Connection refused www:/var/lib/mysql# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m ysql.sock' (111) What can i do ?, I dont know what things i delete or forgot to move again, everythings seem ok. my os : linux mandrake 8.1 ... thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql special query
Hi all, Thanks for helping me with escape " previously, a stripslash like (cf php ) mysql function would be easy in next version, i think. I d like to make another strange query is :: I have a table with row having some flag column (0/1) several a set. I d like to retieve each that doesnt have only one 1 in a set of column. Is there any better way which avoid to make an addition and check the result. Something with mysql native function ? Thanks _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql stripslash fonction ? to escape ' ""
I know that function in php, but I generate sql from a sql queries in order to export some data from on database to another. I make something like that : select concat('INSERT INTO links VALUES(NULL,"99","',link.about,'","', from links, ... this queries gives me sql insert command. but in some field eg : link.about there is " char but " is my string delimiter, so in that particular case where about field has " on it the string is prematurly terminated and gives me wrong sql insert. i d like to have a mysql function to escape char in field about so i can make rigth insert in all case. I d like to avoide addition scripting langage, sql is enough ? Thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql stripslash fonction ? to escape ' ""
Hi all, I generate some sql statement with a sql query and make some insert. But when inserting, I get some surprises with some strings value which contains ' or " , " cant be escape because its my string delimiter. How can I do to correct this : is there a mysql function stripslash (eq in php). a+. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql fulltext index doesnt seems to do things
Hi all, I have a uge table data about 700mb pii 333 200mb ram. mysql 4.02. I try to add a full text index alter table listing add fulltext (about,title,description); but it seems to do noit effect the ib files in the datadir seems to keep the same length no grow. when querying it say no full text index for that columns ERROR 1191: Can't find FULLTEXT index matching the column list the mysql client seems to consume when asking for idexin via a alter table listing add fulltext (about,title,description); query. so I kill him what can i do ? thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
huge sql dump strange file
Hi all, I make a huge sql dump to mysql client ie : mysql < dump.sql the dump.sql is nearly 650 MB. I get some strange file near my table files : 12 -rw-rw1 mysqlmysql8678 mar 28 22:26 /var/lib/mysql/doz/#sql-9a8_17.frm 63428 -rw-rw1 mysqlmysql64880640 mar 28 22:51 /var/lib/mysql/doz/#sql-9a8_17.MYD 129304 -rw-rw1 mysqlmysql132075520 mar 28 23:39 /var/lib/mysql/doz/#sql-9a8_17.MYI can I delete them ? Thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: pb while querying in strange db name
we have to escape name select * from `db-name`.`table-name`; works. great mysql.! _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
pb while querying in strange db name
Hi all, I ve got a database with the name db-name when making : select * from db-name.table; I get a error. something is wrong in your syntex near : -name ... How can I tell mysql that db-name is a database name ? Thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
check sql int a sql file before submitting
Hi all, I d like to sql a huge sql that I have before submitting to the server. I notice that when 1 erreor is encounter the serveru stop to precess. I d like to list all the errors that are in that sql file. Because I generate it n want to know all my erreors at one time in order to repair all theme in one time. And don't want to process each time I encounter an error. I m thinking about sql syntax. thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Capacité Mysql
Here we speak english. Ici on parle anglais. Tu peut copier les fichiers binaires des tables de mysql (*.MYD *.MYI *.frm) dans le DATADIR ex : linux /var/lib/mysql par contre il doit y avoir des problemes avec l intégrité des données. Je te conseil de lire la doc de mysql en francais ss nexen.net. a+ > Bonjour, J'utilise Mysql 3.23... sous un environnement Solaris 7. La taille de la base de donnée est de 1Go 5. Quelles sont les limites pour le bon fonctionnment de mysql ? Existe il un moyen plus rapide de faire des copies de bases que le dump ? Merci Cordialement, Tony Jarriault --- Service webmaster : mailto:[EMAIL PROTECTED] Tel : 01-34-49-06-69 MGN : http://www.mgn.fr --- Tony Jarriault mailto:[EMAIL PROTECTED] Tel : 01-34-49-06-43 MATRA GLOBAL NETSERVICES Societé du groupe PROSODIE 8, rue Grange Dame Rose 78140 Vélizy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
rdf utf-8 -> to mysql howto
Hi all, My purpose is to transform an rdf utf-8 file into sql for mysql. Data are both in french/english, in french there are stange caractere that doesnt render well (çèé...) What the output had to be ? Mysql only support latin1 ? I m lost in all that encodage ! Help me I dont know how to parametrer the php parser I make. // create parser $xp = xml_parser_create("UTF-8"); // set element handler xml_set_element_handler($xp, "elementBegin", "elementEnd"); xml_set_character_data_handler($xp, "characterData"); xml_parser_set_option($xp, XML_OPTION_CASE_FOLDING, TRUE); xml_parser_set_option($xp, XML_OPTION_SKIP_WHITE, TRUE); xml_parser_set_option($xp, XML_OPTION_TARGET_ENCODING, 'UTF-8'); Have I to decode / encode //if (!($xml = utf8_encode($xml))) { //echo 'ERROR'."\n"; //} Thanks for all. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
hierarchical struture into mysql
Hi all, I m looking for a tree struture for which can be easilly queried with mysql features. I only know the tree with row having a parent id. Retieving children can only be done with recursive : mysql doesnt do that ? Thanks _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: database password recovery
a telnet to mysql works : www:~/MySQL# telnet localhost 3306 Trying 127.0.0.1... Connected to localhost.localdomain (127.0.0.1). Escape character is '^]'. 2 4.0.2-alpha-debug9`VmEN7i, Bad handshakeConnection closed by foreign host. but still cant erase this password ! www:~/MySQL# /usr/bin/mysqladmin -u root password '' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' www:~/MySQL# /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' a+. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
database password recovery
Hi all, It's urgent I upgrade my mysql server with some rpm that I found elsewhere on the web But when accessing db I was rehected. Ii d like an easy way to recover my password or to put a blank pass like it was ! see what I ve got ! www:~# mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) Thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql + ext3 + data=journal ?
I ve read an article tellinf that it s a plus. But with no explanation. With journal option you journaling the data too. So it migth prevent from a myisamchk ? It s my opinion. But the best security u can add into this is transaction. a+. > On Mon, Mar 11, 2002 at 05:06:56PM +0100, Matthias Jaekle wrote: > > Hello, > > > > I am running mysql with datafiles on a ext3 file system. Is there > > an security advantage for mysql, if I mount the ext3 file system > > with the option data=journal ? > > I don't know a lot about ext3 yet. Is that full journaling or > metadata only? > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.47-max: up 32 days, processed 1,042,867,093 queries (374/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 _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql from windows to linux - I found
After having search in all the doc i see that I have a mysql 4.01 version ... It was so simple a mysqld restart and all was ok. Surely mysql have fil descriptor in memorry. Aie aie aie. a+. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql from windows to linux
see : http://www.mysql.com/doc/U/p/Upgrading-to-arch.html If you are using MySQL Version 3.23, you can copy the .frm, .MYI, and .MYD files between different architectures that support the same floating-point format. (MySQL takes care of any byte swapping issues.) 2 pcs x86 1under windows xp the other under linux mandrake. I have near 50 database or more, the copy of the datadir is the best solution. As i tell I can select ... Butr no inserting ! see my Error: 1036 - Table country is read. If you have a cool solution my 2 mysqld (zindows and linux) are on the same lan ! Thanks. > You should use mysqldump[.exe] to export/import, on the respective systems: > > 4.8.5 mysqldump, Dumping Table Structure and Data > http://www.mysql.com/doc/m/y/mysqldump.html > > C:1 > > > Hi all, > > I developp a site with some mysql table which are files myd myi n frm under > windows x86 arch. > I copy my table into a liinux box x86 arch too. > > Bu when trying to modidy tables I get an Error: 1036 - Table country is read > only > > I manage the rigth of new created tables. > I get things like that that I report to my read only tables : > > 12 -rw-rw1 mysqlmysql8674 jui 15 2001 country.frm > 24 -rw-rw1 mysqlmysql 20516 jui 15 2001 country.MYD >4 -rw-rw1 mysqlmysql1024 jui 15 2001 country.MYI > 12 -rw-rw1 mysqlmysql8564 mar 9 23:18 TableName.frm >0 -rw-rw1 mysqlmysql 0 mar 9 23:18 TableName.MYD >4 -rw-rw1 mysqlmysql1024 mar 9 23:18 TableName.MYI > > I make a chown -R mysql.mysql * > n chmod 660 * > > > > Nothing change. > > > > _ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql from windows to linux
Stange I make a ps : mysql 6337 0.0 5.4 27588 15608 ? S23:22 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/ www. sassandra-conseil.com.pid --skip-locking mysql server is reunnig with mysql user. I make a su mysql : this works mysql> update TableName set FieldName =1; Query OK, 1 row affected (0.00 sec) Rows matched: 2 Changed: 1 Warnings: 0 with new created table but with other nothings > > 12 -rw-rw1 mysqlmysql8674 jui 15 2001 country.frm > 24 -rw-rw1 mysqlmysql 20516 jui 15 2001 country.MYD >4 -rw-rw1 mysqlmysql1024 jui 15 2001 country.MYI > 12 -rw-rw1 mysqlmysql8564 mar 9 23:18 TableName.frm >0 -rw-rw1 mysqlmysql 0 mar 9 23:18 TableName.MYD >4 -rw-rw1 mysqlmysql1024 mar 9 23:18 TableName.MYI > a+. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql from windows to linux
Hi all, I developp a site with some mysql table which are files myd myi n frm under windows x86 arch. I copy my table into a liinux box x86 arch too. Bu when trying to modidy tables I get an Error: 1036 - Table country is read only I manage the rigth of new created tables. I get things like that that I report to my read only tables : 12 -rw-rw1 mysqlmysql8674 jui 15 2001 country.frm 24 -rw-rw1 mysqlmysql 20516 jui 15 2001 country.MYD 4 -rw-rw1 mysqlmysql1024 jui 15 2001 country.MYI 12 -rw-rw1 mysqlmysql8564 mar 9 23:18 TableName.frm 0 -rw-rw1 mysqlmysql 0 mar 9 23:18 TableName.MYD 4 -rw-rw1 mysqlmysql1024 mar 9 23:18 TableName.MYI I make a chown -R mysql.mysql * n chmod 660 * Nothing change. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
fulltext search in boolean mode that i can t understand
Hi, I try to use boolean search into my database but I sometimes estonished of the results. I make such query : SELECT * FROM T_Stories WHERE match (Summary,Content,Heading,livecountry,livecity,Author) against ('fiat' IN BOOLEAN MODE) AND Verified = 'Y' LIMIT 12 I can retrieve rows that have fiat in the matches column : (Summary,Content,Heading,livecountry,livecity,Author). Bu when I make +fiat, it s ok : SELECT * FROM T_Stories WHERE match (Summary,Content,Heading,livecountry,livecity,Author) against ('+fiat' IN BOOLEAN MODE) AND Verified = 'Y' LIMIT 12 I have the rows I wanted. As I see in the doc + isnt mandatory : apple banana find rows that contain at least one of these words. So no rows for fiat alone. But with the word notpresent which is not present in my rows, the query : SELECT * FROM T_Stories WHERE match (Summary,Content,Heading,livecountry,livecity,Author) against ('fiat notpresent' IN BOOLEAN MODE) AND Verified = 'Y' LIMIT 12 return rows that have fiat inside, the sames that +fiat have ?! I thinks it s not normal or there is a misunderstanding ? Thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ignore words in full text indexes
Hi, > Or maybe there are too many. It appears that any word that appears > in more than half the rows is treated as a stop word: > > http://www.mysql.com/doc/F/u/Fulltext_Search.html > I read this page but this condition doesnt hurt my mind. I don t know what happen I modify fait to fiato I regenerate the index. And find rows with fiat word, the row I find has only word, you devine : fiat. My query : SELECT * FROM T_Stories WHERE match (Heading) against ('+fiat -bagnole' IN BOOLEAN MODE) Tell me If I doesn t understand the way mysql treat fulltext in boolean mode : so MySQL search rows that has heading wich was ok with +fiat -bagnole constraint, he has rows, in this rows if for example : fiat that I want to select is present much more than half of the data selected in a row, this row is rejected ? By data selected in a row, here in my sample is * -> the appearance for fiat in the row is calculated with all the columns ? Thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ignore words in full text indexes
Hi all, I m using mysql 4.01 alpha I read in the doc : "MySQL uses a very simple parser to split text into words. A ``word'' is any sequence of letters, numbers, `'', and `_'. Any ``word'' that is present in the stopword list or just too short (3 characters or less) is ignored. " My queries let me devine that <=4 words are ignored. How to know more. SELECT * FROM T_Stories WHERE match against ('+fiat -bagnole' IN BOOLEAN MODE) doesnt give any row but when changing fiat to fiato it gives me row ? I regenerate the index beetween queries -> nothing ? Is there any easy way planed fro changing stopword and words min length in the future ? By an easy way I didint want to recompile a mysql server only changing some files or syetem database, like the mysql database is ? Thanks. Regards. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: **Backing Up A Database**
How did u do exactly ? It's not documented. Does it take a long. Do u have to flush and lock tables before, that can be critical for 24/24 server. what conf for logrotate ? a+. >I personally issue "mysqldump"s via cron and maintain the files using "logrotate" (Redhat Linux), which >automatically zips and rotates them. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
update to mysql 4.01 under mandrake
hi all, This question is a little like the suse update. But perhaps I could find answer. I have a mandrake distrib with rpm support, u know that mandrake is derive from redhat. Can I install a mysql 4.0.1 package on it ? thanks. a+. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
update to mysql 4.01 under mandrake
hi all, This question is a little like the suse update. But perhaps I could find answer. I have a mandrake distrib with rpm support, u know that mandrake is derive from redhat. Can I install a mysql 4.0.1 package on it ? thanks. a+. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
about a mysql facility
Hi all, Imagine a php script query a database wich is down. Is there any facility that allow me to query the mysql database again when it will be up. Or is the only way a sql batch generated and a periodically crontab script wich 'mysqladmin ping' the server and and launch this batch when ready. Has anyone heard of a thing like that ? thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
pb while adding new field to a db ?
Hi all, I hava a mysql database wich contain some country name only country names some a old like USSR ... I have to add some field into this db from the file found at the ripe net ftp.ripe.net file : iso3166-countrycodes.txt see part of this file : Some Codes from ISO 3166 Updated by the RIPE Network Coordination Centre. Source: ISO 3166 Maintenance Agency Latest change: Thu Aug 7 17:59:51 MET DST 1997 Country A 2 A 3 Number -- AFGHANISTAN AF AFG 004 ALBANIA AL ALB 008 ALGERIA DZ DZA 012 AMERICAN SAMOA AS ASM 016 List of changes applied, as specified in registration newsletters: Newsletter III-1, 1989-12-5: Burma deleted, Myanmar added (same numeric value, change of country name) my bd countain field like : country_us, country_de how can I elegantly add the field from the ripe file that I didn't hav into my db ? thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error
I m franch a little latin, no u re not an error. see at www.mysql.com if u can found doc into your language have a look at grant / revoke command to make 'fire1.uniube.br' allowed to query the server. GRANT ALL ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY "password" "all" is too much u can try : ALL PRIVILEGES FILERELOAD ALTER INDEX SELECT CREATE INSERT SHUTDOWN DELETE PROCESS UPDATE DROPREFERENCES USAGE insert,select,update,delete is well - Original Message - From: "Joabe Fuzaro" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 7:37 PM Subject: Error > Hi, > > I'm brasiliam, so.. > > my english is very bad > > I'm a error: > Warning: Host 'fire1.uniube.br' is not allowed to connect to this MySQL > server > > Tanks > > Joabe > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: About spam
Personnaly I found no particular spam on this list, in the beginning of the year I found article dated to the 01/01/2003 and not the 01/01/2002, this message was refused cause it doens t contain words like sql I thinks that my mail client wich doesn work well (hum outlook). a+. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: UNION
You have to search for "create temporary" table then make severals insert into this_table as select Note that the temporary table are thread local I think so only the current connexion can see it. > HI, > > I found a very usefull function in Mysql (to combine the result of many > SELECTS in one result set ), which is UNION > SELECT > UNION [ALL] > SELECT > [UNION >SELECT ...] > > the problem is, that it was implemented in version 4.0 and above; > anyone can tell me if there is a way to re-phrase the same query but > for an older engine, like 3.23.33 > > best regards > Walter D. Funk > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: A bug somewhere in the list manager
Hello I receive message from : the 31/12/2002 and then from the 01/01/2003 and now seems to works from the 01/01/2002. ? sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
About a sql hacking for future
Hello, I try to reference some value of previous row in a sql statement. But today it's not possible due to the thread state of var, can t we do a row state ? thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to make a reference to previous row into a sql statement
set @i=0; set @precprest=''; select cmd.no_client,cmd.no_cmd,cmd.no_prest,eye.libelle,hair.libelle, @precprest as b,if(@i=0,0,@precprest:=cmd.no_prest),@i:=@i+1 It s like if the "if" was evaluate one time. To: <[EMAIL PROTECTED]> Sent: Saturday, December 15, 2001 10:16 PM Subject: Re: how to make a reference to previous row into a sql statement > set @precprest=''; > select cmd.no_client,cmd.no_cmd, > @i:=@i+1,@precprest:=cmd.no_prest as b, if(@i>1,0,1) > from > > I can make a variable depending on the row because > @i:=@i+1 dispaly 1,2,3 > but if(@i>1,0,1) is always 1 the value at the end of the thread. > > Can make an something to memorize the previous value of a column ? > > > > - Original Message - > From: "David Yahoo" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, December 15, 2001 9:42 PM > Subject: how to make a reference to previous row into a sql statement > > > > Hi, > > > > I know that mysql can reference var into sql statement, I think like > > @var, i cant retrieve this info. > > > > . > > > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > 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: how to make a reference to previous row into a sql statement
set @precprest=''; select cmd.no_client,cmd.no_cmd, @i:=@i+1,@precprest:=cmd.no_prest as b, if(@i>1,0,1) from I can make a variable depending on the row because @i:=@i+1 dispaly 1,2,3 but if(@i>1,0,1) is always 1 the value at the end of the thread. Can make an something to memorize the previous value of a column ? - Original Message ----- From: "David Yahoo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, December 15, 2001 9:42 PM Subject: how to make a reference to previous row into a sql statement > Hi, > > I know that mysql can reference var into sql statement, I think like > @var, i cant retrieve this info. > > . > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
how to make a reference to previous row into a sql statement
Hi, I know that mysql can reference var into sql statement, I think like @var, i cant retrieve this info. . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php