Jump to content


Photo

Cant export mysql files!


  • Please log in to reply
4 replies to this topic

#1 web helper

web helper

    Newbie

  • Member
  • Pip
  • 2 posts
  • Main OS: Windows Vista

Posted 05 October 2009 - 09:31 AM

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

#2 Ric

Ric

    Project Manager

  • Admin
  • PipPipPipPipPip
  • 1,535 posts
  • Gender:Male
  • Location:Cambridge,UK
  • Interests:Electronics
    Internet in general
    Open source projects
  • SourceForge IDmpgcan
  • Wiki ID: Ric
  • Main OS: Windows XP

Posted 05 October 2009 - 11:18 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 :)

#3 web helper

web helper

    Newbie

  • Member
  • Pip
  • 2 posts
  • Main OS: Windows Vista

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 yousocrates

yousocrates

    Newbie

  • Member
  • Pip
  • 1 posts

Posted 20 January 2011 - 01:56 AM

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

#5 backlashforblow

backlashforblow

    Newbie

  • Member
  • Pip
  • 1 posts
  • IRC Nickname: backlashforblow
  • Main OS: Windows Vista

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




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users