Different methods of publishing sites using Plesk control panel..

Here’s a brief documentation on creating & publishing sites using different methods. Once you add a Domain in Plesk control panel, you can create your site content (Web pages, scripts & graphic files that compose your site) on your home or office computer & then publish it to the web server in any of the following ways:

* Through FTP connection (most common & easiest way),
* Through Plesk File Manager,
* Through Adobe Dreamweaver or Microsoft FrontPage software.

Let’s go through each of the following processes one-by-one.

1) Publishing Sites Through FTP:

1. Connect to the server with any FTP client program, using FTP account credentials that you specified during setup of hosting account or obtained from us in the welcome email. Ensure that the passive mode is enabled if you are behind a firewall.
2. Upload files & directories that should be accessible through HTTP protocol to the httpdocs directory.
3. Place your CGI scripts into the cgi-bin directory.
4. Close your FTP session as you’re done with publishing the site using the FTP method

2) Uploading Sites Through Plesk File Manager:

1. Log in to Plesk control panel.
2. Click the domain name you need.
3. Click File Manager in the Hosting group.
4. Create & upload files & directories.

Place the files & directories that should be accessible via HTTP protocol to the httpdocs directory. Place your CGI scripts into the cgi-bin directory.

* To create a new directory within your current location, click Add New Directory in the Tools group, specify the directory name & click OK.

* To create new files in the required directory, click Add New File in the Tools group, in the File creation section specify the file name, select the Use html template check box, if you want file manager to insert some basic html tags to the new file, & click OK. A page will open allowing you to enter the content or html-formatted source of a new file. After you are done, click OK.

* To upload a file from the local machine, click Add New File in the Tools group, specify the path to its location in the File source box (or use Browse to locate the file), & click OK. You can upload up to 3 files at once through three separate File Source boxes. If you are uploading an archive file (.zip or .rar), select the corresponding Upload archive & extract it check box to extract the uploaded archive contents in the folder where the file was uploaded.

* To view or edit an existing file, click its name. When editing an HTML file, Plesk opens internal WYSIWYG editor by default. If you want to edit the source code of the HTML file, click Html. To return back to WYSIWYG mode, click Design.

When you upload web content through File Manager or FTP, your control panel automatically sets the appropriate access permissions for files & directories.

* To rename a file or directory, hover on one of the icons which displays the ‘Rename’ text. Type in a new name & click OK.

* To copy or move a file or directory to another location, select the required file or directory using the appropriate check box, & click Copy/Move. Specify the destination for the file or directory to be copied or renamed to, then click Copy to copy, or Move to move it.

* To update the file or directory creation date, click Change Timestamp. The time stamp will be updated with the current local time.

* To remove a file or directory, select the corresponding check box, & click Remove selected icon. Remove Selected. Confirm removal & click OK.

3) a. Publishing Sites from Microsoft FrontPage:

Microsoft FrontPage deals with two kinds of Web sites: disk-based & server-based. In short, a disk-based site is a FrontPage Web site you create on your local hard disk & then later publish to a Web server. A server-based site is one you create & work with directly on a Web server, without the extra step of publishing. Here’re the instructions on publishing only disk-based web sites.

You can publish disk-based web sites either through FTP or HTTP. The server your account is hosted on is running FrontPage Server Extensions, hence you would publish your site to an HTTP location. For example: http://your-domain.com/MyWebSite. If your server supports FTP, you would publish to an FTP location. For example: ftp://ftp.your-domain.com/myFolder.

After publishing, you can manage your site through FrontPage Server Extensions.

To access FrontPage Server Extensions management interface:

1. Log in to Plesk.
2. Click the domain name you need.
3. Click FrontPage Management in the Hosting group.
4. According to the Microsoft FrontPage support settings of the domain, one of the following icons will appear next to Add New FrontPage Subaccount:
   • Click FrontPage WebAdmin to manage a site, which is not protected by SSL.
   • Click FrontPage-SSL WebAdmin to manage an SSL-enabled site.
5. Type your FrontPage administrator’s login name & password, & click OK.

For instructions on using FrontPage server extensions, see online help (FP WebAdmin > Help) or visit Microsoft web site.

3) b. Publishing Sites with Adobe Dreamweaver:

Before publishing a site from Dreamweaver, you need to define the site properties, that is, you need to tell Dreamweaver where your site files are located on your computer, & to specify the server to which you want to publish the site.

1. To define a site in Dreamweaver:
2. From the Site menu, choose New Site. The Site Definition screen opens.
3. Click the Advanced tab.
4. In the Local Info category, specify the following:
   • Site name. This will show in Web browser’s title bar.
   • Local root folder. This is the folder on your computer where all of your site files are stored. For example c:\My Site
   • Default images folder. Specify the folder where your site’s graphic files are stored. For example c:\My Site\images
   • HTTP address. Specify your domain name. For example, http://your-domain.com
5. From the Category menu, select the Remote Info item.
6. From the Access menu, select the FTP option. Most likely, your server supports publishing through FTP (File Transfer Protocol, commonly used for transferring files over the Internet).
   • FTP host. Type your FTP host name without the ftp:// prefix. For example, your-domain.com.
   • Host directory. Specify the directory on the server where your site will reside. In most cases, this is httpdocs.
   • Login & password. Specify the login name & password for access to the FTP account.
   • Use passive FTP. Select this option only if your computer is behind a firewall.

Specify the following settings:

7. To ensure that you specified the correct login & password, & that Dreamweaver can connect to the server, click the Test button.
8. To save the settings, click OK.

Now to publish your site:

9. Open your site in Dreamweaver.
10. From the Site menu, select the Put option (or press Ctrl+Shift+U simultaneously), this will make the files to be published over the server.

Best Control Panel

Control panel access is now provided as standard with more or less every web hosting package that you can purchase these days, regardless of the form of web hosting that you have chosen to use or the web hosting provider that you use for your web hosting needs. Control panels are available for any form of web hosting; for example, with shared web hosting services you may be provided with client side access to a web hosting control panel but with VPS and dedicated server hosting you are provided with your own installation of the product therefore meaning you have full control of it. The control panel that you are provided with is dependent on the operating system that you choose to base your web hosting account on, since not all web hosting control panels can work on a single operating system. The main thing to consider when choosing a control panel for a shared web hosting package or for your VPS or dedicated hosting server is whether you know how to use the control panel concerned; there is no point in ordering hosting based on a control panel that you are going to be unable to use. In order to use a control panel properly, you also need to ensure that your chosen web hosting package will be able to support it.

Control panels provide you with an easy way to manage your web hosting account or server using a web browser, but are seen by some as a waste of time since they themselves have the necessary skills to manage a lone server. If you are unable to see any advantages that control panels can bring to you, then it probably isn’t worth wasting your time looking for a VPS or dedicated server that come with a control panel, but shared web hosting packages normally come with client side control panel access as default. Some of the main advantages that control panels can bring you can include:

• web based management - since a majority of web hosting control panels are now web based, you need to use a web browser in order to use them to their full effect - this means that in theory you could use a web based control panel from any computer that is connected to the internet in any part of the world, providing you with a massive advantage when it comes to sorting server problems out
• client management - if you want to host your own web hosting clients and have a reseller hosting package, VPS hosting server or dedicated server then you can make use of a web hosting control panel in order to allow you to host and manage all your clients as well as to allow your clients to manage their own web hosting accounts
• ease of use - using a control panel makes it easy for you to manage your server and/or web hosting account since an easy to use GUI is provided, whereas without a control panel you would have to rely on your web hosting provider making the necessary changes on your behalf or you would need to have the necessary skills to manage a server.

Since control panels can provide you with so many advantages, it is important that you consider a control panel for the form of web hosting that you are looking into, regardless of whether or not you have the skills to manage a server for example. Even though you may have to pay extra for control panel access in the case of VPS and dedicated server hosting, the advantage of being able to manage your web hosting account or server from anywhere can benefit all users.

Prior to choosing the control panel that you think would be appropriate for use with your web hosting package, you will need to select the appropriate operating system on which you want to base your web hosting package so that you can make sure that your websites will be able to function correctly in the web hosting environment. Because of this, your choice of web hosting control panel will be reflected by the operating system that you choose to host your website on for the main reason that not all control panels are able to function correctly with some operating systems. However, some operating system dependent control panels that you may come across could include:

• cPanel - this control panel is currently only able to run on the Linux operating system meaning that a majority of web hosting providers use it to offer their shared Linux web hosting services, however, many web hosting providers also offer cPanel as a separate add-on which is available for their VPS servers and dedicated server hosting packages
• Plesk - although Plesk is available for both Linux and Windows based web hosting servers, it is seen as the most reliable control available for Windows web hosting meaning that it is used by a majority of web hosting providers in this area - Plesk control panel is slightly more costly than cPanel meaning that web hosting providers tend to shy away from using it for Linux web hosting services
• LXAdmin - LXAdmin is traditionally offered as a control panel for VPS hosting servers since it is included as a default template by web hosting providers who are using the HyperVM VPS control panel system to offer their VPS hosting services, this means that it isn’t available for other forms of web hosting including dedicated servers
• Helm - Helm is an old Windows web hosting control panel that isn’t used by many web hosting providers nowadays since it is easy as unreliable, therefore meaning that you shouldn’t be considering a Windows web hosting package if it is based on the Helm control panel.

All of the above mentioned control panels are provided by web hosting providers at the moment, therefore meaning that a majority of web hosting companies that you may look into will probably be offering a combination of control panels for their web hosting services based on the above list. However, since there is a lot of choice when it comes down to control panels, it is important that you do your research to ensure that you choose the right control panel for you.

Your choice of control panel can also be affected by other factors. One of the main factors is the specification of your VPS, since for example, cPanel requires that your server has at least 256MB RAM but that at least 512MB of RAM is recommended to allow cPanel to run smoothly on any Linux web hosting server. Other factors that may also influence your choice could include the overall cost of a license for your chosen control panel as well as how secure it is. These factors may affect your choice in the following ways:

• server specification - if you have a server that doesn’t have enough resources in order to cope with a control panel then you will find that the control panel probably won’t function correctly and that your server will frequently crash - this is something that you don’t want since it means that you and your clients may be affected in the event of downtime
• cost - some control panels can cost a lot for the right to use them, when in the fact they don’t provide users with value for money since they aren’t provided with a great wealth of features that could help boost their website traffic for example if they were provided with website enhancement features or script installers
• server security - one thing which more and more system managers are taking into consideration is system security, and how they can make their systems more secure to ensure that malicious attackers are unable to gain access to their servers in any way - this means that system managers are being more skeptical about how secure web hosting control panels are.

If you feel that the control panel you have chosen is right for you, then there is no reason why you shouldn’t go ahead and purchase the necessary license for it. Web hosting control panels are only suited to someone if they are secure and are able to meet the requirements of anyone that is going to be using them. Although some may be daunted by the cost of a control panel, the benefits that you will receive by purchasing a control panel will more than supercede the disadvantages you will face if you don’t purchase a control panel.

In conclusion, in order to choose the right control panel for you, you need to consider your requirements such as what you will expect from a web hosting control panel along with whether you think you will be able to use it correctly. As with anything, using a control panel will take some getting used to but you still need to do your research prior to purchasing a license so that you know what you are getting yourself into. Control panels can provide you with major advantages, and unless you have server administration skills, you will be at a disadvantage if you don’t purchase a control panel license.

About cPanel And Plesk

cPanel and Plesk are the two popular control panels that are provided by most of the web hosting services to aid the users create and modify their websites easily. cPanel is available only with Linux operating system, whereas, Plesk is available with the Linux as well as with the Windows operating system. However, the latest version of cPanel that will be released in the year 2008 will be compatible with both the operating systems.

When buying a hosting account, you must make several decisions. One of the important decisions is to consider about which control panel to choose that will be the easiest and also will have better in-built web utilities. There are many web control panels available, but the most popular are the cPanel or Plesk. Below is the comparison of cPanel and Plesk which should help you decide which of the two will suit your web needs.

The cPanel and Plesk both offer similar basic features. Using either, you can easily create, or edit, or delete e-mail accounts, thereby manage all your email accounts, as well as also perform all domains or sub-domains maintenance from either of the control panels. You can also upload all your files and manage them from your cPanel or Plesk account. There are other add-ons available with both and for most of the webmasters, these capabilities are sufficient to produce and manage good websites.

cPanel

cPanel (Control Panel) is a very popular graphical web-hosting control panel used to simplify the administration of websites. The cPanel is provided by the cPanel Inc. It is a proprietary product. cPanel is chiefly used by the commercial hosting services and being a proprietary product, it requires monthly license fees.

cPanel is a very popular control panel and is used by most of the web designers and web masters now-a-days. It was mainly designed for Speed Hosting. cPanel is based on Perl scripts and requires no access to the database most of the time. It is an excellent graphical user interface (GUI) which helps in developing and designing the website attractively and giving it a professional look.

cPanel has many features like the FTP, e-mail management, domain and sub-domain control, back-up facility, database management, etc. cPanel even takes extremely less time than most other to load. Web developers can have their own applications and add-ons like ‘Fantastico’ and ‘RVSkins’ installed using cPanel.

cPanel even has a statistics sidebar, which gives you every detail of your website, for example, the domain name, e-mail accounts, disk space usage, SQL database, monthly bandwidth used, sub-domains, parked domains, and many more exciting applications are provided by the cPanel.

cPanel even provides Web Host Manager (WHM), which is specifically used for simplifying the reseller web hosting. By using this feature, you can easily set up a reselling account and resell web hosting service.

Migration of your website and the web hosting account to another web hosting service is easily possible through the site migration module as the cPanel. This makes it very easy to transfer your entire site or some important data from one site to another.

Plesk

Plesk is the most preferred website control panel now-a-days, as it is more reliable compared to any other website control panel. The fact that, it is compatible with the world-renowned Windows operating system makes it more special. Plesk has different versions for Windows and the Linux operating systems. You can even use the same control panel for different operating systems. Plesk is also very easy to learn. This makes it very easy for the users to learn this control panel and, in turn, saves a lot of time and money.

However, the main disadvantage of Plesk is that the web developers and the web designers cannot create their own applications and add-ons in Plesk. Also, there is some security problem noted with Plesk. Hackers can easily gain access into this control panel even if the user name and password are changed often.

So, if you want the control panel which is compatible with Widows as well as Linux operating systems, then you can choose Plesk. However, if you want the easiest control panel which allows you to install many attractive programs, then you need to choose the cPanel.

More notes on the cPanel and Plesk that will help you decide further:

The cPanel and Plesk both have a great graphical user interface (GUI) to begin your work from. It is said that the cPanel has the better GUI and is user-friendly as well. The Plesk graphical user interface (GUI) can appear a bit difficult to a first-time user. cPanel must have been designed specifically for the novice users than the Plesk design, hence the cPanel is preferred by the novice and also by the professionals.

cPanel is being provided by almost all the major web hosting services and includes the Fantastico Deluxe installer that again includes many wonderful web utilities and powerful scripts. Using the Fantastico, you can easily install forum blogs, content management systems (CMS), e-mail accounts, community boards or forums, even install the e-Commerce shopping cart solutions, and other web tools to make your website very professional easily. There is absolutely no need to know web programming, coding, or advanced database knowledge. You can install all these utilities and scripts and have them running within minutes.

Plesk also provides an application pack. Plesk also can use major third-party web utilities, but the cPanel and Fantastico seems to be in more demand.

To credit Plesk, by the way, it can support both the UNIX and Windows based web servers while cPanel can only be used on UNIX-based web servers. As the UNIX based servers are not expensive to utilize, most of the webmaster will prefer the cPanel as it costs less to host their websites.

If you have decided to publish your website on  World Wide Web then You must to register a unique domain name. After domain registration process you can add your unique domain name through Plesk control panel on a windows hosting. Plesk is easy and popular control panel for windows server hosting.

First you need to logging to your Plesk Control Panel. You will get your  plesk control panel logging details by your web hosting company.

Please use following steps to add your new domain name in your plesk control panel.

Login your Plesk control panel>>>
Now click on clients from the navigation bar on the left.

· Click the Domains shortcut in the navigation panel.

Read the rest of this entry »

Using ASP.NET Enterprise Manager

ASP.NET Enterpise Manager is a web based database management system designed specifically for the management of Microsoft SQL databases through a web browser, without the need for any desktop database management systems such as Microsoft’s SQL Server Management Studio. ASP.NET Enterprise Manager is included as default with an installation of Plesk for Windows, meaning that if you are a customer who uses Plesk based Windows hosting, you will most likely have used ASP.NET Enterprise Manager at least once to manage a Microsoft SQL database that you have hosted under your web hosting account. The ASP.NET Enterprise Manager application itself is an open source one meaning that if you run your own stand alone Microsoft SQL database server, you have the ability to install this program on your server so that you can remotely manage your databases from any internet connected location in the world, just so long as you have access to a web browser.

The application is based on the Microsoft ASP.NET programming framework, which along with Microsoft SQL Server itself makes a very good combination of tools for developers who wish to build their websites and applications to run in a Windows based hosting environment. The main functions of ASP.NET Enterprise Manager are similar to those of PHPMyAdmin, which is a similar application designed for the administration of MySQL databases from a web browser; this means that if you are a multilingual developer who likes to develop using both MySQL and PHP along with ASP.NET and MSSQL then you will have no problems with managing the databases that you have created for your websites and applications through your web browser, although you might also be using a desktop database management system - although that is dependent on your requirements. In a Plesk environment, using ASP.NET Enterprise Manager is fairly easy since it will already have been setup for you by your web host, and Plesk makes it a breeze to launch since all you have to do is select the necessary web admin icon which should be located next to the database name on the database management screen, although this will be discussed at a later stage.

ASP.NET Enterprise Manager has only been designed for the web based management of Microsoft SQL databases, which is indicated by its name; it is because of this reason that it can only be run in Windows based web hosting environments since other operating systems such as Linux aren’t able to run ASP.NET based web pages or scripts for the main reason that ASP.NET is a Microsoft application, thus meaning that it can only be run on Microsoft operating systems. If you do want to setup your own installation of ASP.NET Enterprise Manager in order to manage your stand alone Microsoft SQL database server, then it is easy to setup since all you have to do is upload the necessary files and configure the necessary permissions; once thats done all you need to do is configure the application to work with your databases, and you can then start administrating and managing them from the comfort of your web browser from any internet connected location in the world, giving you freedom as to where you can manage them. The actual layout and structure of the ASP.NET Enterprise Manager application is based around and is similar to that of Microsoft’s desktop MSSQL database management application, which means that if you are used to using the desktop version then you will have no problems adjusting to the new web based interface that you will be provided with once you have it up and running.

Since the application is an open source one, there is no official line of support available for it; this means that if you are looking to install it yourself but don’t feel that you have the appropriate amount of knowledge, you should try and avoid doing so since you could end up damaging the server in which you want to set the application up - in this case you should just stick with using Microsoft’s desktop application to manage your Microsoft SQL databases that you have created and are using within your web hosting environment. If you feel that you need certain help with one specific feature of the ASP.NET Enterprise Manager, then your web host should be more than willing to help you out; if they are unable to, then you should consider looking at the manual for Plesk in the case that you are hosted on a Plesk based Windows hosting server.

Launching ASP.NET Enterprise Manager From Plesk Control Panel

Plesk provides ASP.NET Enterprise Manager as standard with the Windows version of its control panel to allow people who are using the control panel to manage and host their websites which need to be hosted within a Windows based hosting environment to manage their Microsoft SQL databases on the fly that they might need to power the backends of their websites or applications that are based on either the classic ASP or ASP.NET programming frameworks, both of which were produced by Microsoft. Launching ASP.NET Enterprise Manager from Plesk is a relatively easy task; to begin with, you will need to select the ‘databases’ icon from the hosting control panel for the domain that contains the database that you want to administrate:

You will then be presented with the following screen:

You will need to scroll down to the database management section, where several different details of the databases that you have created for the domain concerned are displayed; these different details are:

• type (circled red) - this is the system that the database concerned is based on, for example if you have created a MySQL database then you will see a dolphin symbol listed in this column and a smaller icon labeled ‘SQL’ if you have created a database that is based on the Microsoft SQL server database system
• name (circled green) - this is the name that you have chosen to give the database concerned, you will need to specify the database name for example in a dynamic web page or script that has been written in a scripting language such as PHP to enable the script or web page to interact with the database
• database server (circled blue) - this is the server on which your database is hosted, in most cases this will be the local server on which your entire web hosting account is located, meaning that interactivity between your scripts and databases should be easily achieved
• web admin (circled purple) - if you select the icon in this column then it will take you to the web based management panel for the type of database that you have select - PHPMyAdmin will be launched if its a MySQL database and ASP.NET Enterprise Manager will be launched if the chosen database is a Microsoft SQL based one.

In order to launch ASP.NET Enterprise Manager so that you are able to administrate a Microsoft SQL based database, you will need to find a database that has the Microsoft SQL symbol by it (see above); you will need to then select the web admin icon for the database concerned. This should then load ASP.NET Enterprise Manager for you, where you can then start to administrate the database that you have decided to load ASP.NET Enterprise Manager for.

As you have just seen, launching the ASP.NET Enterprise Manager from Plesk is a very simple task, which means that you can easily manage your databases from anywhere in the world as long as you have the internet; you will also need to make sure that you are able load Plesk from the location that you’re at first, since Plesk runs on an unfamiliar port for most routers which means that it might be blocked and won’t allow you to access it.

The ASP.NET Enterprise Manager Homepage

Once you have launched ASP.NET Enterprise Manager for the Microsoft SQL Server database the you want to administrate, you will need to select the appropriate database from the left hand pane so that you can start managing the different aspects of it:

You will then be taken to a page where you can choose to manage one of four different aspects related to the running of your MSSQL database:

• tables (circled red) - tables are the things that hold the fields for your database, and what will eventually contain the individual records for each different database entry, although in some situations you might only need to have one record dependent on what you want to use the actual database or table for
• views (circled green) - these are different factors that are related to the running of your database, unless you are an advanced user you will not need to touch these since they could effectively corrupt your database is not dealt with correctly
• users (circled blue) - you will need to setup user accounts for your database so that it can be accessed by your scripts and web pages that have been built using either the classic ASP or ASP.NET programming frameworks, both of which have been designed and produced by Microsoft
• stored procedures (circled purple) - these are designed to make dynamic web pages built using either the classic ASP or ASP.NET programming frameworks load faster, since they work in a way that allows the actual needed SQL query to be stored and then loaded when requested by either a dynamic web page or script.

It is evident that ASP.NET Enterprise Manager provides you with many tools that you can use to manage your MSSQL databases through your web browser. The functions that are provided are almost as powerful as those that are provided by Microsoft’s desktop database management system, although if you are a more professional user you will probably be using the desktop management program because of the extended features that it provides.

With the different factors that ASP.NET Enterprise Manager is able to provide you with, you are able to make sure that you can effectively manage and configure your database to work in the way that you want it to on the fly through your web browser using the web based control panel that you have been provided with by ASP.NET Enterprise Manager.

Creating a New Table

Whilst managing your MSSQL database, you will probably be wanting to create new table so that you can easily expand the functions of your ASP.NET or classic ASP based website or application, which can be easily done if you know what sort of functions you want to add to your website and that you know how to use a database in conjunction with it. In order to create a new table, you will first need to select the icon labeled ‘tables’ from the ASP.NET Enterprise Manager homepage for the database that you want to create the table for:

You will then need to select the ‘new table’ option which is located under the ‘tables’ option within the left hand panel of ASP.NET Enterprise Manager:

You will then be prompted to enter the following details:

• table name (circled red) - you will need to give your new table an identifiable name, this is because you will most likely want to be able to access it from your classic ASP or ASP.NET based web pages or scripts, and in order to do this you need to ensure that your table’s name is easily identifiable
• columns/fields (circled green) - you might want to take this chance to create the necessary fields which you might want to ensure that you are able to store the necessary details within your table and database - although creating a proper field will be discussed later on.

Once you click ’save table’ you should then be redirected to a page which should hopefully tell you that your table has been successfully created. Once you have created your table, you can then go on to the creation of fields so that you are able to organise the data that you have stored in your new table effectively, thus allowing you to edit or delete an existing database record if you feel the need to if it happens to be fraudulent - i.e. entered in by a spammer or some sort of malicious program that has managed to gain access to your database.

Conclusion

In conclusion, ASP.NET Enterprise Manager provides you with many features that you can use to effectively manage your MSSQL databases whilst on the fly, since you can easily view and manage your database and its contents through your web browser from any internet connected location, allowing you to manage your databases from anywhere in the world - whether it be on the top of Mount Everest using a mobile phone or on a boat in the middle of the Atlantic Ocean! ASP.NET Enterprise Manager’s integration with the Plesk control panel allows you to create your databases from within the Plesk control panel, and then edit and manage them through the ASP.NET Enterprise Manager meaning that you can easily create your databases on the fly as well, meaning that you can easily expand your website whilst you are on the move from any internet connected location in the world.

As mentioned previously, ASP.NET and Microsoft SQL databases make a good combination for developers who wish to build websites and applications that they want to host within a Microsoft Windows based hosting environment. Although both programs will only run on the Windows operating system, they are both freely available for use meaning that resources to help you to learn the different features of both are widely available for viewing and download. You will however require a Windows Server or Windows XP Pro license in order to have the IIS web server if you want use Microsoft SQL server and ASP.NET on your own dedicated server; these aren’t needed in a shared hosting environment since your web host will have purchased the Windows server license for the server on which you are hosted, thus meaning that you don’t have to worry about any sort of licensing costs unless you want to purchase a commercial application for use within your website.

You can download the free Microsoft Visual Web Developer from http://asp.net/ if you wish to learn and use ASP.NET and Microsoft SQL server but don’t have the funds to spend on a more professional program such as Microsoft Visual Studio. If you feel that you have the necessary knowledge and don’t require any sort of WYSIWYG editor or an editor which gives you hints and tips with your coding, then you can stick with the Notepad program that is included with Windows as standard - if you feel that this is too basic then you can always give jEdit a try. If you wish to view material related to teaching you ASP.NET and Microsoft SQL server then you can take a look at http://asp.net/ in general, since this site contains many different video tutorials with the main aim of teaching novices these two powerful programs in order to breed a new generation of knowledgeable programmers.

Using PHPMyAdmin MySQL Database Manager

PHPMyAdmin is the third party web based MySQL database management panel that is provided and installed as standard with both the cPanel and Plesk control panels, and in the case with Plesk it is provided with both versions (Linux and Windows); if you run your own server without a control panel, then it is also available for download and manual installation since it is open source software meaning that anyone is able to download it for use as many times and on as many machines as they want. With the use of PHPMyAdmin, you are able to manage any databases that you have created from either your cPanel or Plesk web hosting account on the fly, since it is an application that is accessible from your control panel’s homepage and can be used through your web browser, which means that you are able to manage your databases from any internet connected location where you are able to use a computer that has a web browser installed on it.

The main features of PHPMyAdmin allow you to create new tables in your database, as well as to edit and delete others which you have created previously in your database; you can also view and modify the data that has been entered into each individual table, which means that you can easily delete a row for example if you think it might be a fraudulent sign up, in the case that you are running an online shop or some sort of membership system for your website or online community. If you have decided to go with your own install of PHPMyAdmin on your control panel-less server, then you are also given the ability to create new databases on the fly through the system if you are logged into it as the server administrator, or if you are running it on a Linux machine - ‘root’; this makes PHPMyAdmin an all in one solution for someone who wants to be able to manage their stand-alone MySQL databases server on the fly without having to use a desktop database management system.

With the use of PHPMyAdmin in conjunction with a hosting control panel, such as cPanel or Plesk, you are able to manage all the MySQL databases that you have created without the need to open a new window or new program session each time you want to administer a different database; this means that if you are wanting to mange multiple databases that you have created for different purposes throughout your website, you are able to do so without having to use a complicated desktop database management system that might not even let you administer multiple databases, forcing you to open a new session to the server that you are wanting to use each time you want to manage a different databases, even if all the databases that you want to manage are hosted on the same server.

If you are using a control panel in conjunction with PHPMyAdmin, then you will not be able to use it to create new databases for your hosting account, since it is a limit that most web hosts choose to put on the web based administration program since it easily allows customers to create more databases than they are allowed to limited by the amount that has been assigned to their web hosting account; in this case you will have to use your web hosting control panel to add, edit and delete MySQL databases for your web hosting account.

In most cases, you will be using PHPMyAdmin to manage MySQL databases that you have created to be used in conjunction with your PHP based website or application that you are hosting within your web hosting account, which in most cases should be either Plesk or cPanel based to give you the most functionality; this is because PHP and MySQL are known to be the best combination when it comes to databases and scripting languages, since both are open source and can run on either the Linux operating system or on Windows based systems, meaning that PHP and MySQL based websites and applications can be hosted in almost any environment - other combinations are only able to run in certain environments, for example MSSQL and ASP.NET based applications will only run on Windows based servers.

As previously mentioned, MySQL is a database technology that is commonly used in conjunction with the PHP server side scripting language to give developers maximum flexibility when it comes to building their websites and what functionality they are able to achieve with the use of MySQL as the database engine to drive the backends of their websites and projects.

Launching PHPMyAdmin From cPanel

PHPMyAdmin comes installed as default with any cPanel installation, meaning that once you have cPanel installed and configured correctly, you can quickly and easily setup a web hosting account and start adding the databases that you want or need; once you have done that, you can then start using PHPMyAdmin to administer your MySQL databases. Launching PHPMyAdmin from cPanel is a relatively easy task, and is one that can be carried out from any internet connected location, just so long that you can access cPanel from the web browser that you are using; in order to launch PHPMyAdmin from cPanel, you will need to select the icon labeled ‘PHPMyAdmin’ from the ‘databases’ section of cPanel:

One thing to note is that through PHPMyAdmin in cPanel, you are able to administer all the MySQL databases that you have created under your web hosting account, meaning that you don’t have to launch a new window of PHPMyAdmin each time you want to administer a different MySQL database that you have under your web hosting account. Once you have selected the appropriate icon, you should be directed to a page notifying you that PHPMyAdmin is loading, then after that to the PHPMyAdmin homepage:

Launching PHPMyAdmin From Plesk

PHPMyAdmin is also available with both the Linux and Windows versions of the Plesk control panel to allow you to manage any MySQL databases that you have created or want to create within your Plesk based website hosting account; this means that you are able to host your PHP based website or application in a Windows or Linux based environment just so long as the Plesk control panel is installed and that the web server has been appropriately configured to allow this. In order to launch PHPMyAdmin for a MySQL database that you have created through Plesk, you will first need to select the ‘databases’ icon from the hosting control panel for the domain that you want to manage the database for:

You will then be presented with a list of databases that you have previously created in your Plesk website hosting account, the following features are displayed along with the databases name:

• database type (circled red) - this is shown as an image: if the database is a MySQL database then a dolphin will appear in the column concerned, and if it is a Microsoft SQL database then the Microsoft Windows logo will be displayed within this column
• name (circled green) - this is the name of the actual database which you chosen when you were creating it, this is the name that you will need to use in your server side scripts if you are wanting to use them in conjunction with a database that you have created
• server (circled blue) - this is the server that the database is hosted on, in most cases this is the local server on which your website is hosted, although the name of the external database hosting server will be displayed if different
• web admin (circled purple) - if you click on the image in this column, it will load the necessary web administration panel for the database that you have selected it for.

In order to launch PHPMyAdmin for a MySQL database that you have hosted within your website hosting account, you will need to select the web administration icon for a MySQL database that you have hosted within your web hosting account; PHPMyAdmin should then load for the database that you have selected to administrate. One thing to note is that unlike the cPanel version of PHPMyAdmin, the Plesk version will only administer one database at a time meaning that you will have to go back to the Plesk control panel and launch a new session of PHPMyAdmin for each individual database that you want to administer.

The PHPMyAdmin Homepage

Once you have launched PHPMyAdmin from either Plesk or cPanel, you should be taken to the homepage where you can then start to administer the database or databases concerned, with ease. PHPMyAdmin is able to provide you with many different details about the server on which you are hosted, and specifically the MySQL installation that is hosted on the same server as your website, these details might be needed when you are developing your PHP based website or application; the main details that the PHPMyAdmin homepage is able to provide you with include:

• MySQL server version (circled red) - this piece of information is important when developing PHP based websites and applications, since newer versions of PHP might not be compatible with older versions of MySQL and newer versions of MySQL might notbe compatible with older versions of PHP, which is normally the case in most situations
• server and username (circled green) - these two pieces of information are important since you will need them when developing server side PHP based scripts and applications which are going to be utilizing the MySQL database that you are administrating - the server name is the server on which the database is hosted, and the username is what you will need to gain access to the database concerned along with the password that you have specified for the username
• MySQL character set (circled blue) - this piece of information might be important to you when you are developing language related applications, which might be using a range of different languages and characters.

If you have decided to go with a stand-alone MySQL server with a manual PHPMyAdmin installation, then you will also be given the ability to create new MySQL databases through the PHPMyAdmin control panel, although this isn’t possible if you are using a cPanel or Plesk installation meaning that you will have to use your hosting control panel if you want to create new databases for use with your dynamic websites or applications. Links are also provided on the homepage to take you to different parts of the control panel to allow you to manage and administer different features of your MySQL databases, these will be discussed further on.

Administrating a Database

To administrate a MySQL database that you have hosted within your web hosting account, you will need to select one that you have created from within PHPMyAdmin. You will see that all the MySQL databases you have created under your hosting account are listed down on the left hand side of PHPMyAdmin if you are using the cPanel version, and if you are using the Plesk version you should notice that the MySQL database that you have chosen to administrate is listed down on the left hand panel as well:

Once you have clicked on the name of the database that you want to administrate, you should be redirected to the following management page for the database that you want to administrate:

From the management page for the database that you have chosen to create, you are able to carry out the following actions to help administrate your MySQL database effectively:

• create new tables - you will probably find that you will need to create new tables for your database every so often if you are looking to expand the functionality of your PHP based website or application, and new tables will be needed to hold the data so that the new parts of your website or application are able to function dynamically like the rest of the website or application
• management of existing tables - if you already have tables created in the MySQL database that you are managing, then you are able to edit and delete them from the same screen where you can create them from - this means that you can manage your tables easily and effectively through your web browser with the help of PHPMyAdmin.

The above options are available under the ’structure’ tab of the database management panel, other available options include:

• SQL (circled red) - you can use this part of the database management panel to execute SQL queries on your database, for example to create a mass of a new tables without doing it manually, or to do a lookup on your database so that you can search and pull up a specific record that you might have stored within your MySQL database
• search (circled green) - you can use this feature of the database management panel to search through all the records which you have stored in your database, and pull up a specific one for modification or deletion if needed
• query (circled blue) - this feature works in the same way as the SQL feature does, although it is much more manual an better for beginners since it allows you to specify the actual search parameters yourself, meaning that PHPMyAdmin will automatically create the necessary SQL query - basically it works in the same way but without the need for you to enter your own complete SQL query
• export (circled purple) - the export feature of PHPMyAdmin creates a ‘dump’ of your database which is basically an SQL file which you can download and use as a backup of your database, meaning that if your database does happen to get deleted for any reason then all you have to do is run the SQL query contained within the dump file which will then automatically recreate your original database for you
• import (circled yellow) - the import feature of PHPMyAdmin is the opposite to the export feature, meaning that it allows you to import any dumps that you have taken of your database.

Creating a New Table

As mentioned previously, you may want to be creating new tables for your database from time to time so that you are able expand the functionality of your PHP based website or application that is interacting with the MySQL database that you are currently managing through PHPMyAdmin. With expanded functionality, you might be able to bring in more visitors to your website if you are expanding it by increasing the number of services that you are able to provide your customers with, for example. In order to create a new table, you will first need to select the structures tab from the database management panel of the database that you are managing:

Once on the structure page, you will then need to scroll down to the section labeled ‘create a new table on database x’, and will need to enter the following details to aid in the creation of your new table:

• name (circled red) - this is the name that you want to give your table, you should make the name relevant to what the table is going to be used for - i.e. you should call it ‘members’ if it is going to be holding information related to the members of your website
• number of fields (circled green) - this is the number of different rows of data that you want your new table to have, a field is individual meaning that one field is dedicated to one piece of information i.e. a telephone number.

You will then be redirected to the management screen for the table that you have just created, where you will be able to create and manage the fields that you want your new table to contain and in order to help manage and organize the data that you want to store in your new MySQL database efficiently. You should create new tables for each different section of your website to help keep the stored data as segregated as possible to ensure maximum ease when administrating your MySQL database in the future. You should also use as many fields as possible to help keep the stored data segregated, just as you would with tables; if you keep your data organized then will be easier to view and find through the PHPMyAdmin MySQL database management system, and it will be much easier for your scripts and web pages to find the data that you want.

Creating a Field

Fields are the individual table rows in which MySQL stores your data, whether it be the data that you have entered into it through PHPMyAdmin or the data that has been added when visitors sign up to your website. Fields are needed to ensure that your database can be used properly, to store data; without fields in tables, data can’t be stored in your database since there isn’t any way that the data can be categorized and stored in the correct place as would be possible with the use of fields. In order to create a new field under the table that you have previously created, you will need to select a table from the ’structure’ tab of the management panel for the database that you are administrating; you will then be prompted to enter the following data in order to create a new field for the table concerned:

• field (circled red) - this is the name that you want to give your new field, you should make the name relevant to the data that is going to be stored within it - you need to give a field a name since it needs to be identifiable so that it can be used in conjunction with your PHP based websites and applications
• type (circled green) - this is the type of data that you are going to be storing in your new field - the two main types of data are varchar and int, a varchar being just regular words including numbers and int being short for ‘integer’ which in other words is a number which means that this would be the type if you are storing phone numbers under your new field
• length/values (circled blue) - this is what you want to limit the length of the data in the field to - if you are going to be using your database in conjunction with a PHP based website or application then you needn’t worry about this option since you can use your own code in your scripts to limit the length of certain fields
• null (circled purple) - if you choose to make the field null, then you are allowing for the field to be empty when used, meaning that you could end up having many blank fields - if you choose to make it not null then there will have to be data in the field for it to be entered into the MySQL database properly
• extra/auto-increment (circled orange) - if you want to make this the primary field which will be the id field for each separate database record, then you might want to turn on auto increment to ensure that each individual record receives an individual id when it is created or entered into the MySQL database that you are managing
• primary key (circled pink) - if you choose to make the field that you are creating the primary key field, then it will be the one which holds the individual key to identify each different record if needed, it is recommended that you make this field auto-increment as well to ensure that each record receives an individual id.

Once you click ‘create’, you should then be redirected to a page hopefully telling you that your new field has been successfully created and that you can start adding data using it. In most cases you are able to create as many different fields in your database tables as you want, although it is recommended that you only create the ones which you need, since too many can start to affect the performance of your database as well as MySQL in general. One thing to note is that every table needs a primary key field which should auto increment to ensure that each individual record which is created within the table receives a unique id so that they can easily distinguished between and sorted easily.

With the use of MySQL databases, you can easily expand the possibilities and functionality of your PHP based website or application since you are able to make use of the dynamics of having a database and using server side components to make the most out of your web hosting account. For example, you could start a membership system for your website to allow visitors to sign up and view premium content, and in this case a MySQL database would come in handy since you would need somewhere to centrally store the details of all the people who have signed up to your website.

Creating a Dump/Backup

You should regularly backup the contents of your database to ensure that if it does happen to get deleted or corrupted for some reason or another, you can easily restore it without experiencing too much unneeded downtime allowing you to get your website up and running again quicker than others who don’t have any sort of database backup might be able to. In most cases, the database is the centre or heart of your website and without it your website wouldn’t be able to run since all the website’s content is stored within it, and if your website has no content or is broken then you ight find your visitors going elsewhere - it is because of this that you should always take regular backups of your database to ensure that you don’t loose any website critical data or information that can’t get deleted. In order to create your dump/backup, you will first need to navigate to the ‘export’ tab of the database that you want to backup:

You will then be asked to select which tables you want to backup in the case that you are backing up an entire database, by default all the tables that your database contains are selected. You are given a number of different formats that your dump or backup can be downloaded as, some of these different formats being:

• CSV - comma separated values - this is a common file format that is usable on almost any operating system because of its age, dating back to the early days of business computing - is normally used with tabular data, such as that which you are trying to backup from your MySQL database
• CSV for MS Excel 2000 - comma separated values for Microsoft Excel 2000 - see above, the only difference being that this one is designed for use with Excel 2000
• Microsoft Word 2000
• PDF - portable document format - created by Adobe to allow easy exchange of documents, in most cases it is a read-only format meaning that you will be unable to modify the data contained within the backup
• SQL - structured query language - this will create an SQL file which will contain the code which you can easily run as an SQL query on another database or on a new one if the database that you happen to be administrating gets deleted or lost for some reason or another - will restore all original data in seconds, although the timescale does depend on the amount of data being backed up or restored
• XML - extensible markup language - this is normally used by developers since it allows them to specify and create their own tags when they are coding websites or applications - with a backup it utilizes custom tags to arrange the data efficiently within the file that you will be able to download.

Conclusion

In conclusion, PHPMyAdmin is a powerful third party web based database administration tool that will allow you to effectively manage all of your MySQL databases with ease from any internet connected location in the world, thus allowing you to manage your MySQL databases whilst you are on the move. With its management features you are given the ability to create and manage both tables and fields within your MySQL databases so that you can effectively manage and organize the data which you want them to hold; this means that can easily access the information held by your database from your PHP based websites and applications, giving your website maximum flexibility when it comes to expanding the functionality of it. You are given many different expansion options for your PHP based website or application when it comes to MySQL since you can easily create different features that utilize a database to hold your data in either the short term or the long term.

PHPMyAdmin is also an industry leader when it comes to open source database management systems, since it is bundled with both the cPanel and Plesk web hosting control panels, meaning that you are given a large amount of freedom to configure your MySQL databases the way you want them to be when it comes down to being hosting on a shared hosting package utilizes either Plesk or cPanel to manage your website as well as the other on the server as well as the server itself on which you are hosted. If you choose to use PHPMyAdmin on a stand-alone MySQL server then you are given even more advanced functionalities, such as the ability to use it to create new databases if you are logged into it as the root or administrator user thus meaning that you don’t need a third party control panel if you just want to administrate the databases that you are hosting on your server.

PHPMyAdmin is the right solution for you if you are looking to administrate your databases whether you are on the fly, at home or in your office; it contains features that make it superior to may desktop database management systems which gives one advantage, but the best advantage has to be the fact that it is web based meaning that you can access it from any internet connected location, and use any of its features - meaning that for example you could be sitting on a beach in Hawaii with a wifi laptop and be creating new tables for your database so that at the same time you are able to expand the functionality of your PHP website or application - although thats the last thing almost anyone would be doing! PHPMyAdmin is an open source application, meaning that it is freely available for download and use by anyone and can be used as many times as one wants to, meaning that you aren’t restricted by any license terms as you would be with a commercial application of the same type.

As mentioned previously, PHP and MySQL make the best programming and database combination since they are both open source and come with a range of tools and add-ons that allow you to make the most out of both. If you are looking to learn a dynamic server side language which you can use in conjunction with a database system, then you should look no further than PHP and MySQL - there are also a wide range of tutorials available in this blog and on the internet that you can use to aid you in the learning process. You can also buy a wide range of commercial books based around teaching you PHP and MySQL.