t.pid
--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
to go?
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" <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
2) What 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 [
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 anonym
ASSWD_PRIV_ROOT') WHERE
User = 'root';
exit
---
It all works pretty well. 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
hlocalhost < 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
mailto:todd_...@ssiresults.com>> wrote:
I'm looking for automation direction...
I've found many packages that
7;admin'@'localhost' IDENTIFIED BY 'admin-password';
If there is a better way to do this than using expect I 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 rig
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, m.
Try looking in Control Panel->Administrative Tools-> Services and deleting
all the MySQL services.
I suffered the same problem, and the following worked for me:
http://www.andy.name.my/2009/03/cannot-create-windows-service-for-mysqlerror0/
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 ques
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_
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 wrote:
Hi
I have MySQL 5.0.64 compiled from source. When I run myisamchk
on any
table I get the following warnings:
Wa
_size=20971520
sort_buffer_size=20971520
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 followi
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
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 war
index 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?
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
://dev.mysql.com/doc/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:
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 k
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 co
perfectly valid 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
ans that the query result is not cached. It does not mean
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 in
access 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 archive
p database 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:/
;studied" your query, my guess 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: h
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 possible_ke
you using? I found some issues with InnoDB
regarding this error. Please check the .err log of mysqld as well.
Regards, Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ags. When
> it tries 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
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 M
+
2 rows in set (0.02 sec)
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$ my
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
2)
Hi all,
how mysql manage the query_cache TimeToLive (live) and how can I change it ?
Thanks
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
--
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
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 buffe
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 a
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:ht
+
| wait_timeout | 28800 |
+---+---+
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
> 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 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
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 My
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 transac
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
innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;i
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 sai
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 mysqlmys
2000M;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
root[root] @ 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'
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:
&g
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 re
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
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.
>
&
tz <[EMAIL PROTECTED]> wrote:
> 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://d
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 ('+"f
y much!
>
> Regards,
>
> Jerry 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
>
>
> &
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
>
cords in here,
> that's going to kill you.
You're right, but I didn't find another better way. What do you think
it's better?
>
> - michael
>
>
> On 9/19/07, thomas Armstrong <[EMAIL PROTECTED]> wrote:
> > Hi.
> >
> > I've got t
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 friend
is
wrong?
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]
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 '/e
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?
--
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.
--
anybody concur whether this happens for them too?
And if so, is this a bug?
grtz,
Thomas
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, thoma
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 '
--+--+
4 rows in set (0.00 sec)
i.e. 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
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 worke
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: http://lists.mysql.c
Cf. http://www.phpcenter.de/phorum/read.php?f=1&i=50453&t=50453 +
http://www.heidisql.com/.
cheers, Thomas
t.j. loeffler
eth zurich
institute of geology
CAB E 10.4, universitaetsstrasse 6
8092 zurich, swi
gt; select id, name from tableName where name like '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]
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 id
TAB=' '
WHITESPACE="${BLANK}${TAB}"
DATE=$(cat mydatafile.csv | sed \
-e "3 !d" \
-e "s/^[$WHITESPACE]*//" \
-e "s/.*/'&'/")
DATA=$(cat mydatafile.csv | sed \
-e "/[A-Z]/ d" \
-e "
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 PROTE
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 much.
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 o
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
only two files:
--
-rw-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]>
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 ha
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
t1.id = 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
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 [mai
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:
├─mysqld_safe───mysq
mailto:[EMAIL PROTECTED]
Sent: 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]
Ma
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
E name = 'Tom'"
but that wouldn't work. And yes, I have made sure that it isn't a
problem with the parseInt() method by using hard-coded values...only
hard-coded doubles work, hard-coded ints wouldn't.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROT
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
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),"
1 - 100 of 669 matches
Mail list logo
