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 Blocking
INSERT/UPDATE on SLAVE
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 this would happen.
This means that I
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 had a mysql instance. The
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 Message
On
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 booted and now my slave can't execute
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 the list of IN()
clause
is the
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 fulltext index, the fulltext index
becomes
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
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
aren't any duplicates in the database.
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 can't connect to mysql.sock error. I
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 get to run properly - Checked by
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
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. We are planning to move to MySQL.Please
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:
When updating a table with a
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 mysql with the following results:
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 regarding MS
Access and MySql:
Greeting
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 Access and MySql:
I am using ODBC
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
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 import a file to the database
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`,
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 testdb WHERE col1 LIKE '%'
The above
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
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 dcir el por que sucede esto
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 table through code in my DB. I can
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 have two of them running at the same
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:15 AM, charles kline [EMAIL
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:05 PM, Bernd Jagla [EMAIL
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 under Red Hat 9.
I've defined a
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, Bernd Jagla [EMAIL PROTECTED] wrote
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
On 3/2/04, 1:29:59 PM, Mark
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] wrote regarding Re:
no one can log
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 ?
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:04:37 PM, Bernd Jagla [EMAIL
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 regarding Re:
no one can log on any more:
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 regarding Re:
no one can log on any more:
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 want to sum a column from several tables
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 last night were taking just 2 seconds are
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
they run a select * on a table in that
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 database. I
can't find a discussion
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] wrote regarding
Minimum privileges required
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 machine...
-Original Message-
From:
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 regarding Re:
Minimum privileges required
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:
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] wrote regarding Re: Query
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
datatype longblob. What I am trying to do is
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
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 I am new to mySQL, and PHP. I
am
used to
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 following:
Create Index Index1 on Table1
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 fair
percentage
of maintenance etc
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 actually a bug in 4.0.17.
Upgrading to
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 results then divide by :
Good
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 issue with a series of mysql queries
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 returning ID:
Hi list peeps
In many
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 tables are EXACTLY SAME, but they sit on 2
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 upgrade to 4.1 to
support unicode for
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 going through all of
my code to make
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 previously asked this question and saved the
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
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 client
and it has very short line
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
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 Hat 7.3 on a HP Netserver LC2000, dual
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
curious
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.
One interesting thing is that I
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:
[EMAIL PROTECTED] wrote:
Did you
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 quite the right word, it simply exits
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 both. I have set bin-log option
in
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 ***
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 Basic problem with character sets:
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
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 error. I'm pretty sure that I've set
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: Indexing Woes:
I have checked
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 and odbc:
Using phpmyadmin I have
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
On 2/11/04, 4:54:21 PM, Chris
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
regarding RE: Indexing Woes:
None of
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 [EMAIL PROTECTED] wrote
regarding Remote
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
On 2/9/04, 10:53:00 AM, Mike
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 diagram - any
suggestions on a tool
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 have a database with one 17GB table
You have attempted to login with out supplying a username. Try logging in
like:
mysql -uusername -ppassword
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,
Is any one met
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:
ConStr = Provider=MSDASQL;DRIVER=MYSQL
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 index from tablename to get index
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 replication. After sorting out most
Try using the actual MySQL dump command
mysqldump --Bdatabase --tablesoptional -uusername --opt -ppassword -hhost |
mysql -uusername -ppassword -hhost
Original Message
On 2/5/04, 10:46:21 AM, UpFront Technology [EMAIL PROTECTED]
wrote regarding migrating mysql database:
Hello,
I
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. it's default value is
28800., my
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 from the slave:
I Think it is ok:
In
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 MESSAGE-
Hash: SHA1
OK, I've got
What about if the user enters
mysql -uusername -ppassword
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 PROTECTED] wrote:
Was
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 Staunton [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 February 2004 14:31, [EMAIL PROTECTED] wrote:
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 regarding
maintaining connects to
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 insert went fine.
mysql INSERT INTO
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 do, I always have this
number of error
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 regarding index change
moving files
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 update
from APT seems to have destroyed
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 to enable in
my.cnf
the generic
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 files on the machine nothing named
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?
...
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 ECHILD resets on Queries:
its pretty
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 trying to start the server
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, I have tried it in different places
100 matches
Mail list logo