Cant export mysql files!

[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