You are here: Portal Home > Knowledgebase > MySQL
The knowledgebase is organized into different categories. Either choose a category from below or search the knowledgebase for the answer to your question.
Search
Articles
Do you support MS SQL?
No, we do not support MS SQL.
Views: 70
How can I backup my databases?
1. Log into cPanel and click on the "Backups" link under the Files section. 2. Under the...
Views: 72
How can I monitor what my MySQL server is doing?
A handy little Linux application called mytop fits this just perfectly. This is a near-time...
Views: 76
How do I backup MySQL in Linux?
1. Copying from the mysql directoryBy default, MySQL databases on servers that use Linux are...
Views: 140
How do I connect to my database using a program?
If you wish to administer your database from your own computer, via a program like navicat or...
Views: 67
How do I create a MySQL back-up?
1. First log in to your Cpanel 2. Click MySQL Databases 3. Click phpMyAdmin 4. Click Export...
Views: 66
How do I create an empty MySQL database?
1. First log in to your Cpanel 2. Click MySQL Databases 3. Create a user by typing any username...
Views: 67
How do I dump the table structure for my MySQL Database, but none of the data?
The command line option from SSH is: mysqldump -d -u -p database_name > file.sql Where...
Views: 61
How do I import a database (Command Line)?
**SSH access is needed for this process. Also you will need the file in .sql format, meaning it...
Views: 67
How to install Mysql
How to install Mysql Via RPM : Please check the following link and get RPM...
Views: 72
How to reset a mySQL password?
If you have lost your root user password for MySQL, you can reset it with the following...
Views: 80
Mysql Basic Commands
[mysql dir]/bin/mysql -h hostname -u root -p Create a database on the sql server. create...
Views: 188
MySQL Optimization / Repair Information
How MySQL Uses MemoryThis page lists some of the ways that the mysqld server uses memory, and...
Views: 89
Repairing MySQL tables that will not open
This should be handled on a case by case basis, but if you are using the default MySQL table...
Views: 82
Securing MySQL
Due to differing needs and requirements this is difficult to answer except on a case by case...
Views: 74
What is my root password for MySQL?
If the server was auto provisioned with MySQL then the root password is the same as the...
Views: 175
What is the best online resource for information about MySQL?
The MySQL website has a complete reference manual with search capabilities available on their...
Views: 78
What Version of MySQL are you running?
We run the latest stable version of MySQL 5.
Views: 69
Powered by WHMCompleteSolution
