--myisam-recover reliable on master and eventually slaves

I am planning to use the --myisam-recover option on a master MySQL server. I would like to know about your experiences on the matter: is it reliable? What about the consequences on the slaves: should they use it as well? Many thanks in advance to this great mailing list :-). -- SQL Jean-Luc

how to access mysql using vb as front end

hi, i am using vb as frontend.can we use database as mysql.can we access data using mysql ac database.if so how.pls send me teh details at the earliest. regards, venkat Join 18 million Eudora users by signing up for a free Eudora Web-Mail

Re: how to access mysql using vb as front end

phani krishna S.V wrote: hi, i am using vb as frontend.can we use database as mysql.can we access data using mysql ac database.if so how.pls send me teh details at the earliest. regards, venkat VenKat: You need MyODBC. It's right

After replication

Hello i installed replication between two mysql servers Now what? is there any software which does insert,deletes,updates on the master and select on both machines or on slave('s) only? is there any recommended setup (virtual ips, NAT anything) that will do the above? -- Kissandrakis S.

messages in log with 3.23.37 and ezmlm

Since I upgrade from MySQL 3.22.32 to 3.23.37 I've got a lot of messages in the 'host.err' log saying: 010511 11:01:56 Aborted connection 359914 to db: 'ezmlmbase' user: '' host: `localhost' (Got an error reading communication packets) where 'ezmlmbase' is the name of the database used

log event entry exceeded max_allowed_packet error: findings

Today on a slave I got: Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'xxx-bin.040' at position 47694 010511 10:37:19 Error reading packet from server: log event entry exceeded max_allowed_packet - increase max_allowed_packet on master (read_errno

firewall

hi all, just a newbie question. can i use a (win) gui mysql client, if i have a firewall installed between my intranet and mysql server. how? - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: how to access mysql using vb as front end

Hi I've been looking in mysql.com and I didn't find myvbql.dll. The MySql website you talk is www.mysql.com? You know all the functions and Sub of the dll that can be used ? Thanks Eugénio Veiga Warren van der Merwe wrote: Hi I am successfully developing with VB and MYSQL using the MYSQL

mysqlbugs

this is the binary version which i downloaded and tried to install when i try to start the server this is the error i get . anyone see anything wrong with this ! 010511 11:27:05 mysqld started ld.so.1: /usr/local/mysql-3.23.33-sun-solaris2.7-sparc/bin/mysqld: fatal: libcrypt_i.so.1: open f

Tr: myphpnuke - please help!

- Message d'origine - De : clictime À : [EMAIL PROTECTED] Envoyé: jeudi 10 mai 2001 12:58 Objet : Tr: myphpnuke - please help! Hello, I am trying to solve the following problem with mysql on myphpnuke-full. Everything is OK in my "localhost" (please see the links) Can you help

Re: firewall

Hi, can i use a (win) gui mysql client, if i have a firewall installed between my intranet and mysql server. how? You should have no trouble, so long as your firewall allows port 3306 through. Also, if your firewall performs Network Address Translation (NAT) then you'll need to make sure

doesn't have a correct index definition. You need to recreate it before you can do a repair

Description I rebooted my server this morning to add more memory, when it was brought back online I receive errnor 127 from mysql when I do simple queries like select * from table; I run myisamchk --safe-recover and get the following on every single table doesn't have a correct index

RE: how to access mysql using vb as front end

Hi there Herewith is the DLL you require (sent on seperate email so as not to clog the group). This zip file includes the source for the dll as well as some documentation. Really easy to use and even more so if you already familiar with ADO. Regards Warren Some sample code Private Sub

group by and order by

I have a table with texts, all of different type, I have field named type to know which is which. What I would want is with one SQL query select the latest from each type, but this query... select id, headline, type from texts group by type order by date; will give the first of each type. I

Re: Problem getting INNOBASE (3.23.37) working on FreeBSD (4.2)

Hi! In the last episode (May 10), Eric J. Schwertfeger said: Also, my initial testing shows that INNOBASE tables are even faster than MyISAM, at least for insertions, though the same tupples in a similar table seem to take up more room. Aside from the restrictions InnoDB tables are faster

Re: how to split database and index

Hi! If you use the InnoDB table type, you can configure the InnoDB tablespace to consist of several 2 GB files which you can put on different disks or in different directories. Look at the online manual at www.mysql.com or www.innobase.fi on how to specify the my.cnf parameters for InnoDB.

Windows CE

hi, is there a MYSQL Database for MS-Windows CE (for pocket pc ex.HP-Jornada)?

synopsis of the problem (one line)

Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release:

Mysql Problem

Hi I am facing great problems beacuse of Mysql server which is not able to take load. My apache is working fine even when the load average shoots of to 130 but my mysql server goes sleep when the load of apache shoots above 30. I am on a dedicated server. My Mysql Ver 3.22.32 I have red

InnoDB, BDB, and Gemini

I have re-read the appropriate manual sections several times, trying to decide what is the best option for my database table types. I am using 3.32.37 on Linux, and am torn between InnoDB, BDB, and Gemini table types. Transaction handling is very important for my application (commit, rollback,

Re: how to access mysql using vb as front end

Hi Thanks to all of you. I've got the file already. Regards Eugénio Robert Henkel wrote: Try going here for the file http://www.mysql.com/Downloads/Contrib/MyTool-DLL_for_VB_and_MySQL.zip and go to this page for some info on the dll http://www.icarz.com/mysql/ Good Luck! -Original

installation

Hi everyone I'm back to the list... I have a slight problem... I have downloaded the 3.23.37 in rpm. I installed it on a SuSE 7.0 box. At the end of the RPM -Uvh, i had the message you should enter a password /usr/bin/mysqladmin... But after a quick look, I don't have any mysqladmin

My Sql C_API(Urgent)

Hi, I am using my_sql_real_escape_string and in that the strmov function of mysqlclient library. I am getting the following errors while compiling: d:\program files\mysql\include\m_string.h(143) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(146) :

mysql++ for Visual C++

sorry you all, but I am new to Visual C++, I am trying to get some code compiled using MySQL++ 1.7.1 for MS Visual C++ 6.0 but I keep getting an error: d:\docs\devel\epiware\mysql++\mysql\include\mysql_com.h(115) : error C2146: syntax error : missing ';' before identifier 'fd'

Re: Help with MATCH AGAINST

Hi All, I am new to this list, and will find it of excellent use to me. I need help with the following: What it is I have a cv database and it is working great, I use PHP and MySQL and have just come across this problem, the client has asked me to search lots of fields in the database. At

Re: InnoDB, BDB, and Gemini

InnoDB definately provides more features that BDB, and is probably going to be faster, Gemini isn't available yet. BDB might be more complete/stable. So I'd say Gemini is out of the picture unless you are looking longer term. I'd do some testing with both we found some bugs in the 3.23.37

Re: how to split database and index

On Thu, 10 May 2001, roger westin wrote: We have a database of size 10GB and its index is also almost of the same size. Now we want this database in MYSQL. Please let me know how we can slpit it across 3-4 hard disks.We are using Linux 6.2 Hi there, My self I have a machine runnig RH

RE: mysql++ for Visual C++

I think I have narrowed the problem down to being the SOCKET is not defined in mysql.h: #ifndef my_socket_defined #ifdef __WIN__ #define my_socket SOCKET #else typedef int my_socket; #endif In my application, i am include mysql++ just as I saw done in an example that came with the code at

Hom many columns is too many?

I am designing an in house database app. for sales/contact management. We've identified out about 75 things to know about a customer/contact from there name all the way to where they went to highschool. Should all these attributes be in one table since they all describe the contact or should

RE: InnoDB, BDB, and Gemini

Goodday to you all Gemini tables are busy being beta tested, and therefore are available. I personally use them and so far so good. I really love having row level locking in MYSQL, and it works like a dream. contact www.nusphere.com for more info. There are currently running with 3.23.36 Enjoy

RE: Hom many columns is too many?

With relational database design you can more then likely break that 75 column table down into many different tables. Look up information on NORMAL FORM this will help you design an effective database. Usually from what I know and have been taught 3rd normal form is as low a level as you want

RE: InnoDB, BDB, and Gemini

Have you noticed a significant speed decline using Gemini tables? RH -Original Message- From: Warren van der Merwe [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:31 AM To: 'Steve Ruby'; 'Kevin McBrearty'; [EMAIL PROTECTED] Subject: RE: InnoDB, BDB, and Gemini Goodday to you

SELECT TOP?

Hi all- I am really new to the list and mysql. Here is my Question. I am used to writing SELECT TOP [num] FROM [table] I have searched the documentation online and found no mention of how to do this. But I did find info on LIMIT that limits the number of records returned. Is this how mysql

Re: Hom many columns is too many?

I would personally suggest they be broken up. I've noticed in the past some speed issues when you have too many columns. - Original Message - From: Richard Reina [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 11, 2001 11:26 AM Subject: Hom many columns is too many? I am

RE: InnoDB, BDB, and Gemini

In all honesty, I have personally not done any testing of Gemini v.s. other types as yet. I am busy converting my app from MS Access to MYSQL, once this is finished I will then be in a better position to answer this as I can test it. Regards Warren ~ Warren van

MySQL -- tee command ???

Hi, everyone, I have a question about the tee command in MySQL. I know one of its applications is to log everything from the screen to the outfile for debugging purpose. But how do I redirect output ONLY to outfile instead of both standard output (screen) and outfile. Because I donot want

Re: SELECT TOP?

On Fri, 11 May 2001, Anthony Colli wrote: Hi all- I am really new to the list and mysql. Here is my Question. I am used to writing SELECT TOP [num] FROM [table] I have searched the documentation online and found no mention of how to do this. But I did find info on LIMIT that limits

My Sql 3.2.3 and real_escape_string in C API

Hi, Does Mysql 3.2.3 support mysql_real_escape_string()? I donot find it included in the Libmysql. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at

Re: MySQL -- tee command ???

It sounds like you might be more interested in the SELECT * INTO OUTFILE syntax...read http://www.mysql.com/doc/S/E/SELECT.html for more information. - Original Message - From: Joseph Chow [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 11, 2001 9:57 AM Subject: MySQL -- tee

Re: MySQL -- tee command ???

On Fri, May 11, 2001 at 10:57:51AM -0600, Joseph Chow wrote: Hi, everyone, I have a question about the tee command in MySQL. I know one of its applications is to log everything from the screen to the outfile for debugging purpose. But how do I redirect output ONLY to outfile instead of

Re: Hom many columns is too many?

I dont think the problem was redudant data. He is talking about 75 distinct fields that no other table contains and ALL data is related to the contact. It makes sence that a table with more columns would have a higher overhead when parsing the queries, but but other than that I dont _think_

2-way replication in MySQL (sql)

Hi, everyone, This is my another question. I have one master server and one slave server now. In case that the master is down for any reason, I want the slave still accessible by clients. Is that possible in my SQL? by two way replications? This problem seems quiet complicated to me.

RE: Hom many columns is too many?

Well with tables not normalized you will more then likely at some point in get redundant data at some point. For instance I enter Joe smith with phone of 123-123-1222 then Joe Smith buys a new home keeps the other home and now has two active phone number with on table you would have to reenter

my sql _escape_string

Hi , Can some one send the exact function description of the following CAPI function: mysql_escape_string I need to use mysql_escape_string as the mysql-real_escape_string is not present in the .def file and is giveing linker error while linking. The C-API documentation says to refer

Re: 2-way replication in MySQL (sql)

On Fri, May 11, 2001 at 11:50:27AM -0600, Joseph Chow wrote: Hi, everyone, This is my another question. I have one master server and one slave server now. In case that the master is down for any reason, I want the slave still accessible by clients. Is that possible in my SQL? Yes. Just

WEB ACCESS TUTORIAL

I am very new to mysql. I need to write a simple database applicatio that will allow web access to enter a name and fill in a form. are there any good tutorials about using the web and mysql ??? thanks -- rr DISCLAIMER: The information in this message is confidential and may be legally

Remote Client Connectivity

I am trying to create an environment where the mysql db server is on one box and my application server is on a second. The db server is running on the first box and I can connect to it locally using the mysql interface. What needs to be installed from the mysql distribution on the application

mysql++ visual C++

i got my initial problem figured out ...but now i am getting a bunch of linker errors: msvcprtd.lib(MSVCP60D.dll) : error LNK2005: class std::basic_ostreamchar,struct std::char_traitschar __cdecl std::operator(class std::basic_ostreamchar,struct std::char_traitschar ,char const *)

Re: InnoDB, BDB, and Gemini

On Fri, 11 May 2001, Kevin McBrearty wrote: I have re-read the appropriate manual sections several times, trying to decide what is the best option for my database table types. I am using 3.32.37 on Linux, and am torn between InnoDB, BDB, and Gemini table types. Transaction handling is very

Encode/Decode Problem

I'm using encode/decode with PHP to crypt my database. Until now was OK, but I one string, and the MySQL return the string this (without the []...): [Oõ#M¼ô«~àý~ªÔbëÿ9S Z ] The fact is I can't insert this encode string into MySQL table! My select: select decode(Oõ#M¼ô«~àý~ªÔbëÿ9S

group by (bug)

Hi, Using this script, you can see the problem. I want to receive only the records with string 'I am the first' The select will return one record with string 'I am the second' please, send me any suggestion or bug-fix. Rodrigo mailto:[EMAIL PROTECTED] --- create database

inserting into blob on an asp page using vb or javascript

Hi All, I have created a simple MySQL database with a blob field. I would greatly appreciate it if someone could help me upload a file to a particular BLOB field using a ASP page with JavaScript or VBScript. Thanks in advance for all your help, Anoop The difficult we do immediately,

RE: mysql++ visual C++

ok, i just tried to create a new project that was just a console application, and everything seems to work there, it is only when I am trying to build an MFC dialog application that I am getting the linker errors ... the problem is below: // this is fine Connection con(mysql_cpp_data); //

simultaneous connections

Hi, I'm reading in my documentation (I have a book) that MySQL allows up to 101 simultaneous connections. Gadzooks! How can MySQL claim to be at the Enterprise level with this limit? Is there any way around this? Thanks, Don

Update problem, or more likely and problem understanding how to do updates.

Ok, based on the given syntax from the mysql manual.. UPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1, [col_name2=expr2, ...] [WHERE where_definition] [ORDER BY ...] [LIMIT #] I've been trying to update some records in a test database I've been playing with. I'm

RE: simultaneous connections

PREVIOS THREAD ON THIS TOPIC: Hope it helps Hi, Make sure that MySQL on your OS supports 5000 connections ! Check OS specific restrictions in MySQL documentation. Regards -- Joseph Bueno NetClub/Trader.com John Barton wrote: Try putting a line like the following in your my.cnf file: This

Re: Problem getting INNOBASE (3.23.37) working on FreeBSD (4.2)

In the last episode (May 11), Heikki Tuuri said: Dan Nelson wrote: No ANALYZE TABLE - correct key and subkey cardinality counts work wonders for complex queries (probably easy to add). InnoDB does the estimation of cardinalities required by the MySQL optimizer. But the counts are not

Re: simultaneous connections

Mysql allows 101 connections by default, 100 client connections plut it reserves one for administrator access. You can set your own maximum connection limit in the my.cnf file by using the directive: [mysqld] set-variable = max_connections= where xxx is the amount you want to set as the

Re: simultaneous connections

Don Pro wrote: Hi, I'm reading in my documentation (I have a book) that MySQL allows up to 101 simultaneous connections. Gadzooks! How can MySQL claim to be at the Enterprise level with this limit? Is there any way around this? Thanks, Don

Re: simultaneous connections

Don Pro wrote: Hi, I'm reading in my documentation (I have a book) that MySQL allows up to 101 simultaneous connections. Gadzooks! How can MySQL claim to be at the Enterprise level with this limit? Is there any way around this? Thanks, Don

RE: Update problem, or more likely and problem understanding how to do updates.

I don't believe you need the second set update Pictures set Date Posted = '2001-05-09', Notes = 'Test' where ID ='1'; I think that should work -Original Message- From: Barry L. Jeung [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 3:56 PM To: [EMAIL PROTECTED] Subject: Update

Re: Update problem, or more likely and problem understanding how to do updates.

You only need to specify SET once. update Pictures set Date_Posted = '2001-05-09', Notes = 'Test' where ID ='1'; - Original Message - From: Barry L. Jeung [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 11, 2001 12:55 PM Subject: Update problem, or more likely and problem

Re: Mysql Quota Support/DB Size Limitations

In the last episode (May 10), Nathan Boley said: Hi, I was interested in implementing size limitations on specific databases. I've searched the mysql docs for an mention of quota support, but I am not able to find any. I found that by chown the individual database directories and their files

Adding columns/tables to mysql database

I would like to be able to filter users based on other criteria than just their name/host. Will mysql complain/refuse to work if I add columns to the mysql database user table, or any other table in the mysql database? If I could do that, it would greatly simplify things for me. Thanks.

RE: group by (bug)

This is not a bug. Why don't you just select * from abc where field2 = 'I am the first';? Or: mysql select *, min(field2) from abc group by field1; +--++-++ | ID | field1 | field2 | min(field2)|

table options and performance

I've been doing some testing to determine tradeoffs with performance for using the Innobase or BDB tables. The testing application contains bulk inserts which must be processed as quickly as possible. The results I'm getting look very bad for innobase. Am I doing something wrong? I'm

RE: RTFM - Show locks

I too have wondered this... it looks like the manual just says (in your case) user 'b' will wait indefinitely for the lock held by user 'a' to be released. Maybe you could just have user 'a' hold a READ or READ LOCAL lock and not a WRITE lock, therefore user 'b' will still be able to do SELECTS

MySQL 3.23.38 released

Hi! This release includes mainly fixes for BDB and InnoDB tables. You can now find MySQL-Max (MySQL binaries with support for the above table types) for most supported platforms at http://www.mysql.com/downloads/mysql-max-3.23.html The windows binary is under testing and should hopefully be

Re: Help with MATCH AGAINST

$SQL = SELECT * FROM cvtemplate WHERE employment_type = '$employment_type' AND location = '$location' AND related_discipline = '$related_discipline', MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY

Re: Hom many columns is too many?

Just because one table has many columns does not mean it is not normalized. The original message stated that there is all kinds of different information about a contact from their first/last name to the high school they graduated from. Given enough information about a person it would be easy to

New install failed on Linux, what the??

010511 18:05:14 mysqld started 010511 18:05:14 /usr/local/libexec/mysqld: Table 'mysql.host' doesn't exist 010511 18:05:14 mysqld ended These error messages above are in the log when I start mysql with: /usr/local/bin/safe_mysqld --user=mysql I can't figure out why, I ran mysql_install_db

DATE for NOW() is incorrect for 64 bit compile

Description: Linux Alpha build. NOW() returns correct date, year 2053. How-To-Repeat: rimmer:~ # mysql ufn; Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 69 to server version: 3.23.37-Max-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer

SCO and getrusage()

Hello all, I am having trouble compiling a client program on a SCO UNIX 5.0.4 I wrote a simple C program to connect to the mysql server which by the way is the binary distribution 3.23.36. I am using the SCO cc compiler and linker. I know how to compile programs on this platform. At least I

Re: My Sql C_API(Urgent)

Hi, Instead of working with the strmov function use pointers to work on it, like I had to Ex: char myQuery[1024]=; CurrentAddress = myQuery; CurrentAddress+= mysql_real_escape_string( MysqlStruct,CurrentAddress, string, strlen(string) ); Best of Luck, S.K. Singh. - Original

Ordering of Dates

I'm creating a Blogger-like system for my website and I have it check for posts within the last 14 days using the following command: $result = mysql_query(SELECT * FROM data WHERE TO_DAYS(NOW()) - TO_DAYS(postdate) = 14,$db); However, in the while loop and the printf's this is going to display

RE: Ordering of Dates

Add ORDER BY postdate DESC to the end of the query. I'm creating a Blogger-like system for my website and I have it check for posts within the last 14 days using the following command: $result = mysql_query(SELECT * FROM data WHERE TO_DAYS(NOW()) - TO_DAYS(postdate) = 14,$db); However, in