Re: Changing Database Files Path

From: The Natural Philosopher <tnp_at_invalid.invalid>
Date: Mon, 21 Nov 2016 07:40:26 +0000
Message-ID: <o0u8db$teh$1_at_news.albasani.net>


On 21/11/16 04:03, Thomas 'PointedEars' Lahn wrote:
> Robert Wolfe wrote:
>
>> Well, trying to put together a LAMP server based on Raspbian 8 and for
>> some reason, when I go to move the database files over to my evternal
>> 1TB USB drive, I get a message saying that mysql is unable to start --
>> even though the permissions have not stayed the same and the value in
>> the datadair setting is correct.
>
> You can not just copy or move MySQL database files, you have to create and
> import a database dump to maintain data integrity. This has been discussed
> here *very* often before.
>
Odd. I have done it often with ISAM files.

-- 
"The great thing about Glasgow is that if there's a nuclear attack it'll 
look exactly the same afterwards."

Billy Connolly
Received on Mon Nov 21 2016 - 08:40:26 CET

Original text of this message