Hi Philip,
If you are worried about permissions, go to your mysql root directory
and enter:
# chown -R mysql.mysql .
The UID and GID should not make any difference. I don't think this
would effect your ability to log in.
If this is a new installation of the server, check the default
Hello mysql,
I have a PHP script that is running the following query:
SELECT `Messages`.`ID`,
`Messages`.`Sender`,
`Messages`.`Subject`,
DATE_FORMAT( `Messages`.`Date`, '%D %M %Y' ) AS Date,
LEFT(`Messages`.`Text`, 200 ) AS Preview,
`Messages`.`New`,
`Profiles`.`NickName`,
Hello mysql list,
As is very often the case, five minutes after I posted this, I found
the problem or solution, not sure it was the problem as I am not
convinced that mysql ought to get confused so easily. I changed
DATE_FORMAT( `Messages`.`Date`, '%D %M %Y' ) AS Date,
DATE_FORMAT(
Hi again,
I found a way that works for the query I wanted in my sproc. It uses
your solution to insert into a temporary table, and then uses a SELECT
in the IN-part.
I don't know yet if this solution may have side-effects. I need to read
more about how temporary tables is handled by MySQL, as
Hi
How do I create a table inside a perl script using a hash to give table name
and mysql statements?
thanks.
--
View this message in context:
http://www.nabble.com/CREATING-A-table-using-a-hash-in-perl-tp15353263p15353263.html
Sent from the MySQL - General mailing list archive at Nabble.com.
Hi all:
Our sistem crashed and we're trying to recover our data. The disc is
fine but the OS is gone, so I'm trying to get at the actual mysql
databases document. Does anybody know where to look for them in a
*nix system?
Thanks,
Riccardo
--
[EMAIL PROTECTED]
www.riccardoperotti.com
I've got MySQL 5.0.55a running on a Windows XP system. All tables in the
active database on the system are innodb. The startup log says that innodb
recovery completed and that connections are available. Meanwhile, mysql is
writing to the hdd at around 2MB/sec according to process explorer.
I
Il giorno 08/feb/08, alle ore 21:55, Riccardo Perotti ha scritto:
Hi all:
Our sistem crashed and we're trying to recover our data. The disc is
fine but the OS is gone, so I'm trying to get at the actual mysql
databases document. Does anybody know where to look for them in a
*nix system?
On Fri, February 8, 2008 13:09, Paolo Amodio wrote:
Il giorno 08/feb/08, alle ore 21:55, Riccardo Perotti ha scritto:
Hi all:
Our sistem crashed and we're trying to recover our data. The disc is
fine but the OS is gone, so I'm trying to get at the actual mysql
databases document. Does
RedHat centric systems store them in /var/lib/mysql
On Feb 8, 2008, at 2:55 PM, Riccardo Perotti wrote:
Hi all:
Our sistem crashed and we're trying to recover our data. The disc is
fine but the OS is gone, so I'm trying to get at the actual mysql
databases document. Does anybody know
-Original Message-
From: Magne Westlie [mailto:[EMAIL PROTECTED]
Sent: Friday, February 08, 2008 5:37 AM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: stored procedure, parameter type help needed
Hi again,
I found a way that works for the query I wanted in my
Gavin Towey wrote:
Hi,
We normally use the binaries, but there's a few patches I want to try
out, so I've gotten the source. Now I've also compiled sources many
times, so that process isn't a problem. However, what I wanted to do is
try to compile the source with the exact same
Il giorno 08/feb/08, alle ore 22:29, Riccardo Perotti ha scritto:
On Feb 8, 2008, at 4:02 PM, Paolo Amodio wrote:
Il giorno 08/feb/08, alle ore 21:55, Riccardo Perotti ha scritto:
Hi all:
Our sistem crashed and we're trying to recover our data. The disc
is fine but the OS is gone, so
13 matches
Mail list logo