Add the following line to you slave my.cnf file:
replicate-ignore-db=mysql
>> Original Message <<
On 3/16/04, 2:44:53 PM, cvarda <[EMAIL PROTECTED]> wrote regarding Re:
Blocking INSERT/UPDATE on SLAVE (replication):
> I'm currently replicating all databases, so
First, do not replicate the MySQL database from the master to the
slave(s). Then create users on the slave that only have the desired
rights. In your case, SELECT only.
>> Original Message <<
On 3/16/04, 2:02:13 PM, cvarda <[EMAIL PROTECTED]> wrote regarding Bloc
Did you look in the error log for the slave to find out the reason it can
not contact the master?
>> Original Message <<
On 3/15/04, 1:39:44 PM, Daniel Gibby <[EMAIL PROTECTED]> wrote
regarding hard boot killed replication execution:
> My master server was hard
You did not state the tool you are using so I am not sure if the syntax
is meant to be a constraint or an index. Since an Index was stated once
for each column I am assuming the first UNIQUE is a constraint while the
actual index is preceded by the INDEX keyword.
>> Original Mes
If the table types are all MyISAM and you took a consistent backup the
answer is most likely yes.
>> Original Message <<
On 3/15/04, 7:50:39 AM, mt m <[EMAIL PROTECTED]> wrote regarding restoring
a database from tape:
> Hi,
> Recently we EOLed a machine that h
How did you originally populate the MySQL database with this table in
question? Did you export the table via MS Access and load the data with
either LOAD DATA or mysqlimport?
...
Out of curiosity why did you use Access to create and populate the
tables, export them to MySQL and are using Access
What is `special` about this one? If you are using ODBC links why are you
needing to convert the table? MS Access is merely your GUI to the
underlying data.
>> Original Message <<
On 3/4/04, 2:28:31 PM, Steve Siesel <[EMAIL PROTECTED]> wrote regarding Re:
MS Acc
Are you using ODBC Links or are you importing the table into MS Access
from MySQL? Are there unique constraints on the table to prevent
duplicate data from being entered?
>> Original Message <<
On 3/4/04, 1:57:15 PM, Steve Siesel <[EMAIL PROTECTED]> wrote regardi
The MySQL server is not running. Did you start the MySQL server?
>> Original Message <<
On 3/4/04, 1:19:28 PM, Scott Bounds <[EMAIL PROTECTED]> wrote
regarding RE: mysql reply - Checked by Vexira - - Checked by Vexira - -
Checked b:
> I ran the ps -ef | grep my
I was unable to reproduce the error on 4.0.17 using the supplied data.
>> Original Message <<
On 3/4/04, 11:42:56 AM, Sergei Golubchik <[EMAIL PROTECTED]> wrote regarding
Re: Corrupt full text index:
> Hi!
> On Mar 04, [EMAIL PROTECTED] wrote:
> > >Description:
MyODBC/MySQL connections can be made DSN less.
>> Original Message <<
On 3/4/04, 11:28:19 AM, Gilbert Wu <[EMAIL PROTECTED]> wrote
regarding OLEDB Provider for Mysql:
> Hi,
> We are developing in Microsoft's C++.NET with MS SQL Server as the
underlying DBMS. W
Can you do a ps -ef | grep mysql and post the results? Also can you log
in using mysql --user=mysql -p -P3306
Original Message dated 3/4/04, 10:43:26 AM
Author: Scott Bounds <[EMAIL PROTECTED]>
Re: mysql reply - Checked by Vexira -:
I have attached my my.cnf file. I am not sure how to "connect
What operating system are you using? What does your my.cnf look like for
the sections
[mysqld]
...
socket=
...
Can you connect to the MySQL server?
>> Original Message <<
On 3/4/04, 10:14:26 AM, Scott Bounds <[EMAIL PROTECTED]> wrote
regarding RE: Can't seem to
Does the socket actually exists? Are you able to connect via port?
>> Original Message <<
On 3/4/04, 9:04:02 AM, root <[EMAIL PROTECTED]> wrote regarding Can't
seem to get to run properly - Checked by Vexira -:
> >Description:
> I keep getting the same old
You have no join criteria between your tables.
>> Original Message <<
On 3/4/04, 9:23:41 AM, Erich Beyrent <[EMAIL PROTECTED]> wrote
regarding Duplicates returns in query?:
> Hi all,
> I have a problem with a select returning duplicates, even though there
> are
Here are two suggestions:
1) One option is to use source database to dump data into a MySQL
readable format, then import/load the data into MySQL.
2) Another option is to use a language like C++/or Java and open
simultaneous connections to each database. One dumping data, format the
data then o
Did you use a MySQL binary or one that you compiled? What version of 4.0
did you test against?
>> Original Message <<
On 3/4/04, 7:43:02 AM, <[EMAIL PROTECTED]> wrote regarding Corrupt full text
index:
> >Description:
> When updating a table with a fullte
This functionality exists in 4.1.x versions of MySQL
>> Original Message <<
On 3/4/04, 8:07:15 AM, Gabriel Alessandria <[EMAIL PROTECTED]> wrote
regarding Sintax - Where xx not in (another Select structure):
> There exists the possibility of doing a SELECT where
In your VB code, are your connections pooled, or are you using the same
connection for each database call?
>> Original Message <<
On 3/3/04, 1:12:07 PM, Jacque Scott <[EMAIL PROTECTED]> wrote regarding
CREATE TEMPORARY TABLE:
> I am trying to create a temporary
Que es la version de MySQL. De la computadora?
>> Original Message <<
On 3/3/04, 12:42:25 PM, Miguel Angel Solorzano <[EMAIL PROTECTED]> wrote
regarding Re: Fw: imposible cargar datos en tablas:
> At 15:33 3/3/2004, Marcelo Rodriguez Salinas wrote:
> >Me podrian
Do these files contain the .frm, .myd and .myi file extensions? How were
these files originally created?
Original Message dated 3/3/04, 10:11:10 AM
Author: Manda Sairam <[EMAIL PROTECTED]>
Re: Re: how to import a file to the database :
The file is a binary file these are mysql db files I need
If you want all values why not just do
SELECT *
FROM testdb
...
The `%` will not match NULL values.
>> Original Message <<
On 3/3/04, 9:41:22 AM, "Jonas Lindén" <[EMAIL PROTECTED]> wrote
regarding LIKE % not including NULL values?:
> Hello list
> SELECT * FROM
If you plan on constructing this your self may I suggest that you create
a matrix of all the possible scenarios/issues you would like to trap and
define how you want to those `automatically` handled. For example,
`replication stopped`, `duplicate index`, `long running query`, `corrupt
table`, e
Does the file contain valid MySQL syntax? If so, you can import the file
using
\. file_name
from the MySQL monitor
>> Original Message <<
On 3/3/04, 8:40:45 AM, Manda Sairam <[EMAIL PROTECTED]> wrote regarding
how to import a file to the database :
> how to i
A union is designed to integrate two+ result sets into one. Can you not
just join the tables together and perform a sum in the select clause?
>> Original Message <<
On 3/2/04, 3:46:30 PM, Lorderon <[EMAIL PROTECTED]> wrote regarding
UNION:
> Hello All,
> I wan
What version of Irix are you on again? Not meaning to inject this late
but did you have a look at this section in the MySQL manual?
http://www.mysql.com/doc/en/SGI-Irix.html
>> Original Message <<
On 3/2/04, 3:05:39 PM, Bernd Jagla <[EMAIL PROTECTED]> wrote regard
Are you sure you allotted 512MB for both read_buffer and
sort_buffer_size? Try reducing these values so that the total is roughly
80 percent of your total physical memory.
>> Original Message <<
On 3/2/04, 2:26:31 PM, Bernd Jagla <[EMAIL PROTECTED]> wrote regardi
The database server becomes unresponsive to new threads?
What is the result of the following equation?
key_buffer_size + ( (read_buffer_size + sort_buffer_size) * max
_connections )
...
Is this larger than you physicall memory?
>> Original Message <<
On 3/2/04, 2
Did you run a stack trace?
>> Original Message <<
On 3/2/04, 9:02:15 AM, "Nisim," Lior <[EMAIL PROTECTED]> wrote regarding
Mysql 4.1.1 crashes:
> hi
> My server crashes on sub qurey , can any one help ?
> ---
What error message, if any is thrown when someone attempts to log in when
the two queries are running? Is the system as a whole performing slowly?
What version of MySQL are you running?
>> Original Message <<
On 3/2/04, 1:37:34 PM, Bernd Jagla <[EMAIL PROTECTED]
Correct, the timestamp field will be updated if the value is not
specified. But, the value is being specified by the empty string. You can
try specifying the columns you want and see if this forces MySQL to auto
populate your timestamp fields.
>> Original Message <<<
Can you post the explain plan? I would be interested to see if temp table
tables are being created or if the system is swapping or if the the temp
tables are so large that the entire system begins to act poorly.
>> Original Message <<
On 3/2/04, 12:35:20 PM, Bern
An invalid datetime, or in your case, an empty value, will be set to the
nearest zero value representation.
>> Original Message <<
On 3/2/04, 1:06:50 PM, Mark Riehl <[EMAIL PROTECTED]>
wrote regarding Load Data and Timestamps:
> All - I'm running MySQL 4.0.13 u
When the queries in question are running, what does top look like? With
an insert that large it may be beneficial to disable any keys that may be
active on the target table and re-enable them after the data has been loaded.
>> Original Message <<
On 3/2/04, 12:08
If you are wanting a checkbook like display then each entry is either a
debit or credit and each is on its own line.
Your query will display this. I would add an ifnull to display a zero
when the the debit/credit is null.
>> Original Message <<
On 3/2/04, 10:50:1
What does the explain plan reveal?
>> Original Message <<
On 3/2/04, 9:05:17 AM, Bernd Jagla <[EMAIL PROTECTED]> wrote regarding no
one can log on any more:
> Hi there,
> I have some weird sql statements that seem to eat up all resources from
> mysqld.
> Once I
Analyze your table. Your cardinality is invalid.
>> Original Message <<
On 3/1/04, 10:22:36 AM, Brian Power <[EMAIL PROTECTED]> wrote
regarding When I woke up this morning...:
> Hi all,
> I'm a having a stange problem with mysql-nt on win2000.
> Querys that la
GRANT SELECT, LOCK TABLES ON dbname.* TO dump@'%' IDENTIFIED BY 'dump';
mysqldump --opt -udump -pdump -hlocalhost -B dbname --tables table_name
worked just fine for me.
>> Original Message <<
On 2/27/04, 1:40:46 PM, Paul DuBois <[EMAIL PROTECTED]> wrote regardin
Can you do a show grants for [EMAIL PROTECTED] for both users and see if there is
a glaring difference in permissions?
>> Original Message <<
On 2/27/04, 12:33:56 PM, "Tucker," Gabriel <[EMAIL PROTECTED]> wrote
regarding RE: Privileging:
> Yes - the same machin
Give the use the lock option if you plan on using the --opt.
>> Original Message <<
On 2/27/04, 12:02:34 PM, Jim Shea <[EMAIL PROTECTED]> wrote regarding Re:
Minimum privileges required for mysqldump:
> >On 2/27/04, 10:12:56 AM, Jim Shea <[EMAIL PROTECTED]> wrot
The user will need SELECT access to the table(s) in question.
>> Original Message <<
On 2/27/04, 10:12:56 AM, Jim Shea <[EMAIL PROTECTED]> wrote regarding
Minimum privileges required for mysqldump:
> I want to create a user that has the minimum rights to dump a
Are you running this test from the same machine for both users?
>> Original Message <<
On 2/27/04, 9:55:03 AM, "Tucker," Gabriel <[EMAIL PROTECTED]> wrote
regarding Privileging:
> Hello
> I have a user that is granted all privileges for their database. When
t
Without seeing the data I am assuming that you are going over the 30%
threshold with your less/greater equal to where clauses. What sort of
criteria are you asking the database engine to search for?
>> Original Message <<
On 2/25/04, 9:44:02 PM, <[EMAIL PROTECTED
Your resultSet needs to be scrollable. You have created a streaming
resultSet.
>> Original Message <<
On 2/26/04, 12:33:38 PM, Ted Hulick "(nVision" "Software)"
<[EMAIL PROTECTED]> wrote regarding Large
ResultSets/TYPE_SCROLL_INSENSITIVE:
> I am using this:
What about
SELECT (SUM( ads.col * 1.91) * ads.depth ) ) / 131.77
FROM ads
WHERE date = '2004-02-26'
AND editionID = '13'
AND ads.page = '16'
>> Original Message <<
On 2/25/04, 4:19:12 PM, "Rogers," Dennis <[EMAIL PROTECTED]> wrote
regarding Query help - add res
I am assuming that the Memo field is a text datatype and you were
encountering the duplicate key bug.
>> Original Message <<
On 2/25/04, 3:28:58 PM, James Lamanna <[EMAIL PROTECTED]> wrote
regarding Re: Problem with indexes:
> Found out that the problem was act
Are you not able to do
SELECT *
FROM table
WHERE col = "O\'Brien"
?
>> Original Message <<
On 2/25/04, 1:25:06 PM, Larry Brown <[EMAIL PROTECTED]>
wrote regarding command line escape for apostrophe:
> I usually use php for most of my work, but I have to run a
Can you do a show create table Table1 and see how the index is defined?
>> Original Message <<
On 2/25/04, 12:02:43 PM, James Lamanna <[EMAIL PROTECTED]> wrote
regarding Problem with indexes:
> So I'm having issues with indexes in mysql 4.0
> I issue the follow
Are you using the DTS to schedule replication or periodic data imports?
>> Original Message <<
On 2/25/04, 11:48:02 AM, "HACKATHORN," TODD "(SWBT)" <[EMAIL PROTECTED]> wrote
regarding updating tables in MySQL:
> Hello,
> Sorry if this is a obvious question, but
What MySQL version are you running?
Original Message dated 2/25/04, 9:19:43 AM
Author: Gregorio <[EMAIL PROTECTED]>
Re: Nested queries:
This is the query i want to run but i doesn't work.
select id from c_table where users_id in (select id from users where
locations_id=3) order by data_ora
Have you changed the interactive_timeout and wait_timeout values?
>> Original Message <<
On 2/24/04, 4:54:57 PM, <[EMAIL PROTECTED]> wrote regarding inserting huge
string:
> hi,
> I am using mysql 4.0.14. I have a table where one of the fields has a
> dataty
Configure your my.cnf data_dir parameter to point to the raid Hard Drive.
>> Original Message <<
On 2/24/04, 12:44:13 PM, Kirti "S." Bajwa <[EMAIL PROTECTED]> wrote regarding
How to install data on a RAID HDD??:
> Hello List:
> First my apology: I have previous
MySQL is designed to do that. If no data is changed, then MySQL will not
perform the update.
>> Original Message <<
On 2/24/04, 11:36:39 AM, Jacque Scott <[EMAIL PROTECTED]> wrote
regarding Updating a Record:
> I am converting from Access 2.0 to MySQL and I am
What is being logged to the *.err log in the data directory?
>> Original Message <<
On 2/24/04, 12:42:19 PM, Dale Goolcharan <[EMAIL PROTECTED]> wrote
regarding Fresh/New install of MySql 4.1 :
> Hi,
>I am currently running mysql4.0 and I will like to upgrad
Would creating a merge table be a solution for you?
>> Original Message <<
On 2/24/04, 11:04:53 AM, Lorderon <[EMAIL PROTECTED]> wrote regarding
Union EXACT Tables:
> Hello All,
> Is there a way to make concat 2 tables together without using UNION ?
> The table
You could try creating a function in Java or C/C++ or whatever your
preference is that wraps the select statements up for you and returns the
insert ID.
>> Original Message <<
On 2/24/04, 11:02:51 AM, David Scott <[EMAIL PROTECTED]> wrote regarding
INSERT return
Are you logging slow queries? Have you run an explain plan for the
queries in question?
>> Original Message <<
On 2/24/04, 10:29:33 AM, Bill Marrs <[EMAIL PROTECTED]> wrote regarding
disabling optimizations to identify slow queries:
> I've found a performance i
My confusion, I thought that was what you were asking for.
>> Original Message <<
On 2/18/04, 10:01:24 AM, Martijn Tonies <[EMAIL PROTECTED]> wrote
regarding Re: Possible values in "COMMAND" for SHOW PROCESSLIST:
> Hi,
> Are you sure about this? According to
>
Do you fail with a user who has a password?
>> Original Message <<
On 2/17/04, 3:11:44 PM, Cira Account <[EMAIL PROTECTED]> wrote regarding Can't
connect using C API:
> I apologize if the listings below are badly
> formatted. I am posting this from a webmail cl
Checking table
Closing tables
connect out
Copying to tmp table on disk
Creating tmp table
Deleting tmp table
Deleting from main table
Deleting from reference tables
Flushing tables
Killed
Sending data
Sorting for group
Sorting for order
Opening tables
Removing duplicates
Reopen table
Repair
Here are the instructions for doing a stack trace.
http://www.mysql.com/doc/en/Using_stack_trace.html
>> Original Message <<
On 2/13/04, 2:24:30 PM, Jacob Friis Larsen "(Eksperten" "admin)"
<[EMAIL PROTECTED]> wrote regarding Re: MySQL 4.0 crashed; Please help:
Would you mind posting your cnf. This may be a syntactical error.
>> Original Message <<
On 2/13/04, 2:08:40 PM, <[EMAIL PROTECTED]> wrote regarding RE: FW:
Installation issue on SuSE 9.0 Pro box:
> Yes, there are spaces/tabs before and after the equal sign.
Just a guess but do you any space between the key and value?
innodb_data_home_dir = /var/data/mysql
Original Message dated 2/13/04, 1:21:26 PM
Author: <[EMAIL PROTECTED]>
Re: FW: Installation issue on SuSE 9.0 Pro box:
I was curious if anyone has experienced this same error and even more
curiou
Did you perform a stack trace?
>> Original Message <<
On 2/13/04, 2:36:42 AM, Jacob Friis Larsen "[Eksperten" "admin]"
<[EMAIL PROTECTED]> wrote regarding MySQL 4.0 crashed; Please help:
> Can someone help me find out what caused this crash?
> My system is a Red
Was the update peformed in either the WITCD or WITTD database?
>> Original Message <<
On 2/12/04, 9:52:57 AM, Liying Huang <[EMAIL PROTECTED]> wrote
regarding Re; Re: question for replication:
> Show slave status:
> *** 1. row *
What is the output from show slave status?
>> Original Message <<
On 2/12/04, 8:43:44 AM, Liying Huang <[EMAIL PROTECTED]> wrote
regarding question for replication:
> Hi,
> I tried to do replication from master-> slave, I used windows,
> MySql 4.0.17 version on
What message is being logged to the error log?
>> Original Message <<
On 2/12/04, 8:32:20 AM, Greg G <[EMAIL PROTECTED]> wrote regarding Second
mysqld fails...:
> This is strange. I've tried to set up a second mysqld to run, but it
> fails. Well, fails isn't q
These files will be created in the /tmp directory or where ever your temp
directory was declared. One temp table will be created for each ALTER or
CREATE INDEX statement.
>> Original Message <<
On 2/11/04, 5:42:31 PM, Chris Fossenier <[EMAIL PROTECTED]> wrote
re
If I am reading your parameter correctly, MySQL will limit the size of
the temporary file created to 30GB. If the file exceeds this limit, then
MySQL will use key cache to create the index. What is the footprint of
your MYD and MYI files?
>> Original Message <<
Can you connect from the command line as this user from this host?
Have you tried using a different user?
Can you ping the target host from the source host?
>> Original Message <<
On 2/11/04, 3:25:49 PM, Adam Staunton <[EMAIL PROTECTED]> wrote
regarding RE: mySQL
Performing your indexing in one batch will create a temp table only once
as opposed to n-times.
What is the current value of your myisam_max_sort_file_size?
>> Original Message <<
On 2/11/04, 2:53:34 PM, Chris Fossenier <[EMAIL PROTECTED]> wrote
regarding RE: Ind
Have the grant tables been set up to allow this user access from this
host?
Do a show grants for this user.
>> Original Message <<
On 2/10/04, 5:52:11 PM, Adam Staunton <[EMAIL PROTECTED]> wrote
regarding mySQL and odbc:
> Hi all,
> I am getting the following
Yes a duplicate copy of the table is created and the Indexes are created
on that new table, the original table is dropped and the new table is
renamed. What type of data is being indexed? Are you attempting to index
while the database is being actively used? What version of MySQL are you
using?
This is Ascii 241 and should display fine in your MySQL monitor.
SELECT CHAR(241) displays correctly for me. How are you inserting this
character into the database?
>> Original Message <<
On 2/11/04, 11:20:30 AM, Julien Martin <[EMAIL PROTECTED]> wrote
regarding
You could create a User defined Function that contains this logic. At the
present time, an UDF needs to be coded in C.
Depending on how your `users` interface with the application, you could
write a C/C++ or java command line interface as well.
>> Original Message <<<
One way is to expose the port that MySQL is running on via the firewall.
Another option could be to run ssh on the target MySQL machine and
forward the MySQL ports giving you a secure connection.
>> Original Message <<
On 2/9/04, 6:41:19 AM, Carlos J Souza <[EMAI
Datanamic is not free but very affordable and a nice utility. Windows
only though...
>> Original Message <<
On 2/6/04, 1:22:55 PM, David Perron <[EMAIL PROTECTED]> wrote regarding
Erwin from sql script:
> I have a sql file that I would like to convert to an ER
You should be handling the timeout connection in your code. You will be
looking for a SQLState of `08S01`. Once you have captured this your can
attempt to reconnect to the database.
>> Original Message <<
On 2/5/04, 4:21:36 PM, dan orlic <[EMAIL PROTECTED]> wrote
What version is the MySQL client? Is the user logging on remotely?
>> Original Message <<
On 2/5/04, 4:22:37 PM, Michael Satterwhite <[EMAIL PROTECTED]> wrote
regarding Re: Bad handshake:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> On Thursday 05 Februa
The short answer is `yes`. Your fields should match the data that they
will hold. It sounds like the creator is accustomed to using tools such
as MS Access where the `Text` field is a common catch all datatype.
>> Original Message <<
On 2/5/04, 3:45:57 PM, Adam
What about if the user enters
mysql -u -p
>> Original Message <<
On 2/5/04, 2:22:29 PM, Michael Satterwhite <[EMAIL PROTECTED]> wrote
regarding Re: Bad handshake:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> On Thursday 05 February 2004 14:14, [EMAIL PR
Was the user created under MySQL 4.1 or a previous version? How are you
connecting? MySQL monitor, ODBC, JDBC, etc. ?
>> Original Message <<
On 2/5/04, 1:40:20 PM, Michael Satterwhite <[EMAIL PROTECTED]> wrote
regarding Bad handshake:
> -BEGIN PGP SIGNED ME
Can you ping the master from the slave?
What do you have in the master.info file?
>> Original Message <<
On 2/5/04, 12:19:29 PM, <[EMAIL PROTECTED]> wrote regarding Re: replication:
slave returns a 1236 error_code.:
> Since you asked ..
> here is the my.cnf
Not sure if you mistype but the file is called my.cnf not my.cfg
>> Original Message <<
On 2/5/04, 11:31:43 AM, dan orlic <[EMAIL PROTECTED]> wrote regarding
issue with my.cfg:
> i have an issue with my.cfg. I am trying to change the value of
> wait_timeout.
Try using the actual MySQL dump command
mysqldump --B --tables -u --opt -p -h |
mysql -u -p -h
>> Original Message <<
On 2/5/04, 10:46:21 AM, UpFront Technology <[EMAIL PROTECTED]>
wrote regarding migrating mysql database:
> Hello,
> I am trying to copy
Is the server Id for your slave setup? What does the my.cnf for the slave
look like?
>> Original Message <<
On 2/5/04, 10:17:11 AM, <[EMAIL PROTECTED]> wrote regarding replication:
slave returns a 1236 error_code.:
> Hallo,
> I am having trouble setting up rep
This is mentioned in the create table section:
http://www.mysql.com/doc/en/CREATE_TABLE.html
>> Original Message <<
On 2/5/04, 1:58:43 AM, Karam Chand <[EMAIL PROTECTED]> wrote
regarding Result returned by "show index from"...:
> Hello
> I am executing show ind
Is the MyODBC driver installed on the Webserver? Without it, you will
still encounter this error message.
>> Original Message <<
On 2/5/04, 9:05:51 AM, Gilbert Wu <[EMAIL PROTECTED]> wrote
regarding RE: Need DSN less help:
> Try something similar to this:
> Co
You have attempted to login with out supplying a username. Try logging in
like:
mysql -u -p
>> Original Message <<
On 2/5/04, 8:38:13 AM, Arunachalam <[EMAIL PROTECTED]> wrote regarding
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES):
> Hi all
Have you run a check/analyze on the table in question? The table will
need to be repaired before you proceed.
>> Original Message <<
On 2/4/04, 11:11:12 PM, Devios McShady <[EMAIL PROTECTED]> wrote regarding
index failing on large database - any ideas why?:
> I
Try setting the basedir=
parameter in your my.cnf file.
>> Original Message <<
On 2/4/04, 3:32:26 PM, Michael Satterwhite <[EMAIL PROTECTED]> wrote
regarding Starting MySQL 4.1:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> I've reinstalled MySQL 4.1. I'm
All logging will grow very rapidly on a `busy` server. To enable all
logging you can add the --log option to the safe_mysqld command.
safe_mysqld --log
>> Original Message <<
On 2/4/04, 3:48:46 PM, Daniel Powell <[EMAIL PROTECTED]> wrote
regarding Re: Mysql ECHI
If the server is up and running can you log in a perform a
show variales from the mysql monitor. From this information you can learn
where your logs are being stored.
...
Also, what sort of logging are you currently performing? Are you logging
just errors , slow queries or everything?
...
A locate *.err returns nothing?
What happens when you attempt to start MySQL with safe_mysqld?
>> Original Message <<
On 2/4/04, 3:04:54 PM, Daniel Powell <[EMAIL PROTECTED]> wrote
regarding Re: Mysql ECHILD resets on Queries:
> nothing of the sort. no .err file
The hostname.err log will generally be located in the data directory.
>> Original Message <<
On 2/4/04, 2:42:02 PM, Daniel Powell <[EMAIL PROTECTED]> wrote
regarding Re: Mysql ECHILD resets on Queries:
> Where exactly SHOULD these be and is it something I need t
Have you looked in the hostname.err logs for the MySQL server?
>> Original Message <<
On 2/4/04, 2:00:53 PM, Daniel Powell <[EMAIL PROTECTED]> wrote
regarding Mysql ECHILD resets on Queries:
> Ive got a machine running redhat 9 kernel 2.4.20-28.9 and a recent up
The older system is choosing to use a different index. I would suggest
running an analyze on your new tables and see if you can get the newer
system to use the same Postsindex8 index.
>> Original Message <<
On 2/4/04, 1:01:46 PM, Alan <[EMAIL PROTECTED]> wrote r
Are you able to start the MySQL server? Is there anything being logged to
the hostname.err log?
>> Original Message <<
On 2/3/04, 7:23:50 PM, "vincent.gueu" <[EMAIL PROTECTED]> wrote
regarding Mysql error message:
> I've installed mysql under Linux and what I
Did you run an ANALYZE TABLE?
>> Original Message <<
On 2/4/04, 9:33:30 AM, rmck <[EMAIL PROTECTED]> wrote regarding index
question:
> I ran an insert..select from one table to the other ( changed some column
types to int from varchar on new table).
> the inser
Limit needs to be the last line in your query
>> Original Message <<
On 2/2/04, 1:55:13 PM, Matthew Stuart <[EMAIL PROTECTED]> wrote regarding
LIMIT not working problem:
> This query is working fine apart from the LIMIT part. I can't see what
> is wrong with it,
100 matches
Mail list logo
