Web Hosting Forum | Lunarpages
News: October 6, 2008 - Submit Your Site for the October 2008 Site of the Month!
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
October 12, 2008, 06:51:17 PM


Login with username, password and session length


Pages: [1]   Go Down
  Print  
Author Topic: Plesk phpmyadmin and backing up mysql database - 0 byte files  (Read 107 times)
smaxwest
Pong! (the videogame) Master
*****
Offline Offline

Posts: 20


« on: July 24, 2008, 10:35:42 PM »

I don't know if there's been a patch issued, but it's happening to me at least, here's the problem:

http://forum.swsoft.com/showthread.php?t=51891

"one of my clients is trying to export a database that has a table of 31M in size, but he can't.When he tries to export it to a file he receives a file of 0 bytes in size.Also when he exports it in plain text in the browser he gets a blank page.
I've managed to dump it in the shell but i cannot give the client access to the shell, he must do it through phpmyadmin.
I've tried several tweaks to the php.ini but with no result.
Here are the settings that I've tried to modify from php.ini
Quote:
max_execution_time = 30
max_input_time = 60
memory_limit = 50M
post_max_size = 8M
upload_max_filesize = 50M"

Here's the fix:

1. Open your plesk php.ini (my plesk php.ini located: /usr/local/psa/admin/conf/php.ini)
2. Find memory_limit change to example: memory_limit = 256M
3. Stop and start psa services: /etc/init.d/psa stopall , /etc/init.d/psa start


Logged
perestrelka
Administrator
Master Jedi
*****
Offline Offline

Posts: 1058



« Reply #1 on: July 26, 2008, 12:24:43 AM »


Just to add, if the db that is being exported is a few hundreds of megabytes in size even this recommended change won't help. It is highly advisable to use console mysql tools for export.
Logged

Kind Regards,
Vlad Artamonov
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.6 | SMF © 2006-2008, Simple Machines LLC

Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM