WampServer

hmmm I have an issue.

Is there any way I can increase the PhpMyAdmin configuration so I can upload a database script larger than 2 meg
As it will only allow a script of 2 meg and no more?

Secondly I get an (export.php: Missing parameter) argument when trying to download a database.
I have a 40 meg database and it has taken me 3 hours ((machine slow) need more memory) to break it down into under 2 meg chunks to upload to phpMyAdmin.

The thing is I had to change all references to [mysite.net] to local host and on one attempt I inserted localhosr instead of localhost, "silly me" so as I have adjusted some of the tables it is not the same as the copy I have on my system.
The export php missing parameter is stopping me downloading the DB sql file.
I found out this mistake when I tried a network path off my site and it said it could not display the page and when I checked it said [localhosr] , so I know it was a mistake I made when uploading the 32 parts of the DB.
So to cut a long story short it won’t download the DB file?
Any advice, apart from be more careful next time...
John

Log does not show anything
120719 18:19:13 [Note] Plugin 'FEDERATED' is disabled.
120719 18:19:13 InnoDB: The InnoDB memory heap is disabled
120719 18:19:13 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120719 18:19:13 InnoDB: Compressed tables use zlib 1.2.3
120719 18:19:13 InnoDB: Initializing buffer pool, size = 128.0M
120719 18:19:13 InnoDB: Completed initialization of buffer pool
120719 18:19:13 InnoDB: highest supported file format is Barracuda.
120719 18:19:14 InnoDB: Waiting for the background threads to start
120719 18:19:15 InnoDB: 1.1.8 started; log sequence number 1595675
120719 18:19:15 [Note] Server hostname (bind-address): '(null)'; port: 3306
120719 18:19:15 [Note] - '(null)' resolves to '::';
120719 18:19:15 [Note] - '(null)' resolves to '0.0.0.0';
120719 18:19:15 [Note] Server socket created on IP: '0.0.0.0'.
120719 18:19:15 [Note] Event Scheduler: Loaded 0 events
120719 18:19:15 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log' socket: '' port: 3306 MySQL Community Server (GPL)
120719 18:48:40 [Note] wampmysqld: Normal shutdown

120719 18:48:40 [Note] Event Scheduler: Purging the queue. 0 events
120719 18:48:40 InnoDB: Starting shutdown...
120719 18:48:41 InnoDB: Shutdown completed; log sequence number 1595675
120719 18:48:41 [Note] wampmysqld: Shutdown complete

120719 18:56:08 [Note] Plugin 'FEDERATED' is disabled.
120719 18:56:08 InnoDB: The InnoDB memory heap is disabled
120719 18:56:08 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120719 18:56:08 InnoDB: Compressed tables use zlib 1.2.3
120719 18:56:09 InnoDB: Initializing buffer pool, size = 128.0M
120719 18:56:09 InnoDB: Completed initialization of buffer pool
120719 18:56:09 InnoDB: highest supported file format is Barracuda.
120719 18:56:09 InnoDB: Waiting for the background threads to start
120719 18:56:10 InnoDB: 1.1.8 started; log sequence number 1595675
120719 18:56:10 [Note] Server hostname (bind-address): '(null)'; port: 3306
120719 18:56:10 [Note] - '(null)' resolves to '::';
120719 18:56:10 [Note] - '(null)' resolves to '0.0.0.0';
120719 18:56:10 [Note] Server socket created on IP: '0.0.0.0'.
120719 18:56:10 [Note] Event Scheduler: Loaded 0 events
120719 18:56:10 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log' socket: '' port: 3306 MySQL Community Server (GPL)
120719 22:03:08 [Note] wampmysqld: Normal shutdown

120719 22:03:10 [Note] Event Scheduler: Purging the queue. 0 events
120719 22:03:12 InnoDB: Starting shutdown...
120719 22:03:24 InnoDB: Shutdown completed; log sequence number 1699561
120719 22:03:24 [Note] wampmysqld: Shutdown complete

120720 9:50:17 [Note] Plugin 'FEDERATED' is disabled.
120720 9:50:17 InnoDB: The InnoDB memory heap is disabled
120720 9:50:17 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120720 9:50:17 InnoDB: Compressed tables use zlib 1.2.3
120720 9:50:17 InnoDB: Initializing buffer pool, size = 128.0M
120720 9:50:17 InnoDB: Completed initialization of buffer pool
120720 9:50:17 InnoDB: highest supported file format is Barracuda.
120720 9:50:17 InnoDB: Waiting for the background threads to start
120720 9:50:18 InnoDB: 1.1.8 started; log sequence number 1699561
120720 9:50:18 [Note] Server hostname (bind-address): '(null)'; port: 3306
120720 9:50:18 [Note] - '(null)' resolves to '::';
120720 9:50:18 [Note] - '(null)' resolves to '0.0.0.0';
120720 9:50:18 [Note] Server socket created on IP: '0.0.0.0'.
120720 9:50:19 [Note] Event Scheduler: Loaded 0 events
120720 9:50:19 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log' socket: '' port: 3306 MySQL Community Server (GPL)

OMG you went to alot of trouble to break it up.


just increase the limits as follows


Left click wamp icon> php > php.ini


Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Got rather lost in all this.

If you want to load your local database with large amount of data the best way is to use the mysql.exe and not phpMyAdmin.

From a command window:

C:\wamp\bin\mysql\mysqlx.y.z\bin\mysql.exe -uroot -p < dump.sql
<where x.y.x is something like 5.5.8> or whatever version you have installed of mysql.

It will ask for a password for user root or which ever user you specify, leave blank i.e. just hit enter if you have not set a password yet.
It should then read your database dump file in and action the restore.

Execute this from the folder containing your dump.sql file.


Separate thing:
From the mysql log it looks like you have not yet fixed your hosts file
c:\windows\system32\drivers\etc\hosts ( not extension )

Make sure that you only have a line like this in there
127.0.0.1 localhost

comment out ::1 if it exists with a #

You need to be an administrator to sucessfully save this file.
Simplest way is to copy the file to c:\ , edit it there and then copy it back.

lol if only I knew then what I know now, but hey I had fun (Not)

So I have followed your advice and changed the parameters but I still get

export.php: Missing parameter: what

Now I have been on the phpMyAdmin site and the 11 posts with this error are all not replied to. I have scaned the tinternet and all the results relate to Cpanel issues.......


So I still can not solve this nor find any result that relates?

and I have just changed the host file as requested



Edited 3 time(s). Last edit at 07/20/2012 10:18PM by costcrunchers.

Dazed and confused, well it is Friday night!

You say you are trying to download a database? Do you mean EXPORT using phpMyAdmin?

Are you trying to export from a hosted server i.e. NOT WAMP? i.e. a LIVE server somewhere on t'internet.
OR
Are you trying to export from an old WAMP server??
OR
Have you got some other installation of mysql on your PC??


If all this is going on on your local PC try installing MYSQL Workbench. Its much more intuitive and well documented. This will EXPORT your database for you but only if it lives on your PC, not if its on a web server on t'internet.

Yes Export using php my admin
It is not on a hosted server it is through winamp phpMyAdmin
I have no other version of nysql on my pc. and I am not trying to export from an old wamp server

I will install mysql workbench and try that and let you know

Use the MySQL console found on the wamp menu

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

downloaded mysql workbench and everything works fine now thank

and thanks for the help


John