LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
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 09-24-2006, 03:26 PM   #1
dbc001
Member
 
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:
Quote:
/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:
Quote:
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,
dbc
 
Old 09-25-2006, 12:19 AM   #2
leandean
Member
 
Registered: Oct 2005
Location: Burley, WA
Distribution: Sabayon
Posts: 276

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

http://dev.mysql.com/doc/refman/5.0/...tallation.html
 
  


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


All times are GMT -5. The time now is 04:45 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration