4 replies to this topic

[web helper]

hey guys I get this error when I try and export mysql

"The web server does not have permission to save the file /etc/phpmyadmin/sv2-db_2009-10-05.sql.zip."

what do I need to do to correct this? Thanks

[Ric]

A quick solution:

At the bottom of the export page
Check the box for “Save as file”
Un-Check the box “Save on server in”
This will force a pop-up allowing you to save the exported data to any location.

Truth is it’s a bug! The solution is to edit file:
UniServer\home\admin\www\phpMyAdmin\config.inc.php

At the bottom of this page change the last four lines as shown:
I have commented out the originals for reference:

//$cfg['UploadDir']   = '/etc/phpmyadmin';   // Directory for uploaded files 
//$cfg['SaveDir']	 = '/etc/phpmyadmin';   // Directory where phpMyAdmin can save exported data
//$cfg['docSQLDir']   = '';				  // Directory for docSQL imports,
//$cfg['TempDir']	 = '/tmp';			  // Directory where phpMyAdmin can save temporary files.

$cfg['UploadDir']	 = $drive.'/etc/phpmyadmin';   // Directory for uploaded files 
$cfg['SaveDir']	   = $drive.'/etc/phpmyadmin';   // Directory where phpMyAdmin can save exported data
$cfg['docSQLDir']	 = $drive.'/etc';			  // Directory for docSQL imports,
$cfg['TempDir']	   = $drive.'/tmp';			  // Directory where phpMyAdmin can save temporary files.

Re-start the servers.

All the best
Ric

[web helper]

A quick solution:

At the bottom of the export page
Check the box for “Save as file”
Un-Check the box “Save on server in”
This will force a pop-up allowing you to save the exported data to any location.

Truth is it’s a bug! The solution is to edit file:
UniServer\home\admin\www\phpMyAdmin\config.inc.php

At the bottom of this page change the last four lines as shown:
I have commented out the originals for reference:

//$cfg['UploadDir']   = '/etc/phpmyadmin';   // Directory for uploaded files 
//$cfg['SaveDir']	 = '/etc/phpmyadmin';   // Directory where phpMyAdmin can save exported data
//$cfg['docSQLDir']   = '';				  // Directory for docSQL imports,
//$cfg['TempDir']	 = '/tmp';			  // Directory where phpMyAdmin can save temporary files.

$cfg['UploadDir']	 = $drive.'/etc/phpmyadmin';   // Directory for uploaded files 
$cfg['SaveDir']	   = $drive.'/etc/phpmyadmin';   // Directory where phpMyAdmin can save exported data
$cfg['docSQLDir']	 = $drive.'/etc';			  // Directory for docSQL imports,
$cfg['TempDir']	   = $drive.'/tmp';			  // Directory where phpMyAdmin can save temporary files.

Re-start the servers.

All the best
Ric

Thanks Mate, I will try it and post back here.

[yousocrates]

thanks i was also facing this error now i understand that where is a problem and solve it thank you help

[backlashforblow]

A quick solution:

At the bottom of the export page
Check the box for “Save as file”
Un-Check the box “Save on server in”
This will force a pop-up allowing you to save the exported data to any location.

Truth is it’s a bug! The solution is to edit file:
UniServer\home\admin\www\phpMyAdmin\config.inc.php

At the bottom of this page change the last four lines as shown:
I have commented out the originals for reference:

//$cfg['UploadDir']   = '/etc/phpmyadmin';   // Directory for uploaded files 
//$cfg['SaveDir']	 = '/etc/phpmyadmin';   // Directory where phpMyAdmin can save exported data
//$cfg['docSQLDir']   = '';				  // Directory for docSQL imports,
//$cfg['TempDir']	 = '/tmp';			  // Directory where phpMyAdmin can save temporary files.

$cfg['UploadDir']	 = $drive.'/etc/phpmyadmin';   // Directory for uploaded files 
$cfg['SaveDir']	   = $drive.'/etc/phpmyadmin';   // Directory where phpMyAdmin can save exported data
$cfg['docSQLDir']	 = $drive.'/etc';			  // Directory for docSQL imports,
$cfg['TempDir']	   = $drive.'/tmp';			  // Directory where phpMyAdmin can save temporary files.

Re-start the servers.

All the best
Ric

sounds good to me. It really helped me out a lot. Thanks