Hiya jim,
This could be a few things. Either the database fils has become
corrupted, you put it back in the wrong
place or it is as you say a permissions problem.
MySQL should have other databases, check out the permissions on those.
Also you should have a few
differant files in a directory by the same name as the database (if I
remember correctly) - see how MySQL
stores databases for other/existing tables and copy this (permissions
and all).
Tro try it, make the database files chmod a+rw so everything can read
them, see if it works, then fix
it to be correct :)
It's usually betetr to use mysqldump to take a database dump, then you
do not reply on database binary files,
though so long as the database is shut down whilst you take the backup,
this should be OK too.
Let me kno whow you get on - we can always take this off list to save
everybodys Inboxes :)
--
Leigh Porter
jim corn wrote:
Hi
We were running our MySQL server on a seperate server configured with
a RAID 1 (Mirror). One of the drives died and the mirror was not
working as expected...so i pulled both drives, re-installed the os and
mysql, etc. I took the data from the mysql directory on the old drive
and dumped it into the mysql directory on the new drive...but I seem
to be having troubles with permissions or something like that, as
Webmin will no longer allow me to connect to mange the DB...any
ideas...how should I have restored in such a case. Thanks.
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
jffnms-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jffnms-users
