LinuxQuestions.org
Review your favorite Linux distribution.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 07-08-2011, 01:13 PM   #1
fincher69
Member
 
Registered: Jan 2005
Location: Tallahassee, FL
Distribution: Kubuntu 13.04
Posts: 69

Rep: Reputation: 15
Database stopped showing up, files still there


Howdy all,
I recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. Can anyone point me to 1) why the database no longer shows up 2) how to restore the database from the files? My google'ing hasn't come up with much helpful and I would great appreciate it.
 
Old 07-08-2011, 02:38 PM   #2
szboardstretcher
Senior Member
 
Registered: Aug 2006
Location: Detroit, MI
Distribution: GNU/Linux systemd
Posts: 4,278

Rep: Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694
Is Mysql started?

When you say you moved to a new place, do you mean that you copied your installation over to a new place?

If you mean that you have started MySQL, and that your DB's are no longer listed, then you should check your /etc/my.cnf file to make sure it is pointing to the right directory. If that does not work, make a backup of your MySQL data first, then read this article on how to rebuild your DB's from the ib_ files: http://egil.biz/how-to-recover-mysql-data-from-innodb/

Last edited by szboardstretcher; 07-08-2011 at 02:41 PM.
 
Old 07-09-2011, 01:43 PM   #3
fincher69
Member
 
Registered: Jan 2005
Location: Tallahassee, FL
Distribution: Kubuntu 13.04
Posts: 69

Original Poster
Rep: Reputation: 15
I'm sorry, I should have been more specific. I moved from one apartment to another, but brought the computer and didn't change anything other than just unplugging it and plugging it at the new apartment.

And yes, I have started MySQL and show databases lists one test database that I have, the information_schema and that's it. The wordpress db doesn't show up there. I checked my.cnf and it seemed to be correct. I assume this is verified by the fact that my test database still shows up. When I look in the data directory, I see folders for the test and the wordpress and can't notice any differences that would make mysql recognize one and not the other. I will try those rebuilding instructions and see if that works. Thank you.
 
  


Reply



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
In my database dump txt it is showing some special character as below dhirendrs Linux - Software 1 11-03-2010 08:28 AM
XFCE desktop stopped showing icon knockout_artist Linux - Newbie 1 11-20-2008 09:21 AM
USB external disk stopped showing up on the desktop pwc101 Slackware 21 11-14-2008 12:38 AM
Suse 10.1 LCD stopped showing native 1280 csjens SUSE / openSUSE 2 07-30-2006 04:22 PM
Files not showing up on desktop z9_87 Mandriva 5 05-31-2005 08:37 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 01:23 AM.

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
Open Source Consulting | Domain Registration