Web Hosting Media

Windows Hosting Directories

Local Virtual Directory

Local virtual directories created for folders stored on any hard drive installed on the computer running IIS.

When configuring a local virtual directory, you will be asked to assign an alias to that folder. This alias can be folder's name or any other name that identifies the site to the end user. Also, you will be asked to enter the path of the virtual directory.

Remote Virtual Directory

Remote virtual directories created for folders on hard drives installed on other computers within the IIS domain.

When configuring a remote virtual directory, you will be asked to assign an alias to that folder. You will also ask for the Universal Naming Convention (UNC) address for the folder. To access the folder using the UNC, you will have to enter a valid username and password. All visitors who access data in the virtual directory will automatically use this username and password.

A virtual directory is a folder that appears to the users, to be in the wwwroot (home) folder. However, a virtual directory can be on any computer in the same Microsoft Windows NT domain. Virtual directories created for folders located on:

The same hard drive as the wwwroot directory.
Another hard drive, inside the local computer.
Another computer's hard drive on the network. This machine must be in the same Microsoft Windows NT Server domain as the IIS computer.
Virtual directories established for both WWW and FTP services running on IIS.

Advantages

Virtual servers allow you to host multiple Web and FTP sites on one computer, reducing the need to allocate a computer and software for each site. Virtual servers using Host Headers allow one IP address to be used for multiple Web sites. Virtual servers also enable centralized administration and simple upgrading of known software.

Virtual directories offer the Web administrator flexibility when determining where files stored on the server. Files stored are most easily updated or accessed. Also, the additional storage capacity added without shutting down the server.

Disadvantages

Implementing virtual directories may result in a slight performance drop when accessing folders contained on another computer's hard drive. This performance drop associated with the transfer speed of data over a Local Area Network (LAN).

Hosting multiple virtual servers on the same computer may reduce the overall performance of the server. Web Virtual servers using Host Headers require a Web browser that is HTTP version complaint.

Companies	Price	Server Location	Price	Visit Now
Cloud SSD Hosting	$1.43 /mo.	WILMINGTON, DE, US	Price @ $1.43 /mo.	Visit Now
	$2.99 /mo.	LASALLE, CA	Price @ $2.99 /mo.	Visit Now
	$2.75/mo.	Burlington, MA, US	Price : $2.75/mo.	Visit Now
Lifetime Free Domain	$3.95/mo.	Panama, PA	Start @ $3.95/mo.	Visit Now
	$1.99/mo.	Arlington Heights, IL, US	Start @ $1.99/mo.	Visit Now
	$4.95/mo	AUBURN, MA, US	Start @ $4.95/mo	Visit Now
Cheapest Webhosting	$3.25/mo.	Burlington, MA, US	Start @ $3.25/mo.	Visit Now
	$3.95/mo	Columbus, OH, US	Start @ $3.95/mo	Visit Now
	$4.95/mo	NASHUA, NH, US	Start @ $4.95/mo	Visit Now
Managed WordPress Hosting	$89.00/mo.	Lansing, MI, US	Price : $19.00/mo.	Visit Now

Page Request on Windows Hosting

IIS supports HTTP through Microsoft Windows Sockets. HTTP is a client/server protocol used by the World Wide Web (WWW) service. It means that the client and server interact to perform a particular task. For example, a user can click a hyperlink on a Hypertext Markup Language (HTML) page on the Web causing the existing page to replaced with the new page on the user's screen.

What happens is a bit more complex. The HTTP client/server protocol performs the following steps:

The client browser uses HTTP commands to communicate with the HTTP server.
A connection is established from the customer to the server using the TCP port 80 (by default)
Once the connection made, the request message sent to the server. The requests are typically for a resource file consisting of an image, audio, animation, video file or another hypertext document.
The server sends a response message to the client with the requested data, and the code used to build the page on the customer computer.
The server ordinarily closes the connection, unless the client's browser has configured a "keep alive" option.

Microsoft Internet Information Server (IIS) supports the following Transmission Control Protocol/Internet Protocol) protocols:

Hypertext Transfer Protocol (HTTP)
File Transfer Protocol (FTP)
Simple Mail Transfer Protocol (SMTP)
Network News Transfer Protocol (NNTP)

The simple request message to the server sent in the form of a request method, Uniform Resource Locator (URL) and protocol version. The following is an example of an HTTP request:

get http//www.cpwebhosting.net/reseller/index.html

HTTP/1.0

In this method, the following elements used:

Get: This specifies the request method.

//www.cpwebhosting.net/reseller/index.html. It is the URL for the object requested

1.0 This indicates that HTTP version 1.0 used.

If the message request were a full request, then the additional information would be followed by Multipurpose Internet Mail Extensions (MIME) message containing request modifiers, client information and possibly body content.

Companies	Price	Server Location	Price	Visit Now
Cloud SSD Hosting	$1.43 /mo.	WILMINGTON, DE, US	Price @ $1.43 /mo.	Visit Now
	$2.99 /mo.	LASALLE, CA	Price @ $2.99 /mo.	Visit Now
	$2.75/mo.	Burlington, MA, US	Price : $2.75/mo.	Visit Now
Lifetime Free Domain	$3.95/mo.	Panama, PA	Start @ $3.95/mo.	Visit Now
	$1.99/mo.	Arlington Heights, IL, US	Start @ $1.99/mo.	Visit Now
	$4.95/mo	AUBURN, MA, US	Start @ $4.95/mo	Visit Now
Cheapest Webhosting	$3.25/mo.	Burlington, MA, US	Start @ $3.25/mo.	Visit Now
	$3.95/mo	Columbus, OH, US	Start @ $3.95/mo	Visit Now
	$4.95/mo	NASHUA, NH, US	Start @ $4.95/mo	Visit Now
Managed WordPress Hosting	$89.00/mo.	Lansing, MI, US	Price : $19.00/mo.	Visit Now

Using Perl for Development

Perl has two acronym " Practical Extraction and Report Language," and "Pathologically Eclectic Rubbish Lister,"

It's a retronym, not an acronym. That is, Larry inventor of the languate came up with the name first, and the expansion later. That's why "Perl" isn't in all caps.

There's no point in arguing which expansion is correct, because both of those are endorsed by Larry Wall, Perl's creator and chief architect, implementor, and maintainer.

In perl programs

#!/usr/bin/perl

is there in the first line. That first line is actually a very special comment. On Unix systems, if the very first two characters on the first line of a text file are "#!", Then what follows is the name of the program that executes the rest of the file. In this case, the program is stored in the file /usr/bin/perl.

Perl sees the value as a string. So you don't need to worry about the difference between numbers and strings, just use the proper operators, and Perl will make it all work.

In Perl, the two terms often used as if they're interchangeable. But, to be accurate, the list is the data, and the array is the variable. You can have a list value that isn't in an array, but every array variable holds a list (although that list may be empty).

Companies	Price	Server Location	Price	Visit Now
Cloud SSD Hosting	$1.43 /mo.	WILMINGTON, DE, US	Price @ $1.43 /mo.	Visit Now
	$2.99 /mo.	LASALLE, CA	Price @ $2.99 /mo.	Visit Now
	$2.75/mo.	Burlington, MA, US	Price : $2.75/mo.	Visit Now
Lifetime Free Domain	$3.95/mo.	Panama, PA	Start @ $3.95/mo.	Visit Now
	$1.99/mo.	Arlington Heights, IL, US	Start @ $1.99/mo.	Visit Now
	$4.95/mo	AUBURN, MA, US	Start @ $4.95/mo	Visit Now
Cheapest Webhosting	$3.25/mo.	Burlington, MA, US	Start @ $3.25/mo.	Visit Now
	$3.95/mo	Columbus, OH, US	Start @ $3.95/mo	Visit Now
	$4.95/mo	NASHUA, NH, US	Start @ $4.95/mo	Visit Now
Managed WordPress Hosting	$89.00/mo.	Lansing, MI, US	Price : $19.00/mo.	Visit Now

Use of Arrays in Web Development Programming JavaScript

The array creation functions organized into two categories: those that place the enhanced properties at the end, and those that put the enhanced features at the beginning.

The first four array creation methods place the improved properties at the end of the array and initialize all empty slots to "@." They differ in how they handle the improved properties.And the final three creation methods place the improved properties at the beginning of the array. This set of methods can be used to examine the consequences of not initializing the array, or initializing all of the elements to the same thing, and of initializing only the empty elements.

Associative Array

An associative array is a one-dimensional array of pairs. You access the left member of the pair with a numeric index. You access the right member of the pair with a string index equal to the value of the left member of the pair. For example, (left) myArray[1] = "red" but (right) myArray["red"]= "FF0000".

One of the biggest criticisms of associative arrays is that they are one dimensional. The argument made that the left and right sides constitute a second dimension, of size two, but this is not an actual multi-dimensional array.

In fact, two-dimensional arrays are really just arrays of arrays. Because of the nature of associative arrays, one can develop such complex structures with relative ease.

The function lotsOfColors() starts off by creating the associative array, colors, as well as a comma delimited string that lists the colors it uses. It then cycles through a loop for each color to be processed.

It first extracts the color we want from colorstring (as a string) and then sets the left element of the current associative pair to that string.

Arrays explicitly created by a function that takes a generic this object and gives it a size.

A Windows.ini file is an excellent example of the use of associative pairs. Every entry has a left element, such as *.doc, and a right element, such as c:winword.winword.exe.

In this case, the association is a relationship between a file suffix and the application that created it. Hypertext links are also associations, just ordered backward.

One array which arises frequently in JavaScript applications is an array of newly created child windows, since JavaScript does not provide such an array by default.

The function winArrayAdd( ) can be used to add a window to such a window array.

Since an array is just an unstructured object, we can conveniently make it into a more complex object. For example, we can add a description property to an array.

This is useful because the array may have a short name that is easy to use elsewhere in our code, but that name may not be very illustrative of the array's purpose.

An array is a primordial JavaScript object. Its properties, which represent the array members, can be anything. You must set the special property known as size, however, in your creation function. This property gives the length of the array (and is occasionally referred to as length for that reason). The size property usually put in the zeroth element of the array during initialization.

It means that your arrays will have n+1 elements in total; n elements for data, and one extra element at index zero to hold the array size. You need to be sure that your array access functions do not overwrite the zero elements.

The question is where in the element list they should be placed. If we put at the beginning, the array elements proper do not start at index=1. If we bring them at the end, the array elements are in the right place, but it is now harder to increase the size of the array.

It is because there are referencing problems if you access the properties by their array index, rather than by their names. We will examine the advantages and drawbacks of both approaches.

There is no initialization of the right members of the array. You can also arrange to do this in the createArray function, but only with some effort.

It is because the left element must be unique, and we have initialized all the array elements to the same value, namely the value init. If you have two array members containing the same value, you are only able to get to the first one.

In addition to creating arrays, it is often desirable to be able to reset or clear an array so that it may reuse. A particular procedure, known as a double replacement scheme, must be used to clear or reset an existing array.

This unique approach is needed because you have no way of knowing what values already stored in the array. In particular, you have no way of knowing that they are unique.

Companies	Price	Server Location	Price	Visit Now
Cloud SSD Hosting	$1.43 /mo.	WILMINGTON, DE, US	Price @ $1.43 /mo.	Visit Now
	$2.99 /mo.	LASALLE, CA	Price @ $2.99 /mo.	Visit Now
	$2.75/mo.	Burlington, MA, US	Price : $2.75/mo.	Visit Now
Lifetime Free Domain	$3.95/mo.	Panama, PA	Start @ $3.95/mo.	Visit Now
	$1.99/mo.	Arlington Heights, IL, US	Start @ $1.99/mo.	Visit Now
	$4.95/mo	AUBURN, MA, US	Start @ $4.95/mo	Visit Now
Cheapest Webhosting	$3.25/mo.	Burlington, MA, US	Start @ $3.25/mo.	Visit Now
	$3.95/mo	Columbus, OH, US	Start @ $3.95/mo	Visit Now
	$4.95/mo	NASHUA, NH, US	Start @ $4.95/mo	Visit Now
Managed WordPress Hosting	$89.00/mo.	Lansing, MI, US	Price : $19.00/mo.	Visit Now

Professional web design & SEO

Designing a professional web design is highly important in web development process. Web designing is one of the trickiest processes in web development and selecting the right web development company is hence highly important. You should be highly careful about all the aspects of web development.

Here are the four points that you need to think about, before selecting a web development company.

Focus on setting up your aspirations.
You should decide the budget.
Choose the right web design firm.
Pick the right web hosting company.

Try to analyze the following points too, before starting your search for web design firms.

The need for creating a website.

The period that you are planning to take to establish the website

Know your targeted visitors.

The exact place of your business and the places where you want to establish your brand

Your competitors

Are you planning for an online sale?

Are your competitors involved in an online sale?

What is the payment method that you are planning to adopt?

A proper research using the points mentioned above will help you to take a perfect decision regarding your website design and the web design firm that you need to approach.

CPWebHosting – cheapest web hosting provider is there to guide through the rest of the process.

Internet Marketing is extremely fundamental to whichever online Professional Web Design business. It is a significant fraction of the taken as a whole marketing procedure. The conversation of Internet Marketing imagines privileged accomplishment – advertising additional to extra people for superior proceeds.

Discussion of proceeds, the position of SEO psychoanalyst just cannot be tangential. Arguably, an SEO plays the noteworthy majority part in make sure that your internet marketing line of attack and website get the greatest visibility in the by now packed out the internet. An SEO analyzes web passage, and work out different stratagem so that your site receives top hits and draw users. The advanced the traffic, the advanced your ROI would be.

Your internet advertising achievement would also depend on other feature like a proficient contented strategy and as well by assuming state of the art website designing services and policy. Internet marketing is a cut throat business nowadays. The elevated the visibility of you in the cyberspace, the extra money you are for the most part likely to make. Triumphant sites like Amazon, eBay, Yahoo, Google, etc. were not conceptualized and constructed in a day. It concerned hours of come up with, use and use again of design stratagem and a foolproof marketing campaign.

At this current time, internet marketing is almost all person used and make advertisement on the websites and get more business. SEO is the best way to marketing on the web.

Companies	Price	Server Location	Price	Visit Now
Cloud SSD Hosting	$1.43 /mo.	WILMINGTON, DE, US	Price @ $1.43 /mo.	Visit Now
	$2.99 /mo.	LASALLE, CA	Price @ $2.99 /mo.	Visit Now
	$2.75/mo.	Burlington, MA, US	Price : $2.75/mo.	Visit Now
Lifetime Free Domain	$3.95/mo.	Panama, PA	Start @ $3.95/mo.	Visit Now
	$1.99/mo.	Arlington Heights, IL, US	Start @ $1.99/mo.	Visit Now
	$4.95/mo	AUBURN, MA, US	Start @ $4.95/mo	Visit Now
Cheapest Webhosting	$3.25/mo.	Burlington, MA, US	Start @ $3.25/mo.	Visit Now
	$3.95/mo	Columbus, OH, US	Start @ $3.95/mo	Visit Now
	$4.95/mo	NASHUA, NH, US	Start @ $4.95/mo	Visit Now
Managed WordPress Hosting	$89.00/mo.	Lansing, MI, US	Price : $19.00/mo.	Visit Now

Tips for Web Development

Use Heading Tags

Use H1, H2, H3 structure of the site corresponding to "Website name," "Section name," "Page topic," or start off with H1 being the main subject of the page itself, and h2, h3 being for sub-topics on the same page

It is excellent for search engine

Use H2 for the menu section, and the second for the main content.

Use Photo Gallery

Try free gallery scripts like:

Coppermine or web album generator from Google

Disable Copy Paste Operations on Books Website

Disable right click, i.e., Copy & Paste operations using JavaScript.

Specify Browser about XHML page

To specify a browser that a file is an XHTML file put DOCTYPE declaration. Only a few mainstream browsers support XHTML, like Opera, Firefox, and Safari.Most importantly, Internet Explorer does not support XHTML at all.

User Div/CSS for Tables

A site have a full table layout then the tables load first (with the colours) then the content but though with DIV/CSS full layouts the content loads first, then the layout turns on.

That is the biggest disadvantage of Table. The content is visible only after the whole table is loaded (at least the entire row loaded).

Frames with no borders

border=0 is not XHTML compliant

Use a frameset DTD since frames are not valid in any strict DTD. The object is the preferred element for importing a document.

To style the border, use in your stylesheet.

"<div>

<pre dir="ltr">frame {

border: 0 none;

}</pre>"

Frames are not compliant, they work with the transitional DTD

Use Photoshop

Design the entire page in Photoshop, then make any changes you want. Improve your design by a great deal, try various combinations, create the buttons and things so that it matches the design. Then finally, once everything else is over, go for the HTML part.

BookMark Link

Use a script/code for creating a "Make us your home page" link or "Bookmark us" link for website but it only works in Internet Explorer browser.

Code:

"<a href="javascript:bookmarksite("Bookmark Title", "http://www.site.com")">"

the javascript:

Code:

"function bookmarksite(title, url){

if (document.all)

window.external.AddFavorite(url, title);

else if (window.sidebar)

window.sidebar.addPanel(title, url, "")

Companies	Price	Server Location	Price	Visit Now
Cloud SSD Hosting	$1.43 /mo.	WILMINGTON, DE, US	Price @ $1.43 /mo.	Visit Now
	$2.99 /mo.	LASALLE, CA	Price @ $2.99 /mo.	Visit Now
	$2.75/mo.	Burlington, MA, US	Price : $2.75/mo.	Visit Now
Lifetime Free Domain	$3.95/mo.	Panama, PA	Start @ $3.95/mo.	Visit Now
	$1.99/mo.	Arlington Heights, IL, US	Start @ $1.99/mo.	Visit Now
	$4.95/mo	AUBURN, MA, US	Start @ $4.95/mo	Visit Now
Cheapest Webhosting	$3.25/mo.	Burlington, MA, US	Start @ $3.25/mo.	Visit Now
	$3.95/mo	Columbus, OH, US	Start @ $3.95/mo	Visit Now
	$4.95/mo	NASHUA, NH, US	Start @ $4.95/mo	Visit Now
Managed WordPress Hosting	$89.00/mo.	Lansing, MI, US	Price : $19.00/mo.	Visit Now

Requirements for Effective Web Development

HTML email/newsgroup messages

Not everyone has news or email readers capable of rendering HTML. HTML messages not only look terrible in non-HTML readers, but it also makes the post larger and therefore it takes longer for it to download. HTML developed for use on the web, and that's where it should stay.

Restricting Visitors

To restrict people from viewing some of the web pages and develop a login screen that accepts a username and password.
If it is check out, then only visitors allowed to go to the next page, if not, they get access denied.

Generate Random Page

Script to generate a random page from a list of pages within a site if a visitor clicks a link.
Simply do a db SELECT statement and specify the number of items you want, from which table and sort by date. Then display it with php or whatever you use.

cloak the email address in Forms
To cloak the email address in the forms so that the spammers can't read it.

Use Macromedia Flash

To create a more attractive web site you can use Macromedia Flash for right color combination, fonts, arrangements and content.Your design has to be beautiful, and content has to be original and provide your visitors what they're searching for your site.

CSS for Background Images

css for background image that can be sized for all of resolution of monitor. You COULD create several versions of the background image, each with a different width reflecting the most popular screen size/resoutions. You could then incorporate a javascript routine to determine what screen size a current visitor has, and selects/sets the body background image accordingly.
Which will just add bloat, and can actually hinder the usability and accessibility of the Web page. Techniques such as "Switchy McLayout" are examples of this type of detitrus, and should be actively avoided like the plague at all costs.

AJAX based popups

The AJAX based popups which are translucent and very efficient as it does not get blocked by popup blockers.
To make the popups at some places having images that take over the screen and usually has a background that has an opacity that you can still see the original page below it.

Companies	Price	Server Location	Price	Visit Now
Cloud SSD Hosting	$1.43 /mo.	WILMINGTON, DE, US	Price @ $1.43 /mo.	Visit Now
	$2.99 /mo.	LASALLE, CA	Price @ $2.99 /mo.	Visit Now
	$2.75/mo.	Burlington, MA, US	Price : $2.75/mo.	Visit Now
Lifetime Free Domain	$3.95/mo.	Panama, PA	Start @ $3.95/mo.	Visit Now
	$1.99/mo.	Arlington Heights, IL, US	Start @ $1.99/mo.	Visit Now
	$4.95/mo	AUBURN, MA, US	Start @ $4.95/mo	Visit Now
Cheapest Webhosting	$3.25/mo.	Burlington, MA, US	Start @ $3.25/mo.	Visit Now
	$3.95/mo	Columbus, OH, US	Start @ $3.95/mo	Visit Now
	$4.95/mo	NASHUA, NH, US	Start @ $4.95/mo	Visit Now
Managed WordPress Hosting	$89.00/mo.	Lansing, MI, US	Price : $19.00/mo.	Visit Now

MySQL on dedicated server

You can install MySQL by compiling the source code with the options that best suit your needs, or by downloading and installing a prebuilt binary.

Or you can ask the CPWebhosting Support team, and they will do it using the package management system appropriate to your operating system.

You can get both binary and source code at the MySQL website.

Before doing an installation, Operating system needs to prepared for MySQL. You need to create a mysql user and ground under which MySQL will run.

Steps to Compile

It is just a four steps process:

1. Run configureConfigure comes with a host of options you can specify using the syntax configure –option[=value].

For example,

configure –prefix=/usr/local/mysql

tells the installer to use

/usr/local/mysql

as it's installation directory.

2. Run make

This step performs the actual compilation.

3. Run makeinstall

This step takes the compiled binaries and installs all components of MySQL in their proper locations.

4. Under Linux, make sure directory owners are all in order.

chown -R root {INSTALL_DIR}
chgrp -R mysql {INSTALL_DIR}
chown -R mysql {DATA_DIR}

There is a significant difference between MySQL and PostgreSQL, so as a DBA (database administrator) you should know what these differences are, what features you expect to exist in an RDBMS.

As you can see in tables, PostgreSQL supports large set of features common in the commercial RDBMS world than MySQL does.

Features	MySQL	PostgreSQL
ACID compliance		Yes
Aggregate functions	Yes	Yes
ANSI SQL compliance	Incomplete	Yes
API for custom applications	Yes	Yes
Complex queries (UNION, UNION ALL, EXCEPT)	Yes	Yes
Views	No	Yes
Default column values	No	Yes
Dynamically loadable extensions	No	Yes
Extensible, user-defined data types	No	Yes
Foreign Keys	Yes	Yes
Functional Indexes	No	Yes
Functions	Yes	Yes
Hot stand-by	No	Yes
Index methods	Yes	Yes
Inheritance	No	Yes
Kerberos support	No	Yes
Locking granularity	Yes	Yes
ODBC support	Yes	Incomplete
Outer joins	Yes	Yes
Partial indexes	Yes	Yes
Procedural languages	Yes	Yes
Refrential Integrity	Yes	Yes
Replication	Yes	Yes
Rules	No	Yes
Sequences	Yes	Yes
SSL support	Yes	Yes
Stored procedures	No	Yes
Sub-selects	Incomplete	Yes
Transactions	Yes	Yes
Triggers	No	Yes
Unicode support	Yes	Yes

Companies	Price	Server Location	Price	Visit Now
Cloud SSD Hosting	$1.43 /mo.	WILMINGTON, DE, US	Price @ $1.43 /mo.	Visit Now
	$2.99 /mo.	LASALLE, CA	Price @ $2.99 /mo.	Visit Now
	$2.75/mo.	Burlington, MA, US	Price : $2.75/mo.	Visit Now
Lifetime Free Domain	$3.95/mo.	Panama, PA	Start @ $3.95/mo.	Visit Now
	$1.99/mo.	Arlington Heights, IL, US	Start @ $1.99/mo.	Visit Now
	$4.95/mo	AUBURN, MA, US	Start @ $4.95/mo	Visit Now
Cheapest Webhosting	$3.25/mo.	Burlington, MA, US	Start @ $3.25/mo.	Visit Now
	$3.95/mo	Columbus, OH, US	Start @ $3.95/mo	Visit Now
	$4.95/mo	NASHUA, NH, US	Start @ $4.95/mo	Visit Now
Managed WordPress Hosting	$89.00/mo.	Lansing, MI, US	Price : $19.00/mo.	Visit Now

Configuring MySQL server

MySQL has three different kinds of configuration, both for the server process at server startup and for the client processes when a user executes them.

In order of preference, these configuration options include:

Command-line options
Configuration file options
Environment variable options

MySQL specifies options according to the different groups, usually the names of the server tools. The options arranged in group segments. The group name placed within brackets and options applied to it follow.

It can be more clear when you will see the default /etc/my.cnf file.

[mysqld]

user=mysql

datadir=/var/lib/mysql

pid-file=/var/run/mysqld/mysqld.pid

socket=/var/run/mysqld/mysqld.sock

port=3306

basedir=/usr

tmpdir=/tmp

language=/usr/share/mysql/English

View the different options currently set for both server and client

Run mysqld directly with the –help option.

/usr/libexec/mysqld –help

changing the configuration of MySQL

basedir=directory

Specifies the root directory of your MySQL install.

batch

Executes in batch mode, meaning no command-line prompts or other information is sent to stdout. It is the default mode when used with a pipe.

character-sets-dir=directory

Specifies where your character set files stored.

compress

Tells the client and server to use compression in the network protocol.

datadir=directory

Specifies the location of MySQL's data files.

debug=filename

Specifies a file to send debug information.

force

Indicates that you want processing to continue for client utilities even when an error encountered.

host=hostname

Identifies the host to which a client should connect by default.

language=language

Specifies the language to use for localization.

log=filename

Specifies the file to which connections and queries logged.

log-isam=filename

Specifies the file to which isam changes logged.

password=password

Specifies a default password for clients to use to connect.

port=port_#

Specifies the port number to which the server should listen and to which clients should connect.

silent

Silently exit if a connection failure occurs.

skip-new-routines

Tells the MySQL server to avoid new, potential buggy routines.

skip-grant-tables

Tells the server to ignore all grant tables, effectively giving all users full access to the database server.

skip-locking

Potentially provides better system performance by avoiding system locking. It should not used in conjunction with isamchk or myisamchk.

sleep=seconds

Sleep between commands.

socket=name

Socket file to use for local connections.

user=username

Specifies the user name to use for client connections.

variable-name =value

Sets the specified variable name to a particular value.

verbose

Tells MySQL to talk more about what is happening.

wait

Tells the client to wait after a connection failure and then retry the connection.

MySQL supports multiple configuration files. As a general rule, it checks files in the following order of preference:

User configuration file (Linux only).
Configuration file specified through the –defaults-extra-file=filename option.
A configuration file in the MySQL data directory.
The system configuration file.
In all cases except the command-line and user configuration options, the name of the configuration file on Unix is my.cnf and on Windows is my.ini.
A Unix user can override system configuration information by building their configuration file in ~/.my.cnf.
The system configuration file on a Linux system is /etc/my.cnf.

Windows, on the other hand, has two system configuration locations, in order of preference:

C:my.cnf

C:WINNTSystem32my.cnf

You can alternately specify a file on the command line using the –defaults-file=filename option.

This option causes all the possibilities defined in other files to be ignored, even if they not overridden in the file you specify.

Companies	Price	Server Location	Price	Visit Now
Cloud SSD Hosting	$1.43 /mo.	WILMINGTON, DE, US	Price @ $1.43 /mo.	Visit Now
	$2.99 /mo.	LASALLE, CA	Price @ $2.99 /mo.	Visit Now
	$2.75/mo.	Burlington, MA, US	Price : $2.75/mo.	Visit Now
Lifetime Free Domain	$3.95/mo.	Panama, PA	Start @ $3.95/mo.	Visit Now
	$1.99/mo.	Arlington Heights, IL, US	Start @ $1.99/mo.	Visit Now
	$4.95/mo	AUBURN, MA, US	Start @ $4.95/mo	Visit Now
Cheapest Webhosting	$3.25/mo.	Burlington, MA, US	Start @ $3.25/mo.	Visit Now
	$3.95/mo	Columbus, OH, US	Start @ $3.95/mo	Visit Now
	$4.95/mo	NASHUA, NH, US	Start @ $4.95/mo	Visit Now
Managed WordPress Hosting	$89.00/mo.	Lansing, MI, US	Price : $19.00/mo.	Visit Now

Shell script to start, stop, and restart MySQL

Mac OS X automatically executes all scripts under the

/Library/StartupItems

Directory when the system boots up. If that directory does not yet exist, you will need to create it.

For MySQL, you should create the directory

/Library/StartupItems/MySQL

and place the startup shell script MySQL and the configuration file StartupParameters.plist in that directory.

Once those files are set up, you need to edit the host configuration file

/etc/hostconfig

and add the line:

MYSQLSERVER=-YES-

1.2.3.1.1 MySQL

The shell script to start, stop, and restart MySQL looks like this:

"#!/bin/sh

. /etc/rc.common

StartService( )

{

if [ "${MYSQLSERVER:=-NO-}" = "-YES-" ]; then

ConsoleMessage "Starting MySQL"

cd /usr/local/mysql

bin/mysqld_safe –user=mysql &

}

StopService( )

{

ConsoleMessage "Stopping MySQL"

/usr/local/mysql/bin/mysqladmin shutdown

}

RestartService( )

{

if [ "${MYSQLSERVER:=-NO-}" = "-YES-" ]; then

ConsoleMessage "Restarting MySQL"

StopService

StartService

else

StopService

StartupParameters.plist

The configuration file looks like this:

"<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE plist SYSTEM "file://localhost/System/Library/

DTDs/PropertyList.dtd">

<dict>

<key>Description</key>

<string>MySQL Database Server</string>

<key>Provides</key>

<array>

<string>MySQL</string>

</array>

<key>Requires</key>

<array>

<string>Network</string>

</array>

<key>OrderPreference</key>

</dict

></plist>"

Once installed, you should run the mysql_install_db tool to set up your databases.

Under FreeBSD, for example,

place this script in

/usr/local/etc/rc.d.

Once installed, you should run the mysql_install_db tool to set up your databases.

Well after starting the server, and before doing anything else, set a password for the root user:

mysqladmin -u root password a_good_password

Companies	Price	Server Location	Price	Visit Now
Cloud SSD Hosting	$1.43 /mo.	WILMINGTON, DE, US	Price @ $1.43 /mo.	Visit Now
	$2.99 /mo.	LASALLE, CA	Price @ $2.99 /mo.	Visit Now
	$2.75/mo.	Burlington, MA, US	Price : $2.75/mo.	Visit Now
Lifetime Free Domain	$3.95/mo.	Panama, PA	Start @ $3.95/mo.	Visit Now
	$1.99/mo.	Arlington Heights, IL, US	Start @ $1.99/mo.	Visit Now
	$4.95/mo	AUBURN, MA, US	Start @ $4.95/mo	Visit Now
Cheapest Webhosting	$3.25/mo.	Burlington, MA, US	Start @ $3.25/mo.	Visit Now
	$3.95/mo	Columbus, OH, US	Start @ $3.95/mo	Visit Now
	$4.95/mo	NASHUA, NH, US	Start @ $4.95/mo	Visit Now
Managed WordPress Hosting	$89.00/mo.	Lansing, MI, US	Price : $19.00/mo.	Visit Now

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this: