Can not upload large Database file in local server

[saroya]

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 .

[TheProdigyGuy]

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;