Re: Server-Crash - What to do?

over again (with bit by bit copy). After You have done rescuing FS, use myisamchk on rescued tables. Martins Karel W. Dingeldey wrote: Hello, yesterday my server crashed. The harddisk got corrupted, including some MySQL table files. So MySQL can't see some of its tables, although the

Right platform for huge db with huge RAM

tel Xeon 32bit with RAM>4GB? If AMD 64 bit wins, which motherboard would be more reliable and faster to use (2CPUs, DDR2 memory up to 16GB or so)? Thanks in advance! -- Best regards, Martins mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archiv

Re[2]: Mysql Web interface for normal Users

Hi! Just wanted to bring up an old topic - the situation with mysql web clients is the same as last year or is there any new good software? Something that would be easy to use and look nice to the users? I'm also looking for something quite simple yet enough customizable. Thanks! Ma

problem with decimal part

le as (6,5) but the problem is that mysql stores the number as 9.0 and I don't want that, I want the number to be the exact number I read from the file. Is there any way to fix that? I thought of using a VARCHAR data type. What do you think? Thanks -- Com os melhores cumprimentos Jo

Re: problem with decimal part

mark addison wrote: On Fri, 2006-08-11 at 10:30 +0100, Jorge Martins wrote: Hi, I have a client that want's to store in a table the exact number that he get's from a file, i've used a DOUBLE data type (MySQL 3.2x), but I have the following problem: If the number is for ex

How to have AUTO_INCREMENT ignoring 0?

record values,...) TIA, Fernando Martins -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How to have AUTO_INCREMENT ignoring 0?

From: Paul DuBois [mailto:[EMAIL PROTECTED] > At 21:09 +0200 6/16/03, Fernando Martins wrote: > >In AUTO_INCREMENT fields, inserting a 0 into the field requests a new > >sequence number. > > > >Is it possible to turn off this behaviour? (without messing with >

MySQL Connection Failed: Can't create a new thread

I am having problems with the number of simultaneous connections in the MySQL. I configured 5000 connections but when arriving in 4096 it presents the errors below. MySQL Connection Failed: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual fo

mySQL newbie confusion

Hi, my experience comes from VB6 with access databases. I'am trying to get one quick and practical overview about the mySQL capabilities (web online database). But so far i'am really loss and confuse regarding the mySQL setup and installation procedure. I'am using WIN98 with mySQL4.01.11 and foll

Re: Help about date conversion ...

I want to write date type in the format "DD/MM/" to the database? Can I do this with some parameter to mysql.ini? ** Amilton Martins Infosoft Informática Ltda. www.infosoft.inf.br - Befo

Audit - Log

poses? Thanks Frederico Martins - 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 <[EMAIL PROTECTED]> To uns

Fatal error: Can't open privilege tables: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2)

o choose this. I installed the binary freebsd package which is suppose to be very reliable to a quick start. Thanks -- Ricardo David Martins _ AVISO Esta mensagem (incluindo quaisquer anexos) pode

Spatial data at InnoDB tables

According to MySQL Manual: "MySQL 4.1 introduces spatial extensions to allow the generation, storage, and analysis of geographic features. Currently, these features are available for MyISAM tables only." This means that I can not have transactional processing in a table with spatial data, right

Date Format in MySQL

Hello Friends Is possible to change the MysQL Date fromat from -mm-dd to dd-mm- ? Thanks Claudemir F. Martins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Database Security

then get access to the MySQL Databases. Is there a good way to protect the passwords ? Regards Claudemir F. Martins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Backup of all Databases

which contain all databases, is a good idea for a backup ? Regards Claudemir F. Martins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To re

How to Know if DBD is installed ?

Hello How is possible to know if the DBD (for Perl Interface) is already installed in Mysql ? Is there a way to install it , after MySQL is installed ? Regards Claudemir F. Martins - Before posting, please check: http