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 database db, the database name will be user_db. If you…

Yes you can setup custom nameservers, the IP addresses will be the IP addresses of the nameservers provided in your Account Information e-mail. You can find out the IP address of a server by opening a command prompt on your pc and typing: ping <servername>…

On paid premium accounts the database server host name can vary. The only way to check it is to look in the left information bar in your cPanel. It will be either sql.byethost??.org or localhost the port is 3306 (standard) To use a MySQL database with your…

If a database or new databases are not showing in phpmyadmin OR you are having troubles accessing phpmyadmin, then trying the following can fix most the time. 1) log into your cPanel 2) click on 'remote sql' 3) remove all the entries in 'remote sql' 4) add…

Overview The default character set for MySQL is latin1, with a default collation of latin1_swedish_ci. This is a common type of encoding for Latin characters. You can also change the encoding. utf8 is a common character set for non-Latin characters. You can…

You do not need to own your own domain name to open an account with us, all of our plans include a free domain or subdomain you can use to get started.

Unfortunately we do not support the ODBC driver for MySQl on our hosting plans.

Usually you will be interested in changing your MySQL collation in order to solve problems with foreign character encodings. The most common case is to change your MySQL collation from latin1 to utf8. This can be done by using phpMyAdmin and following the…

The easiest way to empty a MySQL database is through phpMyAdmin. Once in phpMyAdmin, select the database you wish to empty. A list with all the database’s tables will appear. Click [Check All] to select all tables. Click the box [With selected:] and choose…

For importing large databases we recommend using tools such as MySQL Query Browser. Before being able to connect remotely you will have to: Create a database and assign a username with full privileges to it; Add your IP address in the allowed IPs to access…

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 when you want to use phpMyAdmin. Follow the steps below to complete…

You can backup a MySQL database through phpMyAdmin using the 'export' option.

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 collation for all tables at a time: <?php $db = mysql_connect(‘localhost’,’myuser_mydbuser‘,’mypassword‘);̷

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 engine from MyISAM to InnoDB. The MySQL query that should be…

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 our servers is EST. This is a global setting which cannot be changed. You can, however, use an easy workaround if you wish…

If you have already created a MySQL user through the cPanel -> Mysql Databases tool you may want to update its password. You can complete the task through the same tool -> Current Users section. Click on the respective user and a new MySQL Account Maintenance…

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 shared servers. Fortunately, there is an easy solution for…

Please note there is a 10mb upload limit on Freehosting accounts. If you are having problems trying to import a large database using PHPMyAdmin then we suggest using the following MySQL dump importer: http://www.ozerov.de/bigdump/ This allows you to split…

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 example table called “sample” with only two rows – “number”…

It is always a good idea to keep your databases’ tables optimized. Fortunately, making this optimization is quite easy when using phpmyadmin available in your cpanel To perform the optimization, log in to your phpMyAdmin and select the database whose tables…

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 database from the drop-down box next to Repair DB: and then click the Repair…

You may need to change the password of your database in order 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 your database is to recreate the MySQL user attached…

MySQL stored procedures and stored routines are supported after MySQL 5. All our clients can use MySQL stored procedures and routines on their web hosting accounts. To use stored procedures, you should first create a database and add a database user to it.…

Your user does not have enough privileges for creating or dropping databases in PhpMyAdmin because of security restrictions. The only way you can add or drop databases is through cPanels mysql manager

In order to solve this issue follow these steps: Open the MySQL dump with a text editor on your local PC / MAC; Delete the line saying "CREATE DATABASE yourdbname". Usually this line is found at the very beginning of the file; Save the file and try to import…

This error indicates that the syntax of your query is not correct. Reasons for incorrect mysql queries vary and require programming knowledge for debugging. In case you need assistance with such problems you can order our development services, create a support…

If you have problems accessing your database at your web hosting account remotely please make sure that: You are using the correct MySQL hostname – it should be yourdomain.com or your server’s name; You are using the correct MySQL database / username…

If you have problems setting up the mysql database for your application please make sure that: Your application is using the correct mysql hostname: (this will be shown in the left hand bar of your cPanel, if it is not shown on the left bar then the hostname…

By default, the databases on our servers are created with latin1_swedish_ci collation. This may cause some issues if you use your application with languages with non-standard characters (Cyrillic, Chinese, etc.). Therefore, the best practice prior to installing…

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 mysql -u USERNAME -pPASSWORD DBNAME < dump.sql"); ?> Where USER,PASSWORD…