Edit MySQL database


Can I edit MySQL database tables without creating applications?

Yes, you can use phpMyAdmin included in H-sphere to edit MySQL tables.

MySQL for my websites


Hi, for my shopping carts, chat boards websites, I am using MySQL to manage databases, designing tables, and adding, deleting, and updating records, all from within your web browser.

For, the websites which have got the requirments of the databases, we can use MySQL in them. The MySQL database server is the world’s most widely used open source database management system. A database is a structured collection of data, which may be anything from a list of products on your site to large amounts of information in a corporate network.

To add, access, and process data stored in a computer database, you need a database management system. Since computers are very good at handling large amounts of data, database management plays a central role in computing, as stand-alone utilities, or as parts of other applications.

How we can administer this MySQL?

You can use, phpMyAdmin which is a tool written in PHP intended to handle the administration of your MySQL.

Here is list of phpMyAdmin features:

1. Create and drop databases
2. Create, drop, and alter tables
3. Delete, edit, and add fields
4. Execute any SQL statement
5. Manage keys on fields .

To access phpMyAdmin please follow these instructions.

1. Login to the members section.
2. Click on the MySQL Database tools icon.
3. Click on the phpMyAdmin link beside the database that you wish to access.

www problem with my site


my site is hosted on a dedicated server. if you go to my site http:// sitename.com .. it works properly but if put www. in front nothing comes up, but without www. it works fine.

The problem is you’re missing an A record in the DNS for the www. Add an a record with www pointing to your IP, that should take care of it. Also remember to make sure your host headers are set correctly.

Web Hosting with email backup


Hi,

web hosting companies provides only 1 mail server for domain but the problem is if the server goes down , emails will bouncing.

Is there any web hosting provider provide more than 1 mail server for each domain hosted on them?

Please advice.

Thank you.

Transfer a forum from one host to another???


hi,

i have a forum in my old host and now i want to move it to my new account at cpwebhosting.net, without losing all the posts / members and, of course the skin.

how do i do it?

you create a backup via the cPanel option then restore it via the cPanel on the other host.

You should first install latest version of phpbb from fantastico and then restore the backup of your database from your control panel and add entry of the database name, username and password in the config.php file.

Cpanel and subdomain help


Hello,

I have a domain zzz.com, and in public_html there are about 100 folders,
I am just wondering how can use these 100 folder in this way:
1.zzz.com
2.zzz.com
3.zzz.com

….

100.zzz.com

Is there script that can do this??

thanx in advance

Once you setup your subdomain name through cpanel there is an option to setup redirection. You pick the subdomain for redirection and then point it to the folder that you want.

How test the maximum bandwidth ??


hi,

I have a dedicated “CentOS” server with “cpanel/whm”
I have VNC setup and I can remote connect to my server. So I can virtually use the server just like my home computer

My question is How do I test the maximum bandwidth to the server. i want to upgrade bandwidth.

ANY help is appreciated.

Why don’t you install MRTG ? that will give you detail of bandwidth usage, incoming and outgoing traffic details.

Website security issue


hi,

I have a host, but what do I need to do to make a portion of the site secure.

You need a certificate for HTTPS.

DO you want that or do you want to just PW protect a directory?

hello,

if you want to protect certain parts of your site, then password protects certain parts of you site, which you can do it simply using your control panel.

Please, note that securing a server and https is two very different thing.

Https is a method to encrypt information in transit and in no way does it apply to securing a server! By default TCP port would 443 while unsecure would be 80. This SSL certificates can be created via linux using such tools as openSSL If I am not mistaken its free.

Password protect, do you mean to restrict certain portion of your site and using a password as a form of authentication? If you so, you always use .htaccess to configure that kind of stuff.

Now, securing a server. I mean physically securing your server say you have your own dedicated box. There are lot of factors to take into consideration. Your OS, what level of security you want and such.

It could be as simple as blocking certain ports on your server to a more complex task such as to lock down PHP and use mod_security with apache or securing your TMP partitions.

What is Mambo?


Hi I am using the easy app but i m not able to understand what Mambo is?

Mambo is a full featured content management system that can be used for your websites.