Welcome Guest. Please Login or Register  


You are here: Index > Webuzo > General Support > Topic : import mysql 50mb file size won't work, php.in modified.



Threaded Mode | Print  

 import mysql 50mb file size won't work, php.in modified. (8 Replies, Read 35161 times)
crossing
Group: Member
Post Group: Newbie
Posts: 14
Status:
I have modified php.ini with right sizes:

upload_max_filesize = 100M

but I still can't upload 50mb mysql file via myphpadmin import option. I still get (Max: 2,048KiB) on import tab.

What I have to do to import my database file ?
IP: --   

import mysql 50mb file size won't work, php.in modified.
crossing
Group: Member
Post Group: Newbie
Posts: 14
Status:
I modified this to :

post_max_size = 100M
IP: --   

import mysql 50mb file size won't work, php.in modified.
crossing
Group: Member
Post Group: Newbie
Posts: 14
Status:
I don't undestand why it does not work.  I have similar problem with bandwidth showing on main panel 75% Used (3gb) although I have 3TB and I did set Bandwidth Limit (in MB) to 30.000 on admin-settings with no result.
IP: --   

import mysql 50mb file size won't work, php.in modified.
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Quote From : crossing July 18, 2013, 9:36 pm
I have modified php.ini with right sizes:

upload_max_filesize = 100M

but I still can't upload 50mb mysql file via myphpadmin import option. I still get (Max: 2,048KiB) on import tab.

What I have to do to import my database file ?


Sir please make sure you are editing the php.ini located at /usr/local/emps/etc/php.ini followed by restarting the Webuzo service from the terminal.

Code
Root > service webuzo restart



Quote
I have similar problem with bandwidth showing on main panel 75% Used
(3gb) although I have 3TB and I did set Bandwidth Limit (in MB) to
30.000 on admin-settings with no result.
       


Sir the graph shown in Webuzo is as per the usage not as per the limit of your bandwidth.

Also the setting in the Admin Panel will send you an alert email if the bandwidth exceeds the specified value in the Admin Panel.

We have made a provision to set the Total Bandwidth from the Webuzo Enduser Panel and it will be available in the upcoming version of Webuzo.

If you still face any issues, please open a support ticket with the root details of your server and access to your Webuzo Enduser Panel, we will resolve your issues.
Support : https://www.softaculous.com/support/open.php

You can also add us on Skype.
Username : webuzo


Edited by valley : July 19, 2013, 7:13 am

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

import mysql 50mb file size won't work, php.in modified.
crossing
Group: Member
Post Group: Newbie
Posts: 14
Status:
1. Thank you, but why php.ini from Panel does not do that ? What's the purpose of that php if does not do anything ? 2. I try to upload MySQL and after uploading 25% it starts over and over again.
IP: --   

import mysql 50mb file size won't work, php.in modified.
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Quote From : crossing July 19, 2013, 7:34 am
1. Thank you, but why php.ini from Panel does not do that ? What's the purpose of that php if does not do anything ?


Sir the option to edit php.ini from the Enduser Panel will act for installations made to the port 80. Whereas , the php.ini located at /usr/local/emps/etc/php.ini works for Webuzo itself i.e at Webuzo ports. Also, if you noticed phpMyAdmin is accessible through Webuzo and hence shares the above mentioned php.ini

Quote
2. I try to upload MySQL and after uploading 25% it starts over and over again.

Could you please open a support ticket with the root details of your server and access to your Webuzo Enduser Panel, we will resolve your issues.
Support :  https://www.softaculous.com/support/open.php


Edited by valley : July 19, 2013, 7:49 am

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

import mysql 50mb file size won't work, php.in modified.
asifashi
Group: Member
Post Group: Newbie
Posts: 5
Status:
I have tired both way to increase upload file size. My database is 300MB and Webuzo providing 50MB. I have made change from PHP.ini from end user and also from /usr/local/emps/etc/php.ini  via ssh and restart web service. Both of these don't effect anythig.
IP: --   

import mysql 50mb file size won't work, php.in modified.
webuzo_manager
Group: Member
Post Group: Elite Member
Posts: 268
Status:
Hi asifashi,

Uploading 300 MB file via the web is too much if the network gets timed out or fails there is no way to restore or start from the failure point.

I suggest that you upload the file via FTP and then you can import the .sql file via command line.

Let me know if you want the commands.

Edited by webuzo_manager : August 22, 2018, 7:14 am
IP: --   

import mysql 50mb file size won't work, php.in modified.
asifashi
Group: Member
Post Group: Newbie
Posts: 5
Status:
I have try a lot's these changes made effect on Filemanager upload files size but not in PHPMyadmin Import file size
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 19, 2024, 6:26 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.067