Hi Guys,
We are currently using MySQL as the backend to the RT Request Tracker
Ticketing system. The problem is that we are seeing total data loss from
the InnoDB after a proper shutdown of the database using mysqladmin
shutdown.
We have observed this once on a Sparc Enterprise 420R with 4 CPU's
Hello, I still trying to get my replication working witout success. I included show
processlist and show slave status. Can anyone make out from them what I am lacking?
I am running mysql 5.0.0 on a linux master trying to replicate them on a windows slave
Best regards
/Jonas
Hi all,
My setup is windoes 2000, Access 2000 and Mysql built from source on Debian.
Some tables can be seen but all new entries are marked #Deleted. If I
close the table in Access and re-open it, its looks fine.
Others have every field marked #Deleted and nothing I do makes those
tables
Hola, I figured it out myself, The problem was that I didnt specify any
tables. I thought that if you replicated a database the tables would be
included. That is not the case.
I added this to make it work.
Replicate_Wild_Do_Table: CellDB%.%
Regards
/Jonas
- Original Message -
From:
Hi all,
I have noticed that when I change a password using sqlyog, the password table stores
as plain text which surely can'y be right ?
Can anyone tell me what I'm doing wrong here. All the passowrds originaly were added
useing the command line client in Dos window. and when originally viewed
From: Talk21 [EMAIL PROTECTED]
I have noticed that when I change a password using sqlyog,
the password table stores as plain text which surely can'y be
right ?
Can anyone tell me what I'm doing wrong here. All the
passowrds originaly were added useing the command line
client in Dos
Ricardo Lopes [EMAIL PROTECTED] wrote:
I have to copy some records from one table into the same table is it
posible?
my sql is like this:
INSERT INTO equipamento_componentes (cod_equipamento_componentes, cod_tipo,
numero, data_colocacao, cod_componente)
SELECT '', 'C', 65, NOW(),
GROUP_CONCAT() is in 4.1. :-)
Oh, so close yet so far. We're running 4.0.14 and my company has
no plans on upgrading in the near future. *sigh*
Thanks for the info, however!!
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
hi,
I'm using mysql mysql 4.0.18-log, and I'm having trouble (i tried also
with an older 3.23.49-log and give the same).
It's running on debian 2.4.20.
I explain the case :
I've a multi-processes application, each of these process doing about that :
while (1)
{
wait some client,
while (1)
- how to autonumber rows in SQL result
I would like to put an auto numbering column in any SQL SELECT result, is it possibile?
miroslav i.
Hello,
I use MySQL 4.1 in Windows 2000 and don't get connect with MySQL
Administrator.
The message what get is:
Could not connect to the specified host.
MySQL Error Nr.1115
Unknown character set: 'utf8'
Details of the my connection:
Username: root
Password: not informed
Hostname: localhost
Thanks so much, that did the trick.
I really appreciate the mercy on a poor newbie.
Thanks again,
David
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 31, 2004 5:28 PM
To: David McBride
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re:
Miroslav I. [EMAIL PROTECTED] wrote:
- how to autonumber rows in SQL result
I would like to put an auto numbering column in any SQL SELECT result, is it
possibile?
You can use variables, for example:
mysql SELECT @id:=0;
++
| @id:=0 |
++
| 0 |
++
1 row in set
What type of connection are you using?
Linked table or you connect on demand?
Osvaldo
-Original Message-
From: Patrick Kirk [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 7:32 AM
To: Osvaldo Sommer
Subject: Re: Using Access as client all fields are marked #Deleted
Osvaldo
Hi,
If I start mysql bound to a particular address on our server, eg:
mysqld --bind-address=MY_IP_ADDRESS
and this server has 2 nics connected via 2 switches. If the first NIC or
switch fails,
can I use iptables to forward incoming mysql requests from the 2nd
(alive) nic (IP address)
so it
hi
the error mentioned in the file is...
fatal error : can not open privilege tables can not
find file : './mysql/host.frm' (errno 13)
what to do now...
regards
alqama
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
Date: Wed, 31 Mar 2004 16:03:43 -0600
To:
Errno 13 indicates a permissions error. Please check the ownership of the
data directories you're using to make sure that the mysql user group.
Dave
-Original Message-
From: muhammad alqama [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 9:46 AM
To: [EMAIL PROTECTED]; [EMAIL
hi
the error mentioned in the file is...
fatal error : can not open privilege tables can not
find file : './mysql/host.frm' (errno 13)
but in the directory /var/lib/mysql/mysql the file
host.frm exists...(/var/lib/mysql/ being the data
dir)
what to do now...
regards
alqama
Good morning,
I just upgraded to MySQL 4.1 from 4.0. The upgrade went fine but now all of my
timestamp fields are being cut off half way through the time. Example field:
2004-04-01 10:4
Can anyone provide some insight into why I have this issue and how I can resolve it?
Thanks!
- - - - - - -
David McBride [EMAIL PROTECTED] writes:
Thanks so much, that did the trick.
I really appreciate the mercy on a poor newbie.
David,
You're quite welcome. Now if I could find an employer willing
to pay me for utilizing the 23 years of knowledge I used to provide
such a solution :)
hello
the directory /var/lib/mysql/mysql (datadir) has
read/write permissions for user mysql and for root
group
drwx-- 2 mysql root...
but the file /var/lib/mysql/mysql/host.frm (as well
as all the files in dir .../mysql/mysql) has
permissions only for root
-wr-wr- 1 root root
The following .asp code sinppet gives error.
Dim rs
Set rs = Server.CreateObject(ADODB.Recordset)
rs.Open printjob,objConn, adOpenForwardOnly, adLockOptimistic , adCmdTable
rs.AddNew
rs(jobid) = Request.Form(jobno)
rs(closesize) = Request.Form(closize)
All the files in the mysql directory should be owned by the mysql user, so
yes, you should change all of them.
Michael
muhammad alqama wrote:
hello
the directory /var/lib/mysql/mysql (datadir) has
read/write permissions for user mysql and for root
group
drwx-- 2 mysql root...
but
Is there any way to see what date a record was changed on? I am building a
database of mostly imported CSV files. The files would be imported on the
day they were created and would not have a date field in them. May hope
would be to have a field in the database that would show the date the
Can you add a timestamp field in your table? This field will be updated upon
insertion and updates.
On Thu, 01 Apr 2004, Jeff Cook wrote: Is there any way
to see what date a record was changed on? I am building a database of mostly
imported CSV files. The files would be imported on the day
Hi All,
has anyone seen this error message before
040331 0:26:00 ft_read_next: Got error 127 when reading table ./
040331 0:26:38 ft_read_next: Got error 127 when reading table ./
040401 0:23:10 ft_read_first: Got error 127 when reading table ./
040401 0:23:19 ft_read_next: Got error
hello
it is now running ..
thank everyone who helped me ... many many thanks
regards
alqama
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
Date: Thu, 01 Apr 2004 12:13:43 -0500
To: muhammad alqama [EMAIL PROTECTED]
Subject: Re: starting mysql daemon
I am looking at the syntax for creating table( section 6.5.3 of the manual):
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)]
[table_options] [select_statement]
and:
create_definition:
part-1 (- inserted by me for reference)
col_name type [NOT NULL | NULL]
It would really help if you could tell us at least which version of MySQL
you are using. It might also help to know which OS you are using and what
command you issued to get this error message.
Rhino
- Original Message -
From: Jason Chuong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Dear Sir/Madam,
I am looking for a manual for MySQL Control Centre, so that I may supply
it to the students I teach. Do you have such an items or can offer any
assistance.
This I hope will assistance the students in their learning for a Module
called Internet Programming, for which we use MySQL
- Original Message -
From: Khashan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 1:04 PM
Subject: Create Table Syntax
I am looking at the syntax for creating table( section 6.5.3 of the
manual):
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
I didn't found hostname.pid file.
SOS SOS
--- J.R. Bullington [EMAIL PROTECTED] wrote:
The next step is to shutdown mysqld, delete the
mysql and temp tables from
your /data/ folder, and then re-run the
scripts/mysql_install_db. That will
reinstall the mysql/hosts.frm, which will basically
- Original Message -
From: muhammad alqama [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 10:49 PM
Subject: Re: starting mysql daemon
hi
the error mentioned in the file is...
fatal error : can not open privilege tables can not
find file :
I am using mysql 4.0.16.
Is it possible to put a calculation of two other columns as the default
value for a third column?
Like:
time = decimal 3,2
rate = decimal 3,2
totals = default is time * rate
Thanks,
-Mike
--
MySQL General Mailing List
For list archives:
We are considering porting mySQL to vxWorks. Can anybody offer some
advice or references ? May be somebody has done this already.
The intention is to use a trimmed down version of mySQL with HEAP
tables. Only a very basic set of features would be used. ODBC is a
requirement.
I'd appreciate
What is the connection type ? ODBC ?
-Ursprüngliche Nachricht-
Von: Shrikrishna Sathe [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 31. März 2004 12:53
An: [EMAIL PROTECTED]
Betreff: DB Connection
The following .asp code sinppet gives error.
Dim rs
Set rs =
Hi. This is the qmail-send program at lists.mysql.com.
I'm afraid I wasn't able to deliver your message to the following
addresses.
This is a permanent error; I've given up. Sorry it didn't work out.
[EMAIL PROTECTED]:
Sorry, no mailbox here by that name. (#5.1.1)
--- Below this line is a copy
Right. You're grouping by user_id and throwing in title, and you're hoping
to influence which of the titles is chosen to go with user_id, but as title
is neither part of your group nor part of an aggregate function, its value
is undefined. See the manual for an explanation
Hello,
Through some strange quirk in my MySQL console application (an older version of
PHPMyAdmin), 4 indexes that I created on different columns of a table all resulted in
indexes with the same keyname, that of the first column that was indexed. The field
of each index is correct, just the
Thanks for the reply.
It seems like the syntax for create_table/create_definition
should have 2 part-2 modifiers
1- one part-2 'column' modifiers for the each column.
and
2- another part-2 table modifiers for the table as a whole ?
( at the end of column definitions).
two questions:
-- Are
Hi list, I'm having the following problem when I tried to connect to MySQL
server through terminal mysql client it displayed Can't create thread errno
(11) , I worked around the variables thread_stack and thread_cache_size,
its initial value was 64KB for thread_stack and 20 for
When this happens are you able to ping the MySQL server? The literal error
message is Resource temporarily unavailable
Have you looked in the hostname.err file to see if anything else is being
logged?
On Thu, 01 Apr 2004, Mikel - wrote: Hi list, I'm having
the following problem when I tried
Hi All,
I was wondering if there was a way in mySQL wherein I tell the
autoincrement spec where to start from?
Eg. Autoincrement startfrom 1
And the values go in as:
10001..10002 and so on,.. instead of 1..2..3..
..like sequencing in oracle
Any help is appreciated,
Thanks
Amit Wadhwa
Data
Hi,
I'm getting output like
select a.hostid,a.hdesc,b.ipadd1,c.make,c.model,d.name,d.version from host
a,ipdet_temp1 b,makemodel c,software d,hsdet e
- where a.hostid=b.hostname2 and a.makemodel=c.makemodelid and a.hostid=e.host_id
and e.software_id=d.softwareid and
similar-ish to setting your sequence in oracle
try this:
The create table statement below will start the auto increment at 1
CREATE TABLE TableX (
X_primary_key INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
X_col1 VARCHAR(20) NOT NULL,
X_col2 VARCHAR(40) NOT NULL,
X_col3 VARCHAR(10) NOT
No, we did not run out of disk space, we had 102GB free using reiserfs
partition.
We are running all the defaults for transactions, so we have REPEATABLE-READ
as our tx_isolation. We should have allowed enough time for this transaction
to finish, this is in a production environment that has run
Are you just wanting to remove the header information? If so, then try
mysql --skip-column-names
On Thu, 01 Apr 2004, Seena Blace wrote:
Hi,
I'm getting output like
select a.hostid,a.hdesc,b.ipadd1,c.make,c.model,d.name,d.version from
host a,ipdet_temp1 b,makemodel c,software
Try this:
When you add an AUTO_INCREMENT column, column values are filled in with sequence
numbers for you automatically.
For MyISAM tables, you can set the first sequence number by executing SET
INSERT_ID=value before ALTER TABLE or by using the AUTO_INCREMENT=value table
option. See section
I am running mysql-standard-4.0.18-unknown-freebsd4.7-i386-linuxthreads and
I am unable to achieve more than 440 connections. I receive the common
Can't create a new thread (errno 35). If you are not out of available
memory, you can consult the manual for a possible OS-dependent bug. Now, I
have
Hi all- Here is more info on compiling mysql with icc 8 from the mysql
packagers list-
As for my attempts, I compiled successfully a couple times and the first
benchmark I did was faster than the gcc compiled server by about 10%-
unfortunately, I can't say if this is a conculsive test since the
sorry- typo- the gcc binary was 4.0.18
yonah
Yonah Russ wrote:
Hi all- Here is more info on compiling mysql with icc 8 from the mysql
packagers list-
As for my attempts, I compiled successfully a couple times and the
first benchmark I did was faster than the gcc compiled server by about
10%-
I am currently using FileMaker Pro for a relatively large database and I am
wondering how to speed it up. Would MySQL speed things up? Is FileMaker in
some way inferior to MySQL? If so, how? Would it be easy to use a FileMaker
plugin to access the MySQL database, or should I write a PHP front?
Is there anyway to get mySQL to generate a warning or other info when
it ignores a row via LOAD DATA INFILE IGNORE? I'm happy having the
duplicates ignored but ideally would like to log which records were
dupes in a place I can find them again.
--
thanks,
Hi folks. I have a problem creating a foreign key constraint which I just
don't seem to be able to figure out.
There are three tables, for which the 'show create' output is given below:
CREATE TABLE `users` (
`UserID` int(11) unsigned NOT NULL auto_increment,
`ContactID` int(10) unsigned NOT
Hello,
we are currently running MySQL version 3.23.58, and plan to upgrade to 4.0.18
via the RPM's on a RH/Linux system,... can we retain all the user privileges and
databases without loosing any data and our user privileges after the upgrade...
we do have backups of all the databases.
Is
Victor
I want output like
noname amt
1 10
20
instead of below
noname amt
1 10
1 20
thx
Victor Pendleton
Hi,
Need a SQL/Design help.
I have a table as follows:
ORDER_HISTORY
--
ORDER_ID | ORDER_NAME | ORDER_AMOUNT | ORDER_DATE
--
10 | Order 1| 20.00| 10-Jan-2003
11 | Order 2| 200.00 |
Can MySQL actually produce result sets like the ones Seena wants? In DB2,
which I know a lot better than MySQL, DB2 doesn't produce such a result set
by itself; you use a program like QMF to suppress the duplicate information
on the rows and replace them with blanks.
Is there an equivalent
I can't suggest a complete solution but I think the answer is going to start
with the week() function. See
http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1403.
You're lucky; figuring out which week a date belongs to was something I had
to do in DB2 a few years back. The user was on
I saw somebody has MySQL statement this way:
StringBuffer sql = new StringBuffer(512);
sql.append(SELECT ThreadID, ForumID,
MemberName, LastPostMemberName, ThreadTopic,
ThreadBody);
sql.append( FROM + TABLE_NAME);
sql.append( ORDER BY + sort + + order);
Hi,
I guess this is for a java.sql.PreparedStatement as the '?'
seem to indicate that.
LIMIT limits ;-) the number of rows retrieved,
i.e. LIMIT 10, 20 gives you 20 rows starting at row 20 in the
resultset and LIMIT 10 gives you the first 10 rows.
See: http://www.mysql.com/doc/en/SELECT.html
Mike Blezien [EMAIL PROTECTED] wrote:
Hello,
we are currently running MySQL version 3.23.58, and plan to upgrade to 4.0.18
via the RPM's on a RH/Linux system,... can we retain all the user privileges and
databases without loosing any data and our user privileges after the upgrade...
we
Here is the file.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I recently just upgraded to MySQL 4.0.18. I still have a few questions about
the new query-cache. Since I am new to the query-cache, I really hope
someone has some answers.
The documentation says:
The FLUSH TABLES statement also flushes the query cache.
What does that mean exactly? Does it mean
64 matches
Mail list logo