Re: Show master status - "mysqld_multi" - distribution master[SOLVED]

2016-08-23 Thread Jose Julian Buda
On 23/08/16 11:26, sujeet gupta wrote: Hi Dear, It's not a mysql issue, show me every step you followed to create master slave hierarchy. Its like you missed some steps while configuring server. Show master configuration and slave configuration separately. On Aug 23, 2016 6:45 PM, "J

Show master status - "mysqld_multi" - distribution master

2016-08-23 Thread Jose Julian Buda
e. How can i see the right logfile name/position(show master status) for each mysql instance on the replication distribution master? Is it a mysql client issue? The log distribution server is running MySql 5.5.50 Thank you in advance. -- Jose Julian Buda -- MySQL General Mailing

Re: Replication problem -solved

2014-08-30 Thread Jose Julian Buda
On 30/08/14 12:56, william drescher wrote: Thanks for pointing out the importance of the "last error" I resynced the slave to the master, reset the master position, and restarted the slave. Now all works fine and I am much better equipped next time to debug the loss of the link. When is the

Re: Replication problem

2014-08-30 Thread Jose Julian Buda
On 30/08/14 09:39, william drescher wrote: On 8/29/2014 7:40 PM, Suresh Kuna wrote: You can paste the show slave status\G here for us to review and on Master, show global variables like 'log-bin%'; show master status ( 3 to 4 times continuously ) Master: +--+--+--

RE: Recover accidentally deleted MySQL database files

2010-05-21 Thread Jose Luis Marin Perez
file Version 1 #114487: DBase 3 data file (8960 records) #114488: MySQL table definition file Version 9 #114489: MySQL MISAM compressed data file Version 1 #114490: DBase 3 data file (256 records) There any way to recover these files in its original location? Thanks Jose Luis -Mensaje

Recover accidentally deleted MySQL database files

2010-05-21 Thread Jose Luis Marin Perez
.7 Distrib 4.1.20, for redhat-linux-gnu (i686) using readline 4.3 Thanks Jose Luis

Re: How can avoid 2 selects and 2 while? SOLVED

2009-02-12 Thread Jose Julian Buda
- Original Message - From: "Brent Baisley" To: "Jose Julian Buda" Sent: Thursday, February 12, 2009 1:21 PM Subject: Re: How can avoid 2 selects and 2 while? On Thu, Feb 12, 2009 at 10:43 AM, Jose Julian Buda wrote: table_1: product_id

How can avoid 2 selects and 2 while?

2009-02-12 Thread Jose Julian Buda
print("Name %s --- Price %s\n",$row2[name],$row2[price],); } } . How can i do this without 2 select and whitout 2 while and the "features" be printed just one time? Thank you in advance Jose Julian Buda

Re: Mysql Replication out of sync

2009-01-09 Thread Jose Julian Buda
maybe if you put on the slave server : mysql> STOP SLAVE; mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; mysql> START SLAVE; then just to check take a look at this lines : mysql> show slave status\G; ... Slave_IO_Running: Yes Slave_SQL_Running: Yes ... it will restart the r

Re: MyIsam Locking Questions

2008-08-28 Thread Jose Estuardo Avila
0 and hide = 0 ORDER BY rd.created_at ASC limit 350, 25 Notice the only one that actually executing is the first select. all others including the insert are locked. Why would the 3rd query a select be locked by the first query another select. On Aug 28, 2008, at 10:07

Re: MyIsam Locking Questions

2008-08-28 Thread Jose Estuardo Avila
I understand that reads are locked by writes but nowhere does of mention that reads also block reads. Boy queries y posted to the list are selects. Jose E. Avila(tachu) Yuku/Kickapps Sent from mobile device. On Aug 28, 2008, at 5:48 AM, "Perrin Harkins" <[EMAIL PROTECTED]>

MyIsam Locking Questions

2008-08-27 Thread Jose Estuardo Avila
Hi, I've been trying to find information on how myisam handles locks. I though myisam had locking only on writes and not on reads. For some reason and after a lot of digging i've been seeing that some queries(albeit bad queries) cause other queries to hang even though they are selects is th

MYSQL connection failed: Can not connect to MySQL server

2007-10-30 Thread Jose Romero
Hi,I have a mail system on FreeBSD 6.2 + Exim 4.62 + MySQL 5.0. Exim was compiled with MySQL support, the MySQL database is external to the mail server. Although the system works, I have a lot of daily messages in exim's log with the following error: MYSQL connection failed: Can not connect to M

view problem

2007-04-05 Thread jose
Hello, I'm having some problems with views. Could please someone give me some help? I created two tables and a view. I created the view using WITH CASCADED CHECK OPTION because I need to update some columns of the view. When I do update 2007_marche set data_invio_teramo = current_date where azi

source compilatio or install precompiled packages

2006-10-24 Thread Jose Manuel Peso
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi list, Why is recommended the precompiled package install way (as i read in the downloads page)? Thanks, Jose -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

unix_timestamp + milliseconds support?

2006-02-09 Thread Jose Antonio
An efficient way to store time is as UNIX_TIMESTAMP (4 bytes) instead of using DATETIME data type (8 bytes). We were using this technique to save the time in our database. Now we need to support millisecond resolution as we need to store data comming 8 times per second, that is, every 125 millisec

Spatial Extensions in MySQL: Multidimensional Points?

2006-02-07 Thread Jose Antonio
int (X,Y,Z): (0,0,0), (1,1,1), (4,4,2), (-2,30,18) And for a new point (3, -1, 1.5), I need to know which of my other points are closer and what the distance is. Any clues? Thank you in advance, Jose.

Unknown problem with backup restore

2006-01-17 Thread Jose Maria de Dios
I am trying to restore a backup on a two processor machine with a Debian installation with 2.4 kernel and 2GB or RAM, but when it reaches a MyISAM table of about 1.8 GB it stops restoring with no error output. The MySQL version is Distrib 5.0.16. I have tried to restore it in many other systems (un

autocasting

2005-12-21 Thread Jose Soares
Hi all, I have some troubles about autocasting and unsensitive case. Look at this: mysql> select data_fattura from 2005_ordini where data_fattura = 9911; | -00-00 | | -00-00 | | -00-00 | | -00-00 | | -00-00 | | -00-00 | | -00-00 | | -00-00 | |

Merge/Combine two server

2005-12-12 Thread Juan Jose Sanchez Mesa
Hi! We have 2 MySQL servers and now we have purchased one more powerfull server and want to combine the databases from the two older server into the new server. Can we just make dumps from older server and make restores into new servers ? What happen with databases users ? Can be dumped the dat

Re: Append one table to another?

2005-10-11 Thread Jose Miguel Pérez
f you need to have more control over what is copied, you can add a WHERE clause in the SELECT above. Also, you can restrict how it is done by adding some fields restrictions: INSERT INTO table1 (field1, field2) SELECT field1, field FROM table2 WHERE field1 =

Datetime with milliseconds?

2005-09-23 Thread Jose Antonio
onal field storing the milliseconds and have it also in the primary key. Before changing the design I would like to check with you. Maybe you have faced the same problem and you have found a better solution. Thank you in advance. Jose.

Re: MySQL Subquery bug or am I doing something wrong?

2005-09-01 Thread Jose Miguel Pérez
t you know... I'm not the only one inserting values into the table. :-) Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Subquery bug or am I doing something wrong?

2005-09-01 Thread Jose Miguel Pérez
t; FROM sites_criterios -> ); Empty set (0.01 sec) Note that this query is THE SAME as the previous one, but with a wider result set inside the subquery. This makes no difference in my queries as we confirmed at least the word "su-turno" does not exists. Thanks for your patience. If you think I'm doing something wrong please reply. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: BLOB FILES ERRORS

2005-08-12 Thread jose nuno neto
p://dev.mysql.com/doc/mysql/en/select.html ::: > ::: >jose nuno neto <[EMAIL PROTECTED]> wrote: ::: >>Hi, ::: >> ::: >>I'm trying to use MySQL Blob columns to store files ::: >> (docs,gifs,pdf.) but I'm getting corrupted files from the DB. ::: >>

BLOB FILES ERRORS

2005-08-11 Thread jose nuno neto
Hi, I'm trying to use MySQL Blob columns to store files (docs,gifs,pdf.) but I'm getting corrupted files from the DB. the applications runs php, loading file content with addslashes but in order to spot the error i've tried it with mysql only like this: column file is a MEDIUMBLOB INSERT IN

mysql_install_db problem

2005-03-11 Thread jose
install with other machine. Thanks in advance ** Jose Antonio Rodrigo Sistemas Gamepro S.A 944792879 email [EMAIL PROTECTED] http:\\www.gamepro.es http:\\www.juegon.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: SELECT on string field

2005-02-01 Thread Jose Miguel Pérez
- www.domain.com?id=2 (There is no /) Beware though, this usage will not use indexes on "url" column so be careful and do not use this on big tables. You will need to use more elaborated techniques to speed up query times on big tables. Cheers, Jose Miguel

MySQL win32 and SSL

2005-01-25 Thread Jose Antonio
Dear all, I need SSL support for MySQL. I've checked the documentation and it seems that for windows there is no SSL support in the binaries. In addition the documentation in the examples is for Linux. Has anyone has used MySQL with SSL in windows? If so ... how? How easy is to set it up? What

Re: MySQL 4.1.8 & InnoDB: data unavailability among different connections

2005-01-14 Thread Jose Antonio
I'm doing the Commit so probably is the extra settings in the SQL. Could you please elaborate a bit more on that? Thank you in advance, Jose. Jeff Mathis escribió: simple answer is transactions. until you issue a commit, or otherwise specify extra settings in your SQL syntax, other connec

MySQL 4.1.8 & InnoDB: data unavailability among different connections

2005-01-14 Thread Jose Antonio
a importer process. Any clue on what may be going wrong? Thank you in advance. Jose. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: c program Bus Error (core dumped)

2005-01-11 Thread Jose Miguel Pérez
Hi Andy! > After compiling with the options (as suggested by Jose Miguel Pérez) [...] > I now get ... > Everything Cool with the connection > Bus Error (core dumped) > > Sound familiar!! Sorry Andy but I couldn't help any more. I am not familiar with Solari

Re: c program Bus Error (core dumped)

2005-01-11 Thread Jose Miguel Pérez
z It worked fine, maybe you should try to compile with debug options and give gdb a try. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: c program Bus Error (core dumped)

2005-01-11 Thread Jose Miguel Pérez
o be some "%" inside "whatever" you will get coredumps. For instance, see what happends when in your program, mysql_error(connection) returns "Please use %d to display integers." (Not a real MySQL error, obviously!! :-) Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Compiling 4.0.22 source including some 4.1.x functions

2004-11-30 Thread Jose Miguel Pérez
functions (which I suppose I can include them even as UDF functions). Please, anyone could give me advice on that? Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MatLab connector

2004-11-25 Thread Jose Antonio
Do you know if I can use MySQL data from MatLab? Does it exists a connector for MatLab in the same sense as JDBC for Java? Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

The better and more efficient way to store datetime data.

2004-11-24 Thread Jose Antonio
-01 00:00:00' and '2004-10-15 00:00:00'" Discussion is open and suggestions are more than welcome. Jose. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: COUNT Problem

2004-10-17 Thread Jose Miguel Pérez
assigned tasks. If you want to > further select which one of the projects with the most assigned tasks you > want, you must order by another column, like date (or filter out the > projects in the WHERE clause). > > Given said that, > > Cheers, > Jo

RE: COUNT Problem

2004-10-17 Thread Jose Miguel Pérez
must order by another column, like date (or filter out the projects in the WHERE clause). Given said that, Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Query with group by

2004-09-21 Thread Jose Miguel Pérez
olution. ;-) > > That would have to do the same thing behind the scenes. I have to beg you pardon here. ;-) Think again this solution doesn't require a JOIN, nor a temporary table. I think the UDF solution doesn't have to be less efficient than a MAX or AVG aggregate fun

Re: Query with group by

2004-09-16 Thread Jose Miguel Pérez
led something like EXTERNAL_MAX(...) or something, so that we could do like: SELECT EXTERNAL_MAX(date, version) ---> i.e: Returns the "version" value for the row with MAX(date). This, for sure, will be the best solution. ;-) Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query with group by

2004-09-16 Thread Jose Miguel Pérez
the join are unique. The result set returned with the last example is this: ++--+-+ | date | location | version | ++--+-+ | 2004-09-16 | PARIS| 10 | | 2004-09-16 | NEW-YORK | 10 | | 2004-09-15 | TOKYO| 11 | ++--

Re: In search of a good MySQL GUI client

2004-09-09 Thread Jose Miguel Pérez
ing. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: In search of a good MySQL GUI client

2004-09-09 Thread Jose Miguel Pérez
't showing them in the list. A nasty GUI bug, sure, but this renders SQLyog unuseable to me. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

In search of a good MySQL GUI client

2004-09-08 Thread Jose Miguel Pérez
involved creating such a tool, I'm a programmer after all, and some of them are in beta anyway. I would appreciate if anyone knows some tool which good foreign key support. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: root without permissions...

2004-08-29 Thread jose usoz
make order in my list of users - hosts names. Thanks and saludos, jose. -- Jose Usoz / Cromosfera http://www.cromosfera.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: root without permissions...

2004-08-29 Thread jose usoz
the databases i can access -> [EMAIL PROTECTED] jusoz]$ mysqlshow -u root +---+ | Databases | +---+ | test | +---+ [EMAIL PROTECTED] jusoz]$ mysqlshow -u jusoz +------+ | Databases | +--+ | backup_mySQL | | datos-mySQL | | mysql| | test

root without permissions...

2004-08-29 Thread jose usoz
tion id is 15 to server version: 4.0.18 **changing the passw -> [EMAIL PROTECTED] jusoz]$ mysqladmin -u root -h localhost password "" mysqladmin: unable to change password; error: 'Access denied for user: '@localhost' to database 'mysql''

HELP mysql.sock is missing in Mac OS X

2004-05-12 Thread Jose Manuel Islas Romero
I start MySQL and it seems to start the server normally >TrentCioran:/usr/local/mysql TrentCioran$ sudo ./bin/mysqld_safe >Starting mysqld daemon with databases from /usr/local/mysql/data >040512 21:27:05 mysqld ended but when i try to open the mysql console it sends me the message: >TrentCior

lost sa password

2004-03-18 Thread jose manuel
Hi all: Long time ago I've installed MySQL on my Debian Machine and I'm pretty sure I did'n left the "sa" pwd blank as recommended. Now, I'm installing other apps that need that "sa" pwd in order to be installed properly butI can't remember the pwd. is possible to recover the sa passwo

Deleting using a table as reference.

2003-12-04 Thread Jose Miguel Pérez
e that I use MySQL 4.0.12, so I cannot use the DELETE ... USING ... syntax which were added in 4.0.2 Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Errors starting Mysql

2003-10-09 Thread Jose Rojas
03 2:57 AM Subject: Re: Errors starting Mysql > "Jose Rojas" <[EMAIL PROTECTED]> wrote: > > > > I have installed Mysql 2.23.56 in Linux (Cobalt), but when it is started shows the next messages in the ../var/*.err file: > > > > mysqld started > >

Errors starting Mysql

2003-10-08 Thread Jose Rojas
I have installed Mysql 2.23.56 in Linux (Cobalt), but when it is started shows the next messages in the ../var/*.err file: mysqld started /home/mysql/libexec/mysqld: File './dns1-bin.1' not found (Errcode: 13) 031008 15:18:16 Could not use dns1-bin for logging (error 13) 031008 15:18:16 /home/

Re: ip range lookup

2003-10-04 Thread Jose Miguel
index | +-+---+---+-+-+--+-- -+--+ System: MySQL server 4.0.13 on a Red Hat 7.2 box. Cheers, Jose Miguel. - Original Message - From: "Willem Bison" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]&

error configuring mysql

2003-09-29 Thread Jose Rojas
I am trying to run the initial configure program on a Cobalt RaQ2 appliance, following the instruction from http://www.ospex.com/raq2-php-mysql-apache.html It seems, that some initial parameters are missing, like --host. What are the right ones I have to use? Here are the errors it displays: [

Re: How many records can a single MySql Table Hold.

2003-08-22 Thread Jose Miguel Pérez
you don't have more indexes than really needed. You can test with a temporal table without any keys (not even primary) and adding indexes until you get the behaviour described so that you can locate which is the problem. Cheers, Jose Miguel. -- MySQL General Mailing List For

URGENT : Benchmark

2003-07-22 Thread Antonio Jose Rodrigues Neto
Help me ... Antonio Jose Rodrigues Neto <[EMAIL PROTECTED]> wrote:Hi All, I almost finish my MSC Thesis and my thesis is iSCSI Performance. I would like to make tests using Fibre Channel and iSCSI with MYSQL. Please I will need informations (cookbook) how does implement tunning on

Visual Foxpro

2003-06-12 Thread "Ruiz González, Jose de Jesus"
nous() ) COdbc::SetBatchMode( COdbc::GBatchMode() ) *COdbc::SetTransactions( COdbc::GTransManual() ) COdbc::SetLogOn *COdbc::SetQueryTimeOut( 600 ) *COdbc::SetDispWarnings( .T. )

Re: Specifics on using join & multiple tables

2003-06-05 Thread Jose Miguel Pérez
en "(sales2.amt - sales1.amt) == NULL" which is, obviously, erroneous for your pourposes of getting an increment of 1000 in the sales. I hope this helped! Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: nested ORDER BY statements

2003-06-05 Thread Jose Miguel Pérez
wice, except for the JOIN clauses, of course. For example, you cant type "... WHERE blah, blah WHERE blah, blah too" nor repeat a GROUP BY, SORT, etc. May I suggest you to read the manual more carefully? ;-) Cheers, Jose Miguel. -- MySQL General Mailing Li

Re: Problem connecting with sockets to MySQL

2003-05-29 Thread Jose Miguel Pérez
3.41 version. However, I have read all the changelogs up to 4.0 and it doesn't say anything the developers have changed something to the low level connection layer or something. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

Problem connecting with sockets to MySQL

2003-05-29 Thread Jose Miguel Pérez
s seen above. I have not come to a conclusion on this topic, so all you can help is greatly appreciated. I go so far as to capture the packets with a packet sniffer (ethereal), and I got crazy: Everything seems fine, all connections generate the same packets, in the same order... But when conne

Re: How to compile mysql-3.23.55 on Aix 4.3.3.11

2003-03-16 Thread Jose
Thats right. problem resolved. Thanks. set-variable=thread_stack=256k in the [mysqld] portion of you're my.cnf file. HTH -Bart -Original Message- From: Jose [mailto:[EMAIL PROTECTED] Sent: Sunday, March 16, 2003 10:22 AM To: [EMAIL PROTECTED] Subject: How to compile mysql-3.23.

How to compile mysql-3.23.55 on Aix 4.3.3.11

2003-03-16 Thread Jose
Hi! First of all i had working mysql 3-23-35 on aix 4.3.3.10. After upgrade to 4.3.3.11 it doesn't works. I get: Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/tmp/mysql.sock Now i'm trying to compile 3.23.55 version to probe if it work

Re: Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL

2003-03-16 Thread Jose
pañol http://aixpanish.com - Original Message - From: "Bhavin Vyas" <[EMAIL PROTECTED]> To: "Jose" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, March 15, 2003 11:13 PM Subject

Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL

2003-03-15 Thread Jose
I get this error after upgrade my server aix 4.3.3.10 to 4.3.3.11: Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock Any one can tell me what could be the problem ? Thanks.

Slower access from a client some router hops away from mysql server

2003-02-14 Thread Jose Luis Pérez
We have developed an application with Visual Basic 6 managing through myoledb some mysql server tables. Perhaps it´s basic, but we have seen that the client application runs much more slower in a point separated through 2 routers and with 2 Mbps circuits than in the vlan where the mysql server is

Problem compiling mysql on HPUX

2002-02-13 Thread Hector Jose Montalvo Herrera
code 1 Stop. What should do I? Thanks ______ Ing. Hector Jose Montalvo Herrera Triara Operaciones Libramiento Santa Rosa #111 Col. Futuro Apodaca Apodaca, Nuevo Leon. http://www.triara.com |unix/linux is most powerful..;-)| ______ Ing. Hector Jose Montalvo Herrera T

PASSWORD function

2002-01-03 Thread Jose Alvarez
Dear friends, I am quite new to MySql and database development in general. I am doing my first db ever. I came across a problem following the instructios in teh book beginning PHP4 by Wankyu et al., Wrox. The exercise is to create a user table, contaning user id?s and passwords. The authentificat

Question of a Beginner

2001-12-26 Thread Jose Villanueva
> I'm a beginner in MYSQL, please can anyone tell me the right command in > ORACLE equivalent to the EXEC SP of SQL Server, i'm working with ORACLE > SP, i will apreciate any hepl, thanks. > > Jose Villanueva ---

Re: date type

2001-11-28 Thread Jose Gerardo Amaya Giron
[EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] > > m] On Behalf Of Fabio Roger > > Sent: Wednesday, November 28, 2001 12:35 PM > > To: Jose Gerardo Amaya Giron; [EMAIL PROTECTED] > > Subject: Re: date type > > > > > > timestamp is a good start > &

date type

2001-11-28 Thread Jose Gerardo Amaya Giron
Hello all I got a a simple question, I changing from access to MySQL. I have in access some fields that have date and time. What type of field in MySQL can handle this. thanks Gerardo Amaya - Before posting, please check: h

MySQL Newbie and Access Database

2001-11-22 Thread Jose Gerardo Amaya Giron
Hello all, I just start up with mysql so I have some stupid questions to ask. right now I have an MS Access database with one table that has 25 fields and like 2000 records in it. I'm trying to move to MySQL in order to have a better DB. I can define the database and the table manually that's not

What Licence of Mysql Win32 is Free ?

2001-11-10 Thread Jose Luis Maieron
I'need know what version of MySQL running in Windows, is free licence ? Thanks ! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To requ

no mysqladmin

2001-11-01 Thread jose
Unfortunately there's no /usr/bin/mysqladmin file in my system. >How-To-Repeat: >Fix: >Submitter-Id: >Originator:Jose Solorzano >Organization: >MySQL support: [none | licence | email support | extended email support

mysql 3.23.42 errors during compile on Solaris

2001-09-13 Thread Jose Raimundo da S Barbosa
Hi, when I compilling mysql that occur something error below on solaris. Soft Spc. Solaris 8 Mysql 3.23.42 gcc 3.0.1 GNU Make 3.79.1 My steps: gunzip -d -c mysql-3.23.4.tar.gz | tar xvf - cd mysql-3.23.42 CC=gcc CFLAGS="-O3" CXXLD=g++ \ CXX=gcc CXXFLAGS="-O3 -fe

mysql 3.23.42 errors during compile on Solaris

2001-09-12 Thread Jose Raimundo da S Barbosa
Hi, when I compilling mysql that occur something error below on solaris. Soft Spc. Solaris 8 Mysql 3.23.42 gcc 3.0.1 GNU Make 3.79.1 My steps: gunzip -d -c mysql-3.23.4.tar.gz | tar xvf - cd mysql-3.23.42 CC=gcc CFLAGS="-O3" CXXLD=g++ \ CXX=gcc CXXFLAGS="-O3 -fe

Re: Looks like any user can read the mysql db!

2001-08-15 Thread Jose de Leon
mysqld is running as mysql == On Wed, 15 Aug 2001 17:46:58 -0400 "Vadim P." <[EMAIL PROTECTED]> wrote: > Jose-- > > Are you running mysqld as 'root'? > > Run it as 'mysql' and change the group membership

Re: Looks like any user can read the mysql db!

2001-08-15 Thread Jose de Leon
Can somebody running redhat using the mysql rpm provided by redhat, version 3.23.36-1, please try this and verify if it exists as a bug for you too? Thanks, Jose == On Thu, 16 Aug 2001 03:01:20 -0700 Jose de Leon <[EMAIL PROTECTED]> wrote: > This

Re: Looks like any user can read the mysql db!

2001-08-15 Thread Jose de Leon
Here are the perms on the mysql db files /var/lib/mysql/mysql Also, I was logged into mysql with a plain user 'jose' that had access to only his db, 'jose' grant select,insert,create,drop,delete,alter on jose.* to jose@localhost identified by 'jose';

Re: Looks like any user can read the mysql db!

2001-08-15 Thread Jose de Leon
atabase directory I'm not sure how you would read in those tables. > > The only thing I was able to read in was the .err file > > perhaps you can explain in more detail what you did? > > thanks, > > -- Andrew > > - Original Message - > From: "Jose de Le

Looks like any user can read the mysql db!

2001-08-15 Thread Jose de Leon
MySQL 3.23.36 Using the LOAD DATA command, I was able to read the first field of user.MYD. I think I should be able to load the rest of the table with a little bit of playing around... I think with a little bit of ingenious delimeter specification, etc, anybody should be able to load any tabl

Re: Problem with MySQL over HP-UX 10.20

2001-08-07 Thread Jose Vilmar Estacio de Souza
Hi! We had the same problem. Apparently, this is caused by the missing of some patches. After we applied the patches listed below, the problem disappeared. phco-23684, phss-12727, phss-19739 phss-23672. If I am not mistaken, they are related to dce. {}S Jose Vilmar Estacio de Souza MailTO

Re: Problem compiling on HPUX 10.20

2001-08-01 Thread Jose Vilmar Estacio de Souza
Hi, Sorry by my dumb question. Could you tell me where I could find this manual? Also in what section of the manual could I find the info about the patches for hp-ux 10.20? Many thanks in advance! - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROT

Can mysql.users table props be modified?

2001-07-16 Thread Jose de Leon
database name field? Can I make these changes just to the databse tables or must I recompile MySQL for new sizes? Thanks, Jose - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

bug please help

2001-06-29 Thread Jose Garcia
I was trying to install Mysql in win 98 and after several attempts all I got was: (using mysqld command) (I also send you the my.cnf file I had to edit several times) Please help InnoDB: a new database to be created! InnoDB: Setting file c:\ibdata\ibdata1 size to 20971520 InnoDB: Database phys

Re: 3.23.39 Solaris binary on Solaris 2.6 (sparc)

2001-06-26 Thread Jose Vilmar Estacio de Souza
Hi, I don't know if you can use 2.7+ in a 2.6. However I downloaded and compiled the source without no problems. Until now it's running ok. Please, tell me if I can help! {}S Jose Vilmar Estacio de Souza MailTO: [EMAIL PROTECTED] + 55 21 7894-3041 INFORMAL INFORM

Re: Mysqld crashes immediately

2001-06-09 Thread Jose Vilmar Estacio de Souza
Hi, we had exactly the same problem here. We solved it by applying some patches in the operating system. Unfortunately.I don't have in this momente the relation of patches applied but I can't get them on next monday. Let me know if you were interested and we can send them.

Problema con mysql

2001-06-03 Thread Juan Jose BorreX
hola amigos, tengo el siguiente problema con mysql, Cuando ejecuto mysql me sale el siguiente mensaje: Can´t connect to local MySQL server through socket '/usr/lib/mysql/mysql.sock/ (111) ¿Por ke me sale esto? Espero ke me ayuden. Gracias _

What is reference_priv used for?

2001-05-14 Thread Jose de Leon
there is a clear description in the documentation that I missed, please point me to the URL. If not, please describe how I would use this privilege. Thanks, Jose - Before posting, please check: http://www.mysql.com/manual.php

Problems BDB tables

2001-05-14 Thread Jose Manuel
Hi. This is my first post to this list, and it's about a problem we have with BDB tables in MySQL. From time to time when we retrieve data from a table we don't get right answer, i mean, we get part of the result set. Then if we make an "optimize table " and try to retrieve same data we get right

What is best way to check mysql status?

2001-03-20 Thread Jose de Leon
telnet to port 3306. Thank you, Jose de Leon - 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 <[EM

Enforcing quotas with MySQL?

2001-03-15 Thread Jose de Leon
Does MySQL allow either user or group quotas to be enforced per database? Thanks, Jose - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

MySQL 3.23.33 fail on SOLARIS 8 x86 and gcc 2.95.2

2001-03-02 Thread Diego Jose Varona Agredo
Hi I'm follwing all instructions to install mysql-3.23.33 on Solaris 8 to X86, and the compilers and programs installed are gcc version 2.95.2 19991024 (release) perl v5.6.0 built for i86pc-solaris tcl tcl8.3 make 3.79 flex version 2.5.4

Help for my first approach

2001-02-19 Thread Jose Luis Faria
ned 1 exit status ---- if you can, help me. thank you very much! -- -- :) cumprimentos --- Jose Luis Faria Tec. Superior Informatica - Administrador de Sistemas /\ /\/\

Re: Creative solution with XML,PHP,MYSQL

2001-02-17 Thread Jose Carlos R. de Andrade
It is even possible to do just with JavaScript, by being creative. However, refreshing the page seems the logical option. Is there any special reason for not doing it? I am almost always in favor of keeping things on the server side. Jose Carlos >Relax, XML has N.O.T.H.I.N.G. to do with w