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

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

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

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

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) ,

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

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

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)

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:

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

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

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

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

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:

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

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

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

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.

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

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

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

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:

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

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:

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