0
votes
0answers
101 views

no access to preivous databases in mysql56 after password reset, but showing in data folder

i had problem with mysql (windows machine, mysql5.6) login because of power failure, after trying various solution, i did password reset for root. This helped me to login mysql using root account. But ...
0
votes
0answers
235 views

Mysql won't start after replacing data in datadir.

so I have a little problem. I had errors with our old system and was unable to backup the old databases properly so I went ahead and backed up the datadir which had all of the databases folders inside ...
1
vote
2answers
67 views

MySQL transfer from backups

I had a server die and I have been trying to restore the data onto a new server. I had a mysql database. I have all the files stored in /var/lib/mysql. Each database had a database privileges ...
1
vote
1answer
359 views

MySQL ZRM restore failed with mysql error unknown command \0

I am restoring an incremental backup with ZRM server on mysql database. I am having blob data in the tables. The incremental backup not getting restored and giving mysql error unknown command '\0'. ...
0
votes
1answer
118 views

Recovering InnoDB

Bit of tough situation. Running MySQL 5.5 on Ubuntu 12.04. Looking to add some functionality to our internal site, I installed Kaltura. In doing so, my existing MySQL databases seemed to lose all ...
3
votes
2answers
7k views

Recover mysql database - mysql/mysqldump gives “table <database>.<tablename> doesn't exist (1146)”

Backstory Ubuntu died (wouldn't boot) and I couldn't fix it. I booted a live cd to recover the important stuff and saved it to my NAS. One of the things I backed up was /var/lib/mysql. Reinstalled ...
2
votes
3answers
5k views

Recover MySQL tables from frm files

I'm desperate, and hoping some kind soul can rescue me! I'm dealing with restoring a completely crashed server. Everything is back up except for there's an issue with one domain which uses MySQL (no ...
1
vote
1answer
341 views

Recovering/Rebuilding MySQL .FRM, .MY* files from IBDATA1

I recently had an incident in which several MySQL files were wiped out (mostly from WordPress, but also a few of MySQL’s own files). The IBDATA1 file is unaffected, but several .frm are gone as are a ...
0
votes
1answer
112 views

selectively import “record sets” from one mysql instance to another

I have a mysql server hosting a production database, and routinely I make snapshots of it, which we can also use as a staging environment. Sometime bad things happen, e.g. we delete a row (and all ...
1
vote
3answers
572 views

Restore MySQL Databases from File backups, not MySQL Export

I've got a Windows Server and I get Windows Server Backup to backup all the files every day. I don't however have a system image so I cannot use that. I've tried just copying the database files into ...
0
votes
1answer
1k views

How do I restore MySQL .frm .MYD .MYI files in OS X Lion [duplicate]

Possible Duplicate: How to restore mysql database from the physical files? I received a bunch of these types of files and haven't a clue as how to restore the database on my Mac. I've found ...
0
votes
3answers
117 views

Mysql data recovery

The linux machine on which we have the mysql has crashed due to a power failure. This probably caused the mysql server to crash too and we are not now able to restore/backup/export the database from ...
1
vote
2answers
2k views

Unable to restore a Mysql database using an sql dump file

I am setting up a new project on my development system and am stuck with creating the database. I have a large .sql file to create the database with. At first I created an empty database called ...
1
vote
1answer
197 views

MySQL Database Restore error

Getting the following error: ERROR 2006 (HY000) at line 530: MySQL server has gone away Which I get after running the following from the MySQL (5.1.53-community) command line: CREATE DATABASE ...
5
votes
1answer
455 views

Mysql disaster recovery

We just got a major disaster: somebody made an uncontrolled update on the production database, and obviously, the backup process is not working since a long time, so we got a major data loss. A 40 ...
0
votes
2answers
402 views

automatic mysql backup in windows server 2003 [closed]

someone Know and can recommend me an open source program or freeware software to realize automatics backups in mysql under windows server 2003. I need automatize a task every day. A shareware ...
2
votes
3answers
332 views

What's the best thing to do when you accidentally delete things from a database?

What's the best thing to do when you accidentally delete things from a database that you shouldn't, restore from a backup?
0
votes
1answer
211 views

Rebuilding a MySQL database from 160 retreived files with no name

I had a server crash and it took with it the hard drive. I put the hard drive in a USB enclosure, but the main partition would not mount because the partition was corrupted. I was able to see the USB ...
0
votes
4answers
819 views

How to create empty database from existing one (Mysql)

I have a mysql db with many tables. I'm starting a new farm which should contain empty versions of the same database tables. How can I efficiently create empty database based on existing one?
1
vote
2answers
1k views

Error code 1005 (errno: 121) upon create table while restoring MySQL database from a dump

I have a linux prod machine and a Win7 64bit dev machine. My workflow includes dumping the production MySQL database on the linux machine and restoring it in my local MySQL database on the windows ...
0
votes
1answer
711 views

MySQL Server - Got error -1 from storage engine

I am currently trying to restore a MySQL table from the .ibd file. I have been following the instructions on the MySQL reference manual on how to use DISCARD and IMPORT TABLESPACE to replace the .idb ...
2
votes
5answers
15k views

I accidentally dropped my MySQL database in PhpMyAdmin, is there a possibility to recover my database?

I accidentally dropped my MySQL database in PhpMyAdmin, is there a possibility to recover my database?