MySQL Forums - Data Recovery Forum for Data Recovery. http://forums.mysql.com/list.php?156 Sun, 26 May 2013 04:12:52 +0000 Phorum 5.2.19 http://forums.mysql.com/read.php?156,584198,584198#msg-584198 mysqldump .sql file will not import. (no replies) http://forums.mysql.com/read.php?156,584198,584198#msg-584198 Dumped entire database into a single .sql file.
Completely removed mysql installation, and reinstalled fresh.
Import Data > dumpedfile.sql
Fails with syntax error every time at same line.

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `AddDate` BEFORE INSERT ON interviewlist FOR EACH ROW
SET NEW.InterviewListDateCreated = CURDATE(); */;;
DELIMITER ;

Always fails when it tries to create the trigger/event/ or procedure. I have multiple triggers defined for most tables. So having to recreate them one by one would be a bit annoying. Did mysqldum put in the wrong syntax?
I am trying to import as root user through MySql Workbench > import data]]> B W Data Recovery Wed, 17 Apr 2013 16:42:46 +0000 http://forums.mysql.com/read.php?156,582123,582123#msg-582123 tables are missing need urgent help (1 reply) http://forums.mysql.com/read.php?156,582123,582123#msg-582123 I have this installation Apache/2.2.14 (Ubuntu), MySQL-client versie: 5.1.41
PHP uitbreiding: mysqli

I have many databases and since yesterday at all these databases some tables are missing. Well according to the error's I see the tables are missing.

I don't have any backup, how to recover these tables?

Need urgent help for this]]> sulo bilo Data Recovery Sat, 20 Apr 2013 03:22:23 +0000 http://forums.mysql.com/read.php?156,577820,577820#msg-577820 How restore BD with bin file!! (no replies) http://forums.mysql.com/read.php?156,577820,577820#msg-577820 The names:
mysql-bin.000001
mysql-bin.000002
.....
mysql-bin.000011
mysql-bin.000012


I tried using the command below, but failed. No warning message appears. As shown at the bottom of the image page.

mysqlbinlog mysql-bin.000001> C:/binlog
or
mysqlbinlog mysql-bin.000001> C:/binlog.txt
or
mysqlbinlog mysql-bin.000001> C:/binlog.sql


the image: http://img266.imageshack.us/img266/9625/mysqlj.png]]> Lucas LucasAhcor Data Recovery Thu, 24 Jan 2013 10:20:31 +0000 http://forums.mysql.com/read.php?156,576501,576501#msg-576501 Restore 'mysql' db dump in ndbcluster environment shows errors while restoring system database 'mysql'. (no replies) http://forums.mysql.com/read.php?156,576501,576501#msg-576501
I have very urgent questions related to backup/restores of databases in a node of ndbcluster environment.

I used mysqldump to backup all the databases. it got successful. Now when i try to restores those db dumps, i see the error in restoring 'mysql' system database.

here are the results:

[root@IfxLinux mysql-cluster]# mysql < /tmp/my.sql
ERROR 1036 (HY000) at line 386: Table 'ndb_apply_status' is read only

error says 'ndb_apply_status' table is read only and restore halts.

even dropping 'mysql' database shows error:
system command = /usr/bin/mysql -u backup --socket=/var/lib/mysql-cluster/mysql.sock -e 'FLUSH PRIVILEGES;drop database `mysql`;' out err = ERROR 1051 (42S02) at line 1: Unknown table 'ndb_apply_status'.


Please help and advise how to resolve this. We are able to restore all other databases apart from 'mysql' database from a dump. Is there any way to drop 'ndb_apply_status' table and recreate it manually later after restore completes?

#Note: we don't want to use start backup and ndb_restore programs.

Since we are in urgency.
Any kind of help is appreciated.]]> piyush nagar Data Recovery Mon, 24 Dec 2012 09:19:03 +0000 http://forums.mysql.com/read.php?156,575054,575054#msg-575054 Script timeout passed (Import) (no replies) http://forums.mysql.com/read.php?156,575054,575054#msg-575054
I read some news and changed the php.ini as below
max_execution_time = 6000
max_input_time = 6000

The backup file just about 700K, anyone can help please~~]]> Small Fai Data Recovery Sun, 02 Dec 2012 09:23:07 +0000 http://forums.mysql.com/read.php?156,573206,573206#msg-573206 InnoDB Transportable Tablespaces - Recovering Data from Stranded .ibd Files is a Thing of the Past (no replies) http://forums.mysql.com/read.php?156,573206,573206#msg-573206 - http://mysqlblog.fivefarmers.com/2012/11/07/smarter-innodb-transportable-tablespace-management-operations/
- http://mysqlblog.fivefarmers.com/2012/09/07/understanding-innodb-transportable-tablespaces-in-mysql-5-6/
- https://blogs.oracle.com/mysqlinnodb/entry/innodb_transportable_tablespaces

InnoDB Transportable Tablespaces - Recovering Data from Stranded .ibd Files is a Thing of the Past
- http://www.chriscalender.com/?p=1078]]> Edwin Desouza Data Recovery Thu, 08 Nov 2012 01:35:47 +0000 http://forums.mysql.com/read.php?156,571715,571715#msg-571715 How to restore dates from ibdata1 and old dump. (5 replies) http://forums.mysql.com/read.php?156,571715,571715#msg-571715 I tried reinstall mySQL 5.5 on virtual machine, then i load old data base from dump. After that i stoped mySQL server and replace ibdata1 file, in my.ini I typed innodb_force_recovery=1 but no result, then innodb_force_recovery=2..6. But no lost datas in old database that I load from old dump.
How can I restor my dates? Can anyone help me?
Thank you all, regards Ruslan.]]> Ruslan Valitov Data Recovery Mon, 19 Nov 2012 04:30:57 +0000 http://forums.mysql.com/read.php?156,569014,569014#msg-569014 Webinar 9/27: MySQL High Availability Realized (no replies) http://forums.mysql.com/read.php?156,569014,569014#msg-569014 https://www1.gotomeeting.com/register/575821320

High availability is about more than making sure that apps can get to your data even if there is a failure. How about when you are upgrading your database schema? What if you need to add memory to a database server or reconfigure/restart MySQL? If your apps want to read data from a MySQL slave, how can you be sure they are not reading stale data without re-coding your apps?

What if your main data center takes a hit? And what if you want better MySQL stability, performance, and simplified administration, but you cannot or do not want to re-write your apps or convert your current data to run with a proprietary MySQL re-write or a promised new version of MySQL?

During this webinar, we will go through a detailed case study to show you how you can start with the MySQL version/build (MySQL Community 5.x, MySQL Enterprise 5.x, MariaDB, Percona, etc.), along with the data and apps that you already have, and iteratively build up a highly-available, scalable, multi-site database infrastructure where you can perform complex data management tasks with single commands.

You will see live demos of the following:
- Transition from MySQL 'native' replication to a Continuent Tungsten cluster with zero app downtime
- Reading consistent data from slaves without app changes (SmartScale)
- Schema upgrade on the master database server with no app downtime (switch operation)
- Automated fail over when a MySQL database server crashes
- Recovery of a failed master to a fully operational slave with a single command
- Switch of database operations to a remote site with no app down time (geo-clustering, cross-site 'switch' operation).

Join us at https://www1.gotomeeting.com/register/575821320 !]]> Petri Virsunen Data Recovery Wed, 19 Sep 2012 20:17:58 +0000 http://forums.mysql.com/read.php?156,568873,568873#msg-568873 InnoDB “corruption” ? (1 reply) http://forums.mysql.com/read.php?156,568873,568873#msg-568873
I am a newbie in using MySQL and I face a problem with InnoDB.

I use

5.1.63-0ubuntu0.11.10.1 Apache/2.2.20 (Ubuntu) MySQL client version: 5.1.63

and receive continosly the following error during reading data from a localy installed mySQL db.

InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 387794.

After rebooting the system, I can gain access again to the db and I can read continuously the "corrupted" data w/o any problem at all (for few minutes or several hours) until the same problem re-appears (for different data read attempts)

Any idea on the source of the problem?

Thanks in advance,

I.



Here is the error.log:

I have checked the HDD with S.M.A.R.T utility and I could not find any problem
I deactivate apprmor w/o any result
I also tried SQL_NO_CACHE option in the query w/o any result
120918 13:07:06 InnoDB: Page checksum 3504102879, prior-to-4.0.14-form checksum 1216630776 InnoDB: stored checksum 2100325079, prior-to-4.0.14-form stored checksum 1216630776 InnoDB: Page lsn 2 1168743501, low 4 bytes of lsn at page end 1168743501 InnoDB: Page number (if stored to page already) 387794, InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0 InnoDB: Page may be an index page where index id is 0 175 InnoDB: (index "PRIMARY" of table "OII"."dataset_cs_1") InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 387794. InnoDB: You may have to recover from a backup. InnoDB: It is also possible that your operating InnoDB: system has corrupted its own file cache InnoDB: and rebooting your computer removes the InnoDB: error. InnoDB: If the corrupt page is an index page InnoDB: you can also try to fix the corruption InnoDB: by dumping, dropping, and reimporting InnoDB: the corrupt table. You can use CHECK InnoDB: TABLE to scan your table for corruption. InnoDB: See also http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. InnoDB: Ending processing because of a corrupt database page. 120918 13:07:07 [Note] Plugin 'FEDERATED' is disabled. 120918 13:07:07 InnoDB: Initializing buffer pool, size = 64.0M 120918 13:07:07 InnoDB: Completed initialization of buffer pool InnoDB: Log scan progressed past the checkpoint lsn 2 2380293142 120918 13:07:07 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 2 2380293162 120918 13:07:07 InnoDB: Started; log sequence number 2 2380293162 120918 13:07:07 [Note] Event Scheduler: Loaded 0 events 120918 13:07:07 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.63-0ubuntu0.11.10.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)]]> Ingmar Sandberg Data Recovery Wed, 26 Sep 2012 05:34:42 +0000 http://forums.mysql.com/read.php?156,568306,568306#msg-568306 Trying to repair bad table in MySQL (5 replies) http://forums.mysql.com/read.php?156,568306,568306#msg-568306
I will start by apologizing for being a MySQL “noob”.

We are working on a customer’s DB that appears to have corrupted data in at least one field in row 3600. We found the corruption when attempting to upgrade the DB to a newer version of our medical application (my company is a VAR). When our conversion runs it hangs in this table at row 3600 (there are a total of 97450 records in the table) and the MySQL service kicks offline.

We have tried MySQL querys to…

1) delete the bad record
2) replace the data in the bad field with a null or “” or a space
3) dump the bad table to a file (thinking we could remove the bad record(s) and reimport the data to an empty table)

Every time we hit the bad record the MySQL service kicks offline. The only thing we can do with the table is a count of all records. We can also read the data out of the first three fields, when we attempt to read the data in the fourth field the MySQL service kicks offline. Our software application appears to run okay though I am sure it would crash if we could identify the patient with the bad data.

All the MySQL repair articles I have found detail the steps of the repair using the MySQL command line (which I assume is the MySQL shell) but they all appear to require the MyISAM engine. This DB is setup using the InnoDB engine and when I attempt to convert the offending table to MyISAM the MySQL service kicks offline.

This older version of our medical application uses Version: '5.0.26-community-nt' socket: '' port: 5153 MySQL Community Edition (GPL). I have tried all the MySQL Query Browser versions from 1.1.9 to 1.1.20 and the latest version of MySQL WorkBench and always get the same results. The err logs don’t seem to be any help (though I included some info from it at the end of this post).

I started out working in a Windows Server 2003 EE VPS and am now on a dedicated Windows box running Windows Vista Home Premium SP2 with an AMD Phenom II x4 955 processor running at 3.2 Ghz and 2 Gig Ram.

The table structs are…
CREATE TABLE `soapware_charts_xmldocumentitems` (
`DocumentItemID` varchar(36) NOT NULL default '',
`DocumentID` varchar(36) NOT NULL default '',
`ItemType` varchar(50) NOT NULL default '',
`ItemData` longtext NOT NULL,
`CheckSum` varchar(50) NOT NULL default '',
`ItemName` varchar(50) default '',
`Deleted` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`DocumentItemID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 4096 kB; InnoDB free: 5120 kB; InnoDB free: 512'$$

We are up against the wall and any help would be roundly appreciated.

Mark Beans
MedicalAIS.com



Here are a few lines related to the crash in the .err log…

120912 12:44:07 InnoDB: Started; log sequence number 38 286627932
120912 12:44:07 [Note] C:\Program Files\SOAPware\SOAPware DataServer\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.26-community-nt' socket: '' port: 5153 MySQL Community Edition (GPL)
120912 13:14:29 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120912 13:14:29 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 38 286627942.
InnoDB: Doing recovery: scanned up to log sequence number 38 286627942
InnoDB: Last MySQL binlog file position 0 0, file name
120912 13:14:29 InnoDB: Started; log sequence number 38 286627942
120912 13:14:29 [Note] C:\Program Files\SOAPware\SOAPware DataServer\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.26-community-nt' socket: '' port: 5153 MySQL Community Edition (GPL)
120912 13:29:45 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120912 13:29:45 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 38 286627952.
InnoDB: Doing recovery: scanned up to log sequence number 38 286627952
InnoDB: Last MySQL binlog file position 0 0, file name
120912 13:29:46 InnoDB: Started; log sequence number 38 286627952
120912 13:29:46 [Note] C:\Program Files\SOAPware\SOAPware DataServer\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.26-community-nt' socket: '' port: 5153 MySQL Community Edition (GPL)]]> Mark Beans Data Recovery Tue, 09 Oct 2012 07:02:15 +0000 http://forums.mysql.com/read.php?156,565466,565466#msg-565466 Restore InnoDB data basing on .frm and common ibdata file (6 replies) http://forums.mysql.com/read.php?156,565466,565466#msg-565466
I can't launch my MySQL instance. Below will show you logs.
When it were in working state it has been of version 5.0.65. Than MySQL hang and I decided to kill the processess. Aftermath I upgraded it to Percona 5.5 and tried to start. It were unable to start because of ib_logfiles incostintency error (don't remember exactly).
I have saved original ib_logfiles0/1 and ibdata1/2. Then removed existing and started MySQL. It has created new files and now started successfully.
Then I took my ib* files and directiory of database with .frm files and copied it to test server where I have MySQL 5.5.24.

But when I start MySQL it shows me: 

# /usr/sbin/mysqld --innodb_force_recovery=4
120818 14:16:03 [Note] Plugin 'FEDERATED' is disabled.
120818 14:16:03 InnoDB: The InnoDB memory heap is disabled
120818 14:16:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120818 14:16:03 InnoDB: Compressed tables use zlib 1.2.3
120818 14:16:03 InnoDB: Using Linux native AIO
120818 14:16:03 InnoDB: Initializing buffer pool, size = 128.0M
120818 14:16:03 InnoDB: Completed initialization of buffer pool
120818 14:16:03 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120818 14:16:03  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Warning: a page in the doublewrite buffer is not within space
InnoDB: bounds; space id 0 page number 174801, page 0 in doublewrite buf.
InnoDB: Warning: a page in the doublewrite buffer is not within space
InnoDB: bounds; space id 0 page number 174810, page 1 in doublewrite buf.
InnoDB: Warning: a page in the doublewrite buffer is not within space
...
many times of similar output
...
InnoDB: Warning: a page in the doublewrite buffer is not within space
InnoDB: bounds; space id 0 page number 331774, page 126 in doublewrite buf.
InnoDB: Warning: a page in the doublewrite buffer is not within space
InnoDB: bounds; space id 0 page number 331775, page 127 in doublewrite buf.
InnoDB: Error: trying to access page number 247048 in space 0,
InnoDB: space name ./ibdata1,
InnoDB: which is outside the tablespace bounds.
InnoDB: Byte offset 0, len 16384, i/o type 10.
InnoDB: If you get this error at mysqld startup, please check that
InnoDB: your my.cnf matches the ibdata files that you have in the
InnoDB: MySQL server.
120818 14:16:03  InnoDB: Assertion failure in thread 140573762901792 in file fil0fil.c line 4434
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
12:16:03 UTC - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.


key_buffer_size=16777216
read_buffer_size=131072
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 346679 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x29)[0x7fd9e1880eb9]
/usr/sbin/mysqld(handle_fatal_signal+0x3d8)[0x7fd9e17691d8]
/lib/x86_64-linux-gnu/libpthread.so.0(+0xf030)[0x7fd9e0f23030]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35)[0x7fd9df9d3475]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x180)[0x7fd9df9d66f0]
/usr/sbin/mysqld(+0x5eed67)[0x7fd9e1940d67]
/usr/sbin/mysqld(+0x5cb450)[0x7fd9e191d450]
/usr/sbin/mysqld(+0x5cbb1f)[0x7fd9e191db1f]
/usr/sbin/mysqld(+0x5bcc5c)[0x7fd9e190ec5c]
/usr/sbin/mysqld(+0x5a8eef)[0x7fd9e18faeef]
/usr/sbin/mysqld(+0x5b3357)[0x7fd9e1905357]
/usr/sbin/mysqld(+0x5e1006)[0x7fd9e1933006]
/usr/sbin/mysqld(+0x5e20b9)[0x7fd9e19340b9]
/usr/sbin/mysqld(+0x5cea24)[0x7fd9e1920a24]
/usr/sbin/mysqld(+0x57f0da)[0x7fd9e18d10da]
/usr/sbin/mysqld(+0x54de9f)[0x7fd9e189fe9f]
/usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x41)[0x7fd9e176b471]
/usr/sbin/mysqld(+0x32ad87)[0x7fd9e167cd87]
/usr/sbin/mysqld(_Z11plugin_initPiPPci+0xa43)[0x7fd9e1680163]
/usr/sbin/mysqld(+0x2b3895)[0x7fd9e1605895]
/usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x45b)[0x7fd9e160650b]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd)[0x7fd9df9bfead]
/usr/sbin/mysqld(+0x2abd29)[0x7fd9e15fdd29]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.

I also downloaded innodb-tools but seem to be I'm not prefoessional enough to operate with that.

So now I have all ibdata files, all ib_logfiles, all .frm files but can't lauch MySQL to dump them.

What can I do now?]]> Michael Abramovich Data Recovery Thu, 23 Aug 2012 07:53:10 +0000 http://forums.mysql.com/read.php?156,564944,564944#msg-564944 Recovery from a MySQL dump is too long ! (1 reply) http://forums.mysql.com/read.php?156,564944,564944#msg-564944
My INNODB database has a size of 80GO. I've a replication setup on 3 slaves and I backup my db from them.

If a problem occurs on the database, a recovery from a dump takes around 6H ! That's too long for us.

2 ideas :

1. Stop the slave and doing a copy of the folder (/var/lib/mysql). Then, I can copy it on another server daily.

2. Stop the slave, take a dump and when it's finish, pull the dump in another MySQL instance daily.

Do you have another idea ? What's your advices ?]]> Bob Sauvage Data Recovery Wed, 15 Aug 2012 21:15:10 +0000 http://forums.mysql.com/read.php?156,563835,563835#msg-563835 Copy of data folder (1 reply) http://forums.mysql.com/read.php?156,563835,563835#msg-563835
I we have problem with harddisk of the server,Suddenly the machine is down, So as there is no any other way to backup of the database i copied all the data which is in /varlib/mysql and send that to another machine and then changed the file and folder permissions and ownerships which the original one have, after that i restarted the server.Here comes the problem with this, mysql could not start again and errors in the error log is

120803 12:02:10 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
120803 12:02:10 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)

I could understand what to do.

THe complete error log is

InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120803 16:00:10 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120803 16:00:11 InnoDB: Started; log sequence number 0 47587
120803 16:00:11 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
120803 16:00:11 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)

What to do any idea please.]]> dileep ch Data Recovery Fri, 10 Aug 2012 05:22:11 +0000 http://forums.mysql.com/read.php?156,563755,563755#msg-563755 ERROR 1064 (42000) when loading v5.0.45 db (no replies) http://forums.mysql.com/read.php?156,563755,563755#msg-563755
ERROR 1064 (42000) at line 36138: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''PK\0\\0\0\0!\0¬PW\0\0À\0\0\[Content_Types].xml ¢( \0\0\0\0\0\0' at line 1]]> Joe Lloyd Data Recovery Thu, 02 Aug 2012 18:04:24 +0000 http://forums.mysql.com/read.php?156,561511,561511#msg-561511 data Lost in recovery (1 reply) http://forums.mysql.com/read.php?156,561511,561511#msg-561511
I have a table that got currupted. it has almost 600k regist's but when it recovers it shows only 19.

i tried several ways with repair and myisamchk. none worked.

log of recovery tells wrong bytesec, any idea how to restore it?

repair log:
- recovering (with keycache) MyISAM-table [PATH]
Data records: 577073
Wrong bytesec: 0- 0- 0 at 0; Skipped
Data records: 19]]> Sérgio Vicente Data Recovery Thu, 19 Jul 2012 08:35:08 +0000 http://forums.mysql.com/read.php?156,561055,561055#msg-561055 MyISAM Recovery from files, not loaded (no replies) http://forums.mysql.com/read.php?156,561055,561055#msg-561055 We had got a desaster in our server, where had to recover the DB directly from files, where I had severl innodb, and MyISAM databases.

All was fine, unless the crm DB, it's not being loaded by mysql, where I have copied all over the /var/lib/mysql directory, and repast it in the new server.

The error in that DB, it's absolutly not being load by mysql, and when i go to it's directory, it's not showing it's files as a directory, if not, as a one single file, not a directory, when i try to open it with nano, i see all the db information there, in sql format, but something absolutly wrong.

Even, when i try to create another db with the same name, mysql admin is decling that as the dabase exist, but it's not being loaded.

Any idea, or help, please?]]> Ubunter Lynux Data Recovery Fri, 13 Jul 2012 10:01:19 +0000 http://forums.mysql.com/read.php?156,560163,560163#msg-560163 Corrupt Schema (1 reply) http://forums.mysql.com/read.php?156,560163,560163#msg-560163 Ryan Bradley Data Recovery Thu, 12 Jul 2012 04:37:44 +0000 http://forums.mysql.com/read.php?156,557515,557515#msg-557515 innodb recovery (1 reply) http://forums.mysql.com/read.php?156,557515,557515#msg-557515 My website has crashed a few days ago.

Hosting company says some innodb database crashed.

They send mysql data folder. i tried to restore database. but phpmyadmin only showing MyISAM tables.

I checked database with navicat. when i click innodb table, i got this error "table 'xyz.wp_posts' doesn't exist"

is there anyway to fix this on windows?

feel free to download db
www.degisimanaliz.com/xyzdb.tar.gz

very old backup
www.degisimanaliz.com/29_Ocak_Yedek_deganaliz.sql.gz

sorry for my english

Have a nice day]]> cnar duzen Data Recovery Thu, 21 Jun 2012 03:27:52 +0000 http://forums.mysql.com/read.php?156,540575,540575#msg-540575 lost files after system restore (no replies) http://forums.mysql.com/read.php?156,540575,540575#msg-540575
How do I recover files after system restore wipe?
please please please help I had alot of viruses so i did system restore with a recovery cd and wiped everything and i forgot i had reallly really reallllly precious stuff on there and now its gone could someone please help me if possible.

system restore lost files


Plz help and suggest me.

Thanks for your suggestion]]> mabdwasoft drew Data Recovery Thu, 24 May 2012 05:45:32 +0000 http://forums.mysql.com/read.php?156,528550,528550#msg-528550 Physical Replication using RBL (no replies) http://forums.mysql.com/read.php?156,528550,528550#msg-528550
Is it possible to take mysqlbinlogs that are generated using RBL method and can it be applied to DR database? Using source prod_RBL_binlog.sql I get max_allowed_packets exceeded the limit. Whereas am importing file size of about 500MB and set the max_allowed_packets=1024M, and client also as 1024M. But I still get the same error. Is my approach is fine first of all? If not please let me know.

It works fine with SBL. Only RBL is it possible to do this way?

mysqlbinlog master_bin.0001 master_bin.0002 master_bin.0003 > /mysql1/snapshot/first_reg_bins_$time_stamp.sql

Above is the way I get prod_RBL_binlog.sql for RBL. Please suggest.]]> Mannoj Kumar Data Recovery Fri, 27 Apr 2012 08:20:01 +0000 http://forums.mysql.com/read.php?156,527550,527550#msg-527550 Advanced Multi-Master Solutions Made Easy with Continuent Tungsten (no replies) http://forums.mysql.com/read.php?156,527550,527550#msg-527550 https://www1.gotomeeting.com/register/656585273

Continuent Tungsten has broken new ground to make previously complex or completely unattainable MySQL data management solutions simple and easy to deploy. Continuent Tungsten brings high availability, performance scaling, and simple cluster management to off-the-shelf MySQL. Continuent Tungsten also includes advanced multi-master topologies that enable users to spread data across clusters and sites.

In this webinar we show how to architect and manage cutting edge data management topologies. We start with simple clustering, build up to multi-master/multi-site, and end by illustrating how to integrate your MySQL systems to other DBMS types. The webinar includes live demos of simple failover, DR site setup, and fan-in from multiple sites to a single reporting server. By the end of the talk you will understand how Continuent Tungsten works and the problems you can solve with it.

Continuent Tungsten customers include American Express, AT&T, Constant Contact, F-Secure, Financial Times, Juniper Networks, Hearst Magazines UK, Marketo, Norwegian Broadcasting Corporation, Sony Music Entertainment, Thomson Reuters and Zappos.com, an Amazon company. The largest Tungsten Enterprise deployment processes 500,000,000 transactions per day on 150TB of managed data.

Join us at https://www1.gotomeeting.com/register/656585273 to learn how you can put the power Tungsten to use today!]]> Petri Virsunen Data Recovery Wed, 25 Apr 2012 20:24:19 +0000 http://forums.mysql.com/read.php?156,523933,523933#msg-523933 Database Recovery (1 reply) http://forums.mysql.com/read.php?156,523933,523933#msg-523933
I have recovered a database from a failed hard drive and am trying to revive it on a new system. I have installed MySQL, copied over the folder containing the FRM, MYI, and MYD as well as the ibdata1 file. I changed permissions on the restored files for my system and restarted MySQL. I can login to MySQL, switch to the database, and see all the tables but when I attempt to query or any repair I recieve "table 'blah' doesn't exist. Is there something I'm missing in the restore? Is there anyway to salvage to the data? Hope all is well and thanks in advance.]]> Phill Vanderpool Data Recovery Mon, 23 Apr 2012 10:31:56 +0000 http://forums.mysql.com/read.php?156,522182,522182#msg-522182 recovery mysql 5.5 (no replies) http://forums.mysql.com/read.php?156,522182,522182#msg-522182
please suggest any solution. The platform is windows XP.]]> S Justus Data Recovery Wed, 28 Mar 2012 13:51:52 +0000 http://forums.mysql.com/read.php?156,521512,521512#msg-521512 Building a Multi-master, Multi-region MySQL Infrastructure in Amazon EC2 (no replies) http://forums.mysql.com/read.php?156,521512,521512#msg-521512 https://www1.gotomeeting.com/register/429957080

Tuesday, 4/3 @ 9 am ET/15:00 CEST/14:00 BST/16:00 EEST
https://www1.gotomeeting.com/register/118613520

Your company has built a great new app and launched it in the cloud. And now you are seeing what many wish for: an exponential adoption of your app. But is your database tier really up to the job?

- What happens if your MySQL server fails?
- Can you fail over to a replica quickly?
- Do you even have a replica to fail over to?
- Can you keep your app available even as you upgrade your database schema or add additional or more powerful database servers?
- Can you easily scale read operations by load balancing them across a set of replicas?
- Do you have a way to maintain a set of data that is globally accessible, across Amazon EC2 regions in the USA, Europe, APAC, Japan etc., and that allows app users to get to and update their data with minimal latency, no matter where they are located?
- How do you make sure that an update made in a database in Japan gets propagated to databases in Europe, USA, APAC etc. with minimal latency?

This webinar focuses on the ways that Tungsten Enterprise can help you to solve these issues by combining local MySQL clusters, for high-availability and scalability, with cross-region, multi-master replication to maintain a globally distributed database.]]> Petri Virsunen Data Recovery Fri, 23 Mar 2012 22:34:18 +0000 http://forums.mysql.com/read.php?156,516150,516150#msg-516150 Table names appear in 'show tables'; but tables don't exist (1 reply) http://forums.mysql.com/read.php?156,516150,516150#msg-516150
Last night an application started reporting MySQL errors. I checked the logs and found errors of the form

ERROR 1146 (42S02): Table 'Database.Table' doesn't exist

When I run "show tables" I see the correct list of tables, but when I try to access any table, e.g. by running "SELECT * FROM Table" I get an error message saying that the table doesn't exist. When I run "repair table Table" I get

+----------------+--------+----------+--------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------+--------+----------+--------------------------------------+
| Database.Table | repair | Error | Table 'Database.Table' doesn't exist |
| Database.Table | repair | error | Corrupt |
+----------------+--------+----------+--------------------------------------+

All the tables use the InnoDB storage engine.

What could cause this error, and is there any way to recover the data?]]> Jonathan Turkanis Data Recovery Sat, 24 Mar 2012 06:36:58 +0000 http://forums.mysql.com/read.php?156,515768,515768#msg-515768 recover from dump, what is state field list? (no replies) http://forums.mysql.com/read.php?156,515768,515768#msg-515768
The size of the MYD is 1.7G and MYI is 599M. The sizes has not changed at all over the past hour. Is the process stuck?

And what does the command 'Field List' mean in show processlist? I am finding it difficult to find information on this.]]> athiq rahman Data Recovery Thu, 16 Feb 2012 14:11:59 +0000 http://forums.mysql.com/read.php?156,514383,514383#msg-514383 Recover data from raw files (2 replies) http://forums.mysql.com/read.php?156,514383,514383#msg-514383
My system has been crashed and has reloaded the windows 7 operating system. I don ’t have any MySQL database backup; is it possible recover my data from raw files ?

MySQL Version 5.1

Thanks & Regards
Thahir]]> Thahir Pattanathel Data Recovery Sat, 24 Mar 2012 10:42:12 +0000 http://forums.mysql.com/read.php?156,513354,513354#msg-513354 entire server restore with dumps of user databases system database along with transaction log backups (no replies) http://forums.mysql.com/read.php?156,513354,513354#msg-513354

I have taken the backup in the following way:

Backup steps:
1.db1,db2,db3 and mysql system databases dumped using mysqldump one by one.
mysqldump db1 >db1.sql

2.flush logs done and noted down the new LogNumber for each database which should the starting log number from which we have to apply logs for that database.

3.copied all logs to media as part of incremental backups.

Restore method I am trying to follow:

1. for each database.sql file
mysql -u user -ppassword dbname <dbname.sql

2. Now I am trying to apply the log files after filtering using mysqlbinlog.
For each database
{
for each log file
{
mysqlbinlog -s dbname logfile > tempfile
mysql dbname <tempfile
}
}


Issue:
User databases are getting restored correctly. But system database 'mysql' is not getting restored upto latest. Any new users created/dropped, etc that get reflected on system database that went into transaction logs are not getting restored.
I can only see the system database 'mysql' content that was backedup using mysqldump. Roll forwarding logs is not bringing further changes.


when I run mysqlbinlog commmand with 'mysql' i get no entries filtered.

Does any have a way to overcome this?


--
Thanks in Advance,
Ravi Thati]]> Ravi Thati Data Recovery Thu, 02 Feb 2012 15:02:18 +0000 http://forums.mysql.com/read.php?156,513221,513221#msg-513221 Import MySQL database lock (1 reply) http://forums.mysql.com/read.php?156,513221,513221#msg-513221
I'm trying to import big database, the reel size of database is 136G.
Well i've impored 128G and the import was locked, i don't really know what cause this.

And i don't really want to drop database and launch again the import. Please find here the information needed :

mysql> show processlist;
+-------+------+-----------+-------+------------+------+-------------------+--------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+------+-----------+-------+------------+------+-------------------+--------------------------------------------------+
| 10578 | root | localhost | openx | Query | 6979 | update | INSERT INTO `banner_vast_element_seq` VALUES (3) |
| 10582 | root | localhost | openx | Field List | 4458 | Waiting for table | |
| 10583 | root | localhost | openx | Sleep | 4197 | | NULL |
| 10585 | root | localhost | openx | Query | 4278 | Waiting for table | DROP TABLE IF EXISTS `banner_vast_element_seq` |
| 10586 | root | localhost | openx | Sleep | 4 | | NULL |
| 10587 | root | localhost | NULL | Sleep | 3082 | | NULL |
| 10588 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+-------+------+-----------+-------+------------+------+-------------------+--------------------------------------------------+
7 rows in set (0.00 sec)]]> mezgani ali Data Recovery Tue, 07 Feb 2012 04:20:49 +0000 http://forums.mysql.com/read.php?156,511543,511543#msg-511543 physical restore from frm and ibdata1. How to connect StoredProcedures and Functions? (no replies) http://forums.mysql.com/read.php?156,511543,511543#msg-511543

I want to restore all my MySQL-DBs from a physical backup of all frm-files and ibdata1-file. I copied the whole data directory from a linux mysql server to a windows mysql server (I put all frm and ibdata1 into the mysql data folder.).
Now, in the windows mysql server I can see all schema. But in the schemas all stored procedures and functions are missing. I checked the proc-table in mysql-schema, all stored procedures and functions are listened there.

Could somebody help me what I have to do that the procedures and functions are in the corresponding shemas?

thanks,
Matthias]]> Mat Wel Data Recovery Tue, 24 Jan 2012 10:11:35 +0000