XAMPPErrorDomain error 1 for changing MySQL data dirs

Question

I tried to move my mysql data dir from one disk to another, I modified the datadir parameter in my.cnf, but when XAMPP, and more precisely, MySQL starts, this error is displayed and MySQL doesn't run.

Operation could not be completed.  
(XAMPPErrorDomain error 1.)  

What's the problem here? I correctly specified the new path.

Solution 1

Look in your logs: apache friends - xampp for linux faq >> Error 1

Solution 2

I also have this problem but none of them works, I compared with files one by one on new machine and the old ones finally find the this works for me:

sudo chown -R nobody:admin /Applications/XAMPP/xamppfiles/var/

Solution 3

Same error. Easily resolved on Mac OSX by changing permissions of the Xampp folder in applications to allow read&write access !

Solution 4

I found a tip elsewhere that says to run:

> sudo ${XAMPP_HOME}/xamppfiles/bin/mysql.server start

I did, and the result was interesting:

> sudo ${XAMPP_HOME}/xamppfiles/bin/mysql.server start
Password:
sudo: /xamppfiles/bin/mysql.server: command not found

Thus ${XAMPP_HOME} is undefined.

So I edited ~/.bash_profile and added the line:

export XAMPP_HOME="/Applications/XAMPP"

After restarting Terminal, our command now yields:

Starting MySQL
. ERROR! Manager of pid-file quit without updating file.

Not sure what to do at this point, but it’s progress.

---

Update: I looked in /Applications/XAMPP/xamppfiles/var/mysql and noticed a .err file (should start with your local computer name, like johns-macbook-pro.local.err). It indicated that my permissions were screwed up: “The error means mysqld does not have the access rights to the directory. File name ./ibdata1”

Setting /Applications/xampp/xamppfiles/var/mysql/ and all its contents to be readable and writable for everyone did the trick. Probably the best solution is to chown -R mysqld /Applications/xampp/xamppfiles/var/mysql/.

View more solutions

Comments

[Petruza]

Thanks, although my error log says nothing about it. Mine is in "Applications/XAMPP/xamppfiles/logs/error_log"

[markratledge]

Try the mysql logs; they may be in different places. (MySQL docs say they're not available in Console.) See serverfault.com/questions/42531/where-is-my-mysql-log-on-os-‌​x And last resort, check that link above for an email for help with that error.

[Petruza]

Thanks, in the end I realized looking at the logs, that mysqld was not using the datadir from my.cnf but instead was following a symbolic link in '/Applications/XAMPP/xamppfiles/var/mysql' pointing to the old data dir. Changed that and it worked, of course. Thanks!

[Alan H.]

Petruza, any more information or details on what you needed to do to clear this error?

[rtf]

Reading this is an answer to the question doesn't really make sense.

[Kai Mattern]

Especially if you just copied back a backup from another machine. Worked for me, too.