FutureQuest, Inc. FutureQuest, Inc. FutureQuest, Inc.
     
Question: I have a Prospector package and I have a Trailblazer package. I would like the Prospector package to have access to one of the MySQL databases under the Trailblazer package. How can I do this? Answer: Having a Cross Connection activat...
QUESTION: How can I access my MySQL databases via SSH? ANSWER: To access your MySQL databases via SSH, you should log in to your shell account using an SSHv2-compatible client of your choice. For suggestions of SSH clients to use, see: http://servic...
Question: I cannot seem to access MySQL for my hosting package. How can I activate it? Please help. Answer: To activate MySQL, please visit the MySQL Manager located in your CNC (Command'N'Control) panel. Once activated you will be able to u...
Question: What is Smarty? Smarty is a template engine for PHP. One of the unique aspects about Smarty that sets it apart from other templating solutions is that it compiles the templates into native php scripts upon the first execution. After that,...
Question: After the PHP4 upgrade, all of the php code on my site broke. After doing a phpinfo(); I discovered that asp-style tags ( instead of ) had been turned off. Answer: Yes, these were turned off in the core, however you have the ability to...
QUESTION: I am brand new to MySQL and need a starting point. Where can I find a tutorial that will help me at this stage? ANSWER: Sources of documentation and tutorials can be found on the MySQL site: http://dev.mysql.com/doc/ [1] For example, a...
Question: What do I do if I have lost or want to change my MySQL password? Answer: You may change your MySQL password at any time by visiting the MySQL Manager section of your CNC (Command'N'Control) panel. Note that doing so will change the...
QUESTION: I've tried creating a new database in phpMyAdmin [1] and via the command line, but it's not working. What am I doing wrong? I would also like to remove a database that I'm no longer using. ANSWER: Any new databases would need to be cre...
QUESTION: I did a large delete in one of my databases and now the database is slow. Did it get corrupted? ANSWER: The ANALYZE TABLE and CHECK TABLE commands are ways to check your tables for various types of corruption. Whenever you delete a lar...
Question: Please delete all files in my mysql database. I don't know how to do this. thanks. Answer: Visiting the MySQL Manager located in your CNC (Command'N'Control) panel will allow you to easily delete a MySQL database on that package. Im...
CPU time is not wall time (as in a clock on the wall). CPU time is the total execution time or runtime for which the CPU was dedicated to a process. The CPU must service many processes every second, not just yours, so your process only gets small ...
QUESTION: I have realized that our PHP does not support the standard string functions "explode" or "split" though it supports "implode". Do you know the reason? I think they should be std functions of PHP. ANSWER: The above functions (explode and...
QUESTION: On your Packages page under Value Added Services, you list "External MySQL Connection." Could you explain this to me, please, or point me to documentation which explains it? ANSWER: By default, your MySQL server is only accessible from th...
WHAT IS PHP? PHP is a server side scripting language. It is not a browser dependent language like JavaScript as PHP code is parsed on the server. The browser only sees the resulting HTML output from the script. However, PHP is more than a simple sc...
Question: I have been pretty frustrated with a lot of header errors I am getting. I know you do not support third party PHP apps, but every app I use gets some kind of error related to information being added to the header after it is sent. Example...
UPDATE: The CNC MySQL Manager [1] offers an option for creating and downloading backups of databases. The instructions that follow are for manually creating a MySQL backup using SSH [2]. MySQL is hosted on a separate physical machine from the web s...
If you have created a backup of your MySQL databases and need to restore it, or you want to add data to your database from a mysqldump [1] you performed, you're in the right place! First, this tutorial ONLY covers backups done with mysqldump [2]. ...
QUESTION: I think my database may be corrupted and I am unable to run isamchk on my tables. How can I check and/or repair my tables? ANSWER: As the databases are physically located on backside dedicated MySQL servers, 'isamchk' cannot be run from ...
In order to prevent too many server resources from being used by a file upload process, PHP scripts are subject to restrictions. The limitations are ruled by various factors, including upload file size limits, memory constraints, and CPU runtime [1]. The ...
QUESTION: I need to import (or export) data into my MySQL database from a text file. Can I use "LOAD DATA INFILE" (or "SELECT INTO OUTFILE")? This doesn't appear to work. ANSWER: LOAD DATA INFILE and SELECT INTO OUTFILE will not work as these ...
Question: I have some forum software that needs updating and I've tried to back up the large database using SSH. I've done it several times before and had no problems. This time it said that the "file size limit was exceeded". What is the limit and wh...
Question: Are there disk space limits that apply to each MySQL database? What about table limits? Answer: There is no disk space limit imposed on each database. The disk space being used by each database is simply counted against the disk spa...
QUESTION: How can I check the version of MySQL running the database for my site? ANSWER: For a quick answer, visit the Server Info section of your CNC [1]. You can also quickly determine the version using the 'version' command once logged in to t...
QUESTION: I have a Trailblazer package with IRs under it. I would like to access MySQL from the IRs. Can I? ANSWER: IROs and DS-IRs include MySQL access privileges via the primary domain they overlay. You may allow "one" IRM to access MySQL, ...
Question: Using php, when I try to include files on mydomain.com on Rasmus I get the following error: Warning: Failed opening '/xmydomain/inc/footer.inc' for inclusion (include_path='') in /big/dom/xmydomain/inc/connect.inc on line I can corre...
QUESTION: Can you add .php in your apache httpd.conf file to work as well as .php3? Can you also add index.php as a default name for a document? We have a forum package that needs this in order to function correctly. ANSWER: The extension ".php" is...
QUESTION: It seems as if PHP Includes are taking a long time. The entire code for this page is: and the file to be included is only 3KB (give or take some bytes). Pages with multiple includes have slowed to a crawl. Can you look into the causes...
Question: I have set up an email form that uses the PHP function mail() to send a message to an auto-responder with the intention that the auto-responder would respond to the form's poster ($email). This is not happening. The php script sends the m...
FutureQuest provides MultiLevel Versions of PHP, which is known as PHPML. The Default version of PHP is the most current stable version of PHP and you can determine what version of PHP your package is currently using from your CNC Server Info Page. ...
UPDATE: phpMyAdmin is now available pre-installed on all Genesis Class [1] servers. To access, use the "phpMyAdmin" link in your CNC [2]. If you have not already upgraded to Genesis Class, you can find a (free) upgrade option under "Server Info" in you...
Question: Browsing from MyPHPAdmin is working for most of the databases/tables, but for database "xdomain_5" table "MemFull" browsing is returning: "SQL-query: SELECT * FROM MemFull MySQL said: Lost connection to MySQL server during query" ...
QUESTION: How can I troubleshoot my PHP scripts? Where are my error logs located? ANSWER: PHP errors will be logged in /big/dom/x_domain_/logs_cgi/php_error Apache errors will be logged in /big/dom/x_domain_/logs_web/error PHP errors from SSL...
This guide will explain the process of uploading files using PHP on the FutureQuest [1]® servers. This tutorial assumes that you have some experience with PHP. PHP on the FutureQuest [2]® servers runs under Secure_Mode [3]TM, which was devised by Futu...
The phpinfo file will output a large amount of information about the current state of PHP. This includes information about PHP compilation options and extensions, the PHP version, server information and environment, the PHP environment, OS version informa...