Problem with xampp

I still got a problem with xampp.
I can work locally for sometime but after an hour or two I always get en error massage in phpmyadmin:

#1 - Can’t create/write to file ‘C:\xampp\ mp\#sql_141c_0.MYD’ (Errcode: 17)

I’ve found some solution - I defragmentate the c disc and everything is fine. But for some reason after sometime I still get that error.
How can I fix permanently?

before using zampp, was there mysql installed in your system? bcoz separate versions of mysql can conflict and through errors.

There’re mysql and phpmyadmin folders but neither of them include log folder :confused:

Try searching for a file called mysql.log xamp must have a different folder structure to wamp

Anything showing up in your mysql log around about the times that you get the error?

I don’t know.
It looks like that:
Suddenly all my categories in wp-admin and on localhost site disappear.
And when I try use PHPMyAdmin I get that error.
That’s it.

It helps when I make defragmentation of c:/ disc.

When PHPMyAdmin is giving the error, do all other apps on the server give a similar error?

What version of windows is it on?

did you check permissions for the parent directories c:\xampp\ mp\ (folders)?
what version of phpMyAdmin & database engine are you using?

I’ve only seen an error message like that once - in my logs for my live site.

The host was “swapping out” the database at the time.

Maybe try reinstalling MySQL?

I’ve only found apache log folder. Logs from the day when there’s an error:


[Sat Sep 18 00:55:27 2010] [notice] Parent: child process exited with status 1073807364 -- Restarting.
[Sat Sep 18 12:42:26 2010] [warn] pid file C:/xampp/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Sat Sep 18 12:42:27 2010] [notice] Digest: generating secret for digest authentication ...
[Sat Sep 18 12:42:27 2010] [notice] Digest: done
[Sat Sep 18 12:42:49 2010] [notice] Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i mod_autoindex_color PHP/5.2.8 configured -- resuming normal operations
[Sat Sep 18 12:42:49 2010] [notice] Server built: Dec 10 2008 00:10:06
[Sat Sep 18 12:42:49 2010] [notice] Parent: Created child process 6108
[Sat Sep 18 12:42:57 2010] [notice] Digest: generating secret for digest authentication ...
[Sat Sep 18 12:42:57 2010] [notice] Digest: done
[Sat Sep 18 12:43:07 2010] [notice] Child 6108: Child process is running
[Sat Sep 18 12:43:07 2010] [notice] Child 6108: Acquired the start mutex.
[Sat Sep 18 12:43:07 2010] [notice] Child 6108: Starting 250 worker threads.
[Sat Sep 18 12:43:07 2010] [notice] Child 6108: Starting thread to listen on port 443.
[Sat Sep 18 12:43:07 2010] [notice] Child 6108: Starting thread to listen on port 80.
[Sat Sep 18 14:16:01 2010] [warn] pid file C:/xampp/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Sat Sep 18 14:16:01 2010] [notice] Digest: generating secret for digest authentication ...
[Sat Sep 18 14:16:01 2010] [notice] Digest: done
[Sat Sep 18 14:16:05 2010] [notice] Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i mod_autoindex_color PHP/5.2.8 configured -- resuming normal operations
[Sat Sep 18 14:16:05 2010] [notice] Server built: Dec 10 2008 00:10:06
[Sat Sep 18 14:16:06 2010] [notice] Parent: Created child process 7352
[Sat Sep 18 14:16:09 2010] [notice] Digest: generating secret for digest authentication ...
[Sat Sep 18 14:16:09 2010] [notice] Digest: done
[Sat Sep 18 14:16:14 2010] [notice] Child 7352: Child process is running
[Sat Sep 18 14:16:14 2010] [notice] Child 7352: Acquired the start mutex.
[Sat Sep 18 14:16:14 2010] [notice] Child 7352: Starting 250 worker threads.
[Sat Sep 18 14:16:14 2010] [notice] Child 7352: Starting thread to listen on port 80.
[Sat Sep 18 14:16:14 2010] [notice] Child 7352: Starting thread to listen on port 443.
[Sat Sep 18 16:19:46 2010] [notice] Parent: child process exited with status 1073807364 -- Restarting.
[Sat Sep 18 17:36:39 2010] [warn] pid file C:/xampp/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Sat Sep 18 17:36:40 2010] [notice] Digest: generating secret for digest authentication ...
[Sat Sep 18 17:36:40 2010] [notice] Digest: done
[Sat Sep 18 17:36:55 2010] [notice] Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i mod_autoindex_color PHP/5.2.8 configured -- resuming normal operations
[Sat Sep 18 17:36:55 2010] [notice] Server built: Dec 10 2008 00:10:06
[Sat Sep 18 17:36:55 2010] [notice] Parent: Created child process 900
[Sat Sep 18 17:37:00 2010] [notice] Digest: generating secret for digest authentication ...
[Sat Sep 18 17:37:00 2010] [notice] Digest: done
[Sat Sep 18 17:37:03 2010] [notice] Child 900: Child process is running
[Sat Sep 18 17:37:03 2010] [notice] Child 900: Acquired the start mutex.
[Sat Sep 18 17:37:03 2010] [notice] Child 900: Starting 250 worker threads.
[Sat Sep 18 17:37:05 2010] [notice] Child 900: Starting thread to listen on port 443.
[Sat Sep 18 17:37:05 2010] [notice] Child 900: Starting thread to listen on port 80.
[Sat Sep 18 22:49:05 2010] [notice] Parent: child process exited with status 1073807364 -- Restarting.

Permissions are ok.
I’m using Vista

I don’t know how the folder setup is on XAMP but on WAMP, one of the folders in the wamp folder is called logs, in the logs folder is a file called mysql and that file is the mysql log.

Hhmm, I don’t know… But I haven’t noticed anything more.
Are there any log files in xampp that I can check?