[mailto:[EMAIL PROTECTED]
Sent: Tuesday, 23 May 2006 4:57 PM
To: mysql@lists.mysql.com
Subject: InnoDB problems under 5.1.9
Dear MySQL,
I've installed 5.1.9 from source on a SUSE 10 box. But I can't get
InnoDB tables respected.
I have used the correct compilation flag (--with-innodb).
SHOW
---
-Original Message-
From: Ben Clewett [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 23 May 2006 4:57 PM
To: mysql@lists.mysql.com
Subject: InnoDB problems under 5.1.9
Dear MySQL,
I've installed 5.1.9 from source on a SUSE 10 box. But I can't get
InnoDB tables
: InnoDB problems under 5.1.9
Logan, David (SST - Adelaide) wrote:
Hi Ben,
Try doing
SHOW ENGINES;
Here: (pertinent cols only)
++--+--+-++
| Engine | Support | Transactions | XA | Savepoints
: Tuesday, 23 May 2006 5:50 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: Re: InnoDB problems under 5.1.9
Logan, David (SST - Adelaide) wrote:
Hi Ben,
Try doing
SHOW ENGINES;
Here: (pertinent cols only)
++--+--+-++
| Engine
Ben Clewett wrote:
Dear MySQL,
I've installed 5.1.9 from source on a SUSE 10 box. But I can't get
InnoDB tables respected.
I have used the correct compilation flag (--with-innodb).
SHOW VARIABLES; lists all the usual innodb variables.
The innodb table space has been created in
Hi Gerald,
I am sure I don't have this in my my.cfg. I am using the supplied
'large table' my.cfg. The *only* innodb option I have is the command
line parameter to mysqld:
--innodb
If anybody has any other options about how to get innodb working in
5.1.9, I'd be very interested!
Thanks
Hi Gerald,
I am sure I don't have this in my my.cfg. I am using the supplied
'large table' my.cfg. The *only* innodb option I have is the command
line parameter to mysqld:
--innodb
If anybody has any other options about how to get innodb working in
5.1.9, I'd be very interested!
Thanks
Ben, what does SHOW ENGINES show you? It should list all known storage
engines and indicate whether your MySQL install supports it or not.
Here's mine (5.0.21) for comparison; I was able to create a test table
as InnoDB and the SHOW CREATE showed it as InnoDB:
- show engines;
Hi Dan,
This is what I have. What does this mean with regards to InnoDB?
++--++--+-++
| Engine | Support | Comment
| Transactions | XA | Savepoints |
Ben, looks like you've either got it disabled in my.cnf or with a
startup flag, or you've not set all the needed options for InnoDB.
See http://dev.mysql.com/doc/refman/5.0/en/mysqld-max.html, near the
bottom of the page it explains what DISABLED means and refers you to the
error log for
Thanks for the excellent reference, this gives me a lot to go on.
My server is in bits at the moment, I'll let you know when it's up again!
Ben
Dan Buettner wrote:
Ben, looks like you've either got it disabled in my.cnf or with a
startup flag, or you've not set all the needed options for
Thanks for the tip.
Simple problem, my innodb data file was created with the default my.cnf.
When I started it with the large_table version, it used different innodb
table space size. Therefore would not start :)
Cheers,
Ben
Dan Buettner wrote:
Ben, looks like you've either got it
I am trying to install DBD::mysql on the following node:
[EMAIL PROTECTED] cal]# uname -a
Linux snv1 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:56:28 EST 2006 x86_64 x86_64
x86_64 GNU/Linux
[EMAIL PROTECTED] cal]# more /etc/redhat-release
Red Hat Enterprise Linux WS release 4 (Nahant Update 3)
[EMAIL
-
From: Logg, Connie A. [mailto:[EMAIL PROTECTED]
Sent: Thursday, 11 May 2006 5:47 AM
To: mysql@lists.mysql.com
Subject: Installing DBD::mysql - problems
I am trying to install DBD::mysql on the following node:
[EMAIL PROTECTED] cal]# uname -a
Linux snv1 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:56:28 EST
I migrated to mysql 5 but the applications with Visual Basic 5 return
error in data.
We have installed ODBC 3.51
--
Saludos cordiales.
Ing. Gabriel Mahiques
Dto. Control de Gestión
ELECTROINGENIERA S.A.
Telefono: 474 1414
I think you will need to give the list some more information!
What error message do you get? Is it an error when running SQL queries, or a
problem connecting to the database?
James Harvard
At 9:22 am -0300 24/4/06, Gabriel Mahiques wrote:
I migrated to mysql 5 but the applications with Visual
I'm seeing some very odd locking behaviour on 4.1.13:
mysql show full processlist;
As others have suggested , turn your slow query log on in my.cnf , and set
your long-query_time, and you can view your slow queries in the *.log file
in your data dir, and then try to optimize them, you could also try mytop (
http://jeremy.zawodny.com/mysql/mytop/) , and check your queries in real
Folks,
I have a mysql 5.0 db with the following char sets:
mysql show variables like '%char%';
+--+--+
| Variable_name| Value|
+--+--+
| character_set_client |
Is tat query is the problem ?
Then turn on your slow queies and try optimizing those slow queries ?
Post your queries and table description for further help :)
--Praj
On Wed, 29 Mar 2006 12:33:20 -0500
Jacob, Raymond A Jr [EMAIL PROTECTED] wrote:
After a 23days of running mysql, I have
Hello!
I'm having a weird problem i'd like to hear your opinions about:
| [18:44] [EMAIL PROTECTED]:~] # mysqlcheck v games
| v.games
| error: Table './v/games' is marked as crashed and should be repaired
| [18:44] [EMAIL PROTECTED]:~] # mysqlcheck -r v games
| v.games
That usually means the table is corrupt beyond repair and nothing is really
fixing it or there is something one cannot easily comprehend ( this usually
happens with inconsistency among deleted records and some kind of mismatch
that occurs) -anyway what I would really advice in this case is to
After a 23days of running mysql, I have a 3GB database. When I use an
application
called base(v.1.2.2) a web based intrusion detection analysis console, the
mysqld utilization
shoots up to over 90% and stays there until the application times out or is
terminated.
Question: Have I made some
Quoting Kishore Jalleda ([EMAIL PROTECTED]):
That usually means the table is corrupt beyond repair and nothing is really
fixing it or there is something one cannot easily comprehend ( this usually
happens with inconsistency among deleted records and some kind of mismatch
that occurs)
there are
any errors in the table.
Keith
In theory, theory and practice are the same;
in practice they are not.
On Wed, 29 Mar 2006, Sander Smeenk wrote:
To: mysql@lists.mysql.com
From: Sander Smeenk [EMAIL PROTECTED]
Subject: Re: MySQL 5.0.19-2 and repair problems...
Quoting Kishore Jalleda
Quoting [EMAIL PROTECTED] ([EMAIL PROTECTED]):
Have you tried the following myisamchk option:
--extend-check, -e
Yup. But that won't even work at ALL:
# myisamchk -e games.MYI
Checking MyISAM file: games.MYI
Data records: 10644 Deleted blocks: 0
- check file-size
- check record
what's the result of
SHOW CREATE TABLE games
??
I'd drop the indexes on the games table, and then run repair tables,
and then put the indexes back in. Worth a shot.
-Sheeri
On 3/29/06, Sander Smeenk [EMAIL PROTECTED] wrote:
Quoting [EMAIL PROTECTED] ([EMAIL PROTECTED]):
Have you tried
Quoting sheeri kritzer ([EMAIL PROTECTED]):
what's the result of
SHOW CREATE TABLE games
It gives me the create statement for that table.
All perfectly normal. MyISAM table, latin1 charset.
I'd drop the indexes on the games table, and then run repair tables,
and then put the indexes back
According to the manual, 64 to 32 bit shouldn't matter, it should work
fine as long as they're both little endian, or they're both big
endian.
I've copied MyISAM tables from 64 to 32 bit without a problem.
BTW, I suggested that because in the error it said:
myisamchk: error: Key in wrong
Quoting sheeri kritzer ([EMAIL PROTECTED]):
According to the manual, 64 to 32 bit shouldn't matter, it should work
fine as long as they're both little endian, or they're both big
endian.
This friend of mine said he also had major problems moving 32-64.
Crashing mysql's, but not corrupt tables
Jacob, Raymond A Jr wrote:
After a 23days of running mysql, I have a 3GB database. When I use an
application
called base(v.1.2.2) a web based intrusion detection analysis console, the
mysqld utilization
shoots up to over 90% and stays there until the application times out or is
terminated.
2 weeks ago we had a server crashing, and while I was checking it out
(before, during and after crashes) I noticed that after a crash, the
server was slow. Threads would run for 200 seconds or more, and yet
when they finished, nothing was written to the slow query log.
Why would that be? Slow
On 2006-03-20, at 16:12, Gabriel PREDA wrote:
One must issue immediately after connection:
SET NAMES 'utf8'
Also look at:
SHOW VARIABLES LIKE 'collation_%';
SHOW VARIABLES LIKE 'character_set_%';
Server must know what you are assking for... and they ALL have to
talk the
same language !!!
Sheeri,
- Original Message -
From: sheeri kritzer [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, March 28, 2006 9:29 PM
Subject: problems/feature request ideas
2 weeks ago we had a server crashing, and while I was checking it out
(before, during and after
Yes you are right it works... but if the documentation is wrong I will be
wrong in the following also...
Majority of SET statements are documented without quotes:
AUTOCOMMIT = {0 | 1}
BIG_TABLES = {0 | 1}
FOREIGN_KEY_CHECKS = {0 | 1}
IDENTITY = value
INSERT_ID = value
LAST_INSERT_ID = value
I have problem with UTF-8 character set.
I use MySQL 5 and Tomcat 5.5.9.I use NetBeans for
programinnig
in Java.
I made one database and is in UTF8,also all my JSP
pages are set to
UTF8 encoding,and also all HTML are set to UTF8.
When i put ,#273;,#269;,#263;, character date in
database
One must issue immediately after connection:
SET NAMES 'utf8'
Also look at:
SHOW VARIABLES LIKE 'collation_%';
SHOW VARIABLES LIKE 'character_set_%';
Server must know what you are assking for... and they ALL have to talk the
same language !!!
--
Gabriel PREDA
Senior Web Developer
I have downloaded sucesfully the MySQL Migration Toolkit tool. After start the
error with Java appears. I have Java installed on my PC because I work with
Eclipse 3.1.1 + PHPEclipse Plugin. The JDK installed is 1.5. So if any can help
me ...
Regards,
--
ReynierPM
4to. Ing. Informática
Linux
Hi Sean,
I used to have similar problems with different character sets and my
solution is:
1) dump all data using mysql dump utility
2) check if data are OK - view your data with viewer which suports correct
character set
3) if data are not OK try to dump data in different character set
4
Hi,
I am having character set problems while trying to migrate my data
from a server running 4.0.25-standard to a server running 4.1.16. I
believe that the orginal database was using the latin1 character set
(not sure, is there any way to tell? show full column doesn't seem
should be valid xhtml. I use the content-type meta tag just to be safe:
meta http-equiv=Content-Type content=text/html; charset=UTF-8 /
Thanks,
Sean
On 14-Mar-06, at 11:09 AM, Sean O'Hara wrote:
Hi,
I am having character set problems while trying to migrate my data
from a server
. Below is
static php code that I used numerous places:
?
$year=substr($date, 0, 4);
$month=substr($date, 4, 2);
$day=substr($date, 6, 2);
?
All timestamp dependent reports and web pages had problems, once I upgrade to
MySQL 4.1.12. At the end I had to downgrade to 3.23 to bring
. Below is
static php code that I used numerous places:
?
$year=substr($date, 0, 4);
$month=substr($date, 4, 2);
$day=substr($date, 6, 2);
?
All timestamp dependent reports and web pages had problems, once I upgrade to
MySQL 4.1.12. At the end I had to downgrade to 3.23 to bring
);
$month=substr($date, 4, 2);
$day=substr($date, 6, 2);
?
All timestamp dependent reports and web pages had
problems, once I upgrade to MySQL 4.1.12. At the
end I had to downgrade to 3.23 to bring web site
operation to normal. Is there anyway to preserve old
timestamp format
all over
our website and to create various reports. Below is
static php code that I used numerous places:
?
$year=substr($date, 0, 4);
$month=substr($date, 4, 2);
$day=substr($date, 6, 2);
?
All timestamp dependent reports and web pages had
problems, once I
Hello fellow listers,
I recently upgraded via RPMs from 4.1 to 5.0.18 on a RH9.0 (glibc2.3, kernel
2.4.20) machine.
Now I have problems starting the mysqld automatically. When it is invoked, the
error
Couldn't find MySQLmanager or server is emitted. Here is a short history of
my actions
I am having a problem using MySqlDump. Context: I am having to export
some very specific records from our database
We have a table called BIN which has, amongst others, an ID column and
an ACCOUNT_ID column. When I use this
mysqldump -u root -p --complete-insert
Henry,
Maybe the shell is doing something funky with the parens?
maybe try escaping them with the \ ??
Just a wild guess :)
-Original Message-
From: Henry Dall [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 15, 2006 12:06 PM
To: mysql@lists.mysql.com
Subject: Problems
running into the same problems. The MySQL
server itself is running at the moment and has a number of live
databases on it.
060209 18:40:43 mysqld started
060209 18:40:43 [Warning] Can't create test
file /var/lib/mysql/thirdeye.lower-test
/usr/libexec/mysqld: Can't change dir
Wondering if anyone can shed some light on a problem I am experiencing.
I am running MySQL 4.1 on a Red Hat Enterprise Linux ES release 4 (Nahant
Update 2) machine.
I have been trying to get the default /etc/init.d/mysqld script to restart the
server but I keep running into the same problems
been trying to get the default /etc/init.d/mysqld script to restart the
server but I keep running into the same problems. The MySQL server itself is
running at the moment and has a number of live databases on it.
060209 18:40:43 mysqld started
060209 18:40:43 [Warning] Can't create test
file
4.1 on a Red Hat Enterprise Linux ES release 4 (Nahant
Update 2) machine.
I have been trying to get the default /etc/init.d/mysqld script to
restart the server but I keep running into the same problems. The MySQL
server itself is running at the moment and has a number of live databases
Hello all,I'm running into a intermittent and very annoying problem with all of my servers. I'm currently running FreeBSD 4.11, exim-4.51-0, and mySQL 4.1.13. My exim config is setup to have exim do a mySQL lookup in order to determine whether a given user's e-mail is hosted by our e-mail
hasn't been failing and being restarted?
Even if you don't find any evidence of such problems, can you check
with ps to see when the mysqld was started?
I'm wondering if there's a system level limit that I'm running into
that would be independant of exim or mySQL's configuration. I'm a
little hazy
I'm trying to set up SSL connectivity to a Fedora Core 4 server running
mysql-server-4.1.16-1.FC4.1 and not having much success. I keep getting
ERROR 2026 (HY000): SSL connection error
no matter what I do.
I followed the directions on
Gurus,
We have recently installed beta version of our application on IBM - Pentium
Xeon - dual processor, 1 GB RAM, 80 GB HDD on Fedora Core 3 OS. The kernel
version which I currently have is: 2.6.9-1.667 and Mysql Server version:
4.0.20-standard.
I have noticed that mysql processes (using
,
Rohit
- Original Message -
From: Lars Heidieker [EMAIL PROTECTED]
To: Rohit Peyyeti [EMAIL PROTECTED]
Sent: Wednesday, February 01, 2006 4:37 PM
Subject: Re: Memory problems?
All these processes share the same address space (linux way of doing
threads) therefor their sizes dont add
this keeps increasing?
Thanks,
Rohit
- Original Message - From: Lars Heidieker [EMAIL PROTECTED]
To: Rohit Peyyeti [EMAIL PROTECTED]
Sent: Wednesday, February 01, 2006 4:37 PM
Subject: Re: Memory problems?
All these processes share the same address space (linux way of doing
threads) therefor
file.
When upgrading between major versions (4.0, 4.1, 5.0, 5.1, etc), it's always
wise to make a full backup of the data files and a full backup of the
database using mysqldump. The output from mysqldump is just SQL so it is
always the safest route if you run into problems.
Greg Fortune
), it's
always wise to make a full backup of the data files and a full backup of
the database using mysqldump. The output from mysqldump is just SQL so it
is always the safest route if you run into problems.
Greg Fortune
On Wednesday 11 January 2006 13:39, Anne Ramey wrote:
I have a problem
I have a problem. I had to upgrade to 4.1 yesterday for an application,
and now I can't convert my old isam tables to myisam:
ALTER TABLE codes TYPE = MYISAM;
ERROR 1017 (HY000): Can't find file: 'codes.MYI' (errno: 2)
and I can't use phpmyadmin because there are isam tables. Is there any
way
Hi all
We are having a weird problem with some queries which are not using some
indexes in date fields.
Query-1
SELECT [field list] FROM tableX
WHERE dateField = [any date expression or constant value]
Query-2
SELECT [field list] FROM tableX
WHERE dateField = [any date expression or constant
-Original Message-
From: Aftab Khan [mailto:[EMAIL PROTECTED]
Sent: 05 January 2006 11:03
To: Javier Diaz
Subject: Re: Problems with indexes on Date/DateTime fields
Is not the second quary doing a full table scan? The
parser may find this better than using the Index.
--- Javier Diaz
if that is
the case we will need to re-visit a few queries
Thx
Javier
-Original Message-
From: Aftab Khan [mailto:[EMAIL PROTECTED]
Sent: 05 January 2006 11:25
To: Javier Diaz
Subject: RE: Problems with indexes on Date/DateTime fields
I agree. Some time full table scan is faster than
using
Javier Diaz wrote:
I would like to know if there is any problem which cause Mysql to not
use date indexes at least you use the = operator, because if that is
the case we will need to re-visit a few queries
If you do a select instead of a delete, will the index be used? (You can
check
]
Are valid for the equivalent
DELETE FROM TABLE-X WHERE [CONDITIONS]
Thanks a lot for your help
Javier
-Original Message-
From: Jigal van Hemert [mailto:[EMAIL PROTECTED]
Sent: 05 January 2006 14:39
To: Javier Diaz
Cc: Aftab Khan; mysql@lists.mysql.com
Subject: Re: Problems with indexes on Date
Javier Diaz wrote:
EXPLAIN SELECT * FROM process_times
WHERE date = date_sub(now(), INTERVAL 2 day)
possible_keysdate_idx,date_proc_idx/possible_keys
key(NULL)/key
rows10778561/rows
EXPLAIN SELECT * FROM process_times
WHERE date = date_sub(now(), INTERVAL 2 day)
.
So far as I know, I selected to use utf-8 encoding at every available
opportunity. I'm wondering if the problems came when saving to a plain
text file.
Can anyone recommend the best way to preserve text encoding methods
when copying a database from one machine to another?
Any
the database, all the Japanese text appears on my home machine as a
series of question marks.
So far as I know, I selected to use utf-8 encoding at every available
opportunity. I'm wondering if the problems came when saving to a plain
text file.
Can anyone recommend the best
.
Not entirely without problems. Most of the Japanese text shows up
correctly. But about 10% of it shows like this:
#12503;#12523;#12539;#12522;#12540;#12501;#12391;
I believe this is because there is probably some Japanese text that was
entered in sometime before the server upgraded MySQL
dave
I believe group is a reserved word. change to grp.
david
-Original Message-
From: Dave M G [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 04, 2006 8:55 AM
To: mysql@lists.mysql.com
Subject: Re: Exporting utf-8 data problems
Thank you for the advice
to 2.6.4 I've been able to set up the language in phpmyadmin as
en-utf-8, and now when I use this interface the data are actually utf8 in
the tables.
hth,
melanie
From: Dave M G [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Re: Exporting utf-8 data problems
Date: Thu, 05 Jan 2006 00
the database, all the Japanese text appears on my home machine as a
series of question marks.
So far as I know, I selected to use utf-8 encoding at every available
opportunity. I'm wondering if the problems came when saving to a plain
text file.
Can anyone recommend the best way
We have an application that uses the libmysql libraries for email
archival. We have recently been getting killed because of
http://bugs.mysql.com/bug.php?id=4143. It seems that mysql keels over
during a big query on a large database and it will not let our client
write to the db until the
Hi,
When I started out I used to do a single query and store the data in a Perl/PHP
datastructure.
I've noticed with time that I'm treating MySQL as though it were part of
PHP/Perl. ie I call a MySQL
primitive everytime I need to read a table/lookup table etc. I develop
Shoppingbaskets/CMS
When under 5.0 you need to export your data doing a character set translation to
latin1 or iso-8859-1. You also need to adjust the export for compatibilty with
older versions (some SQL verbs used in 5.0 are not understood by older
versions)
Jacques Brignon
You can do that either with mysqldump
Hello.
dump, it just cannot restore it back.
Please provide exact actions which you're doing
to restore a backup.
Sandeep Raul [EMAIL PROTECTED] wrote:
Hi,
Need your help in restoring mysqldump from version 4.1 to 5.0
We wanted to update our mysql server from version 4.1.0 to
: PLEASE HELP - problems with back up and restore
I saw both views and stored procedures in the dump file. What error do you
get if you process the script with the source command within the MySQL
CLI?
mysql -uroot -pmypass
(login welcome)
mysql CREATE DATABASE IF NOT EXISTS bcm;
mysql USE
Hi,
Need your help in restoring mysqldump from version 4.1 to 5.0
We wanted to update our mysql server from version 4.1.0 to version 5.0, we took
the mysqldump and upgraded it to version 5.0. But, when we tried to restored
the database dump, it just cannot restore it back.
We searched on the
Hi,
Need your help in restoring mysqldump from version 4.1 to 5.0
We wanted to update our mysql server from version 4.1.0 to version 5.0, we took
the mysqldump and upgraded it to version 5.0. But, when we tried to restored
the database dump, it just cannot restore it back.
We searched on the
Hi,
Need your help in restoring mysqldump from version 4.1 to 5.0
We wanted to update our mysql server from version 4.1.0 to version 5.0, we took
the simple mysqldump and when we tried to restored the database dump, it just
failed. There is no error as such. The execution of dump command
Hi,
I'm really desperate on this on.
After struggling with some really weird bugs I finally finished my project.
Buut I can't perform a good backup and restore.
I'm using :
MySql 5.0.16-nt (essentials version)
Windows xp
The DB contains tables, vw's and sp's.
It is a
Barak Mery [EMAIL PROTECTED] wrote on 11/23/2005 01:51:37 PM:
Hi,
I'm really desperate on this on.
After struggling with some really weird bugs I finally finished my
project.
Buut I can't perform a good backup and restore.
I'm using :
MySql 5.0.16-nt
PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 9:07 PM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: Re: urgent : PLEASE HELP - problems with back up and restore
Barak Mery [EMAIL PROTECTED] wrote on 11/23/2005 01:51:37 PM:
Hi,
I'm really desperate
Mery
Cc: mysql@lists.mysql.com
Subject: Re: urgent : PLEASE HELP - problems with back up and restore
Barak Mery [EMAIL PROTECTED] wrote on 11/23/2005 01:51:37 PM:
Hi,
I'm really desperate on this on.
After struggling with some really weird bugs I finally finished my
Thanks again,
I will try this and read the manual again.
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 9:30 PM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: RE: urgent : PLEASE HELP - problems with back up and restore
There's
Thanks Marko :)
-Original Message-
From: Marko Knezevic [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 24, 2005 12:29 AM
To: MySQL list
Subject: Re: urgent : PLEASE HELP - problems with back up and restore
Dear Barak,
Save yourself year or two of your life and try using MySQL Front
file
thanks
Barak
snipped out backup file
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 9:30 PM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: RE: urgent : PLEASE HELP - problems with back up and restore
There's a new option added in 5.0.13
Hello all
I've installed MySQL Server 5.0.16 and MySQL Client 5.0.16 (from the RPMs on
the MySQL site) on a server running Fedora Core 4. Every time I try to start
the service, I get the Unable to connect to the MySQL server through the
/tmp/mysql.sock error. I've tried several things from the
Hello.
Is this a clean new install of MySQL, or you have already installed
MySQL instance? Please provide more information about your OS version
(I guess it is Windows, isn't it?). May be some tips from the manual
could be helpful:
Today I downloaded and installed MySQL 5.0 (the Complete Package).
Everything seemed to go with the install until it got to the Processing
configuration... stage.
It successfully completed Prepare configuration, and Write configuration
file, and Start service.
But it failed when it got to
On Wed, November 9, 2005 11:05 am, Chris W wrote:
Richard Lynch wrote:
On Sun, November 6, 2005 2:17 am, Chris W wrote:
I just tried to use the output of the export function on phpmyadmin
and
got a million errors. After looking at the file I found that
certain
columns that are strings were
On Sun, November 6, 2005 2:17 am, Chris W wrote:
I just tried to use the output of the export function on phpmyadmin
and
got a million errors. After looking at the file I found that certain
columns that are strings were not quoted at all. I can't find any
reason why some are and some are
I just tried to use the output of the export function on phpmyadmin and
got a million errors. After looking at the file I found that certain
columns that are strings were not quoted at all. I can't find any
reason why some are and some are not quoted. Anyone have any idea why
this is
Which version? Which export type? Strings TEXT, VARCHAR would be quoted.
INT would not, I think.
Their forum might be a better place. www.phpmyadmin.net.
2wsxdr5 wrote:
I just tried to use the output of the export function on phpmyadmin and
got a million errors. After looking at the file I
John Taylor-Johnston wrote:
Which version? Which export type? Strings TEXT, VARCHAR would be
quoted. INT would not, I think.
Their forum might be a better place. www.phpmyadmin.net.
I am using phpMyAdmin 2.6.1-rc. I have no control over that as I am not
the admin on the server. All the
My organization runs an online auction on our intranet server for the United
Way. I'm having a hard time printing out a list of the winning bidders (I'm
under a lot of pressure; the baked goods are getting stale).
In these examples, I've just printed out my bidder's first names, to protect
KEVIN ZEMBOWER [EMAIL PROTECTED] wrote on 11/04/2005 11:05:05 AM:
My organization runs an online auction on our intranet server for
the United Way. I'm having a hard time printing out a list of the
winning bidders (I'm under a lot of pressure; the baked goods are
getting stale).
In
[EMAIL PROTECTED] wrote on 11/04/2005 11:22:35 AM:
This is such a FAQ that they put the answer in the manual:
http://dev.mysql.com/doc/refman/5.0/en/index.html
OOPS! I copied the wrong link. It should have been:
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
Man, you're awesome. Only two typos in the whole procedure. However, for the
life of me, I'm puzzled over how it works. If you have more patience can you
explain?
Correct query (table is singular, not PHPAUCTIONS_...):
CREATE TEMPORARY TABLE tmpWinners SELECT auction, max(bid) as winningbid
301 - 400 of 2763 matches
Mail list logo