Problem importing sql backup
Posted by: faramir_cl (---.adsl.tie.cl)
Date: November 16, 2007 05:43AM

Hello!
After reinstalling WAMP (and upgrading from 1.7.2 to 1.7.3), I notticed when I try to import a database backup, it uses to time out. But when I import it to a freehost I use, it works fine, so I suppose something is not configured properly in my computer, but I dont know where is the problem. I already changed values in php.ini allowing to import big files, and also increased the memory and time allowed, but still having the problem.
And the more frustrating thing, is I know the freehost I use has placed restrictions on php, and even with those restrictions, it can do things I cant do in my computer using Wamp.

I am using a Sempron 3000+ cpu, 2 Gb ram, windows xp pro, the compressed file is about 3,5 Mb size, uncompressed is about 18 Mb, and it contains 10 tables and about 190,000 rows (and growing).

Thanks

Options: ReplyQuote
Re: Problem importing sql backup
Posted by: yfastud (---.mia.bellsouth.net)
Date: November 16, 2007 11:07PM

Try these different settings in c:\wamp\apache2\bin\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

And add this to c:\wamp\mysql\my.ini:

max_allowed_packet = 200M

Have fun,

[test.jlbn.net] (Sample Testing Codes for PHP, MySQL, ASP.net, SQL, JSP)
[www.jlbn.net] (Basic Guide for WAMP & Add-ons)

Options: ReplyQuote
Re: Problem importing sql backup
Posted by: jw_k (---.net-you.de)
Date: November 17, 2007 12:53PM

you may want to read these:
[wiki.cihar.com]
[wiki.cihar.com]
[mysqldumper.de]

Options: ReplyQuote


Sorry, only registered users may post in this forum.