Editing Kloxo large database upload workaround

[[category:Mobilepedia]]
[[category:KLOXO]]

'''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 "

[[Image:import_kloxo.png]]

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