I'm migrating a database from 4.0.12 on Solaris to 4.0.18-0 on Red Hat
Linux. A few of the tables have a 0 (zero) in the auto_increment primary
key column. However, when importing, the 0 in the insert is translated to
the next available auto_increment value thus causing a duplicate key
situation
IP should work just fine. However, if the source webserver is behind a
firewall or otherwise NAT'd, your mysql server may see them coming from an
in between IP instead of the actual webserver. The quickest way to figure
it out is to have the webserver host try to connect and send you the error
I'm looking to use a RHEL4 server with standard RHEL4 packages to connect to
a RHEL4 MySQL 5.0 server. I was curious if anyone knows of any known
problems with a 4.1 client (the one provided with RHEL4) communicating to a
5.0 database? It connects fine, but wanted to be sure there were not any
Does anyone know a function that will return the hostname of the mysql
server you are connecting to?
Just as:
mysql select database();
returns the database you're connected to, I need to display the host I'm
connected to.
Similar to the oracle statement: select host_name from v$instance;
Subject: RE: host info
Brian,
In UNIX from mysql prompt do:
mysql system /bin/hostname
Mikhail
-Original Message-
From: Stanton, Brian [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 27, 2005 11:03 AM
To: 'mysql@lists.mysql.com'
Subject: host info
Does anyone know a function
: host info
Brian,
Have you initiated mysql command with -h host-name option or just
mysql with other options but -h?
Mikhail Berman
-Original Message-
From: Stanton, Brian [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 27, 2005 11:33 AM
To: 'mysql@lists.mysql.com'
Subject: RE: host
:[EMAIL PROTECTED]
Sent: Wednesday, April 27, 2005 2:04 PM
To: Stanton, Brian; mysql@lists.mysql.com
Subject: Re: host info
I don't know if it's possible in MySQL.
That said, in the mysql client, you can type '\s' for
'status'. Look for 'Current user' in the output
To: Stanton, Brian
Cc: 'mysql@lists.mysql.com'
Subject: RE: host info
Hi all,
Mysql server knows the OS server as localhost. the hostname you see in
status is
the OS server from which you connect (the client one), since it's defined in
the
grant.
The only method i can see is : ls datadir_path/*.pid
Use the general query log.
http://dev.mysql.com/doc/mysql/en/query-log.html
Thanks,
Brian Stanton
Systems Administrator, Belo Interactive
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 05, 2005 2:11 PM
To: mysql@lists.mysql.com
Subject:
I upgraded from MySQL 4.0.12 to MySQL 4.0.18 last night and found some
oddities this morning. Apparently some of the varchar data being input into
certain tables had carriage returns: \n in the data. This was an
accidental thing, but on 4.0.12, the \n was ignored when matching on that
record.
Thanks! I was hoping it was something that had already been found. I'll
upgrade as soon as I can.
Thanks,
Brian
-Original Message-
From: Sasha Pachev [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 10:47 PM
To: Stanton, Brian
Cc: '[EMAIL PROTECTED]'
Subject: Re: Replication
Shortly after the MySQL 4.0 line went to production, I upgraded to mysql
4.0.12. Since then my slave has been getting corrupted tables 2 to 3 times
every month. I've also seen this problem in mysql 4.0.13. When I run a
check table on the table in question it gives the following results:
: Wednesday, February 25, 2004 6:09 PM
To: Stanton, Brian
Cc: mysql (E-mail)
Subject: Re: SQL_BIG_TABLES and replication
Stanton, Brian wrote:
I'm currently running mysql 4.0.13 on red hat 7.2. The following create
table query currently requires the user to use SET SQL_BIG_TABLES=1
I'm currently running mysql 4.0.13 on red hat 7.2. The following create
table query currently requires the user to use SET SQL_BIG_TABLES=1 for the
query to go through on the master successfully. However, that doesn't seem
to get set when the slave tries to replicate the create table statement.
14 matches
Mail list logo