Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 09-24-2006, 04:26 PM   #1
Registered: Jan 2004
Distribution: Slackware, Ubuntu
Posts: 97

Rep: Reputation: 15
mySQL can't find files after moving to new server

My old server died, so I built a new one. I was able to pull the mysql files from /var/lib/mysql so I still have all my data. After a little bit of work I managed to access the data in phpmyadmin, but my php apps still can't connect to their databases.

First I moved all my data from /var/lib/mysql . Then I chmod'd, chgrp'd & chown'd everything as follows:
/var/lib/mysql# chmod -R 660 wordpress/
/var/lib/mysql# chown -R mysql wordpress/
/var/lib/mysql# chgrp -R mysql wordpress/
and here is the tail of my /var/lib/hostname.err file:
060924 15:18:48 [ERROR] /usr/libexec/mysqld: Can't find file: './wordpress/wordpress.frm' (errno: 13)
060924 15:18:48 [ERROR] /usr/libexec/mysqld: Can't find file: './wordpress/wordpress.frm' (errno: 13)
I've done this for several databases and all still give errors. Phpmyadmin can read the databases without problem though, and I've gone into the priveleges and granted the appropriate permissions for the correct user via phpmyadmin. If anyone could help me troubleshoot I would much appreciate it!

thanks in advance,
Old 09-25-2006, 01:19 AM   #2
Registered: Oct 2005
Location: Burley, WA
Distribution: Sabayon, Debian
Posts: 278

Rep: Reputation: Disabled
You didn't create grant tables.


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
php5 ./configure error: Cannot find MySQL header files ldp Linux - Software 28 08-26-2011 01:25 PM
copy support-files/mysql.server, how do I tommytomato Fedora 2 11-13-2009 11:58 PM
LXer: Backup MySQL databases, web server files to a FTP server automatically LXer Syndicated Linux News 0 08-11-2006 10:54 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
cannot find mysql include files lsimon4180 Linux - Software 5 03-25-2005 03:41 PM

All times are GMT -5. The time now is 11:05 AM.

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