Kloxo large database upload workaround

ISSUE:- There is an Issue with Kloxo that it hangs/freezes whenever client uploads File larger than 100mb .

Resolution :- As there is limition with kloxo , we are going to edit phpMyAdmin configuration .

Step 1 :- Let us first go to configuration directory of PhpMyAdmin

           cd  /usr/local/lxlabs/kloxo/httpdocs/thirdparty/phpMyAdmin

Step 2 :- now we have configuration file inside this location

           config.inc.php

open this file with and look for these parameters :-

$cfg['UploadDir'] = ; $cfg['SaveDir'] = ;

Now we have to change the path for UploadDir and SaveDir //please note UploadDir will be used while Import and SaveDir will be used while Export //

Let us take one example of configuration done for 107.167.181.187 server , here username for FTP user is iwmp_mobi with home directory /home/iwmp_mobi/ $cfg['UploadDir'] = '/home/iwmp_mobi/'; $cfg['SaveDir'] = '/home/iwmp_mobi/';

After doing this entry save the file and restart httpd .

This will enable PhpMyAdmin to Look inside /home/iwmp_mobi for .sql files while Import .

while importing we just have to select "Select from the web server upload directory "

Client is Using Core-FTP to transfer database file directly to /home/iwmp_mobi/ directory .