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 posti

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

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

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

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õ^øiZQlj,SO. "; And then it displays kanjies. But I didnt manage to store char into the database ? How can I do ? Thanks. ___

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

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 !

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 '', `

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 ...

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 data

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

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

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 a

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

Re: multiple delete for mysql

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? > >

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

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

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. ___

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

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 t

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

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

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

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

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

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 tex

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

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 - Bef

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

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

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 nex

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 pa

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

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/mys

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@local

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

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

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

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 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 tha

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 hav

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 reg

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

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 >automatic

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+.

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+.

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.

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

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

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+. ---

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

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.my

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/man

Re: how to make a reference to previous row into a sql statement

spaly 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 PR

Re: how to make a reference to previous row into a sql statement

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

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/