How to repair a MySQL database?

we will show you two ways to repair a MySQL database.

1) Through cPanel:

Log in to your cPanel and go to MySQL Databases. In the section Modify Databases, select a database from the drop-down box next to Repair DB: and then click the Repair DB button.

�

If the database engine used by your database supports repair (for example, MyISAM supports it), you will see a list of the repaired tables within the database.

�

If your database engine does not support repair (e.g. InnoDB database engine), you will get the following error message:

�

note : The storage engine for the table doesn't support repair

�

2) Through phpMyAdmin:

Open your phpMyAdmin tool and select the database whose tables you wish to repair.

�

A list with all the database's tables will appear. Tick the tables you wish to repair, or simply click [Check All] to select all tables.

�

Click the box [With selected:] and choose Repair table. This will execute the REPAIR TABLE SQL query on the selected tables and they will be repaired.

admin

Site Admin

 

Posts: 13

Joined: Sat Jul 30, 2011 10:01 pm

Updations about schools software, advance school software

Hello friends,

first how are you?

we have updated own school software as so advance verson. for more please discuss us releted to school software.


facing any problem please mail me on

web.rajansharma@gmail.com
www.matrixworld.in

How many types of hosting

Free Hosting

Some ISPs offer free web hosting.
Free web hosting is best suited for small sites with low traffic, like personal sites. It is not recommended for high traffic or for real business. Technical support is often limited, and technical options are few.
Very often you cannot use your own domain name at a free site. You have to use a name provided by your host like http://www.freesite.com/users/~yoursite.htm. This is hard to type, hard to remember, and not very professional.

Good:	Bad:
Low cost. It's free.	No domain names.
Good for family, hobby or personal sites.	Few, limited, or no software options.
Free email is often an option.	Limited security options.
	Limited or no database support.
	Limited technical support.

---

Shared (Virtual) Hosting

Shared hosting is very cost effective.
With shared hosting, your web site gets its own domain name, and is hosted on a powerful server along with maybe 100 other web sites.
Shared solutions often offer multiple software solutions like e-mail, database, and different editing options. Technical support tends to be good.

Good:	Bad:
Low cost. Cost is shared with others.	Reduced security due to many sites on one server.
Good for small business and average traffic.	Restrictions on traffic volume.
Multiple software options.	Restricted database support.
Own domain name.	Restricted software support.
Good support

---

Dedicated Hosting

With dedicated hosting, your web site is hosted on a dedicated server.
Dedicated hosting is the most expensive option. This option is best suited for large web sites with high traffic, and web sites that use special software.
You should expect dedicated hosting to be very powerful and secure, with almost unlimited software solutions.

Good:	Bad:
Good for large business.	Expensive.
Good for high traffic.	Requires higher skills.
Multiple domain names.
Powerful email solutions.
Powerful database support.
Strong (unlimited) software support.

---

Collocated Hosting

Collocation means "co-location". Collocated hosting lets you place your own web server on the premises (locations) of a service provider.
This is pretty much the same as running your own server in your own office, only that it is located at a place better designed for it.
Most likely an ISP will have dedicated resources like high-security against fire and vandalism, regulated backup power, dedicated Internet connections and more.

Good:	Bad:
High bandwidth.	Expensive.
High up-time.	Requires higher skills.
High security.	Harder to configure and debug.
Unlimited software options.

---

Your Checklist

Before you choose your web host, make sure that:

• The hosting type suits your needs
• The hosting type is cost effective
• Upgrading to a better server is possible
• If needed, upgrading to a dedicated server is possible

Before you sign up with an ISP, surf some other web sites on their servers, and try to get a good feeling about their network speed. Also compare the other sites against yours, to see if it looks like you have the same needs. Contacting some of the other customers is also a valuable option.

---

Example: Martix World

Martix World is a leading web hosting company in the India.

Matrix World offers services including:

• Shared Hosting
• Reseller Hosting
• VPS Hosting
• Dedicated Servers
• 24/7/365 Support

on Linux and Windows platforms, powered by control panels such as cPanel/WHM, Plesk and DotNetPanel.
An account can be setup within a few minutes.