0
votes
1answer
288 views

restore mysql from ibdata/frm files

A hard disk failure has left me trying to restore mysql from copy of "data" folder I had dumps of "most" content but am missing some Data folder has idbdata1 / log files / folders of .frm files So, ...
1
vote
1answer
310 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
0answers
1k views

Can you recover a mysql database completely from ibdata1, log and frm files?

Okay, so bouncing off my other question this morning, we had one of our team members run "sudo chmod 775 /" by accident. It brought down the entire site.. Once I was able to get in, nginx came up ...
0
votes
1answer
942 views

How to repair mysql database

I have a database server(Fedora 14) which mysql is running as the database server. Recently that server broke down and I was only able to get the database directory from the server. I have tried to ...
0
votes
1answer
149 views

copy a MySQL table which has data in ibdata file

I have a database in MySQL with several tables. Some of the tables only have .frm files. Some have .frm .mdy .mdi I believe data for the .frm tables is in the ibdata file. There is a lot of data in ...
1
vote
3answers
187 views

Automatic Incremental Off-Site Backups

I'm running a Linux server where incremental backups (ideally daily) are required. I want things to remain fast, but for the backups to be reliable. I'll be using Apache and a MySQL database, what's ...
5
votes
1answer
1k views

I accidently dropped the mysql db

Today, i was absent minded and instead of droping the databases i wanted I wrote drop database mysql; What do i do now!?! i didnt do anything else since and i havent closed my session. Luckily ...
0
votes
1answer
64 views

MySQL 5.0 broken on snow leopard. How to get data into new 5.1 version?

I've seen some similar questions but I am still a bit unsure on what I need to do. I had Mediawiki installed on Leopard. I then Upgraded to snow leopard which broke MySQL. Everything seems to ...
4
votes
1answer
2k views

MySQL data recovery (innoDB) - missing .frm files but intact ibdata

A recent server fiasco left me with a by-all-appearances intact ibdata file but only half of my .frm-containing directories. I've copied all of this to a fresh mysql install, and have successfully ...
3
votes
5answers
4k views

How can I back up and replicate a large MySQL database?

How can I backup a large database in mysql? And what is the best way to replicate the database? what i'm looking for is backing up large database with large amount of data in a small time limit ...