WampServer

Hi,

Is there away to restore a MYSQL database on WAMP via a single .sql file? taken from a backup from a website on a live enviroment? Just i want to restore the WAMP database to be the same as the one on the live site, to test some things and i can't get the forum to run without doing this. I know you restore via the myphpadmin but its limited to 2kbs so.

Any suggestion be much appreciated!
Thanks

2 mb


and this can be increased in the php.ini


left click wamp icon> php>php.ini


change 2MB to a Larger size

ITS written 2-3 times under MAX POST and MAX UPLOAD ( not exact name, not at pc)

save and restart wamp

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

Yes sorry 2mb!

Excellent, I found the lines in the php.ini file! I'll give it a try

Many thanks
Howard



Edited 1 time(s). Last edit at 01/15/2010 02:55PM by Luminousity.

stevenmartin99 Wrote:
-------------------------------------------------------
> 2 mb
>
>
> and this can be increased in the php.ini
>
>
> left click wamp icon> php>php.ini
>
>
> change 2MB to a Larger size
>
> ITS written 2-3 times under MAX POST and MAX
> UPLOAD ( not exact name, not at pc)
>
> save and restart wamp

I tried this,

Lines i changed in php.ini where,
upload_max_filesize = 2M to upload_max_filesize = 15M
post_max_size = 10M to post_max_size = 20M

but now i get an error when carrying out the "Import" in phpmyadmin,

Fatal error: Maximum execution time of 300 seconds exceeded in **\wamp\apps\phpmyadmin3.2.0.1\libraries\sqlparser.lib.php on line 485

Any suggestions, or would i be better posting on myphpadmin percific forum

Many thanks!

more than 300seconds?

thats very slow lol


open c:/wamp/apps/phpmaydmin/config.inc

add this line after $i=1;

$cfg['ExecTimeLimit'] =00;


this will disablethe timelimit or put it a numberin seconds if you want

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

stevenmartin99 Wrote:
-------------------------------------------------------
> more than 300seconds?
>
> thats very slow lol
>
>
> open c:/wamp/apps/phpmaydmin/config.inc
>
> add this line after $i=1;
>
> $cfg['ExecTimeLimit'] =00;
>
>
> this will disablethe timelimit or put it a
> numberin seconds if you want

Thanks, I'll give it a go now! I'm guessing that its going to take a fair amount of time to import 14mb worth of database into it like that?

Regards
Howard



Edited 1 time(s). Last edit at 01/15/2010 04:04PM by Luminousity.

To bypass the myphpadmin limit, you could use mysqldump/mysql directly. Here's some info: [www.clockwatchers.com]
Regards.