Re: undefined reference to 'mysql_init'
Hi Ali Hi, I am begeener to MySQL. I have installed Suse10 and MySQL and mysql++ in my pc. i want to connect to MySQL through C. When I am compiling the program, I am getting the following error. *** compile your app with the command bellow gcc -o test -L/usr/lib/mysql -lmysqlclient test.c Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: query slow
Hello friends Id like to thanks all friends that helped with this question Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
query slow
Dear friends is their any way to optimize this query bellow, it take +- 2minutes do complete, i think it becouse their no index by the emissao field SELECT * FROM `sav00_sava0400_dbf` WHERE 2000 = YEAR(`emissao`) OR (1999 = YEAR(`emissao`) AND 12 MONTH(`emissao`)) ORDER BY emissao ASC The table structure is bellow CREATE TABLE `sav00_sava0400_dbf` ( `unidade` double(2,0) default NULL, `duplicata` double(6,0) default NULL, `ordem` double(2,0) default NULL, `unidadeped` double(2,0) default NULL, `pedido` double(6,0) default NULL, `emissao` date default NULL, `vencto` date default NULL, `venctoorig` date default NULL, `cliente` double(5,0) default NULL, `cidade` double(4,0) default NULL, `estado` char(2) default NULL, `regiao` double(2,0) default NULL, `microregia` double(2,0) default NULL, `represent` double(3,0) default NULL, `comissao` double(5,2) default NULL, `valorface` double(15,2) default NULL, `valorbaixa` double(15,2) default NULL, `produtogrp` char(3) default NULL, `codbaixa` double(2,0) default NULL, `ocorrencia` double(2,0) default NULL, `databaixa` date default NULL, `jurosdev` double(15,2) default NULL, `jurospagos` double(15,2) default NULL, `dliquidupl` date default NULL, `jurospend` double(15,2) default NULL, `jurosmerc` double(15,2) default NULL, `saldodupl` double(15,2) default NULL, `jurosabona` double(15,2) default NULL, `statusfina` double(2,0) default NULL, `dstatusfin` date default NULL, `valorfatu` double(15,2) default NULL, `trans` date default NULL, `proc004` date default NULL, `agcobr` double(3,0) default NULL, `sitdupl` double(2,0) default NULL, `valordevol` double(15,2) default NULL, `valordesc` double(15,2) default NULL, `sr_recno` bigint(15) NOT NULL auto_increment, `sr_deleted` char(1) NOT NULL default '', `indkey_001` char(254) default NULL, UNIQUE KEY `sr_recno` (`sr_recno`), KEY `SAV00_SAVI0401_01` (`unidade`,`duplicata`,`ordem`,`sr_recno`), KEY `SAV00_SAVI0402_02` (`saldodupl`,`sr_recno`), KEY `SAV00_SAVI0403_03` (`proc004`,`sr_recno`), KEY `SAV00_SAVI0404_04` (`indkey_001`), KEY `SAV00_SAVI0405_05` (`represent`,`emissao`,`unidade`,`duplicata`,`ordem`,`sr_recno`), KEY `SAV00_SAVI0406_06` (`vencto`,`sr_recno`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: query slow
Hi Jay Thanks for the help Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
reclaim disk space
Dear Friends how to reclain the disk space used by an table that was dropped? Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dump only data and Database
Dear Friends What are the best options to dump an entire database on linux (with creation of databases and tables) with out dumping the index creation sentences For dump I use this command mysqldump -e --add-drop-database --add-drop-table dabasename database.sql Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dump only data and Database
Paul Dear Friends What are the best options to dump an entire database on linux (with creation of databases and tables) with out dumping the index creation sentences What is an index creation sentence? Do you mean that you want the dump to include the CREATE TABLE statements, but for those statements not to contain the index definitions? If so, there's no option for that. yes, exactly this, and thanks for the answer Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Band width consume
Dear Friends Is their an Page with data of how much bandwidth mysql consume when using remote servers? Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Band width consume
Dear Friends Is their an Page with data of how much bandwidth mysql consume when using remote servers? Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
encrypt data
Dear Friends is their any way to encrypt data saved to an mysql server? Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Server take 20s to connect
Dear Friends I've set up an mysql server with version 4.1.15 by compiling the .src.rpm on an linux machine running conectiva linux 10 with 1.5Gb of RAM on an Pentiun 4 2.88 Gz machine The app I have is running on windows connecting to this linux server by using direct ip address for mysql linux machine, but is taking more then 20s to connect. also no firewall active on linux server all tables are innodb bellow the server config # Example MySQL config file for very large systems. # # This is for a large system with memory of 1G-2G where the system runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # In this file, you can use all long options that a program supports. # If you want to know which options a program supports, run the program # with the --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size = 32M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 # Don't listen on a TCP/IP port at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction with mysqld must be made via Unix sockets or named pipes. # Note that using this option without enabling named pipes on Windows # (via the enable-named-pipe option) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging is required for replication log-bin # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 1 # Replication Slave (comment out master section to use this) # # To configure this host as a replication slave, you can choose between # two methods : # # 1) Use the CHANGE MASTER TO command (fully described in our manual) - #the syntax is: # #CHANGE MASTER TO MASTER_HOST=host, MASTER_PORT=port, #MASTER_USER=user, MASTER_PASSWORD=password ; # #where you replace host, user, password by quoted strings and #port by the master's port number (3306 by default). # #Example: # #CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306, #MASTER_USER='joe', MASTER_PASSWORD='secret'; # # OR # # 2) Set the variables below. However, in case you choose this method, then #start replication for the first time (even unsuccessfully, for example #if you mistyped the password in master-password and the slave fails to #connect), the slave will create a master.info file, and any later #change in this file to the variables' values below will be ignored and #overridden by the content of the master.info file, unless you shutdown #the slave server, delete master.info and restart the slaver server. #For that reason, you may want to leave the lines below untouched #(commented) and instead use CHANGE MASTER TO (see above) # # required unique id between 2 and 2^32 - 1 # (and different from the master) # defaults to 2 if master-host is set # but will not function as a slave if omitted #server-id = 2 # # The replication master for this slave - required #master-host = hostname # # The username the slave will use for authentication when connecting # to the master - required #master-user = username # # The password the slave will authenticate with when connecting to # the master - required #master-password = password # # The port the master is listening on. # optional - defaults to 3306 #master-port = port # # binary logging - not required for slaves, but recommended #log-bin # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname # Uncomment the following if you are using BDB tables #bdb_cache_size = 384M #bdb_max_lock = 10 # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_group_home_dir = /var/lib/mysql/ #innodb_log_arch_dir = /var/lib/mysql/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high #innodb_buffer_pool_size = 384M #innodb_additional_mem_pool_size = 20M # Set .._log_file_size to 25 % of buffer pool size #innodb_log_file_size = 100M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M
problem with mysql 4.1.3 beta
Dear Friends i was using ,mysql 4.0.15 for production with no problem now i just instaled the 4.1.3-beta for an test and relink my app that use mysql api every time i execute i got an segmentation fault on the call to mysql_num_fields Can any one help Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Erro on Query
Dear Friends. when Creating the follow table CREATE TABLE CONHEC_DBF (CON CHAR (7) , SER CHAR (2) , NUMNF CHAR (8) , SERNF CHAR (2) , LOJA CHAR (2) , PAIDF CHAR (12) , QUANT REAL (6,0) , NOP CHAR (10) , TRAN CHAR (4) , DTC DATE, DTE DATE, ESPEC CHAR (10) , PESO REAL (8,2) , VALORNF REAL (12,2) , FRPESO REAL (12,2) , FREVAL REAL (12,2) , VALKILO REAL (12,2) , PERVFRE REAL (12,2) , PERTFRE REAL (12,2) , OUTROS REAL (12,2) , PREST REAL (12,2) , BCFRE REAL (12,2) , ALIICM REAL (6,2) , ICMS REAL (12,2) , TOTFRE REAL (12,2) , VALOREM REAL (12,2) , CIFFOB CHAR (1) , TIPOFAT CHAR (1) , TIPTRAN CHAR (1) , FATURA CHAR (10) , DATAFAT DATE, DESC REAL (12,2) , IMPEXP CHAR (1) , SR_RECNO BIGINT (15) NOT NULL AUTO_INCREMENT , SR_DELETED CHAR (1) NOT NULL , PRIMARY KEY (SR_RECNO) ) Type=InnoDb I got an Erro when defining Column DESC(same error even if DESC is between ) So how can i Create this Column, or how to resolve this problem mysql server version 4.1.1 Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
myodbc compiling priblems
Dear Friends then in compiling MyODBC (3.51.06)... Making all in samples make[1]: Entering directory `/storage/MySQL/src/MyODBC-3.51.06/samples' source='my_basics.c' object='my_basics.o' libtool=no \ depfile='.deps/my_basics.Po' tmpdepfile='.deps/my_basics.TPo' \ depmode=gcc3 /bin/sh ../depcomp \ gcc -DHAVE_CONFIG_H -I. -I. -I../driver -/usr/local/mysql/include/mysql -I. -I.. -isystem -I/usr/local/include -O3 -DDBUG_OFF -c `test -f my_basics.c || echo './'`my_basics.c /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -L/usr/local/mysql/lib/mysql -lmysqlclient -o my_basics my_basics.o ../driver/libmyodbc3.la -L/usr/local/lib -L/usr/local/mysql/lib/mysql -lm -lz -lodbcinst mkdir .libs gcc -O3 -DDBUG_OFF -o .libs/my_basics my_basics.o -L/usr/local/mysql/lib/mysql -L/usr/lib ../driver/.libs/libmyodbc3.so /usr/local/lib/mysql/libmysqlclient.so -lcrypt -lnsl -lssl -lcrypto -L/usr/local/lib -lm -lz /usr/local/lib/libodbcinst.so -ldl -lpthread -Wl,--rpath -Wl,/usr/local/lib -Wl,--rpath -Wl,/usr/local/lib/mysql ../driver/.libs/libmyodbc3.so: undefined reference to 'my_ismbhead' collect2: ld returned 1 exit status can some one help mysql 4.1.x compiled from source and instaled on /usr/local Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
An doubt about mysql version 4.0.x agains 4.1.x
Dear Friend an friend of mine told that the follow line bellow dont work with mysql version 4.0.x * Support for subqueries and derived tables This mean query like : SELECT A.* FROM (SELECT * FROM TESTE WHERE X = Y) A WHERE COL1 = 3 is this true, or mysql version 4.0.x work properly with this Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem with query
Dear Friends Running the follow query select max( sr_recno) from test_table down work for re the error id returned by mysql_errno is 3731792 server is 4.1.1a-alpha Table structure is SR_DELETEC char(1) SR_RECNO bigint(15) PRI auto_increment VALUE double(18,6) OBS text ENABLE tinyint(4) DATE_LIM date days double(6) percent double(8,2) descr varchar(50) cardid char(1) code_id varchar(8) Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql version 4.0.x ,LOCKS and Transactions
Dear Friends Talking with an friend, he told he that mysql 4.0.x has many problems with lock and transactions, is this true. All table that i use are innodb Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: API C
Hi Galbino is the MySQL-client and MySQL-devel package instaled Regards Luiz www.xharbour.com.br -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
query only that return the fields that an table existe
Dear Friends as subject. is this possible if yes, how to get the field names returned Regards Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.588 / Virus Database: 372 - Release Date: 13/2/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: query only that return the fields that an table existe
Hi Rhino If your table name is bar and it is in a database named foo, the following commands will show you the columns in that table: describe foo.bar; -OR- show columns from foo.bar; If you try either command on a table that does not exist, you get an error message. Therefore, the query only returns the fields if the table exists. Is that what you wanted? That's how I understood your question yes, this is what i want, now to get the name of fields and i should use MYSQL_FIELD with the result returned from the query like MYSQL_RES * res; MYSQL_FIELD *field; mysql_query(my, show columns from foo.bar); res = mysql_use_result(my); for (i:= 0; i=mysql_num_rows(res); i++) { field=mysql_fetch_field_direct(res,i); do ant thing with field Right Regards Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.588 / Virus Database: 372 - Release Date: 13/2/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Postgres to mysql api
Dear Friends What is the mysql api for the follow postgress api PQresultStatus() PQntuples() PQresStatus PQclear() PQgetValue() PQerrorMessage() PQnfields() PQfname() PQfnumber() PQfsize() PQfmod() Regards and thanks in advance Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.588 / Virus Database: 372 - Release Date: 13/2/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
transaction
Dear Friends Does mysql version 4.0.x support the follow sql commands begin transaction commit rollback Regards Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.588 / Virus Database: 372 - Release Date: 13/2/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction
CanIt Vote for ID 3429Daniel I searched all myql 4.0 what new page and did found any reference, is their other page Regards Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.588 / Virus Database: 372 - Release Date: 14/2/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: mysql and borland
- Original Message - From: Luiz Rafael Culik Guimaraes [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 14, 2004 4:35 PM Subject: mysql and borland Dear Friends i uas using mysql 4.0.16 with out any problem now i updated my server to 4.0.18 regenerated my import lib and relinked my app now i get an GPF on this MYSQL * m; m=mysql_init(NULL); any help Regards Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.581 / Virus Database: 368 - Release Date: 9/2/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.581 / Virus Database: 368 - Release Date: 9/2/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql and borland
Hi all Please ignore this message was an old version od libmysql.dll on my windows\system32 folder Regards Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.581 / Virus Database: 368 - Release Date: 9/2/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The Future of MySQL with .NET Plataform
Carlos I will be away for Ms Trash .Net platform inet based programs will be the future. i use rpc on my programs as well standart programming .Net for me nothing more an microsoft way o destroy java Regards Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 2/1/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: programming language
Hi I'm a CLIPPER programmer. I'm looking for programming language (like Clipper) for MySql, that supports constructs such as LOOP, If-then-Else etc. Use xharbour download ftom www.xharbour.org news group news://news.xharbour.org/xharbour Regards Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 21/11/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlclient.lib
Dear Friends Where i can get the source for mysql 4.0.14 I´ve like to contribute with an mysqlclient.lib compiled with Borland C++ compilers as existe an version of this lib for 3.23.36 Regards and thanks in advance Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/03 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlclient lib
Dear Friends where i can find an mysqlclient.lib compiled for borland compiler I use mysql 4 as an windows server Regards Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/03 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlclient lib
Hi At 11:07 26/9/2003 -0300, Luiz Rafael Culik Guimaraes wrote: Dear Friends where i can find an mysqlclient.lib compiled for borland compiler thansk, but for libmysql.dll i created then import lib, but still asking for function inside mysqlclient.lib Regards Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/03 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlclient library
Dear Friends i´ve just download mysql 4.0.14 where i can find an mysqlclient.lib for borland c++compilers, the one on windows download page is for version 3.23.xx Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: images on database
Hi The most common problem in such cases is that the webserver doesn't know what MIME Type the file is and so it doesn't know how to send it. If you are using PHP to upload and later show that image on the web, i could give you the code for the scripts and the structure of the table containg the binary data. yes, i´m using php 4.1 Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
images on database
Dear Friends I has images saved on an mysql table as an blob field, but i could not recreate the image as file by selecting an specific record of this field any ideia Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Linux kernel diferences between all kernel version -- differences between all soaps ...
TheBS Do you mean the stock kernel branches TheBS (2.0, 2.2, 2.4, 2.6)? yes, as you point I need to enumerate the changes between all Version Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]