LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 10-08-2014, 11:15 PM   #1
cbtshare
Member
 
Registered: Jul 2009
Posts: 619

Rep: Reputation: 42
mysql trouble


Hello,
I have a mysql datbase, I believe it was upgraded and nw .MYI and .MYD files are gone, I still have ibdata1 and iblogfile0 and 1 as well as the .FRM file, is there anyway I can recover the database, I'm checking online and find only the solution for wamp servers.copying the ibdata and ib_log files into the database directory doesnt workif I stop and start the server..

I am on ubuntu 10.04

mysql service starts and stops fine

database is accessible , only 2 tables from the database are missing the .myi and .myd files

Table engine is MyISAM

Thank you

Last edited by cbtshare; 10-09-2014 at 12:34 AM.
 
Old 10-09-2014, 05:30 AM   #2
EODSteven
Member
 
Registered: Oct 2012
Location: Manchester, Tn
Distribution: Ubuntu 14.04, Windows 8, Windows Server 2012. Ubuntu Server 14.04
Posts: 196

Rep: Reputation: 3
I am not saying it can't be done but I researched this not to long ago and unless you did or can do a mysqldump I don't think you can recover the database. I guess in a way this is a security feature. The dump command is not ran inside MySql but from the terminal...Let me know if you need the syntax for the command.

Last edited by EODSteven; 10-09-2014 at 05:33 AM.
 
Old 10-13-2014, 04:36 PM   #3
cbtshare
Member
 
Registered: Jul 2009
Posts: 619

Original Poster
Rep: Reputation: 42
Quote:
Originally Posted by EODSteven View Post
I am not saying it can't be done but I researched this not to long ago and unless you did or can do a mysqldump I don't think you can recover the database. I guess in a way this is a security feature. The dump command is not ran inside MySql but from the terminal...Let me know if you need the syntax for the command.
Thank you for your time taken to actually reply.I ended up fixing the issue, because I still had the .frm which is the structure, but no .myd and .myi, so I created those files and then repaired the table inside mysql and then no further errors were thrown, I couldnt however get back old data in those tables because I didnt have a dump.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Trouble with mysql i-Dream Linux - Newbie 1 07-20-2012 12:24 AM
mysql trouble razzera Linux - Server 5 03-30-2010 09:07 PM
Mysql 5.0.41 trouble. Sn!per[SWE] Linux - Server 0 05-11-2007 10:09 AM
MySql trouble Die Woud Linux - Networking 5 11-12-2005 12:10 PM
MySQL trouble gruger Linux - Networking 3 07-14-2003 01:47 PM


All times are GMT -5. The time now is 09:38 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration