Board index   FAQ   Search  
Register  Login
Board index php forum :: Database phpMyAdmin

Can not upload large Database file in local server

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: macek, egami, gesf

Can not upload large Database file in local server

Postby saroya » Sun Nov 06, 2011 10:34 pm

hello all. i am trying to upload large database (size is = 280 MB) in mysql .
i aslo update in php.ini fiel like
1. upload_max_filesize = 2048M
2. memory_limit = 2000M
3. post_max_size = 1000M
and then restart php ( i m using Zend server)

when i import that database in local host ... phpmy admin show only 100mb import in import tab.

so help what to do . how can i solve this problem .
saroya
New php-forum User
New php-forum User
 
Posts: 2
Joined: Sun Nov 06, 2011 10:19 pm

Re: Can not upload large Database file in local server

Postby TheProdigyGuy » Fri Dec 16, 2011 2:24 pm

Hi saroya.
Do you get error like:
Mysql Gone away?
If possible use mysql client for importing database.(not phpmyadmin)
Fix:
Login as root and issuse:
Code: Select all
SET GLOBAL query_cache_size = 52428800;
SET GLOBAL max_connections = 200;
TheProdigyGuy
New php-forum User
New php-forum User
 
Posts: 215
Joined: Wed Dec 07, 2011 5:25 pm


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.