Tagged Questions

1
vote
1answer
95 views

How to recover/restore corrupted Innodb data files?

A while ago, my Windows 7 system on which a MySQL Server 5.5.31 was running crashed and corrupted the InnoDB database. The weekly backup that's available does not cover all the tables that were ...
0
votes
2answers
52 views

Can I find out what version of MySQL from the data files?

I have a very odd situation going on here. I had a linux box running ubuntu 8.10 and MySQL server with a Wordpress installation on it hosting an internal blog for our company. The machine that this ...
2
votes
1answer
190 views

Restore InnoDB tables / database using only data files

I have MySQL Server 5.1.51 installed on Windows Server 2003 as Operating System and using InnoDB as database engine. I have run DROP DATABASE dbName statement by mistake. I have no backup of that ...
0
votes
1answer
123 views

while restoring mysql database, views changed into tables

I have a full database dump and i restored it. But in my new restored server all the views are appeared as MyISAM tables. In early times dumps were restored perfectly. can anyone help me to trigger ...
1
vote
1answer
388 views

ERROR 1100 (HY000) at line 11084: Table 'search_index' was not locked with LOCK TABLES

I'm trying to import a mysqldump backup of a drupal database taken from a server running MySQL 5.0 (which will be upgraded to 5.5) onto my local machine running MySQL 5.5.23. The import fails with the ...
3
votes
1answer
953 views

MySQL Restore Large Dump

I have a dump file of a single table which is 7GB. I try to restore it using mysql -u root -p DB_NAME < .SQL FILE But I don't see any activities in task manager. CPU is 00 and RAM is 5,700 K. I ...
1
vote
1answer
79 views

mysql server password change while restoring

I restored all database backup from another server's dumpfile to my machine. At the end my mysql server's password changed to that mysql server's password. Why it got overwritten? What i need to do to ...
3
votes
3answers
4k views

Restore mysql database with different name

Hello Experts, How can we restore mysql database with different name from mysqldump file. I dont't want to open dump file and edit it. Any other better methods.? regards, Praveen
2
votes
1answer
375 views

BACKUP and RESTORE MySQL Database

I have very specific question. I have seen the instructions on how to backup and restore mysql database using SSH but they barely explain the process when backing up on one server and restoring on ...
3
votes
1answer
1k views

Restore dropped mysql database

I create a database each year from the previous year, back up and then clean up the tables. So I have databases for the past 3 years. This year I did not do a backup and accidentally dropped the ...