Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

I've changed the user+group where apache is running to my user name so I don't have to change the web files I'm editing. But now I get NoDataReceived error trying to import using phpmyadmin.

http://wiki.phpmyadmin.net/pma/FAQ_1.16

What can I do to avoid this problem?

When I change back in /etc/apache2/envvar to www-data for user and group it works to import the same file to the same db. I login to phpmyadmin as root.

share|improve this question
    
One of us is completely confused. I've never run into any problems with the standard setup; what is the problem you're trying to solve in the first place. The link you provided doesn't seem to have anything to do with ownership at all. Is your database very large? If so, you just need to either split it, or compress it using the built-in compression abilities of phpmyadmin (I do this all the time, and have never had a problem). –  Marty Fried Aug 14 '12 at 22:31
    
Why not simply add the permissions for write for your user or any user? –  LnxSlck Aug 14 '12 at 23:34
add comment

3 Answers 3

You need to edit /etc/apache2/conf.d/phpmyadmin.conf:

php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp

to a writable folder for your user.

Or change ownership of that folder:

chown user:user /var/lib/phpmyadmin/tmp
share|improve this answer
add comment

I can't comment on @Giovanni Toraldo answer so I am writing here, I made the change for owner. No I need to take it back. Who is original owner:group for /var/lib/phpmyadmin/tmp ? Thank you

share|improve this answer
add comment

This may help you but use chmod 777 with caution.

sudo chmod 777 /var/lib/phpmyadmin/tmp
share|improve this answer
2  
Never set permissions to any directory to 777. –  guntbert Nov 9 '13 at 12:10
add comment

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.