Search The Knowledge Base
Search our Knowledge Base by keyword or category to find the answers to all of your questions.
There are 22 articles in the Database category.
>>You can download your websites onto your own local machine and create a local web development environment to test your sites. You can then set Break Points in your scripts and watch your computer’s cpu performance as you Step Through your Stack and Heap. You should try to stress test your queries as well to [...]continue reading
>>You can run a repair on all your databases. In the cPanel, click on the MySQL Databases icon and in the Repair section, choose a database to repair. You can safely run a Check and Repair routine on all of your databases. >>You can try to optimize all of your databases. In the cPanel, click [...]continue reading
Export A MySQL Database 1. Using SSH, execute the following command: 2. mysqldump -u username -p database_name > dbname.sql 3. You will be prompted for a password, type in the password for the username and press Enter. Replace username, password and database_name with your MySQL username, password and database name. File dbname.sql now holds a [...]continue reading
MySQL is an open source relational database management system (RDBMS )that uses Structured Query Language (SQL), the most popular language for adding, accessing, and processing data in a database. A relational database management system means that it stores data in separate tables rather than putting all the data in one big area. This adds flexibility, [...]continue reading
We allow 500 maximum connections of mysql.continue reading
If you have problems setting up the mysql database for your application please make sure that: – Your application is using the correct mysql hostname: localhost – Make sure that you are using correct username and password. – Don’t forget to specify your mysql username and database with the prefix yourusername_ in front of its [...]continue reading
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; – Make sure that you are using correct username and password. – Don’t forget to specify your MySQL username and database [...]continue reading
phpMyAdmin is a tool written in PHP to handle the administration of MySQL over the web. Data bases must be created in cPanel, but phpMyAdmin can drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, and export data into various formats. We do not offer support for using phpMyAdmin. You [...]continue reading
If you just need the backup of a single table, select that table from the table list in the left pane and click the ‘Export’ tab. Now do the steps described in the database backup section. Here only the selected table will be backuped. This can be done using the following command. mysqldump –add-drop-table –user=root [...]continue reading
MySQL Database Wizard is a GUI interface for managing MySQL database. It is the easy to use step by step procedure to manage MySQL Database Wizard in cPanel. 1] Login to cPanel >> Select MySQL Wizard. 2] Step 1 >> Create a Database >> Enter New Database Name & Click on Next Step Button. 3] [...]continue reading