RE: MySQL Roles and Groups

Hello Trimurthy, As far as I know, MySQL does not have such thing implemented as other database systems. -- Adrián Espinosa. Engineering Support, Wholesale Systems. Jazztel.com -Mensaje original- De: Trimurthy [mailto:trimur...@tulassi.com] Enviado el: viernes, 14 de diciembre de 20

RE: Get lowest value

Hi Neil, Check this documentation, I think you will have no trouble to adapt it to your code http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_min -- Adrián Espinosa. Engineering Support, Wholesale Systems. Jazztel.com -Mensaje original- De: Neil Tompkins [mail

Slow queries / inserts InnoDB

s. Any way to optimize this? Thank you very much in advance. Adrián Espinosa Moreno.

Function Question

- Emily | 4 - Jenn | 2 - Greg | 1 - Emily | 7 - Bob | 3 - Emily | 3 ----- Nick Moreno|Communications Project Specialist|Home Federal Savings Bank 1016 Civic Center Drive NW|Rochester MN, 55901|Work 651-405-2010|Cell 612-987-0584 -

MYSQL & C

Hi all I have a little question, have you ever work C & MYSQL??? all about that is new for me, if anybody has some info, help me!!! __ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! Regístrate ya - http://correo.yah

Re: mysql x64en server 64 bits

Hi, Try to download using the mirror called : United States of America [X10 WTI / Seattle, WA] HTTP FTP

Re: mySQL support required

Hi Kishore, Please see the following approach : http://dschneller.blogspot.com/2007/09/error-1033-hy000-on-innodb.html Regards, Juan On Mon, Jun 9, 2008 at 8:26 AM, <[EMAIL PROTECTED]> wrote: > > > > Hi , > > > > We are in Urgent need of support to recover from a database problem > > > > Det

Re: purge binary logs on master

Ananda, Use, PURGE MASTER LOGS TO 'name of the last binary that you want leave in your disk'; Regards On Sat, May 17, 2008 at 8:56 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > Hi All, > I using this command to purge binary logs on master, but i dont see the > binary logs getting deleted. These

Re: changing 'max_allowed_packet'

Hi, In your my.cnf put this : [mysqldump] quick max_allowed_packet = 32M Regards, Juan On Fri, May 16, 2008 at 6:55 PM, Sigfrid <[EMAIL PROTECTED]> wrote: > > Hello, I have a simple question: how can I change the value of > max_allowed_packet ? (I use server version: 5.0.51a MySQL Community Se

Re: master - slave replication - slave not updating

Hi Tom, Your master binary log start with mysql-bin.03, then, your insert ( or update) in the master could be in mysql-bin.02 or 1. Please, reload your binary logs again from the beginning ( put mysql-bin.02 or 1, ). Your insert or update could be in one of this files. Regards, Juan

Re: master - slave replication - slave not updating

Hi Tom, The error 1062 you could skipped in the slave modifying your my.cnf ( slave side) using : slave-skip-errors=1062 This error on duplicated records, normally is problem in binarylogs transfer data. But, anyway, please confer that the data exist in the slave. Regards, Juan On Fri, May

Re: MySQL (mysql-5.0.54)

Hi, Please, you must set up the log-bin for enable replication : Example ( in your my.cnf ) --log-bin=mysqld-bin The mysql signal 4 error appear when you install erroneus your environment. I recommed reinstall your MySQL in your OS. Regards, Juan On 5/6/08, Kaushal Shriyan <[EMAIL PROTECTED]>

Re: innodb disabled

sql don't gives any error. still innodb is disabled. > > Thanks, > Prajapati > > On Tue, May 6, 2008 at 7:03 AM, Juan Eduardo Moreno < > [EMAIL PROTECTED]> wrote: > > > Hi, > > > > The InnoDB engine was disable because some ib_log files or Ibdata > >

Re: innodb disabled

Hi, The InnoDB engine was disable because some ib_log files or Ibdata files, InnoDB can´t read. In some cases, could be a directory permissions or some error in creation of ib_logfiles when database is started. If you want , try to see in the error log file generated in order to see more details.

Re: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5)

, Dominik Klein <[EMAIL PROTECTED]> wrote: > > Hi. > > Juan Eduardo Moreno wrote: > > > Sorry, what is your setting for max_allowed_packet variable? > > > > mysql> show variables like "%allowed%"; > +

Re: Performance problem MySQL 4.0.20

Please, mount your disks using "forcedirectio". Regards, Juan On 7/3/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hello, I've a performance problem with our database: Some select statements take about 20 seconds. The same statements on an equal testmachine take less than 1 second. Serve

Re: Alternative command of SET GLOBAL SQL_SLAVE_SKIP_COUNTER

Hi, We have some options in order to skip type of errors in the replication process. Please, identify your number error in slave machine and put into my.cnf "slave_skip_errors= 1087" for example, where 1087 is a recurrent error for your replication architecture. Regards, Juan On 6/8/07, Asho

Re: only select privilege

Hi, Try to do that : GRANT SELECT ON abc.* to 'qa'@'%' identified by 'qa'; flush privileges; Explain : The user qa have access of all tables of user abc. In this command, only SELECT is possible is you connect using user qa. Regards, Juan On 6/8/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:

Re: error after system setup/replication

Keith, When you copied the database, you need recreate de logfiles and the sequences. Then, startup the database. 1) clean your actually log files ( backup to another side) 2) When the database startup automatically recreate the log files and sequence. Send feedback about it. Regards, Juan On

Re: Problem with compex query

t with " indexes for the query"? 3) Im goint to try that. 4) Good Idea. Thanks. - Mensaje Original - De: "Juan Eduardo Moreno" <[EMAIL PROTECTED]> Para: "Patricio A. Bruna" <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Enviados: martes 22 de mayo de

Re: Problem with compex query

stinct | +---+--+---+--+-+--+---+---+ 5 rows in set (0.00 sec) Any ideas? - "Juan Eduardo Moreno" < [EMAIL PROTECTED]> escribió: > Hi Patricio, > > Some options are to prevent programmers/users make a "bad" queries > into > the database' SQL_BIG_SELECTS = 0 | 1 > >

Re: Problem with compex query

Hi Patricio, Some options are to prevent programmers/users make a "bad" queries into the database' SQL_BIG_SELECTS = 0 | 1 The documentation say : "If set to 0, MySQL will abort if a SELECT is attempted that probably will take a very long time. This is useful when an inadvisable WHERE statemen

Re: help on loading the world.sql(script and data) onto world database

Kebede, Send some example of WORLD contains. Regards Juan On 5/9/07, kebede teferi <[EMAIL PROTECTED]> wrote: hi, it's my first time trying my hand in inputting data in batches to mysql database and it drives me crazy, please help. *I've created the WORLD database. *I've downloaded WORLD

Re: expire_logs_days

Hi, I'm experience using expire_log_days and don't work. I set this parameters in the CNF and when the time of ( for example 5 days) is in, don't delete anything. On my expirience, this parameters don't work ( 5.0.27). Regards Juan On 5/2/07, Ofer Inbar <[EMAIL PROTECTED]> wrote: Baron Schwa

Re: MySQL 64 bits

Oie, Sim, é seguro usar MySQL 64Bits. Is safe to use MySQL 64Bits, much better Innodb. Only try to understand that + 10% of Memory is use for 64 bit. For example : total memory 4G ( OS 10% + IO 10% + database 70% + 10% for use 64Bit). You must reserve this 10% in the ecuation. Any help, pleas

Re: Database creation question

for Digital Humanities Network Services Systems Engineer 337 Charles E. Young Drive East PPB 1020 Los Angeles, CA 90095 310/206-8216 From: Juan Eduardo Moreno [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 20, 2007 4:03 PM To: Lopez, Denise Cc: mysql@lists.mysql.com

Re: Database creation question

Denise, Hola!. 1) Connect to the system like root user 2) $ chown -R mysql:mysql /usr/local/mysql/ 3) In oder to create user use : mysql> GRANT ALL PRIVILEGES ON DATABASENAME.* TO USERNAME@"%" IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION; Regards, Juan Eduardo On 3/20/07, Lopez

Re: load sharing

Complementing Chris : Asume that your Application Server is Tomcat. BALANCING SERVERS: You can implement some servers or appliance only for balancing your primary connections. This servers or appliance you must implement using Hearbeat ( only). For example one

Re: Qustion

What a fu...? On 2/24/07, nessah arezki <[EMAIL PROTECTED]> wrote: Bonjour ; Je suis un étudiant en fin de cycle. Dans le cadre de mon projet de fin d'étude, je devais transférer une base de données sous Access à MySQL. J'ai effectué le transfère par Excel Mais j'ai t

Re: backup stratergy

Ananda, For Innodb the best is Innodb Hot Backup ( www.innodb.com (US$) ) For MyISAM you can use a simple backup ( copy/paste) of your files. Also, you can do snapshots using mysqldump. Also, you can use Zmanda ( www.zmanda.com). Regards, Juan Eduardo On 2/23/07, Ananda Kumar <[EMAIL PROTECT

Re: Abnormal mySQL service behavior / 5.0.26

On 2/16/07, Mark Papadakis <[EMAIL PROTECTED]> wrote: Good day, R: are you using MyISAM or InnoDB tables? For the past 2 weeks, we have been dealing with some rather strange problems. While nothing changed in terms of the mySQL server or clients configuration ( including the options provid

Re: How can I detect if MySql is already installed?

Linux : $ rpm -qa |grep -i mysql Regards, Juan On 2/14/07, Zsolt Csillag <[EMAIL PROTECTED]> wrote: Hello, I would like to create a setup program for my demo version that uses MySql database. I need to detect if the target computer has already got the MySql installed because I don't want to

Re: 2 ways replication

Dear all, We can view interesting tipic into : http://www.onlamp.com/lpt/a/6549 Regards, Juan Eduardo On 2/12/07, Atle Veka <[EMAIL PROTECTED]> wrote: 2 way replication, also referred to as dual master replication, has been available for quite some time. However implementation can be tric

Re: MySQL log_slow_queries Error

Hi, You can only set this parameters in order to monitoring slow queries: long_query_time = 120 ( example of 2 minutes) #log-long-format #log-slow-queries=/var/log/slow-queries.log You can enable and disable using " # " You set : log=ON log_slow_queries = ON log_slow_queries=/var/log/slow-q

Re: Error starting service

$ chown -R mysql:mysql yourdirectoryofmysql On 1/31/07, WebIT <[EMAIL PROTECTED]> wrote: Sorry, probably a really simple thing, but when I try and start mysqld it fails. [EMAIL PROTECTED] yum.repos.d]# /sbin/service mysqld start Timeout error occurred trying to start MySQL Daemon. Starting MyS

Re: Strange InnoDB Deadlock Behavior

Jason On 1/15/07, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote: > Jason, > > Send me a my.cnf in order to view your configuration ( using innodb storage > engine). Send me a configuration of your machine ( CPU and Memory). > > Regards > [client] #password = [your

Re: Dual Hardisk

Hi, Your storage engine is Innodb?. If your answer is yes, please see below : innodb_data_file_path=/u01/ibdata1:50M;/u01/ibdata2:50M*;/u03/ibdata3:100M * You can create a new ibdata ( tablespace) in a new device : 1) Stop mysql 2) Change conf ( add new one tablespace) 3) start mysql Regards,

Re: InnoDB vs MyISAM

Octavian, 1) You can use MyISAM for example when you use static information in a webpage. For example, only for store information of customers, something like that.. 2) Innodb is a engine that support ACID, you can use for transactions. For example, load information of sales from PDA ( field)

Fwd: innodb_log_files_in_group

FYI -- Forwarded message -- From: Juan Eduardo Moreno <[EMAIL PROTECTED]> Date: Dec 27, 2006 9:30 PM Subject: Fwd: innodb_log_files_in_group To: [EMAIL PROTECTED] Dave, The default (and recommended) is 2. The log files, save the trasactions into file in circular order

Re: socket error

Waleed, First, please try to upgrade your mysql. Try to review in your my.cnf if your configuration socket appear two twice ( in two lines ). Verify in your environment if your mysql is running using "ps -aux | grep -i mysql". $ service mysql stop $ ps -aux | grep -i mysql $ (if still running

Re: ERROR 1114

Raj, Normally, if you have problem with your configurations, I suggest recreate your databases : 1) backup all your database using mysqldump *$ mysqldump --opt --user=root --password= --databases db1 db2 db3 db4 > /your/directory/of backups/backup.databases.dmp* ** ** 2) delete your databa

Re: innodb_buffer_pool_size. How to setup with more than 5G ?

innodb_log_files_in_group. For example, if your set innodb_log_files_in_group=2 ( ib_log_file001, ib_log_file002 are created) the total size must not exceed 4G. Regards, Juan On 12/18/06, Remigiusz Soko?owski <[EMAIL PROTECTED]> wrote: Uz.ytkownik Juan Eduardo Moreno napisa?: > Hi everyone!! > > &g

innodb_buffer_pool_size. How to setup with more than 5G ?

Hi everyone!! Normally we can set the .._buffer_pool_size up to 50 - 80 % of RAM innodb_buffer_pool_size = 50% of phisical memory. And # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 25% of buffer pool size Now, we installed a machine using Linux Redhat ES with 16

Milliseconds of now()

Hello!, How can obtain the miliseconds of function of NOW()?? In the example we can obtain only 0 ( zero)The result is zero. *SELECT MICROSECOND(now());* Thank you, Juan

RES: SQL Select Idea [ORDER BY]

n Thu, Dec 05, 2002 at 08:54:29PM -0200, Felipe Moreno - MAILING LISTS wrote: > > Well, could you explain the behave of ORDER BY DATE,COD? Just try it (it will order by date, then cod). What I think you want is (as I originally said, but briefly): create temporary table top10 select * from .

RES: SQL Select Idea [ORDER BY]

ten dates). So, >what I really need ia an way to make a select without any "data" from the >DB. I tried to use de LAST_INDEX() function to do this but I didn't go >anywhere. Any ideas??? -Mensagem original- De: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Enviada em: quinta-feira,

RES: RES: RES: SQL Select Idea

: SQL Select Idea On Wed, Dec 04, 2002 at 08:55:51AM -0200, Felipe Moreno - MAILING LISTS wrote: >Well, the SQL Query you requested is exatcly the one I'm asking! :-) No; I want to know what you intended for those 10 dates to do. The LIMIT query worked, as posted by someone else, w

RES: RES: SQL Select Idea

what I'm doing above using only ONE select. Any tips? Best Regards, Felipe -Mensagem original- De: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Enviada em: quarta-feira, 4 de dezembro de 2002 02:06 Para: [EMAIL PROTECTED] Assunto: Re: RES: SQL Select Idea On Tue, Dec 03, 2002 at

RES: RES: SQL Select Idea

old me that TWO selects aren't recommended, but in this case I can't see no other way to do this. If you have any other idea, it will be very helpfull. Thanks! Regards, Felipe -Mensagem original- De: Doug Durham [mailto:[EMAIL PROTECTED]] Enviada em: quarta-feira, 4 de de

RES: SQL Select Idea

---Mensagem original- De: Jim Esten [mailto:[EMAIL PROTECTED]] Enviada em: terça-feira, 3 de dezembro de 2002 17:40 Para: 'Felipe Moreno - MAILING LISTS'; [EMAIL PROTECTED] Assunto: RE: SQL Select Idea Something on the order of... SELECT * FROM processo_arquivos ORDER BY DATE DESC LIMIT

MySQL: Select HELP!

Hi List Users, I want to know if anyone has any idea on how can I do the SQL command below to archive a result. I have one table called processo_arquivos that have a filed called DATE and another FIELD called COD (primary key). I want to select the last TEN (10) dates from the Database, but

SQL Select Idea

Hi List Users, I want to know if anyone has any idea on how can I do the SQL command below to archive a result. I have one table called processo_arquivos that have a filed called DATE and another FIELD called COD (primary key). I want to select the last TEN (10) dates from the Database, but

privileges

I'm using a MySQL and PHP4 setup that was done for me by the websites owner. I am able to run MySQL through telneting in through SSH, but I can't seem to run any MySQL through the website. Mysql_connect() seems to just hang up the browser till it times out. It doesn't give me password or user inco

Mysql_connect problem

you in advance :) -Chris **** Christopher Moreno Web Developer http://www.chaosad2000.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

question about how to disable function...

Hello I installed MySQL version 4.0.1 apha-nt on win2k. I would like to know how to disable function described below: "Word MySQL is present in more than half of rows, and as such, is effectively treated as a stopword (that is, with semantical va

R: [PHP-DB] Delete problem

Yes i review manual many times without success -Messaggio originale- Da: Rick Emery [mailto:[EMAIL PROTECTED]] Inviato: mercoledì 13 marzo 2002 16.52 A: 'Riccardi Moreno'; Php List; Mysql List Oggetto: RE: [PHP-DB] Delete problem MySQL does not currently support sub-sel

Delete problem

sult on mysql Thank's all ---- - Moreno Riccardi - www.webtrade.it - Before posting, please check: http://www.mysql.com/manual.php (the man

R: mysql web-based admin tool?

You could find a useful tool at http://www.phpwizard.net/projects/phpMyAdmin/ Hy Moreno -Messaggio originale- Da: Ed Lazor [mailto:[EMAIL PROTECTED]] Inviato: martedi 29 gennaio 2002 16.54 A: [EMAIL PROTECTED] Oggetto: mysql web-based admin tool? I used to use some php scripts that

R: Access denied for the new created user!

Before login with new account you must reload server with this command: mysqladmin -u root -ppass reload and then you could login with new account -Messaggio originale- Da: wei song [mailto:[EMAIL PROTECTED]] Inviato: venerdi 16 novembre 2001 17.41 A: [EMAIL PROTECTED] Oggetto: Access den

FREEBSD4.4

Hi all, I install mysql-client-3.23.42 on FreeBSD4.4 from FreeBSD boot disk but I'm not able to start the server. Anyone have any ideas how to start server?? Moreno ---- - Moreno Ric

Migrate from mssql7 to Mysql

How can i migrate a database from mssql7 to Mysql? - Moreno Riccardi - Before posting, please check: http://www.mysql.com

mysql.sock ???

Hi all, I've installed mysql 3.23.42 on Freebsd system but when i launch mysql i said me "can't connect to localhost /tmp/mysql.sock not found". How can i repair this error? Thanks Moreno ---

Mysql.sock ????

Hi all, I've installed mysql 3.23.42 on Freebsd system but when i launch mysql i said me "can't connect to localhost /tmp/mysql.sock not found". How can i repair this error? Thanks Moreno ---

Image

How can i insert image in a database. - Moreno Riccardi - Before posting, please check: http://www.mysql.com/manual.php (the

Import Data

I want to import data from text file that contains decimal number (occasionaly with 9 decimal) but mysql import only 2 decimal. My columns is set to DECIMAL(6,9) Hi, Moreno - Before posting, please check: http

R: InnoDB

Thanks Heikki --- - Moreno --- -Messaggio originale- Da: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Inviato: venerdì 5 ottobre 2001 15.08 A: [EMAIL PROTECTED]; [EMAIL PROTECTED] Oggetto: Re:InnoDB Riccardi, your innodb_log_arch_dir is C

InnoDB

service (net start mysql) he return me an error: System error N°1067 Where' s the error? ----- - Moreno Riccardi -- - Before posting, please

R: Party!!!

It's a great idea Free your Mind -Messaggio originale- Da: Andrew Murphy [mailto:[EMAIL PROTECTED]] Inviato: venerdì 5 ottobre 2001 10.37 A: 'Deryck Henson'; MySQL Oggetto: RE: Party!!! Sounds good, as the (altered) saying goes: Life begins at 4.0! -Original Message- From

RES: Hardware

Hi list members! I have a doubt regarding how can I INSERT and SELECT an IMAGE from a MYSQL database. I'm using , in the DB, the BLOB field, so, I will be able to receive binary data. Thnaks for any help! Best Regards, Felipe M