phpMyAdmin setting changes

[LiamMac™]

I run a forum and it has now grown a database that I can no longer handle.

On the host server phpmyadmin allows a larger sql file to be uploaded than my local host.

The database in question is not too big for the host limit but IS for my local limit. This makes any test updates etc that I want to try locally first almost impossible as even the users table is too big to input it into the sql window or upload either. This means I must upload small amounts at a time.

As the database has hit 12mb in sql form it is now ridiculous for this to continue.

I would like to know how to change the profile privileges of the root user to allow for large import files. I cannot locate the settings anywhere within the menu of the program.

I am running: phpMyAdmin - 2.10.1 as part of the WAMPSERVER package, which is Wamp5.

Anyone know?

[LiamMac™]

Problem solved.

For future reference to others, the setting is not found in the menu it is located in php.ini. Variable is located on line 490 as "upload_max_filesize = 2M".

Thanks LiamMac

[Vege]

Why not import it from command line tools to your local host?
Comes with every mysql server
http://www.hmug.org/man/1/mysqldump.php

[scoutt]

for uploading you also have to change POST MAX SIZE in the php.ini fle as well. Sometimes that is to low.

Vege, the setting is is talkiing about has nothing to do with mysql. He want to use phpmyadmin and that has a limit.

[Vege]

Yes, i noticed he wanted to use phpmyadmin.
But mysql has a build in tool to work with dumping and uploading file to local host from localhost to me sound kinda bad practice anyway.
I was merely suggesting a alternative method where any kind of upload limits dont matter.

[scoutt]

yeah but if you upload to your host then more than likely you don't have the option to use command line.

[Vege]

Every windows install comes with option to use command line as we were talking about local install here, why you question this as you know it?

Different question ofcos is it doable by the user as it needs some dos commands.

We dont need to talk about remote server as it allready works. Thou would i use a remote server that dont allow me to ssh into it or use command line tools? no.

[scoutt]

most shared hosting servers don't allow ssh. And even though the remote server has the setting already the sql file will still get big enough to stop uploading.

[Vege]

Whats your point?
I spoke about personal preference, i know that most hosts dont allow ssh.

If remote server has upload problems in phpmyadmin it's becouse of admin of that host and nothing you can really do about it except whine.

If your talking about local host then there are numerous options to dump database and using phpmyadmin is not allways the best one.

Im done with this topic :)