2 Quick questions ?
Posted by: Toppy (---.lnse5.lon.bigpond.net.au)
Date: March 28, 2012 06:45AM

Hi a couple of quick one (I Hope)

My previous WAMP installation on WinXP had WAMP booting up when windows started. but with Win7 , I have to start WAMP up afterwards How can I fix this please..

Downloading tables via phpmyadmin to WAMP works fine until a table is a large one when it refuses to load it because it is too large (my hosting server has no problem sending the file)

Error "the file size exceeded the maximum size permitted by your PHP configuration."

I assume that there are some variables somewhere in an INI file I can change to fix this

Your assistance would be much appreaciated

Toppy

Options: ReplyQuote
Re: 2 Quick questions ?
Posted by: RiggsFolly (---.as13285.net)
Date: April 02, 2012 09:47PM

1. copy the Start -> WampServer > start WampServer Icon to the Startup folder in the start menu.
You should just be able to drag and drop it.

2. phpmyadmin is limited to the execution time you allocate to a php script ( usually 30 seconds). It will eventually fail on large file imports.

try using the mysql.exe.
From a command window cd to the folder containing the executable
c:\wamp\bin\mysql\mysqlX.Y.Z\bin
keyin
> mysql -u root -p -h localhost database < data.sql

where ROOT is your admin userid
-p will make it ask you for the password for root
-h localhost ( is the location of the server i.e. localhost )
database is the name of your db you are trying to load
< data.sql is the file containing your backup eg c:\temp\mydb\backup.sql or whereever you have the file

Options: ReplyQuote
Re: 2 Quick questions ?
Posted by: Toppy (---.lns6.win.bigpond.net.au)
Date: April 12, 2012 07:44AM

Sorry for the delay in answering your post.

Thank you very much, I found it most hlepfull

Regards Toppy

Options: ReplyQuote


Sorry, only registered users may post in this forum.