WebFaction
Community site: login faq
0
1

Hello there,

I'm optimising my website for speed and decided to use MySQL query cache. I been told that I cant use query cache variable on default one click mysql installtion. I have custom PHP application installed. My Question is Is it possible to install MySQL inside custom PHP app by following this forum post http://forum.webfaction.com/viewtopic.php?id=1781 ?

Thanks for your time,

asked 26 May '11, 06:06

webbyfox
24710
accept rate: 100%

edited 26 May '11, 16:31


You won't be installing it "inside" your PHP application. You'll be installing it in your home directory but you'll use the port number from a 'custom application listening on port...' application.

The instructions on the forum thread still work so you should be able to use them without issue.

permanent link

answered 26 May '11, 06:16

David L ♦♦
1.4k13
accept rate: 45%

Thanks, was trying to keep one website inside one folder including database.

(26 May '11, 07:08) webbyfox

Well in theory you can place it wherever you like :)

The only important part is that it's listening on the port assigned to you. Other than that, it's entirely up to you where you install it.

(26 May '11, 07:14) David L ♦♦

Started to following intruction and stuck at ./configure command. The link for downloading mysql doesnt work any more so I tried the latest one which is http://www.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.12-linux2.6-i686.tar.gz/from/http://mirrors.dedipower.com/www.mysql.com/ and then untar it. Then tried .configure --prefix=$HOME/mysql which shouting me about ./configure: No such a file or directory.

(26 May '11, 08:27) webbyfox

And how to 'instruct' the application(s) and/or our custom PHP stack to use our custom MySQL and not the shared (Webfaction) one?

(26 May '11, 10:17) uresende

that i think you can do by changing setting in local.xml

(26 May '11, 13:26) webbyfox

When you see "./configure: No such a file or directory" check that the "configure" script actually exists and has execute permissions set on it. If the script does exist, you can make it executable by running "chmod u+x ./configure".

(26 May '11, 13:32) seanf

There isnt any configure script exists inside mysql installation directory.

(26 May '11, 16:44) webbyfox

Seanf, Could you please have a look at my working directory ? Should I Raise support request for this?

(26 May '11, 17:48) webbyfox

Yes, if you want us to look in your working directory, then you'll need to open a support ticket. Be sure to include the full path to the directory so we won't need to spend a lot of time hunting for it. Thanks!

(26 May '11, 18:07) seanf
showing 5 of 9 show 4 more comments
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×168
×28

question asked: 26 May '11, 06:06

question was seen: 2,856 times

last updated: 26 May '11, 18:07

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2019 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM