--datadir=/var/lib/mysql_3306
--tmpdir=/tmp
--user=mysql
I found the Bug #29327 dated 2007 but without fix.
I use mysqld_multi log file version 2.16 and MySQL 5.6.24 on CentOS 6.
Someone as an idea please? Where is my mistake?
Regards,
Thomas
Am Freitag, 29. April 2016, 14:49:57 schrieb william drescher:
> On 4/28/2016 5:20 PM, Thomas wrote:
> > Hi,
> >
> > I have setup an master slave replication.
> > This works fine.
> > I have running an Apache webserver and some other programms accessing the
&
they write to the slave or do I have to change
something before in the mysql slave configuration?
thanks
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
?
Thanks a lot for your ideas!
Best,
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Got It; Thank You, Thank You, Thank You
On 4/1/2011 11:28 PM, Claudio Nanni wrote:
Hi Thomas,
Did you run the post install script?
http://kae.li/iiikj
Claudio
On Apr 2, 2011 2:20 AM, Thomas Dineen tdin...@ix.netcom.com
mailto:tdin...@ix.netcom.com wrote:
Gentlemen:
- Keep in mind that I have approximately 50 hours into this Mysql
server install and still no
results!
- Regarding the Sun Freeware package mysql-5.0.67-sol10-x86-local.gz
- When installed and started with the following command:
/usr/local/mysql/bin/mysqld_safe --user=mysql
The
is the proper location (Full path please) for host.frm
3) It would be easier to debug this if your error messages included the
full path!
not something like ./ which provides no help in identifing where a file
is required.
Thomas Dineen
110331 18:40:10 mysqld started
110331 18:40:10 [Warning] option
Simple - brilliant. I've modified to cat a temporary script...
1) cat the file as suggested:
cat ~/payload/scripts/create_mysqldb.sql EOF
###---
### Display the current user
###---
create database puppet;
###---
### Display all default accounts
###---
USE puppet;
###---
### Remove
file_with_allsql_you_need.sql
or
cat file_file_with_allsql_you_need.sql | mysql -u root -hlocalhost
and you are done.
On Tue, Jul 27, 2010 at 3:56 PM, Todd E Thomas
todd_...@ssiresults.com mailto:todd_...@ssiresults.com wrote:
I'm looking for automation direction...
I've found many packages that sit on top
. Variable expansion is the problem. For now all
of my other scripts substitute $PASSWD_PRIV_ROOT (from my
1_GLOBAL_ENV.sh) for the actual password. The *.sql scripts do not.
If anyone can shed some light on this I would appreciate the help.
--
Thanks for the assist,
Todd E Thomas
C: 515.778.6913
It's
would greatly
appreciate any pointers in the right direction. Bash is comfortable for
me and perl is within reach. I'm not much versed in anything else right now.
--
Thanks for the assist,
Todd E Thomas
It's a frail music knits the world together.
-Robert Dana
--
MySQL General Mailing List
On Sat, 19 Sep 2009, b wrote:
I'm trying to select all members who have not registered for an event. I
have tables 'members', 'events', and 'events_members', the latter a join
table with event_id and member_id columns.
The closest I've gotten is with this query:
SELECT m.id, m.first_name,
I suffered the same problem, and the following worked for me:
http://www.andy.name.my/2009/03/cannot-create-windows-service-for-mysqlerror0/
Try looking in Control Panel-Administrative Tools- Services and deleting
all the MySQL services.
Hi Tim,
We use LVM snapshots all the time. They are essentially
instantaneous with our 90GB innodb database files.
A command to generate the snapshot could be:
sudo /usr/sbin/lvcreate --snapshot --name mysqlsqlbackup --size 15G /
dev/system/data01
Please let me know if you have any
On Tue, 16 Jun 2009, Thomas Spahni wrote:
Hi
I have MySQL 5.0.64 compiled from source. When I run myisamchk on any
table I get the following warnings:
Warning: option 'key_buffer_size': unsigned value 18446744073709551615
adjusted to 4294963200
Warning: option 'read_buffer_size': unsigned
On Wed, 17 Jun 2009, Johan De Meersman wrote:
Aren't those options defined in megabytes ?
On Tue, Jun 16, 2009 at 4:59 PM, Thomas Spahni t...@lawbiz.ch wrote:
Hi
I have MySQL 5.0.64 compiled from source. When I run myisamchk
on any
table I get the following warnings
read_buffer_size=2097152
write_buffer_size=2097152
What's wrong here?
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi Mike,
The way we do it is installing each mysql instance from a
precompiled binary.
So if you had an 8 core box, and you wanted to use each of the 8
cores, you could install a mysql binary installation and then make 7
copies of it. We use an internal naming convention like the
Hi Scott
You may use the script below to reload replication if you can ensure that
the master db doesn't change during the dump operation. Otherwise you may
set a lock on the master manually.
Regards, Thomas
#!/bin/bash
#
# replicate-reload
#
# This is free software. There is no warranty
larger MAC addresses eventually.
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
the crcval column.
From my understanding, a TRIGGER might do exactly what Thunder needs.
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
Ciao,
Thomas Pundt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
file? Will
this improve results for users?
Any insight is welcome.
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
José I. Merino schrieb:
The main question is:
Will Oracle permits a cheaper DB in his portfolio with almost the same
reliability than his main and expensive DB?
It already has, it's called Oracle Express Edition.
Ciao,
Thomas
--
MySQL General Mailing List
For list archives: http
/refman/5.0/en/join.html,
Join Processing Changes in MySQL 5.0.12.
Best to avoid this issue is to not mix implicit and
explicit joins, as Gerald pointed out.
Ciao,
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On Wed, 8 Apr 2009, Pete Wilson wrote:
Hi everyone --
I'm a MySQL noob. I have MySQL queries in my C code and I was surprised
to find I'm getting a success return from:
mysql_query(pmysql, select * from usrs where(usr=\illegal name\);
In this table called usrs, usr is the primary key and
Hi
How can I specify 'unprintable' characters is a MySQL regexp ?
Query is (example only):
SELECT something FROM table WHERE column REGEXP 'Ã\\xA0';
I'm looking for an equivalent of the search part of a sed expression like
this:
s/Ã\xA0/à/g
which means I want to include a character with
information in many cases.
Cheers
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Mon, 9 Mar 2009, Sven wrote:
Hi folks
I am searching for a generic command to monitor that MySQL instance is
up and running. I don't have any know-how about the schema of the DB.
kind regards
Sven Aluoor
Hi
What about 'mysqladmin ping' ?
Regards,
Thomas Spahni
--
MySQL General Mailing
to the replication user password on SLAVE and
has no access to MASTER (otherwise mysql -h MASTER -e SHOW MASTER
STATUS, would do the trick).
Any other way to make the SLAVE tell me what is's replicating?
TIA
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
that the cache is not used to answer the query.
You may use RESET QUERY CACHE to remove all queries from the cache and
then your next query should be slow again. Same effect if you change
the table, because this makes all cached queries invalid. But why do you
want to do this?
Regards,
Thomas
replication including a
failover solution (e.g. heartbeat).
You could in general do something similar with your webserver and other
systems.
Ciao,
Thomas
--
Thomas Pundt [EMAIL PROTECTED] http://rp-online.de/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
would be: double rows. UNION
eliminates those; if you need them, use UNION ALL. Just a guess though...
Ciao,
Thomas
--
Thomas Pundt [EMAIL PROTECTED] http://rp-online.de/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hi,
I am pretty new in optimizing tables with index and may need some help.
This is my query:
EXPLAIN SELECT timestamp
FROM Meting_INT_COPY
WHERE blockid = '200811252000'
ORDER BY timestamp DESC
LIMIT 1
If I have an index(blockid),
EXPLAIN will return the following information:
type
, Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to save the text to the table in the database, I get the error,
#HY000Got error 139 from storage engine. Does anyone know what this is and
how to fix it?
prompt perror 139
MySQL error code 139: Too big row
Seems you are exceeding some limit.
Regards,
Thomas
--
MySQL General Mailing List
columns (D, E, F) from table_2 if the columns don¹t exist in
| Table_1.
select a, b, c, null as d, null as e, null as f
from table_1
union
select a, b, c, d, e, f
from table_2
should do it.
Ciao,
Thomas
--
Thomas Pundt [EMAIL PROTECTED] http://rp-online.de/
--
MySQL General Mailing
)
mysql
Ciao,
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi list
I don't understand what happen in mysql 4.1.22 ! ! ! ! ! (the same in
version 5.0)
-bash-3.00$ mysql -e show variables like 'wait_timeout%'
+---+---+
| Variable_name | Value |
+---+---+
| wait_timeout | *30*|
+---+---+
-bash-3.00$
hi list,
how can I rename a database with full innodb tables ?
The version is 4.1
Thnaks all
Hi all,
I want to know the main differences between mysql 5.0.41 and MySQL
5.0.51a(last GA release)
I read this page :
http://dev.mysql.com/doc/refman/5.0/en/mysql-nutshell.html but there is
nothing about the developments made by such update...
thnaks all...
Hi.
I've got mySQL 4.1.22 installed from sources on Linux
---
./configure --prefix=/usr/local/mysql
and PHP 4.4.2 installed from sources
---
./configure --prefix=/usr/local/php --with-mysql=/usr/local/mysql
I want to upgrade mySQL from 4.1.22 to 5.0.5 by doing:
1) export DB
Hi all,
how mysql manage the query_cache TimeToLive (live) and how can I change it ?
Thanks
Hi.
I've installed 'mytop' on my Linux server and would like to log the
data provided in order to store it for future situations.
Does anybody know how to perform it? Thank you very much,
--Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Hi.
I've been finding some queries by using 'mytop' which takes +200
seconds to be executed. It wastes tons of CPU resources on my server
and would like to detect them automatically and kill them.
Does anybody have experience with this issue? Thank you very much,
--Thomas
--
MySQL General
Hi
Using MySQL 4.1.19 on Linux, my server's CPU load is very high. I want
to cut it down but I don't know which parameters I might modify to do
it.
These are my server's data:
back log50
basedir /usr/
bdb cache size 8,388,600
bdb home/var/lib/mysql/
bdb log
Hi all,
just a simple question :
Does the query ANALYZE position reads and/or writes locks ?
I read these two pages but I didn't find the answer...
http://www.mysql.com/news-and-events/newsletter/2003-04/a000155.html
http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html
Thanks
Hi.
Using MySQL on Linux, I'd like to analyze the performance and know how
resources (memory, threads) are used during a period of time.
Do you know any tool to carry it out? Thank you very much.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
|
+---+---+
1 row in set (0.00 sec)
Can you explain me why this operation don't work ???
ie: I useed the root account...
Thanks
Thomas Raso
Hi.
Working on Linux, I've got installed MySQL 3.23.58, but I'm
experiencing some problems. For instance, I suffer too many
connections error but I cann't set 'max_connections' parameter to a
value bigger than 250.
I decided to migrate to MySQL 5.0, and I've got some questions:
- I installed
Hi Tiago. Thank you very much for your answer.
I decided to migrate to MySQL 5.0, and I've got some questions:
- I installed MySQL from sources on '/usr/local/mysql'. Is it as easy
as installing it again on '/usr/local/mysql5'?
Yep. Just change the '--prefix' com './configure' time.
ok
Make sure you use the mysqldump from version 5 and not version 3. Also
recheck all your application queries once you have restored the data the
list of changes SQL syntax might haunt you.
But can I use '/usr/local/mysql5/bin/mysqldump' to dump data of MySQL 3?
--
MySQL General Mailing List
Hi all,
on a replication architecture, with the same server, the same Mysql version
(4.1.21) and the same configuration, the same database.
I have a difference between two ibdata file size
Thanks a lot for this explanation,
yeah we are doing many massive update and insert in our databases.
--
Thomas Raso
2007/10/30, Augusto Bott [EMAIL PROTECTED]:
One possible explanation (possibly not the only one): if you do a
massive update on the master, that transaction would need
;ibdata3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdata7:500M:autoextend
The OS is Linux X 2.4.21-40.ELsmp #1 SMP Thu Feb 2 22:22:39 EST 2006
i686 i686 i386 GNU/Linux
4 x Intel(R) Xeon(R) CPU 5140 @ 2.33GHz with 4Go
is anybody has got a documentation about this...
Thanks all
Thomas Raso
There is no way whitout stopping mysql ?
for information it is a version 4.1
2007/10/29, Dan Nelson [EMAIL PROTECTED]:
In the last episode (Oct 29), Thomas Raso said:
i don't understand the size of the ibdata7
-rw-rw1 mysqlmysql2.0G Oct 29 15:18 ibdata1
-rw-rw
ok thanks,
this mysql has got a replication slave...
On the slave the ibdata has got a size close to 15Go (ie the master's size
is 22Go)
have you got an idea about this ???
thanks
2007/10/29, Dan Nelson [EMAIL PROTECTED]:
In the last episode (Oct 29), Thomas Raso said:
2007/10/29, Dan
Hi.
I'm suffering a severe slowness of my server (mySQL 3.23), and want to
detect Slow Queries.
I installed mySQL on '/usr/local/mysql', and works ok. But if I insert
this line into '/etc/my.cnf':
-
log-slow-queries = /usr/local/mysql/log/slow-queries.log
long_query_time = 5
-
it won't
I also tried with:
---
set-variable=long_query_time=5
--
mySQL starts ok, but all queries within the file are:
# Query_time: 0 Lock_time: 0 Rows_sent: 119 Rows_examined: 238
The aren't slow queries, are they?
On 10/4/07, thomas Armstrong [EMAIL PROTECTED] wrote:
Hi.
I'm suffering
] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 20
This is not a slow query, is it?
On 10/4/07, Jørn Dahl-Stamnes [EMAIL PROTECTED] wrote:
On Thursday 04 October 2007 14:06, thomas Armstrong wrote:
Hi.
I'm suffering a severe slowness of my server (mySQL 3.23
Hi.
Using mySQL 4.1.22, I'd like to carry out an SQL query to find a
string containing acute vowels.
mytable:
- item1:
--- firstname: Antonio
--- lastname: Fernández
--- comments: he's from Spain
My SQL query:
--
SELECT id FROM mytable WHERE MATCH(firstname, lastname, comments)
AGAINST
:
thomas Armstrong wrote:
If you need something more complicated, such as only ignoring (, then you
need to get more complicated. You might even need a regular expression.
I'm to browse:
http://dev.mysql.com/doc/refman/5.0/en/regexp.html
http://www.wellho.net/regex/mysql.html
You know
My ft configuration in /etc/my.conf:
--
ft_min_word_len=1
ft_stopword_file=''
-
On 9/21/07, thomas Armstrong [EMAIL PROTECTED] wrote:
Hi.
Using mySQL 4.1.22, I'd like to carry out an SQL query to find a
string containing acute vowels.
mytable:
- item1:
--- firstname: Antonio
Hi Edward. Thank you very much for your answer.
I tried adding these two lines after DB connection (PHP code):
---
mysql_query (SET NAMES utf8;);
mysql_query (SET CHARACTER_SET utf8;);
--
but it won't work :(
The solution you provided could be right because it works, but I don't
dare to
/19/07, thomas Armstrong [EMAIL PROTECTED] wrote:
Hi.
I've got this table in mySQL:
item 1:
-- firstname: John (Johnie)
-- phone: 555-600-200
item 2:
-- firstname: Peter
-- phone: 555-300-400
I created this SQL query to find 'johnie':
SELECT
Thank you Chris for your answer.
On 9/19/07, Chris Sansom [EMAIL PROTECTED] wrote:
Well I'm hardly the world's greatest expert, but I'm curious as to
why you're always separating '%' from 'johnie' with a space, because
that way it will only find Johnie if he has a space before or after
him
Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-Original Message-
From: thomas Armstrong [mailto:[EMAIL PROTECTED]
Sent: Wednesday
Hi.
I've got this table in mySQL:
item 1:
-- firstname: John (Johnie)
-- phone: 555-600-200
item 2:
-- firstname: Peter
-- phone: 555-300-400
I created this SQL query to find 'johnie':
SELECT friends.id FROM friends WHERE ((friends.firstname LIKE '%
johnie %' OR
?
Thank you for any help.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi.
Using mySQL 3.23.58, I'm trying to log slow queries and I made:
log-slow-queries = /usr/local/mysql/log/slow-queries.log
long-query-time = 5
(into my '/etc/my.conf' file)
However, I get this error message:
unrecognized option `--long-query-time=5'
Is this parameter supported in mySQL 3?
I also tried with long_query_time = 5
but got the same error :(
On 7/12/07, thomas Armstrong [EMAIL PROTECTED] wrote:
Hi.
Using mySQL 3.23.58, I'm trying to log slow queries and I made:
log-slow-queries = /usr/local/mysql/log/slow-queries.log
long-query-time = 5
(into my '/etc/my.conf' file
,
Thomas
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there a way to monitor SQL query response times?
Mysqlperformanceblog has patches for higher granularity query log:
http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/
You could always just wrap the query calls in between some time registration
of your own.
--
Hi.
Using mySQL 4.1.22 on Linux, I got this error message suddenly this
morning (it worked ok yesterday):
-
[EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
--
I created a
Hi.
Using mySQL 4.1.22 on Linux, I got this error message suddenly this
morning (it worked ok yesterday):
-
[EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
--
I created a
Fixed:
[]# kill `cat /usr/local/mysql/var/server.pid`
[]# /usr/local/mysql/bin/mysqld_safe --skip-grant-tables
[]# /usr/local/mysql/bin/mysql
mysql update user set password = password('xxx') where user =
'root' and host='localhost';
On 2/20/07, thomas Armstrong [EMAIL PROTECTED] wrote:
Hi
. row 3 of atable should be updated 2 times, adding 6 and 7, as there
are 2 rows in btable where column a is = 3.
How can I do this? Any help is apreciated.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi.
Using mySQL v4.1.9 on Fedora Core 2, I'm suffering a shutdown everyday
around 04:30. These are the contents of 'mysqld.log':
/usr/sbin/mysqld: ready for connections.
Version: '4.1.9-standard-log' socket: '/var/lib/mysql/mysql.sock'
port: 3306 Source distribution
070201 4:29:40 [Note]
I have data that is broken into anything from 30 sec to 15 minute time
series (with a DATETIME field). I need to transform all of this into 15
minute data. Does anyone know off the top of their head if there a way I
could use GROUP BY to make this happen? Nothing I have tried thus far
has
If one has a large number of records per month and normally searches for
things by month, yet needs to keep things time coded, does anyone know
if it make sense to use datetime or separate date and a time columns?
Thanks,
Tom
--
MySQL General Mailing List
For list archives:
Cf. http://www.phpcenter.de/phorum/read.php?f=1i=50453t=50453 +
http://www.heidisql.com/.
cheers, Thomas
t.j. loeffler
eth zurich
institute of geology
CAB E 10.4, universitaetsstrasse 6
8092 zurich, switzerland
www.erdw.ethz.ch
'a%' or name like 'b%' or
name like 'c%';
no. You have to use LIKE.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
/.*/''/ | tr '\012' ',' | sed \
-e s/,*$//)
echo INSERT INTO mytable VALUES(${DATE},$DATA);
exit 0
# end of shell script
The resulting queries can be piped into the mysql client.
HTH,
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hello all...
And thanks ahead of time for the help...
I'm having an issue with a locked table...
I have about 27 tables in MySQL Db that i am working with with multiple
MS Access front ends.. The problem is one of my tables is locked, but
only the first 400 records, the rest is fine... Any
Hi.
There's a lot of '/tmp/ibE3FYj2' files inside my Linux server, created
by mysqld.
Does anybody know how to delete them after being used?
Thank you very much.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi.
I've got three tables (users, books and news), and I would like to
crete a web interface
to manage their data (create items, modify items, delete items).
Is there any PHP script to create it automatically (in the same way
phpMyAdmin does, but
with less functionalities)?
Thank you very
Hi.
My Linux server has just restarted due to memory problems.
Browsing mySQL logs, I've found out 5,000 lines like these in less
than one hour:
--
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file:
'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't
Hola.
With mySQL 4.0.27 I'm trying to create this table
--
CREATE TABLE `test`.`user` (
`user_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`email` TEXT CHARACTER SET COLLATE NULL ,
`firstname` TEXT CHARACTER SET COLLATE NOT NULL ,
)
--
but I get this error:
--
#1064 - You have an
Hi.
Working with mySQL 3.23.58 on Linux, I get this error when trying to
start mysqld:
060716 03:07:21 mysqld started
060716 03:07:21 /usr/local/mysql/libexec/mysqld: Table 'mysql.host'
doesn't exist
060716 03:07:21 mysqld ended
-
This Linux machine
-rw 1 mysql root0 may 30 2005 func.MYD
-rw-rw 1 mysql root 8877 may 30 2005 tables_priv.frm
Where are 'host.frm', 'host.MYD' and 'host.MYI'?
On 7/16/06, thomas Armstrong [EMAIL PROTECTED] wrote:
Hi.
Working with mySQL 3.23.58 on Linux, I get this error when trying
fre 2006-06-23 klockan 01:52 -0400 skrev Michael Stassen:
Thomas Lundström wrote:
Not sure what you're aming for here and how your data is structured but
why not use a join and alias and fetch all info in one select and then
solve what you need in your code?
Something in the line
= t2.id
and t1.id = t3.id
and t1.id = 3
Maybe you can do something like that?
Regards,
Thomas L.
ons 2006-06-21 klockan 17:16 +0800 skrev Song Ken Vern-E11804:
Hi,
I'm trying to build a query in using SQL instead of doing it in Perl.
I am trying to do something like
I'm running MySQL server 5.0...???
mysql mysqldump --help;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that
corresponds to your MySQL server version for the right syntax to use
near 'mysql
dump --help' at line 1
-Original Message-
From: J.R. Bullington
Is there any way to find the time of the most recent update for a row?
Recently I noticed a changed behavior in how linux utilities (ps ans
pstree) report mysql usage.
Previously a ps output would list all active mysql threads, and a
pstree would list the number of mysql threads currently running.
Now I merely see a pstree output such as:
Hi,
I am using Java to maintain a MySQL database. I have a table in the
database created by:
CREATE TABLE track_char (
+ id INT UNSIGNED NOT NULL AUTO_INCREMENT,
+ PRIMARY KEY (id),
+ name CHAR(40),
+ posX
Right...the thing is that they are supposed to be INTs, but I can only
successfully perform an update query if I use doubles for the fields...?
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 1:59 PM
To: Thomas Amundsen; mysql@lists.mysql.com
() method by using hard-coded values...only
hard-coded doubles work, hard-coded ints wouldn't.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 2:09 PM
To: Thomas Amundsen; mysql@lists.mysql.com
Subject: RE: INT wants a float/double?
[snip]
Right
It seems to work with INTs when I do it from the MySQL commandline. I
guess something is weird with the JDBC connector or something...
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 2:26 PM
To: Thomas Amundsen; mysql@lists.mysql.com
Subject
: Tuesday, June 06, 2006 2:38 PM
To: Thomas Amundsen; mysql@lists.mysql.com
Subject: RE: INT wants a float/double?
[snip]
It seems to work with INTs when I do it from the MySQL commandline. I
guess something is weird with the JDBC connector or something...
[/snip]
May I suggest echoing your query
1 - 100 of 639 matches
Mail list logo
