introduction screenshots faq forum blog modules components download
Please use the search function and/or read the FAQ first.

Go to Topic: PreviousNext
Go to: Message ListNew TopicSearchLog InPrint View

Very simple and stupid question



Posted by: bluetrain
December 06, 2009 08:43AM
So I download and run easyphp, everything goes perfectly, but I don't know how to upload the database to mysql. I have a website with 100mb mysql file and tried to run some testing offline. I copy the who public_html folder into www folder in easyphp, but now I'm stuck and mySQL, I don't know how to setup the 100mb mysql file to run the site.

I feel so stupid, please help.
Options: ReplyQuote
Posted by: Amour
December 06, 2009 09:34AM
To import your database, you can use phpMyAdmin, on [localhost] or [localhost] I think ;)
Options: ReplyQuote
Posted by: Jaxolotl
December 07, 2009 01:04PM
to load a 100mb sql file you sould UP the max values, otherwise you'll have a timeout error message.

Are you running easyphp on a local testing server? I'm asking because the values I'llshow you are not "secure" for a production server.

1 - Open the php.ini file
2 - go to line 443 (or about that line) and change max_execution_time = 600
3 - go to line 453 (or about that line) and change max_input_time = 600
4 - go to line 461 (or about that line) and change memory_limit = 128M
5 - go to line 735 (or about that line) and change post_max_size = 200M
6 - go to line 886 (or about that line) and change upload_max_filesize = 200M
7 - go to line 1165 (or about that line) and change mysql.connect_timeout = 600


That should be fine enought ;)
Options: ReplyQuote
Posted by: Amour
December 07, 2009 03:12PM
You can also do that in command line with mysql, it's very fast ;)
Options: ReplyQuote


Go to: Message ListSearchLog In
Your Name: 
Your Email: 
Subject: 
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.