How do I change the max limit size of importing a database in phpmyadmin?

[Devash]

Hi there everyone, I just have a question. The thing is that I want to import a database, but in phpmyadmin it says the max database you can import is: Max: 51,200KiB. How can I change the limit to something bigger like 200mb because the database I want to import is 104mb ,

Please can anyone help me I need this done urgently .

[Infopro]

You should restore something that size via command line. This will work. Upload the .sql to the account first.

mysql -u user:user -p user_databasename < /home/user/DB_Import/databasename.sql

type password for db when asked.

[Devash]

Yes I have tried that but I get this error: ERROR at line 719: unknown command '\S'

Now when i try it again I get this: ERROR 1050 (42S01) at line 19: Table 'jos_banner' already exists

Which means the database has already been imported, so i go to MySQL databases in cPanel and when I look at the database size it says 0.55 MB but the database is 104 mb!!

Please someone help

[Infopro]

Delete the database completely. Restore db as mentioned and it should import ok then.

The above command is to be run via SSH. Not phpMyAdmin.

[Fernis]

Find your php.ini file and edit it then restart apache.

; Maximum allowed size for uploaded files.
upload_max_filesize = 200M

[Devash]

Yes I run the above command via SHH Infopro.

And Fernis I am not too good with SHH and stuff so I wouldn't be able to do what you said, can you do it please or anyone that is good?

[Fernis]

Contact me via PM on these boards. I would be glad to help you out.

[Infopro]

You should be able to edit the php.ini from WHM without allowing anyone onto your server.

[Devash]

How can I do it via WHM? and Fernis I sent you a PM!

Need this done asap!

[cPanelDavidG]

How can I do it via WHM? and Fernis I sent you a PM!

Need this done asap!

WHM -> Service Configuration -> PHP Configuration Editor

If you need to change anything not listed on that page, click the button that switches you to advanced mode.

[Devash]

I can't find php.ini in there cPanelDavidG

[cPanelDavidG]

I can't find php.ini in there cPanelDavidG

Those settings are php.ini

[Devash]

Ahhhh ok, well I changed upload_max_filesize The maximum size of an uploaded file. to 250. Hope this works. does it matter what browser I use?

[cPanelDavidG]

Ahhhh ok, well I changed upload_max_filesize The maximum size of an uploaded file. to 250. Hope this works. does it matter what browser I use?

The browser you use should have no effect on the setting the server-side settings.

[Devash]

Ok, but when I go to phpmyadmin and try to import my database it still says Max: 51,200KiB .