Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
phpMyAdmin hits an error
Posted by: imaaxa (---.knology.net)
Date: July 23, 2009 08:00AM

Just installed WAMP on my vista computer, and my server icon is white. I can get localhost to come up. I can get the php info page to come up. I can do command line interaction with mySQL, but phpMyAdmin errors out with:

#1 - Can't create/write to file 'C:\xampp\tmp\#sqlf8c_4_2.MYI' (Errcode: 2)

I have changed the permission setting on the C:\xampp\tmp\ folder, and still nothing. What ever the problem is, it will not let drupal install on the computer.

Thanks for any help.

Options: Reply•Quote
Re: phpMyAdmin hits an error
Posted by: imaaxa (---.knology.net)
Date: July 23, 2009 08:53AM

ANSWER

I went into the my.ini file in mySQL and changed the #tmpdir=/tmp/ entry to tmpdir=C:/tmp/. It is now working fine.

Here is the url of where I got the answer: [dev.mysql.com].

Hopes that helps someone else.

Options: Reply•Quote
Re: phpMyAdmin hits an error
Posted by: sTimulated (---.cable.ubr06.cast.blueyonder.co.uk)
Date: July 23, 2009 10:02AM

#1 - Can't create/write to file 'C:\xampp\tmp\#sqlf8c_4_2.MYI' (Errcode: 2)

I thought you installed wamp?

Options: Reply•Quote
Re: phpMyAdmin hits an error
Posted by: imaaxa (---.knology.net)
Date: July 24, 2009 05:01AM

I did, and that was the error I got. Weird isn't it?

Options: Reply•Quote
Re: phpMyAdmin hits an error
Posted by: yfastud (Moderator)
Date: July 24, 2009 03:50PM

no, not really weird but it means you didn't completely remove xampp

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: Reply•Quote
Re: phpMyAdmin hits an error
Posted by: elvendertig (---.access.telenet.be)
Date: July 26, 2009 01:45AM

Hello all of you

I have likely the same problem;
"Can't create/write to file '\xampplite\tmp\#sql1034_b_0.MYI' (Errcode: 2)"

Once I had Xampp but that's been a long long while ago..
But I work with Wampserver for severall months already, and a week ago I saw that there was a new version 'wamp2.0i, so I downloaded it, and installed it today. And now I get this error ...
I tried to change the my.ini, but the error stays the same..

Anyone some fresh ideas?

Thanks a lot.



Edited 1 time(s). Last edit at 07/26/2009 02:27AM by elvendertig.

Options: Reply•Quote
Re: phpMyAdmin hits an error
Posted by: toumimi (---.114.116-78.rev.gaoland.net)
Date: July 26, 2009 02:02AM

Delete all my.ini files which are not in wamp folder...

Florian

WampServer Patch (Screenshots)
Topic EN : www.wampserver.com
Topic FR : www.wampserver.com

Options: Reply•Quote
Re: phpMyAdmin hits an error
Posted by: elvendertig (---.access.telenet.be)
Date: July 26, 2009 02:21AM

I've deleted 2 files.. my.ini and my.ini.old, these were both in my c:/WINDOWS/ path..
But it still makes no difference towards my problem ..



Edited 1 time(s). Last edit at 07/26/2009 02:27AM by elvendertig.

Options: Reply•Quote
Re: phpMyAdmin hits an error
Posted by: elvendertig (---.access.telenet.be)
Date: July 26, 2009 02:26AM

And suddenly ..
I restarted wamp for sure..
And now it works winking smiley
Thanks a lot toumimi !

Options: Reply•Quote
Re: phpMyAdmin hits an error
Posted by: toumimi (---.114.116-78.rev.gaoland.net)
Date: July 26, 2009 04:30AM

You're welcome ! cool smiley

Florian

WampServer Patch (Screenshots)
Topic EN : www.wampserver.com
Topic FR : www.wampserver.com

Options: Reply•Quote
Re: phpMyAdmin hits an error
Posted by: sirius60 (---.dslaccess.co.uk)
Date: August 17, 2009 02:41AM

Wow thanks for this I've searched for days to the answer to this problem

As suggested i did a search of the computer for instances of my.ini and found one in windows

I deleted the file, uninstalled Wampserver rebooted reinstalled Wampserver and all is now fine.

Toumimi - you are the greatest - thank you so much winking smiley

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login