A typical question:
I manage a small website I built with a WYSIWYG hosted on cPanel 11.25.0-STABLE, and am trying to install a little free PHP timeclock I found. I’ve already uploaded all the files to my File Manager, but I’m unfamiliar with mysql and don’t know how to proceed with the setup.
Thanks!
Answer: You are not alone. Free hosting will not be the right hosting for most people. Web hosting is the heart of your business and can mean the success and failure for your business.
Before we answer your question, let us review the 7 factors to look for in a good web hosting. An excellent hosting:
- has friendly Live Chat from the start,
- gives more-than-enough webspace,
- offers no limit on bandwidth,
- gives multiple add-on domains,
- has friendly Site Builder,
- has Fantastico and QuickInstall to quickly install apps like WordPress, Joomla, Drupal, OSCommerce, ZenCart and more
- can be easily upgraded to VPS or one of their best dedicated server plans if and when your business require.
To answer your question, many experienced web developers suggest to try Hostgator. If you are building your first website and needs a hosting plan, experts usually highly recommend going with Hostgator because they are the best cheap cpanel hosting around.
What if you find out that Hostgator sucks after you signed up with them? HG has 45 days, longer-than-industry-average money back guarantee so you have ample time to test them out. They are rated A+ by Better Business Bureau which shows their commitment to customer satisfaction. You also do not have to pay for the first month. You can just try their fully functional hosting service – you pay only $0.01 (you need to use the special coupon code). Do you know any other hosting company that can give you that kind of assurance? Anybody can grab an account from Hostgator for almost FREE.
How to Get an Unlimited Hosting Plan for Only 1 Cent
Click the coupon below try Hostgator cPanel hosting for almost free. If you already know that Hostgator is what you want, you can even save 25% off the normal price with the Hostgator coupon 2016 below.
Who Should Not Try Hostgator
To be honest, no web hosting service is perfect. Drawback of Hostgator includes:
- No free domain name – but you can easily get a domain name from the best domain registrar such as Godaddy or Namecheap for $10 or less. Would you agree that a website is not complete without a domain name?
- You need to pay full price after your first invoice – well, they need to make money too and all the support and great service do come with a cost
If you are still not sure if HG is right for you, or you have specific query about anything at all, try the Live Chat at HG. They are fast and knowledgeable. Just shoot them some questions before you decide.
Two ways:
in your cPanel, you have a ‘Shell Access’ or ‘SSH Terminal’. This is how you access the Unix/Linux box hosting your website. Within this terminal, you can add/delete from / modify anything pertinent to your page. Including MYSQL entires.
In your cPanel, you have a tiny link to ‘phpmyadmin’. phpmyadmin is a graphics user-interface for displaying and working with mysql data. Much like any other graphics interface, you are presented with a multitude of options for working mysql data —- one of them, namingly, the import feature.
with the SSH terminal you can simply login to my sql by doing
mysql -u username -p
leave it blank after the -p you will be prompted to enter your mysql password. enter it now.
Cool. now you know how to log in through a terminal; let’s discuss procedure for uploading data into an existnig database. For this example our existing database is named "mydb1"
mysql -u username -p mydb1 < /location/of/the/file/i/want/to/upload.sql;
If the name of the database is correct, and the location to the file that you want to upload into your sql is correct (probably going to end up being something like /var/lib/mysql/upload.sql), then this will auto integreate into your database. If there are no matching tables to fit to upload.sql, new tables will be created based upon the data that exists in upload.sql.
For all intents and purposes, this is simply an example. In this situation, you are completely overwriting the existing database ‘mydb1’ with the upload.sql file. You don’t want to do that.
There is a php tool called phpMyAdmin that exposes the layers of your MySql DB. Clunky, but there isn’t anything better for the price (free). There is an import feature for SQL.
You need that page tool. You need to see how it installs. And, most importantly, you need to learn how to lock it away. Too many noobs leave phpMyAdmin unguarding the back door of their web site. So, learn how to create a privileged folder to install phpMyAdmin.
Linux would have been a whole lot, like 1,000,000 times easier and more secure. You should be aware of that.