Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 964
  • Last Modified:

Import button in phpmyadmin doesn't work

Hi,
I have Linux Debian Squeez, mysql 5.1.61 and phpmyadmin 3.3.7deb7.
When I go to import tab and browse file.sql and press go i does nothing.
It doesn't return no error.

If I copy content of that file file.sql and paste it in to SQL query in same phpmyadmin it will import that table/database.
If I copy that file directly on server and import from command line it also works.

I tried to reinstall phpmyadmin but the problem stays the same.

I have 3 more servers with same configuration and the import button works. (same debian, same versions of mysql, phpmyadmin).
0
eihp
Asked:
eihp
  • 4
  • 2
1 Solution
 
legolasthehansyCommented:
Do you see any errors under /var/log/httpd/error_logs (or similar path)
0
 
Jayachandran PalanisamyTechnical Consultant - LinuxCommented:
Hi,
Please try the followings.

1.download the latest version of PMA(3.4.10.2) and have a try with import option
http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.4.10.2/phpMyAdmin-3.4.10.2-english.tar.gz?r=http%3A%2F%2Fwww.phpmyadmin.net%2Fhome_page%2Fdownloads.php&ts=1333250325&use_mirror=cdnetworks-kr-1

2.Find the default php.ini path on your server and compare the same with another working servers.
To find php.ini conf file.
php -i |grep php.ini

Open in new window


Check the following values.
file_uploads 
post_max_size
upload_max_filesize

Open in new window


If you found something different then change the values and restart the apache.
/etc/init.d/apache2 restart

Open in new window


Good luck :)

Jay
0
 
eihpAuthor Commented:
I have this error when I press upload button:
Mon Apr 02 15:52:20 2012] [client xxx.xxx.xxx.xxx] Symbolic link not allowed or link target not accessible: /home/httpd/htdocs/mybaza/js/mootools.js, referer: http://www.xxxx.hr/mybaza/main.php?token=d921ed84e1e31d63d2d545d9141c4a55
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
legolasthehansyCommented:
Check if Options FollowSymLinks is defined for
/home/httpd/htdocs

should be something like this in /etc/apache2/conf/apache2.conf (or your apache config file)

<Directory /home/httpd/htdocs>
Options FollowSymLinks
</Directory>

Also make sure Options None doesn't follow after this statement.
0
 
eihpAuthor Commented:
In my /etc/php5/apache2/php.ini I have
file_uploads = On
post_max_size = 64M
upload_max_filesize = 256M

File I was try to upload is 35KB

I tried to put in /etc/apache2/sites-available/xxx
<Directory /home/httpd/htdocs/mybaza>
Options FollowSymLinks
Order deny,allow
Deny from all
Allow from xxx.xxx.x.0/24
</Directory>

And after /etc/init.d/apache2 restart, but it didn't help.
Still the same error
0
 
eihpAuthor Commented:
I find the solution for me.
The problem was that I copied the phpmyadmin from /usr/share/phpmyadmin to a new locaton. From that new locaton import button didn't work.
When I put it back to /usr/share/phpmyadmin it works. Still don't know why but it is working now so I won't bother any more.
0
 
eihpAuthor Commented:
no reson
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now