Local Server Setup

[Guest]

Have just managed to get my virtual local server part setup, in that I have managed to get past the phpmyadmin login screen on my local host to show this screen:

 

 

However their is an error at the bottom that reads:

 

The $cfg['PmaAbsoluteUri'] directive MUST be set in your configuration file!

 

I found this in phpmyadmin>config.ink.php:

 

$cfg['PmaAbsoluteUri'] = '';


/**
* Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
* You should use this if and ONLY if the PmaAbsoluteUri auto-detection
* works perfectly.
*/

 

but I don't know it's significance or what to do with it.

 

Any ideas?

 

My second issue is the following message on the same screen:

 

Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.

 

Again, I'm not sure what do about this.

 

Thanks

 

Mark

[241]

is this to be a publically accessible server or just for your own development

[Guest]

This is for my own developement so that I can make upgrades without disrupting my customers.

 

Thanks

 

Mark

[241]

ok then change the line

 

$cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;

to

$cfg['PmaAbsoluteUri_DisableWarning'] = TRUE;

 

this is for the first message as for the second you can set a password or just ignore the message or disable the warning.

 

these will not stop things running and as there is no public access you have less worries.

 

this allows you to concentrate more on the work.

[Guest]

Thanks alot that was extremely helpful. I am trying to import my database that I have dumped from my live site. It is 15meg in size and when I try to do this it runs for about 10 minutes and times out.

 

It appears that the site dump is too big for it too handle.

 

Any suggestions?

 

Thanks

 

Mark

[241]

change the execution time limit

$cfg['ExecTimeLimit']

 

also in php.ini change the script memory sizes to something like 32M

 

max_execution_time = 300

max_input_time = 600

memory_limit = 32M

 

 

you can also split the sql file in to more managable chunks.

[Guest]

Thanks for your help Steve this sort of information is obviously buried deep in manuals, so you are saving me loads of time.

 

I got the first bit OK, but I don't know where to find php.ini.

 

Thanks

 

Mark

[Guest]

Sorry, and how do a split file into smaller chunks?

[Guest]

Still don't have answers for the above 2 questions, but also - have adjusted the allowed download time at $cfg['ExecTimeLimit'] in the config.inc.php, but I am getting this message that I wasn't getting before:

 

CGI Timeout

 

The specified CGI application exceeded the allowed time for processing. The server has deleted the process.

 

I have tried this several times over trying to upload my site dump as zipped or unzipped, but still not successful.

 

$cfg['ExecTimeLimit'] is set to 0 - which it says means unlimitted, but did also try putting in 12000 and it timed out well before reaching this.

 

Thanks

 

Mark

[241]

is this an install of easyphp if not that is the easy option for local setup.

 

php.ini will be found by using the search function and searching php.ini

 

the file is normally located in the root or where apache is installed

[241]

as for splitting the file open the file using something like notepad and highlight some complete sections of tables and cut and paste to a new file.

 

Obviously do this with a copy of the file in case of an oops.

 

or send the file to me and I will send you back several files each of a much smaller size.

 

changing the timeout and script memory size in php.ini will allow handeling of larger scripts.

 

 

set the exectime in the phpMyAdmin config.inc.php to 300

[Guest]

I did do a search, but it didn't find this file. I have setup a virtual server via IIS on windows xp. I have phpmyadmin in the root directory and mysql version 4 on my c:\.

[241]

do you have php installed

[Guest]

if this is your local system then you have total control over everything, uploading a 15 mb file you are better off using mysql from the command prompt, go to the dos prompt, then cd \mysql\bin

run mysql, ie mysql -u root -p databasename

then enter the root password

just to be on the safe side, use databasename;

then type in:

source databasename;

[Guest]

OK it has now said that it has successfully uploaded the file, but it is nowhere to be seen.

[241]

go back to your phpMyAdmin and open the database which should now be populated. When saying the file uploaded you do not see an actual file as you are loading the contents of the file into the database.

 

Not the best explanation in the world but should do the job