Re: Restore data from MySQL data files

2011-11-26 Thread Yves Goergen
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, recreat

Re: Restore data from MySQL data files

2011-11-10 Thread Johan De Meersman
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 all

Re: Restore data from MySQL data files

2011-11-09 Thread Yves Goergen
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.

Re: Restore data from MySQL data files

2011-11-09 Thread Reindl Harald
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 CLEA

Restore data from MySQL data files

2011-11-09 Thread Yves Goergen
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.

Re: Store MySQL data files and log files (log bin) separated!!!

2008-03-12 Thread Raj Shekhar
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 | op

Store MySQL data files and log files (log bin) separated!!!

2008-03-11 Thread Marcos Vinícius Vieira dos Santos
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

Re: Mysql Data files

2005-05-03 Thread Gleb Paharenko
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

Mysql Data files

2005-05-01 Thread V. Agarwal
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 Yahoo!

Re: MySQL data files

2004-09-22 Thread Mir Islam
<[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 Fo

Re: MySQL data files

2004-09-22 Thread DreamWerx
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 the

MySQL data files

2004-09-21 Thread VijayKumar Dogra
   Hello All,    Is there any way by which I can store data files of mysql in other partition of my system   Regards, VijayKumar Dogra

Re: PCAnywhere like linux client - mysql data files administration

2001-12-17 Thread Robert Cross
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: oco

Re: PCAnywhere like linux client - mysql data files administration

2001-12-15 Thread Shankar Unni
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 wind

Re: PCAnywhere like linux client - mysql data files administration

2001-12-15 Thread Gerald-Markus Zabos
trace. Greetings, Gerald >>>>>>>>>>>>>>>>>> Ursprüngliche Nachricht <<<<<<<<<<<<<<<<<< Am 15.12.01, 19:49:05, schrieb "Jack A. Fobel" <[EMAIL PROTECTED]> zum Thema P

Re: PCAnywhere like linux client - mysql data files administration

2001-12-15 Thread Joe Ellis
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 con

PCAnywhere like linux client - mysql data files administration

2001-12-15 Thread Jack A. Fobel
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