| |
MySql / Databases FAQ
The current version of MySql on our servers is 5.0.27
If you require a different version of MySql please contact us and we may be able to assist you with this.
Further common questions on MySql can be found below.
|
Are the MYSQL databases completely configurable via a control panel or similar mechanism?
Can you create an InnoDB MySql table on a NetPivotal account?
Does the size of my database come out of my total disk space and is it limited?
What is MySQL?
Which version of MySql do you have on your servers?
I can see MySql databases listed, but can I have Ms Sql databases instead?
How can I create and manage my MySql databases?
Can I make a backup of my databases?
When I click on PhpMyAdmin nothing happens?
I have a MySql database from my old hosting company. How can I add it to my account?
|
| |
| |
| Are the MYSQL databases completely configurable via a control panel or similar mechanism? |
| |
| Your Control Panel contains a utility called PhpMyAdmin. This is a web-based utility that completely manages the databases on your account, including adding tables and users. |
| |
| Can you create an InnoDB MySql table on a NetPivotal account? |
| |
| Yes, you can use the PHPMyAdmin utility in the control panel to create compatible database tables. |
| |
| Does the size of my database come out of my total disk space and is it limited? |
| |
The size of your database is taken out of your total disk space limit. We don't limit the size of your databases, as an intense query on a small database will still cause a load on our servers.
We do monitor the performance of our servers at all times - please read our Acceptable Use Policy for our policy on continuous heavy users. |
| |
| What is MySQL? |
| |
| MySQL is a relational database management system, which means it stores data in separate tables rather than putting all the data in one big area. This adds flexibility, as well as speed. The SQL part of MySQL stands for "Structured Query Language," which is the most common language used to access databases. The MySQL database server is the most popular open source database in the world. It is extremely fast and easy to customize, due to its architecture. Extensive reuse of code within the software, along with a minimalist approach to producing features with lots of functionality, gives MySQL unmatched speed, compactness, stability, and ease of deployment. Their unique separation of the core server from the storage engine makes it possible to run with very strict control, or with ultra fast disk access, whichever is more appropriate for the situation.
To find out more visit the MySQL web site at http://www.mysql.com |
| |
| Which version of MySql do you have on your servers? |
| |
| We're currently running MySql versions 3.23.58 to 5.0.27 on our servers. If you require a specific version of MySQL please contact our support team and they will be able to choose a suitable server for your needs. |
| |
| I can see MySql databases listed, but can I have Ms Sql databases instead? |
| |
| NetPivotal doesn't support Ms Sql databases on hosting accounts, but we do give a minimum of five MySql databases with all our hosting plans. |
| |
| How can I create and manage my MySql databases? |
| |
Your databases are managed from within your Plesk control panel by clicking on the "Database" icon. This lets you create databases and the usernames and passwords for letting your applications make connections and adjustments.
Once created you can use the PhpMyadmin application within your control panel to manage the database. |
| |
| Can I make a backup of my databases? |
| |
In your control panel database area you can click on PhpMyadmin to manage each of your databases. Within Phpmyadmin there is an "Export" option you can use to backup your database to your httpdocs folder, and download it for backup purposes.
The same procedure can also be used in reverse for importing an existing database. If you have any problems with these processes please raise a support ticket for our technical team to assist you. |
| |
| When I click on PhpMyAdmin nothing happens? |
| |
When you click on the PhpMyAdmin icon the application launches in a pop-up window so please make sure that you have disabled your popup blocker.
You could also hold down the Ctrl button on your keyboard when you click on the icon or add your control panel to your list of trusted sites. |
| |
| I have a MySql database from my old hosting company. How can I add it to my account? |
| |
To add this database to your hosting account you will need to create the database in your control panel by clicking on the Database icon and following the prompts.
When you have done this click on PhpMyAdmin and use the import feature to add the database to your account. You may need our technical team to assist you with this if your database has been provided to you in a compressed format. |
| |
