I am doing this to move data from one table to other and getting below
error.
How can check this particular record at this row number 921888 in dats_tem
table.
insert into reports1.dats1 select * from dats_tem;
ERROR 1292 (22007): Incorrect datetime value: '-00-00 00:00:00' for
column
On 6/26/07, Brown, Charles [EMAIL PROTECTED] wrote:
The MYSQL general query log does not include timestamp of queries that
it logs because queries are logged many many seconds before they are
executed.
Which version of MySQL are you running? I'm running 5.0.22 on my
desktop, but I'm fairly
On 3/14/07, Clyde Lewis [EMAIL PROTECTED] wrote:
System Configuration: Sun Microsystems sun4u Sun Fire E2900
System clock frequency: 150 MHZ
Memory size: 65536 Megabytes
CPU: 12 @ 1200 MHz
I'm looking for a tool that will allow us to determine the max number
of databases that can run in a
We're running mysql 4.1.20. If I understand the manual correctly, I can
change max_connections while mysqld is running without restart mysqld to
make the change take effect
Correct.
But what if mysqld restarts later in some
other situations, like machine reboot, would my (global) change on
On 3/8/07, Gary Sewell [EMAIL PROTECTED] wrote:
I'm having a problem with a single repair query seemingly taking over the
whole server. I'll try and explain….
Large table or 1.2m rows, running a repair on this causes the query queue to
grow and grow and finally max out.
The problem isn't table
On 3/11/07, Jean-Sebastien Pilon [EMAIL PROTECTED] wrote:
I am running a mysql database server and we experienced a power failure.
The mysql server does not want to restart because innodb is corrupted.
Version info:
Mysql version 4.1.11-Debian_4sarge7-log
Debian sarge
Reiserfs filesystem
What
On 3/13/07, Merlin [EMAIL PROTECTED] wrote:
I just compiled mysql4.1.22 on a suse 9.3 machine. All went fine, but
when I try to change the password I get prompted for one. So I hit
return as it is supposed to be blank, right? But it seems to be not:
/usr/local/mysql/bin # ./mysqladmin -u root
On 2/20/07, Clyde Lewis [EMAIL PROTECTED] wrote:
I'm looking to find a way to determine the number of transactions
that a particular database is processing each min/hour/day/month/year
http://dev.mysql.com/doc/refman/4.1/en/show-status.html
Would like to know what is the archive db.opt.
http://www.google.co.uk/search?q=mysql+db.optstart=0ie=utf-8oe=utf-8client=firefox-arls=org.mozilla:en-US:official
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Master_SSL_Allowed: Yes
Master_SSL_CA_File: /root/.mysql/cacert.pem
Master_SSL_CA_Path: /root/.mysql/
Master_SSL_Cert: /root/.mysql/client-cert.pem
Master_SSL_Cipher:
Master_SSL_Key: /root/.mysql/client-key.pem
I need to create an application where i will be requiring a backup server
like when one server fails i can switch automatically to the other server
hosted somewhere else , now the data needs to be consistent on both the
servers, one sol is i keep automated backups on the primary server and
On 12/4/05, Luiz Rafael Culik Guimaraes [EMAIL PROTECTED] wrote:
Dear Friends
Is their an Page with data of how much bandwidth mysql consume when using
remote servers?
mysql show status like 'Bytes_%';
+++
| Variable_name | Value |
Hi,
Our company is considering migrating some tablesfrom MyISAM to InnoDB,
as it has row-level locking and other improvements over MyISAM.
However, one of the things we do at the moment is rsync the MySQL data
directory to our development server every night over an 2Mbps ADSL
connection (as we
Nico Sabbi wrote:
[...]
There are 3 GB of logs that no one needs anymore. Since the master knows
that all
the slaves are correctly aligned up to a certain MASTER_LOG_POS, can't
it automatically remove the logs up to that position?
The problem here is that MySQL masters aren't necessarily aware of
Juan Fernandez wrote:
Hi !!
I am trying to install mysql without the server on fedora:
when I issue the command :
[EMAIL PROTECTED] snort-2.2.0]# cd ../mysql-3.23.52
[EMAIL PROTECTED] mysql-3.23.52]# ./configure --without-server
--prefix=/usr/local/mysql
everything is fine but after I issue the
Juan Fernandez wrote:
I see 3 packges:
Mod_auto_mysql-20030510-3.i386.rpm
Mysql-3.23.58-4.i386.rpm
Php-mysql.
Which one to pick
Thanks !!
Mysql-3.23.58-4.i386.rpm
-- Alex
-Original Message-
From: Alex Greg [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 4:06 PM
To: Juan
Hi,
We recently moved to new servers, and also upgraded from MySQL 3.23 to
4.0.20. We have one master database server and a second identical
machine configured to replicate all databases from the master.
Previously this has worked without a hitch, but we seem to be having
some problems.
The
Michael Winston wrote:
On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote:
Michael Winston wrote:
Hi-
We've been running into a pretty serious problem for the past several
versions of mysql 4.0 running on OS X (both client and server).
Every once in a while we wake up to find the too many
Hi,
I'm noticing this error in various script of ours that run on the cron:
DBI connect('general:10.1.1.80:3306;mysql_connect_timeout=3','root',...)
failed: Can't connect to MySQL server on '10.1.1.80' (115) at
/usr/local/apache/cgi-bin/Shared/DBStuff.pm line 214
This happens on a number of our
Hi,
I have recently had a system crash that required the
installation of a new hard drive. I have access to the
files on the old hard drive, on which is a database I
need to recover.
I am running MySql 3.23.37 and all the tables in the
database to be recovered are MyISAM.
How can I
Stefan,
it depends ...
For MyISAM tables max size is limited by the maximum filesize of your
OS/Filesystem.
Following on from that, the maximum file size you can have on 32-bit Linux is 2GB,
unless your distro has LFS (Large File Support),
in which case is is much larger (terabytes, not
Having just set up a RedHat Enterprise Server V.3 I am trying to add a MySQL
database function. I tried and failed using up2date (following instructions
from RH), so downloaded the rpms and began to install by myself. My input
and the output is shown below:
# rpm -i
Having just set up a RedHat Enterprise Server V.3 I am trying to add a
MySQL database function. I tried and failed using up2date (following
instructions from RH), so downloaded the rpms and began to install by
myself. My input and the output is shown below:
# rpm -i
Alex Greg wrote:
Hi,
Our main database server is a 2 x PIII 1.2Ghz with 1.5GB RAM and a 73GB SCSI
RAID-5 made up of 3 36GB disks. It does between 300
and
1200 queries per second. The read to write ratio is about 4:1.
My problem is that we're hitting our max_connections more
Hi,
Our main database server is a 2 x PIII 1.2Ghz with 1.5GB RAM and a 73GB SCSI RAID-5
made up of 3 36GB disks. It does between 300 and
1200 queries per second. The read to write ratio is about 4:1.
My problem is that we're hitting our max_connections more and more frequently. Is it
safe to
Please how can I remove a RPM installation. I used MySQL-server-4.1.1-1.i386.rpm to
install MySQL, but how can I delete it.
rpm -e MySQL-server-4.1.1-1.i386
-- Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
this isn't an
option.
Any advice on this would be appreciated.
Alex Greg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have a select query which is selecting all records in a table (which has
around 8,000,000 rows in). time is a field of type time. Should I be using
= and = or BETWEEN to find records in a certain range? Which does MySQL
optimise for?
select time,price from csq where id = 12345 and date =
I try to grand some rights by using GRAND
You want GRANT, not GRAND.
-- Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all. I am trying to install mySql on Solaris 2.6. I am getting the
following error during 'make':
ld: fatal: library -lz: not found
ld: fatal: File processing errors. No output written to
.libs/libmysqlclient.so.10.0.0
make[2]: *** [libmysqlclient.la] Error 1
make[2]: Leaving directory
Hi.
I haven't mysql enabled in php. How may I do it? I have php 4.0.4, mysql
3.23.36, both installed on linux RH 7.3.
Install the php-mysql RPM.
-- Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hello,
I am running two instances of mysql. They both run on different boxes, not
networked.
Anyway, I have been developing on one machine, and trying to do a dump and
keep the other box updated with Database changes.
I have ran this from the dev box.
mysqldump --add-drop-table -u
Hello,
we are currently running MySQL 4.0.15 w/InnoDB tables on a RH/Linux 9.0 and
would like to upgrade. the current RPM's installed are:
MySQL-client-4.0.15-0
MySQL-embedded-4.0.15-0
MySQL-devel-4.0.15-0
MySQL-shared-compat-4.0.15-0
MySQL-shared-4.0.15-0
MySQL-server-4.0.15-0
Thx' Alex.
do the old RPM's need to be removed first before upgrading ??
You can just do:
rpm -Uvh MySQL-*
in the directory with the new RPM's in - this will overwrite the old packages
with the new ones.
-- Alex
--
MySQL General Mailing List
For list archives:
34 matches
Mail list logo