tips

SQL download from PHPMyAdmin

To create the database backup, you have three options .

1. Use the cpanel backup option.  This is usually the easiest., however the file will be in .sql.gz format.   If using this option, you will need to first unzip the file using a program such as winrar, then to open the file, unless you have another program already setup to open it, you would use wordpad.

2. Alternative way:

a. login to cpanel
b. click on mysql databases
c. scroll down and click on phpmyadmin
d. If you have more then 1 database, on the left hand side choose the database you want to download.  Do NOT click on any tables for the individual database
e. on the right hand side, click on “export” and make sure that all your tables listed are highlighted.
f. Make sure “save as file” is selected
g. click on “go”

This will allow you to download your database into a .sql file.

3. Another alternative:

Use the same steps as above except on step 6 do NOT “save as file”.  This will display your complete database within the browser window, and you can then do a “copy/paste” into a wordpad file.  If using this method, if saving the information to your local system, save the file as a .sql in case you ever need to import it to phpmyadmin.

WARNING:

If your Database is excessively large, and you may experience issues with either method above if you have any instability with your connection between your location and the server.

If you continue to experience issues, contact your support, advise you are having issues, and ask if a technician can create a backup and save it to your file structure so that it can be downloaded via browser.

They will usually need the following information:

1. Last four of card on record, account username, account password (this is for ownership verification)
2. Database name, database username, database password
3, Location where you would like the database backup moved to, must be inside public_html to allow for download via browser.
4. Url of this forum, so that they can see the history of this issue

About author : This original article is property of Top 10 Web Hosting (http://www.top10webhosting.com). List of best web hosting services company offering PHP and MySQL. Compare & save ! on web hosting fee.

Note : Please include author information if you wish to republish this article.

Your site is down. What should you do.

  1. First, make sure your account is not suspended or terminated. Check your mailbox if you have received a suspended or termination email from your host.
  2. Check to find out whether the site is down for everyone, or just for you. Visit http://downforeveryoneorjustme.com/, plug in your domain name, and click on “just me.” If it’s just you, you’ve got some kind of DNS or connection problem. Contact your ISP.
  3. If your host has a page that list server status, check it. e.g. http://serverstatus.xxxhost.com . If your server box is listed there as offline, most probably their support has aware of the problem, usually you do not have to report it and it will fix by them.
  4. Try to get into your control panel. If you are using CPanel, you will see a server status link and you will be able to see what’s went wrong.
  5. Ping your domain, and also do a tracert from your PC to your domain. If there’s a faulty node somewhere between your location and your server, there is nothing your host can do about it. You can either wait for the problem to be resolved, or contact your ISP for assistance.
  6. If you gone through all the steps above and can’t resolve it, contact your host for support, either email, telephone or online chat.

    While most hosting company offer 99.9% network uptime but they usually do not offer 99.9% server up-time.   Good luck ~

About author : This original article is property of Top 10 Web Hosting (http://www.top10webhosting.com). List of best web hosting services company offering PHP and MySQL. Compare & save ! on web hosting fee.

Note : Please include author information if you wish to republish this article.

Shared hosting limitation

Dedicated server is eventually the kind of server what everyone or business would like to have, eventually because you own the server resources, entirely. However, we all know that it is expensive and not everyone can afford or worth spending money on it.  Most people uses shared hosting because of it pricing and if you have choosen correctly, it does exactly what a dedicated server can do.

For shared hosting services, the most known issue is reliability.  There is usually more than hundreds of websites hosting on the same server. Mail server, mysql server are sometimes hosting on the same server too.  If it happens that a website has been hacked to send spams email or scripting error, the entire server performance will be affected.

Sometimes, a sudden surge of visitors coming to any of the websites on the same server will slow down yours’ too. Therefore, you have to aware of the possible unplanned downtime.

The second common issue is the technical support. You have to make sure that the host has their own technical staff to offer you instant support when you need it, a online chat support is something a must nowadays. Because the server is shared, there is a higher probability that your website will suffer errors or problems. Therefore, you need a good technical support to help you fix the problem so that your website could be up and running again in the shortest time possible.

The next thing to look out is the service capability.  If the shared hosting doesn’t offer features they have stated, stay away from it.

No matter what hosting company/ plan you ended with, research and study is very important. Always know what you are paying for before sign-up. Try out their online chat support, send them an email and see how fast they response to it. Some study work will end you up with a good hosting company.

About author : This original article is property of Top 10 Web Hosting (http://www.top10webhosting.com). List of best web hosting services company offering PHP and MySQL. Compare & save ! on web hosting fee.

Note : Please include author information if you wish to republish this article.

« Prev - Next »