Re: doc for administration mysql

Hello. Use the manual. See: http://dev.mysql.com/doc/refman/5.0/en/ I like MySQL (3rd Edition) by Paul Dubois as well. There a lot of other good books: http://dev.mysql.com/books/ Bayrouni wrote: Hello all, Wich are the best doc for (mysql administration) beginners Thank you --

Re: UPDATE statement causes signal 11 on 5.0.16

Hello. Please, could you explain what does it mean 'Signal 11 without fail'. Usually after receiving such a signal MySQL crashes. Of course, it should do this in normal circumstances. What is in the error log? Check if the problem still exists on official binaries of 5.0.18. Ian Sales (DBA)

Re: mysql driving make.

Hello. Please, could you explain more in detail what is the problem to check table dependencies? mysql command line client supports the batch mode, and you can run queries with -e option in the command line. See: http://dev.mysql.com/doc/refman/5.0/en/mysql-command-options.html Hugh Sasse

Re: UPDATE statement causes signal 11 on 5.0.16

Gleb Paharenko wrote: Hello. Please, could you explain what does it mean 'Signal 11 without fail'. Usually after receiving such a signal MySQL crashes. Of course, it should do this in normal circumstances. What is in the error log? Check if the problem still exists on official binaries of

Re: mysql-4.1.16 starting trouble

Privet! This is a bug: http://bugs.mysql.com/bug.php?id=15965 Have a look here as well: http://bugs.mysql.com/bug.php?id=15151 Most probable you will have to install the latest development source, which has this bug fixed: http://dev.mysql.com/doc/refman/5.0/en/installing-source-tree.html

Re: Migration of DB from MySQL 4.0.20 to 4.0.24

Hello. Sorry for such a late reply. The problem is in the duplicate line `dealer_type_name`. Remove one of these lines. Please, always send a copy of the message to the list. Most probably somebody whould have suggest you the same, if you had posted you mail to the list as well. Kuai

Re: UPDATE statement causes signal 11 on 5.0.16

Hello. Resolve a stack trace and provide it to the list. See: http://dev.mysql.com/doc/refman/5.0/en/crashing.html http://dev.mysql.com/doc/refman/5.0/en/using-stack-trace.html Now about the replication problem. As I've understood you have triggers only on the slave. In my opinion, to solve

Re: UPDATE statement causes signal 11 on 5.0.16

Gleb Paharenko wrote: Hello. Resolve a stack trace and provide it to the list. See: http://dev.mysql.com/doc/refman/5.0/en/crashing.html http://dev.mysql.com/doc/refman/5.0/en/using-stack-trace.html - resolving the stack dump gives me this:- 0x8150650 + 135595600 0xe420 + -7136

Re: mysql-4.1.16 starting trouble

On Tuesday 17 January 2006 14:37, Gleb Paharenko wrote: This is a bug: http://bugs.mysql.com/bug.php?id=15965 Have a look here as well: http://bugs.mysql.com/bug.php?id=15151 Most probable you will have to install the latest development source, which has this bug fixed:

Re: mysql-4.1.16 starting trouble

What about next release in 4.1.x? May be it will fix this bug? I hope it will. Trux wrote: On Tuesday 17 January 2006 14:37, Gleb Paharenko wrote: This is a bug: http://bugs.mysql.com/bug.php?id=15965 Have a look here as well: http://bugs.mysql.com/bug.php?id=15151 Most probable

MySQL 5.1.5-alpha has been released

Hi, MySQL 5.1.5-alpha, a new version of the popular Open Source Database Management System, has been released. The Community Edition is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Note that

Unknown problem with backup restore

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

MySQL 5.0 error after upgrade

Can someone help me. I was running v4 and just upgraded the version to v5.0. Most of my tables are MyISAM with some InnoDb. Most of the MyISAM tables are char fields but a few have integer columns. When trying to create a new table using the Administrator 1.1 program it is fine creating columns

CHAR vs TEXT and fast Row Updates

Hi All, We have an application that needs to update rows in the database 'as fast and efficiently' as possible. To this end, we've tried re-designing the table - can someone clarify the following assumptions we're about to make? 1. Fixed length CHAR fields are quicker to update than

relaying mysql datas

Hi, Recently i think sqlrelay is a solution for me, but now i don't know. I try to explain what I would like to do. I have written a software on win32 platform in c++. It's using mysql database and connecting to it with libmysql.dll. The task is connect two local network throught the

Re: CHAR vs TEXT and fast Row Updates

Hi, 2006/1/17, Karl Pielorz [EMAIL PROTECTED]: Hi All, 1. Fixed length CHAR fields are quicker to update than VARCHAR fields (because the field size is constant) There is no advantage if not all your field in your table are fixed size. as soon as you add a text/blob column, you loose the

Query Browser and MySQL 4.0 - UTF-8

Hello everybody, I'm using Query Browser 1.1.17 on Windows with a MySQL 4.0 database server on Linux and was just editing a piece of text for a web CMS in the database. But what do I get to see there? The content was stored as UTF-8, although the website uses ISO-8859-1 encoding, the data was

Re: question about CONTAINS SQL

- Original Message - From: wangxu [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, January 17, 2006 12:35 AM Subject: question about CONTAINS SQL I notice there are one section in the manual: CONTAINS SQL indicates that the routine does not contain statements that read

Re: how to copt table not whole database

Thank you Shawn. What I originally thought is that if there is any command like 'sqldump' to copy a few tables of a database. Xiaobo Xiaobo Chen [EMAIL PROTECTED] wrote on 01/16/2006 03:33:36 PM: Hi, all How should I copy a table of a database? Thanks in advance. Xiaobo -- Faculty of

Re: how to copt table not whole database

Xiaobo, Using mysqldump, you can specify which tables to copy. The man for mysqldump is as such: mysqldump [options] [dbname [tablename]] Say db 'db' has tables x, y, and z in it. You only want to copy table x. mysqldump db x x.sql(or whatever you want to name it). Dan Thank you

Re: Most efficient way to design this table

How did you get these byte calculations? I thought an INT took up 4 bytes and char(10) would take 10 bytes. http://dev.mysql.com/doc/refman/4.1/en/storage-requirements.html C.R.Vegelin [EMAIL PROTECTED] wrote: Hi Grant, I suggest to change both key fields to Integers. Numeric keys take

Re: how to copt table not whole database

Dan, thank you very much. That's what I want. Xiaobo Xiaobo, Using mysqldump, you can specify which tables to copy. The man for mysqldump is as such: mysqldump [options] [dbname [tablename]] Say db 'db' has tables x, y, and z in it. You only want to copy table x. mysqldump db x

Re: Migration of DB from MySQL 4.0.20 to 4.0.24

My fault about not replying to the list. What is the cause of this extra line? is this a mysqldump bug in that older version of MySQL? how come I was able to export and import this DB in the same version but different platform? Any ideas? Thanks, cybm On 1/17/06, Gleb Paharenko [EMAIL

--replicate-rewrite-db fails when attempting to drop a table

Hi List, I have been asked to setup replication between two customers servers for one particular database, which I will call in this post 'livedb'. The customer also has a copy of this database on the slave which they use for testing. This copy does not contains the same data as the master

Droping multiple tables by a pattern in the table name

Hello, I'm using mysql 4.1.14-standard. I would like to drop multiple tables in one or few queries. I don't have an easy way to predict their names (I have a way to find their names, but it's by using software and I prefer doing it with mysql). All of the table names have a fixed part which I

OK, need a little inspiration here...

I am stomped and not sure how to get results from the particular type of query. While I am not sure, if this is an appropriate place to ask, if nothing else perhaps someone will direct me to a more appropriate forum. I am trying to figure out how to return the latest record in each group of

Re: OK, need a little inspiration here...

Gmail User wrote: I am stomped and not sure how to get results from the particular type of query. While I am not sure, if this is an appropriate place to ask, if nothing else perhaps someone will direct me to a more appropriate forum. I am trying to figure out how to return the latest record

simple load query

hi all... whats the problem with this: load data infile 'stores.txt' into table useyourcash_sports_us (chain, store, address1, address2, city, state, zip,web) FIELDS TERMINATED BY '\t' i get: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server

Re: simple load query

Your FIELDS clause is not in the right place: http://dev.mysql.com/doc/refman/5.0/en/load-data.html HTH, James Harvard At 7:06 pm -0500 17/1/06, kalin mintchev wrote: whats the problem with this: load data infile 'stores.txt' into table useyourcash_sports_us (chain, store, address1, address2,

using SET time_zone for localization

I'm using SET time_zone = 'US/Hawaii' to convert timezones and it's not working. What am I doing wrong? I have verified that the session.time_zone var is set correctly. if(defined('ZMM_USER_LOCALE')) { $query = SET time_zone = ' . mysql_real_escape_string(ZMM_USER_LOCALE) .'; ;