Bill Pratt asked:


When searching for your web hosting service provider, verifying if they offer cPanel is essential. cPanel or control panel would be the GUI or the graphical user interface, which is considered to be one of the best and most functional tools in the industry of web hosting.

It provides the end user with a more convenient and easier way to manage his website. It is a software that makes website administration, which includes the setting up and maintenance of web programs, a breeze. cPanel comprises of a set of web programs, which makes the more difficult jobs doable by even the novice end users.

Through the pictorial interaction of the web server and its webmaster, who is the one who creates the various features of their web server’s Internet presence, things like creating mailing lists, emails and blogs are made simpler.

The interface of the cPanel operates on a couple of Linux platforms, which are RPM-based through port 2082 or port 2083 with the authentication and the login done on a separate web page.

Logging into and using the different programs can be done prove to be straightforwardly. If you need a blog, a bulletin board made using PHP or a content management system, setup is fairly effortless and quick.

Since cPanel has made website administration a lot easier, it has been made the industry standard. It works even better when Fantastico scripts are used with it. It sets off a multitude of tasks, like MySQL table creation for different programs, removing the manual importing of scripts created by third-party vendors that are in the market today. Together, cPanel and Fantastico are able to streamline the process for the end user in setting up software and other applications.

cPanel has efficiently combined the scripts and programs that which used to operate separately. cPanel was able to standardize these programs and scripts, which made webhosting and setup a uniform package for users.

Because of this, cPanel has become an essential part of any web hosting service package that webmasters should check for before purchasing a plan.

However, there is a disadvantage for using cPanel. Since it is widely used, it has become the method of phishers and hackers that create scripts that run and command it to setup unauthorized sub-domains that will be able to gather information from innocent victims. This method is referred to as phishing, and the user must always look out for signs of these when utilizing the cPanel.

Besides this drawback, the benefits and advantages with regard to ease-of-use and the convenience of setting up programs, definitely overshadows the concern regarding phishers and hackers.

Without a doubt, cPanel is the best way to go for web hosting. It is able to provide the user with everything he needs to set up and maintain a website successfully and effortlessly.

techgeek asked:


I have a large form using html and php, but I would like to use javascript to check my mysql database for verification and auto fill support. Like if I wanted the second field when entered to automatically check my database to see if theirs already a record with that form data and then either give me a messege or auto fill the rest of the fields with the database data. How would I go about achieving this?

Rahul Rungta asked:


MySQL is a rock solid, lighting fast database server which has been designed for two factors speed and performance. It is the Ferrari of databases: Light weight, fast and Built for the high speed tracks!

I still hear an awful lot of stories from owners whose databases are running two slow. In my experience, the three main places to look for problems are:

1. Faulty Database Design

2. Bad Queries

3. Server factors

Faulty Database Design

Proper database design is the single most important factor for the ensuring performance and maintainability of the database. Here is what you need to answer when designing a table: Can I reduce the size of data that each row will have? Here is what you can do:

1. Use unsigned numeric values when the application will not store negative numbers. Like the “quantity ordered” of an item in an ecommerce application is never going to be -$125.

2. Use Variable length values instead of fixed length value i.e. used varchar instead of char.

3. Do not use unnecessarily large field sizes. For most ecommerce application “unsigned smallint” is more than enough to store inventory count. A field described as “unsigned smallint” can store a max value of 65535.

4. Don’t ignore normalization; its helps prevent unnecessary repetition of data. The part B of this is, don’t overuse normalization. If the table will not grow in size significantly, there is no point in normalization. For example, if the user table has just 20 rows (i.e. 20 employees in a company), all attempts of normalization are wasted.

5. Use Keys. Don’t decide keys by “The customer id has to be indexed in the order table”. If the order table is being searched 90% of the times by “order date”, it makes more sense to index “order date”.

Remember, how a table will be used should determine how it is designed. Spending time here will save years of frustration.

Bad Queries

It sounds too good to be true but you wont believe the number of developers out there who completely **** at writing queries. There are two types of bad queries:

a) Unnecessary Queries: These are the queries that shouldn’t have been made in the first place. The only way to avoid this is asking, “Do I really need this data?”

b) Inefficient Queries: These are the queries that do not use the underlying table structure or MySQL functions in the correct way.

Here is a starting point to start looking at problem areas:

1. Unnecessary usage of “Select * “statements when the entire processing is being done on a single column. The more data is fetched from the server the more work MySQL has to do and more bandwidth it takes.

2. Using sub-query instead of a join. On a properly designed database, joins are incredibly fast. Using sub-queries just shows a lack of knowledge.

3. Improper use of Keys. This is especially valid for range checks. Remember to use the “Explain” statement to check the usage of keys and then use the “use key” statement in your “where” clauses to force key usage.

Server Factors

Everything done correctly, there still may be some server factors that may be causing the system to be slow. These are:

1. Hardware related

2. Server configuration related

Here is what you can do about the hardware:

1. The more RAM is on the system the better it is. MySQL frequently fetches data from the RAM and more the RAM is on the system, the better it is.

2. Buy the fastest possible RAM! A slower RAM is just irony.

3. Once you are settled with the RAM size and speed, look for processing speed. MySQL can use multiple processors.

Once you are satisfied with the hardware, there are a set of variables in “my.cnf” that you must look at:

a) key_buffer_size: This describes the memory available to store the index keys. The default is 8 MB but you can set it to 25% of the RAM.

b) query_cache_size: This value is by default 0. if you have a lot of repeating queries like in reporting applications etc, make sure you set this value high.

c) table_open_cache: This determines the number of table descriptors that MySQL will keep in the cache. The default value is 64. But, if you have 100 users accessing a table concurrently then this value should atleast be 100. You also have to take into considerations joins etc. Thus, this value should also be kept high.

I hope this article will take one step further in unlocking the mystery of slow servers and help solve some of the problems.

Jossielyn Lucero asked:


Starting an online business may bring out a lot of questions especially when it is your first time.  For instance, choosing a web host for your business may require you to know more about some information regarding the server, choosing the right domain for your business and type of hosting you should go after.  As the business owner, it is very important that you know something about them if you want to take the most control over your website.  You must know how to do minor modification and how to make sure that your site can be found by your target market.

Cpanel is a web-based control panel that allows you to manage your domain and website.  It is the software that runs in most linux based hosting services.  Through this Cpanel, one can have the ability to manage all aspects of e-mail, back-up, files, script installation, and monitoring your website traffic.

Signing up under a web hosting account that uses Cpanel gives you total control of how you will run your website.   Your web host company may be able to help you if you got into problem using it but the software itself offers you total control to run a successful online business by yourself.

Anyone who decided to sell web hosting as part of his business would also have access to Web Host Manager where he can administer web hosting accounts for his customers.  With the use of this software, he can add, delete and modify new and existing accounts.

Signing-up with any hosting company means you agree to abide by the terms of the web host.  You have to keep up with the terms of this agreement for as long as you stay as their customer, which is usually renewable every year.  During this period, the web host company should be able to provide you support by ensuring that their server is in top shape to keep your business up and running 24 hours a day.  They should also provide you updated versions of the software and scripts to make sure that they will run securely and bug-free.

These website softwares are great help for everyone especially to those who are new to web hosting.  They serve as great tools to make administering a web host account simple and easy.  Inside the Cpanel account are step by step video tutorials one can follow if he needs to perform a certain task.    It makes administering multiple sites equally as easy as administering a single website.

It doesn’t matter what kind of website one actually wants to build.  Signing up under web hosting that uses Cpanel is a great option especially if it is your first time building a site. 

As an online business owner, your web host company can be considered your first and foremost business partner.  They must be able to support you with your business goals and endeavors.   A poor web host can be a primary cause of one failing doing business online so make sure that you choose a web host that has the tools that can help you run your business flawlessly.  Make sure that you choose one that you can rely on and can deliver what it promised.

Kashan Junaid asked:


Sun Microsystems elbowed into the enterprise database market Wednesday with the announcement of a proposed $1 billion acquisition of MySQL, an open-source database software company. The deal, which Sun Chief Executive Jonathan Schwartz calls the “most important acquisition in the company’s history,” makes Sun one of the first major public companies to offer open-source software and puts the company head to head with the three big vendors in the $15 billion database market: IBM, SAP, and its former database partner, Oracle.

Compared to those three goliaths, which provide database software to 86% of the enterprise software market, according to Forrester Research, MySQL offers a simpler and cheaper solution. That makes MySQL an appealing option for small- and medium-sized businesses, says Forrester analyst Noel Yuhanna. “Unlike IBM, Oracle and SAP, MySQL has never had 50,000 features, but it does have maybe 10,000 relevant features that are relevant to enterprises,” he says. “That cost savings is one of the key reasons that users have looked at open source, and fewer features means it’s easier to use and manage.”

MySQL’s lighter-weight database system may also fit into Sun’s ambitions of becoming a major player in “utility computing,” a model of information technology infrastructure that pipes in software applications, processing and storage over the Internet rather than from a company’s own data centers. “All other databases on the market today were designed for an offline, back-office use,” says MySQL Chief Executive Marten Mickos. “Our relevance grows as enterprises shift to Web-based architecture, and that’s what’s happening right now.”

One billion dollars, split between $800 million in cash and $200 million in stock options, may seem a hefty price tag for MySQL, which gives its software away to 99% of its customers. But the 1% of MySQL users who do pay for support include big names like Google (nasdaq: GOOG - news - people ), Yahoo! (nasdaq: YHOO - news - people ), Nokia (nyse: NOK - news - people ), and Alcatel-Lucent (nyse: ALU - news - people ). As Sun’s (nasdaq: JAVA - news - people ) size lends legitimacy and the guarantee of long-term service to MySQL, the acquisition will likely convince more and larger enterprises to sign on to MySQL’s cut-rate database systems, Yuhanna says.

“This makes Sun a major open-source vendor, and it will have a major pricing impact on the traditional vendors,” says Donald Feinberg, an analyst with Gartner.

The purchase of MySQL, which has built one of the best brand names among privately held open source companies, is yet more evidence of how tough it is for open source companies to go to the public markets. Red Hat (nasdaq: RHT - news - people ), which has a market capitalization of about $3.7 billion, remains the primary example of a publicly traded open source company: Last year, it bought open source middleware provider, JBoss, for $350 million. Novell (nasdaq: NOVL - news - people ) snapped up SUSE Linux in 2004 for $210 million.

On Sun’s part, the acquisition gives the server and software company a database offering that is capable of storing and manipulating the information used by its software tools, a role it has largely handed to Oracle. That means Sun is attempting to tap into some of the revenue that it formerly directed to Oracle, and may strain the company’s relationship with its former partner.

For Oracle, the deal shouldn’t come as much of a surprise. Sun first hinted at the possibility of entering the database market in 2005 when co-founder Scott McNealy cryptically showed analysts a list of database players including the words “SunDB.” Since then, Sun has made minor investments in another open-source solution, PostgreSQL, hiring developers to work on that non-commercial database product and offering its own support to users.

The MySQL deal, which is slated to close in the first half of 2008, is a sign that Sun is pushing into more open-source software applications and could even enter the Linux market, the terrain of companies like Red Hat. “Sun is doing more and more with being a provider of open source in this enterprise infrastructure space,” says Raven Zachary, an open-source analyst at 451 Group. “I’d start to look at them as a bigger player in software, especially open-source software, through this and other acquisitions.”

Krakowiak asked:


I’d like to be able to upload resumes into a mysql database, be able to search them by keywords, and retrieve them when needed. Is saving them as Blob the best way? If not, which format should they be saved as? I currently have them saved as blobs, but can’t retrieve them, or search through them. I’d like to build a generic Applicant Tracking System using PHP and mysql.

If you can, please help.

If you will advise me to buy an ATS system, save your energy on typing. That wouldn’t be the answer to my question. I am considering buying an ATS if this becomes too complicated…

Thanks!

Ganesh I asked:


When I go to my phpmyadmin(mysql manager) I see a table called wp_users in which passwords of all users are stored but they are encrypted(Example: 3khj4k2lk32lkdddlkfk4kl43ljkfkdl but thats npt the real password). So dus anyone know how to decrypt it?

John Ugoshowa asked:


MySQL is a heavy-duty database server. Used with various software languages, most notably PHP, and part of the LAMP family (which is comprised of Linux, Apache, MySQL, and PHP),

Whether it’s a customer relations management list or medical records, any data you have that needs storing, is stored on a database. You will need a database management system to add, access, edit, and process data in your databases, and MySQL is one of the best and most comprehensive packages on the market. MySQL can also be used as a relational database management system, which means it can store data in various tables that can communicate with one another rather than all in one large “storeroom” of data.

You can run MySQL as a server in your local device or in a remote server. All you need to access your MySQL databases and MySQL functionality is your server name (such as the name server of your MySQL web hosting provider) or the appropriate IP address. You can then input your various commands, most likely using PHP scripts, to interact with your various databases. These commands are written on programming scripts.

When choosing a MySQL web hosting provider, you’ll want to consider some additional factors beyond the standard uptime, backup/redundancy systems, bandwidth, email, and bandwidth concerns.

* Databases: If you’re seeking a MySQL web hosting provider, you’re surely planning on making databases a significant part of your web-presence. You therefore need to find a MySQL hosting provider that offers you at least as many data structures as you might need. A host that promotes itself as a MySQL hosting provider must offer its clients with multiple websites at least five databases.

* Interface: You’ll be working with your databases intimately and frequently. You’ll want a MySQL hosting provider that’s designed its admin interface with the MySQL user in mind. If you have various staff-members involved in the building and maintenance of your various tables and databases, you’ll want to be able to create multiple user I.D.’s to allow varying degrees of secure access. CPanel is a good administrative dashboard to have for MySQL databases.

* CRON support: A cron helps you to run specific scripts for regular, routine tasks to be run at periodic intervals. A MySQL hosting provider should allow you to set up and manage crons from your admin control panel. These scripts are also good for Preventive Maintenance routines.

* PHP Info: The most common script for MySQL databases is PHP. A MySQL hosting provider with PHP extensions enabled is likely to be more frustrating than useful to you. By checking into a prospective MySQL hosting provider’s PHP capabilities, you can ensure compatibility between your scripting language and your database management, thus saving yourself tons of trouble and loads of regrets later on.

Remember, if you are running MySQL databases; make sure that you get a host that specializes in MySQL hosting.

518pablo asked:

This first video will be an overview of what will be covered in the video series

jaS2baca asked:

Tutorial para ligar o Mysql com o C++ builder ou com o Delphi