
Cant export mysql files!
#1
Posted 05 October 2009 - 09:31 AM
"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
#2
Posted 05 October 2009 - 11:18 AM
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

#3
Posted 06 October 2009 - 02:08 AM
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.
#4
Posted 20 January 2011 - 01:56 AM
#5
Posted 15 July 2011 - 07:40 AM
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
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users