Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a doubt :

Is mariadb support datadirectory location change from the default location to the another user defined location ?

When Iam trying to change datadir location of mariadb by editing the path in the configuration file my.ini, after this, restart the mariadb service, but it couldn't started. Only the default(installation) datadir location worked. The same succefully worked with mysql. Because this is the reason for my doubt...

Please anyone to help me from this issue... (Iam trying in windows)

share|improve this question

1 Answer 1

I am using InnoDB and had the same issue on windows (x64), I got the following error line (don't know what you got):

InnoDB: Error: log file .\ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 52428800 bytes!

What helped was deleting the ib_logfile* files in the data folder from the new location. That created new logfiles w/o losing any data in the database.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.