I found that the database I was primarily interested in only had a
MyISAM table (.myd and .myi file), nothing in InnoDB. So I first copied
over that database directory to my other MySQL instance and restarted
it. MySQL Workbench hang a bit when expanding its tree, so I dropped the
database,
Hah. I suspect the machine was running when it crashed - that is, the mysql was
shut down uncleanly?
You can safely ignore the mysql.plugin bit for the moment - that's for when
it's booted properly. It looks like the newer InnoDB has trouble reading your
ibdata file. Possible causes:
* Are
Hi,
Recently a home server has crashed and would not boot anymore into
Windows. We decided to replace it altogether and I managed to repair the
file system more or less so that I could copy some directories from the
broken disk. One of them is the MySQL data directory of that XAMPP
installation.
Am 09.11.2011 21:46, schrieb Yves Goergen:
The old machine was an unknown MySQL version on Windows XP
pfff - unknown version? how comes?
The error log is attached to this mail. It all sounds like real bugs in
MySQL, at least it's standing in the file
there is no attachment
so please CLEAR
On 09.11.2011 21:58 CE(S)T, Reindl Harald wrote:
Am 09.11.2011 21:46, schrieb Yves Goergen:
The old machine was an unknown MySQL version on Windows XP
pfff - unknown version? how comes?
The old MySQL installation doesn't run anymore because the OS is gone. I
could only backup the files.
Marcos Vinícius Vieira dos Santos wrote:
I used --localstatedir in ./configure but both data files and log files
was stored together.
In your my.cnf file, put the lines (in [mysqld] section
datadir = /sgdb/data
log-bin = /var/log/mysql
--
raj shekhar
facts: http://rajshekhar.net |
Hello everyone,
I am compiling mysql source and need stored MySQL data files and log files (log
bin) separated. For example:
/var/log/mysql /* log files
and
/sgdb/data /* data files
I used --localstatedir in ./configure but both data files and log files was
stored together.
How do
Hello.
See:
http://dev.mysql.com/doc/mysql/en/myisam-storage-engine.html
http://dev.mysql.com/doc/mysql/en/using-innodb-tables.html
V. Agarwal [EMAIL PROTECTED] wrote:
Hi,
On PC, I see *.frm files for each table while I see
3 files on Unix/Linux (*.MYD,*,MYI,*.frm).
Hi,
On PC, I see *.frm files for each table while I see
3 files on Unix/Linux (*.MYD,*,MYI,*.frm).
Need to know what these files are.
I created a table on PC Mysql with type set to InnoDB
which also created *.frm file.
Any ideas ?
__
Do You
Shutdown mysql, move data files, create symlink to datafile(s) on
other partition/disk/whatever..
- Original Message -
From: VijayKumar Dogra [EMAIL PROTECTED]
Date: Wed, 22 Sep 2004 11:22:55 +0530
Subject: MySQL data files
To: [EMAIL PROTECTED]
Hello All,
Is there any way
[EMAIL PROTECTED]
Date: Wed, 22 Sep 2004 11:22:55 +0530
Subject: MySQL data files
To: [EMAIL PROTECTED]
Hello All,
Is there any way by which I can store data files of mysql in other
partition of my system
Regards,
VijayKumar Dogra
--
MySQL General Mailing List
For list
Hello All,
Is there any way by which I canstore data files of mysql in other partition of my system
Regards,
VijayKumar Dogra
Jack A Fobel wrote:
I remember seeing a program awhile back that acts like pcanywhere or
terminal services, to connect to a linux or windows box. Anyone remember
the
name?
Depends what you mean:
a. Terminal services, or b. pcanywhere(tm)
If it's (a), then you've got a wide choice of:
o
subject: PCAnywhere like linux client - mysql data files administration
Hi,
I remember seeing a program awhile back that acts like pcanywhere or
terminal services, to connect to a linux or windows box. Anyone remember the
name?
Thanks,
Jack
i believe your talking about VNC.
http://www.uk.research.att.com/vnc/
Jack A. Fobel wrote:
subject: PCAnywhere like linux client - mysql data files administration
Hi,
I remember seeing a program awhile back that acts like pcanywhere or
terminal services, to connect to a linux
a trace.
Greetings,
Gerald
Ursprüngliche Nachricht
Am 15.12.01, 19:49:05, schrieb Jack A. Fobel [EMAIL PROTECTED]
zum Thema PCAnywhere like linux client - mysql data files administration :
subject: PCAnywhere like linux client - mysql data files administration
Hi,
I remember seeing a program
X-obligatory-filter-fodder: database,sql,query,table
Joe Ellis wrote:
i believe your talking about VNC.
http://www.uk.research.att.com/vnc/
Jack A. Fobel wrote:
I remember seeing a program awhile back that acts like pcanywhere or
terminal services, to connect to a linux or windows
17 matches
Mail list logo