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
--
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)
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
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
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
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
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
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
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:
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
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
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
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
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
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
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
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
- 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
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
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
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
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
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
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
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
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
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
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
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,
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) .'; ;
30 matches
Mail list logo