Re: Restoring failed due to Unexpected Error
yes - take your fingers away and go to a datarecovery company if it is not too late because you are damaging the disk more and more, NOW it is too late for backups! Am 22.11.2011 06:03, schrieb Adarsh Sharma: Any comments to get the data back know. My hard disk crashes about 90% but when I start any kind of backup or select output into a file from 40GB table , it stops after 30 GB then stalled because there are bad sectors to read. Is it possible to get the remaining data ( 10GB) , as all backups are also corrupted resulting in errors. Hard disk heats up after 30 Gb backup , but if no backup is taken it is working fine. Thanks Reindl Harald wrote: Am 18.11.2011 14:18, schrieb Johan De Meersman: - Original Message - From: Reindl Harald h.rei...@thelounge.net but anyways, the message sounds like a damaged compressed file Looks more like he's got an HTML file instead of an SQL file, to me. Have a look inside the file, maybe the HTML is just a wrapper or something. How was the backup taken ? yes the tml is strange but gunzip: stdin: unexpected end of file sounds like the bigger problem to me, backups without verify integrity are a dangerous game because you need them not often but if you need them it is fatal if they are corrupt -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm signature.asc Description: OpenPGP digital signature
RE: Reusing ibdata1 space
Johan, I think you are right about this. The problem does not appear to be with the database at all, but with the undo log. Thanks for pointing me in the right direction. -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Tuesday, November 01, 2011 10:01 AM To: Rozeboom, Kay [DAS] Cc: mysql@lists.mysql.com Subject: Re: Reusing ibdata1 space - Original Message - From: Kay Rozeboom [DAS] kay.rozeb...@iowa.gov I realize that this would not return the unused space to the operating system. But would it return it to MySQL so that it could be re-used for subsequent inserts, instead of extending ibdata1 further? That should normally already happen. An occasional optimize table might help defragment the tablespace, but space from properly deleted records should be reused anyway (save for really small fragments). I recommend you keep track of the innodb free tablespace for a while, and see how that evolves - it should go relatively low before the tablespace expands on disk. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Re: Chinese characters not displaying in Workbench latest version
The problem was the character set not loaded on the OS On 21 Nov 2011, at 22:08, Michael Cole colemic...@gmail.com wrote: I think what he was asking is, Are you running the Mysql workbench on the same machine? You may not have the correct Fonts. Being replicated the character sets of the two dbs should be the same have you checked that they actually are set to the same? On Monday, November 21, 2011 9:20:10 PM Neil Tompkins wrote: MySQL workbench On 21 Nov 2011, at 13:36, Chris Tate-Davies chris.tatedav...@inflightproductions.com wrote: What are you using to view the data? On Mon, 2011-11-21 at 08:22 -0500, h...@tbbs.net wrote: ; 2011/11/20 20:27 +, Tompkins Neil Does anyone know why Chinese characters are not displaying correctly in a replicated database on a slave machine ? I'm just getting square boxes. What displays them? it sounds to me as if the display lacks something, not so much MySQL. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=neil.tompk...@googlemail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
innodb space free decreasing by more then the amount of data we're adding
We just moved a large amount of data off one of our db servers to another one (75gb of data). One thing I've noticed is that over the last couple days the free innodb space has been decreasing by over 2.5 gb a day while we've only been adding 400 mb of data a day to the db server. I'm at a loss as to why the innodb free space would be decreasing like it has been. This is on a MySql 5.0 install. Sean -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Data file for MyISAM engine
Hi ! I would like to ask question regarding to the MyISAM engine. Is there any physical file that you have to be aware of its size for disk sizing, like the ibdata1 in innodb storage engine? It seems that MYD is the data file but this file size seems to be not increasing after the insert sql. Thanks, Yu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Data file for MyISAM engine
- Original Message - From: Yu Watanabe yu.watan...@jp.fujitsu.com It seems that MYD is the data file but this file size seems to be not increasing after the insert sql. That's right, it's an L-space based engine; all the data that has, is and will ever be created is already in there, so storage never increases :-p Seriously though; the MYD file is the datafile and the MYI file is the index file. Both of those will increase with use, although since storage allocation happens based off pages, not records, increases will only happed when the existing pages are filling up. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org