| Posted by JustOne, 05-06-2003, 02:26 PM | | Is it possible for Plesk to limit file upload/imports in phpMyAdmin? I recently moved one of my domains to Hostnexus. Everything was setup well, as expected. The database was setup and the tables created from an export file from phpMyAdmin. The problem is, phpMyAdmin will not import any files into any table if the file is over 3MB. I checked the phpMyAdmin setup parameters and file upload size is 40MB so I opened a ticket with Hostnexus. One reply said I could upload smaller files which isn't practical since the files I'm uploading are currently over 80 MB total. Their last response was "The issue is hard coded into Plesk and can't be changed unfortunately."
What does Plesk have to do with phpMyAdmin? Is there any way around this? I just moved 4 sites away from FeaturePrice and Inferno and really don't want to move again if I don't have to. These tables are also used on another site (and host) and I haven't had any problems with them. The largest file is 18MB which is split into 2 files to upload and the other files are from about 900K to around 8MB. The other host doesn't use Plesk but uses CPanel. Has anyone else ever had this problem?
|
| Posted by jimroe, 05-06-2003, 08:03 PM | | Assuming that you're the server administrator, then you can change this in php.ini as this is a php limitation not a Plesk one.
|
| Posted by JustOne, 05-06-2003, 09:57 PM | | Thanks jimroe but I don't think I have the access to modify the php.ini. When I checked the php setup it said file upload limit is 40 MB, which is why this doesn't make sense to me.
|
| Posted by sprintserve, 05-07-2003, 03:46 AM | | Generally, it is likely that they don't wish to change the global php.ini settings just for your site. Well, how about asking your host to import it in the shell for you?
|
| Posted by Luxore, 05-07-2003, 07:50 PM | | alternately, you could upload the data with ftp and write a short script to import it.
|
| Posted by JustOne, 05-07-2003, 10:11 PM | | Thanks much for the help! I think I'll try one of the work-arounds as I don't want to move the site again. I appreciate your time and suggestions.
|
| Posted by X-Istence, 05-08-2003, 03:11 AM | | upload to ftp and ask host to run the following command for you:
mysql -u (username) -p (database_name ) < /path/to/database/file
make sure the database is empty, give them the password for it, and it will be dumped into MySQL in just a few seconds .
|
| Posted by JustOne, 05-08-2003, 07:03 AM | | Great, thanks, you saved me some research time!
|
| Posted by X-Istence, 05-08-2003, 07:35 AM | | No problem, ran into this problem with a client.
|
| Posted by bitziz, 05-08-2003, 12:44 PM | | I had this problem too.
It's actually not phpmyadmin's problem, it's just apache timing out after waiting for the upload to finish.
|
| Posted by sprintserve, 05-08-2003, 01:16 PM | | Yes. Phpmyadmin is not the most efficient. It will time out importing a 3MB file, and takes over 10 minutes just trying. Using shell will complete the task in milliseconds. It's just no comparison. Get the host to help you import it.
|
| Posted by X-Istence, 05-08-2003, 03:15 PM | | A lot of hosts dont know how to use command line MySQL and cant be bothered to read.
|
| Posted by sprintserve, 05-08-2003, 03:18 PM | | Well. We don't know that about his host, and there's no point in speculating. Let him try out that alternative.
|
| Posted by X-Istence, 05-08-2003, 03:27 PM | | Didnt mean to speculate, but by what he said the answers he got from his host, that is what i make up out of that.
|
| Posted by JustOne, 05-08-2003, 04:21 PM | | The problem is not a time out issue, I've had those before. With phpMyAdmin, I select the file with the browse button and change the import spec. and if the file is over 3MB the screen refreshes, the page title is gone and it's back at the import screen. This all happens within about 1 or 2 seconds. I import these same files into another database, same table names, same browser and files up to about 9 MB with no problem.
I too got the feeling they didn't want to spend time on it but everyone seems to speak highly of them. I need to think a little more, though, because I like the idea of setting up a cron to do this but if I have another problem will I get the same "don't bother me" reply? I want a long term home but would rather move now before this site is fully coded, if moving is the right choice.
|
| Posted by sitekeeper, 05-08-2003, 04:28 PM | | I have seen this happen on cPanel too! I have found IE 6 does not always work right in phpMyAdmin when uploading/downloading a DB. Netscape worked fine though....
|
| Posted by NexDog, 05-22-2003, 02:31 AM | | While we set max_upload parameters to 20mb in php.ini, it does appear that Plesk has it's own limitations. This can be gotten around by importing tables seperately or just asking us to populate the database via commandline shell.
I can assure that I know MySQL alot better than a simple command line dump. (And I'm not even the HN sysadmin).
I do apologise that Adrian's (HN sysadmin) reply to JustOne seemed curt and sorry that is was interpretted as "don't bother me". I can assure you that that is not our attitude at all. Let me know if you succeeded with the db import or need further assistance and I will only be too glad to help.
|
| Posted by LWBigB, 11-25-2011, 08:59 PM | | I realize this thread is quite old, but I figured I would post this here for anyone that stumbles upon this thread and needs the solution. Plesk uses a separate php.ini for admin related stuff. The main php.ini (/etc/php.ini) is for the sites only. So, to allow larger imports in phpMyAdmin, edit the following file:
/usr/local/psa/admin/conf/php.ini
Change post_max_size and upload_max_filesize to whatever value you want, for instance:
post_max_size = 500M
upload_max_filesize = 500M
After that, make sure to restart Plesk:
/etc/init.d/psa stop
/etc/init.d/psa start
That's it! You should be able to import to your heart's content.
|
|
 Add to Favourites
 Print this Article
|
