help with phpmyadmin

[bachbell]

well my host its unable to help unless i buy managed server 35 month bah ..


well phpmyadmin allows only 8mb on data base import so i change max file size in php.ini save end remplace file and restarted but nothings changed


help please

bachbell Reviewed by bachbell on 20th Jul 2010. help with phpmyadmin well my host its unable to help unless i buy managed server 35 month bah ..<_< well phpmyadmin allows only 8mb on data base import so i change max file size in php.ini save end remplace file and restarted but nothings changed help please Rating: 5

[CatchItBaby]

Edit these files in php.ini

upload_max_filesize
post_max_size
max_execution_time

Don't forget to restart.

[Gavo]

Import the sql file via ssh
upload the sql file & login to ssh & cd to the dir where you uploaded the file
then

mysql -u username -p data-base-name < data.sql

[SuicidalMedia]

You are on shared hosting, right?

If you are, download bigdump from http://ozerov.de/bigdump.php , and import your database via bigdump. It's 10 times faster.

EDIT :

My bad I thought that you are on shared hosting. Didn't read whole post, do as Gav0 said.

[bachbell]

nop. im on vps i install kloxo as control panel and include phpmyadmin on it ,, well i will try your advices


and this my php ini congf

; Maximum allowed size for uploaded files.


register_globals = off
display_errors = off
file_uploads = on
upload_max_filesize = 200M
log_errors = off
output_buffering = off
register_argc_argv = on
magic_quotes_gpc  = off 
post_max_size = 200M
magic_quotes_runtime = off
magic_quotes_sybase = off
mysql.allow_persistent = off
max_execution_time = 90
max_input_time = 60
memory_limit = 32M
post_max_size = 200M
allow_url_fopen = on
allow_url_include = on
register_long_arrays = on
session.save_path = /var/lib/php/session
cgi.force_redirect = on

uploding data base its heavy 123mb