Knowledgebase
Webinova Online Customer Support > Webinova Help Desk > Knowledgebase

Search help:


» Category: cPanel MySQL Databases  (Go back)

» Articles in this category:

 
How to change the database engine of a MySQL database table? Article rated 3.0/5.0
In this article we will show you how to change the database engine of a MySQL table. Let’s assume that you have a database table called my_table using MyISAM engine and you wish to change the e...
How to change the collation for all tables in a MySQL database to UTF-8? Article rated 3.0/5.0
Changing the collation for all tables in a MySQL database can be time consuming depending on how many tables you have. That’s why we recommend using the following PHP script for changing the co...
How to optimize a MySQL database using phpMyAdmin? Article rated 3.0/5.0
It is always a good idea to keep your databases’ tables optimized. Fortunately, making this optimization is quite easy when using the phpMyAdmin tool available in cPanel. To perform the optimi...
PHP script for MySQL database import Article rated 3.0/5.0
You should start by creating a file called for example import.php and placing it in your public_html folder. Then edit the file and paste the following code in it:  <?php passthru("nohup my...
’1064 – You have an error in your SQL syntax’ error in phpMyAdmin Article rated 3.0/5.0
Sometimes, when you try to modify a database in phpMyAdmin, you can get this error message when you try to execute the SQL query: MySQL said:  #1064 – You have an error in your SQL syntax...
How to repair a MySQL database? Article rated 3.0/5.0
In this article 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 da...
Can I change the name of a MySQL database? Article rated 3.0/5.0
The name of a MySQL database consists of a prefix, which is your cPanel username, followed by a "_" sign and the actual database name. For example, if your cPanel username is user and you create a da...
How to optimize a MySQL database Article rated 3.0/5.0
One of the most important prerequisites for achieving optimal MySQL database performance is indexing. Indexing is an internal MySQL feature that allows faster gathering of data. Let’s take an e...
How to change the MySQL timezone Article rated 3.0/5.0
When you develop your website, you may have to compare a certain date/time with the current date/time on the server. The timezone on SiteGround’s servers is CST. This is a global setting which ...
What is the information_schema database? Article rated 3.0/5.0
In MySQL version 5.02 and above there is an additional database called information_schema. This database provides access to the database metadata. This includes the name of a database or a table, the ...
How to export a large database using phpMyAdmin? Article rated 3.0/5.0
If you have a large database, it may be difficult to export all of its tables at once through phpMyAdmin. The most common reason for this is the timeout limit most web hosting companies set on their s...
How to access phpMyAdmin directly from my domain? Article rated 3.0/5.0
In order to access phpMyAdmin directly from: http://yourdomain.com/phpmyadmin you need to install phpMyAdmin on your hosting account. This way you won’t have to first log in to your cPanel whe...
What are MySQL triggers and how to use them? Article rated 3.0/5.0
A trigger is a database object that is associated with a table. It will be activated when a defined action is executed for the table. The trigger can be executed when you run one of the following MyS...
I’m getting a ‘Server shutdown in progress’ MySQL error Article rated 3.0/5.0
There are two main reasons for this error message to show: 1) The MySQL query you are trying to execute takes too long and the MySQL server times out. The solution for this issue is to optimize your...
What is the default path to the MySQL binary? Article rated 3.0/5.0
The correct path to the MySQL binary at all SiteGround servers is: /usr/bin/mysql
How to use MySQL stored procedures and routines? Article rated 3.0/5.0
MySQL stored procedures and stored routines are supported after MySQL 5. All SiteGround clients can use MySQL stored procedures and routines  on their web hosting accounts. To use stored proced...
Multi-language applications and UTF-8 databases Article rated 3.0/5.0
By default, the databases on SiteGround’s servers are created with latin1_swedish_ci collation. This may cause some issues if you use your application with languages with non-standard characters...
I cannot create views in MySQL Article rated 3.0/5.0
Regular MySQL users do not have privileges to create views in MySQL. If you try to execute CREATE VIEW with a regular user, you will receive the following error message: #1142 – CREATE VIEW com...
How to reset the password for a MySQL database? Article rated 3.0/5.0
You may need to change the password of your database to improve the security of your website or if your account has been compromised by hackers. Basically the easiest way to change the password for yo...
How to change the password of a Mysql user in cPanel? Article rated 3.0/5.0
If you have already created a Mysql user under cPanel -> Mysql Databases section you may want to update its password. You can complete the task through: cPanel -> MySQL Databases Find the MyS...
 

 
Powered by Help Desk Software HESK - brought to you by Help Desk Software SysAid