Re: Where are actual databases stored?

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 documen

Re: Where are actual databases stored?

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

Re: Where are actual databases stored?

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 where

Re: Where are actual databases stored?

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?

Where are actual databases stored?

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

Crash Recovery Problem

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 ca

RE: stored procedure, parameter type help needed

> -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

Re: Configure options

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 s

CREATING A table using a hash in perl

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.

Re: stored procedure, parameter type help needed

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, a

Re: Date sorting problem with Date_Format?

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( `Messages`.

Date sorting problem with Date_Format?

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`, `Profiles`.`RealName`

Re: Access limited after restore

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 MySql