MySQL Forums :: MyISAM :: Changing Data directory

Advanced Search

Changing Data directory
Posted by: Danny Stommen ()
Date: September 23, 2010 06:20AM

I'm having problems understanding where MyIsam saves the data. So far, I only used InnoDB. In MySQL Administrator -> Start up variables -> InnoDB parameters: I can see 'Data directory'. The location I entered here is were the data is saved. I can see this in Windows Explorer.

But I can't find this field under 'MyISAM parameters'. But under 'General parameters' it is. Why can InnoDB overrule the data directory, but MyIsam can't?

What happens if I change the data directory in the general parameters section? What happens to the current data? Will it be moved to the new location? Or will it result in errors?

Options: ReplyQuote

Subject Views Written By Posted
Changing Data directory 2850 Danny Stommen 09/23/2010 06:20AM
Re: Changing Data directory 1157 Rick James 09/24/2010 11:29PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.