HostMonster Web Hosting Help

Sort by

Help Content Tagged Mysql - 41 results RSS


This article will instruct you how to export a database from the command line (SSH).
Knowledgebase Article 607,626 views tags: database mysql ssh

This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database.
Knowledgebase Article 586,337 views tags: creation database mysql

This article will instruct you how to import a database from the command line (SSH).
Knowledgebase Article 546,479 views tags: database mysql ssh

How do I import a backup of my database (.sql file) using phpMyAdmin?
Knowledgebase Article 365,433 views tags: database mysql phpmyadmin

I need to Export or Import a MySQL database
Knowledgebase Article 289,292 views tags: mysql phpmyadmin ssh

What is CPU Protection
Knowledgebase Article 246,874 views tags: cpu database mysql optimize peak performance query script slow

How to repair and optimize your database using phpMyAdmin:
Knowledgebase Article 236,729 views tags: database mysql optimizing repairing slow speed

A repository of information on how you can manage your database by using the phpMyAdmin interface.
Knowledgebase Article 219,245 views tags: commands database mysql phpmyadmin

How do I create a MySQL backup?
Knowledgebase Article 193,380 views tags: backup database mysql

How to Restore your MySQL Database?
Knowledgebase Article 178,830 views tags: admin database mysql php phpmyadmin restore

I would like to dump the Table Structure for my MySQL Database, but none of the data.
Knowledgebase Article 175,124 views tags: dump mysql ssh structure table

I cannot connect to my database locally or remotely, do I have the correct server, username and password?
Knowledgebase Article 162,283 views tags: connect disconnected hostname mysql user

What version of MySQL are you running?
Knowledgebase Article 150,585 views tags: mysql sql

I get the following database connection error: Warning: mysql_connect() [function.mysql-connect]: Host 'host#.HostMonster.com' is blocked because of many connection errors; unblock with 'mysqlad
Knowledgebase Article 131,140 views tags: blocked connection host localhost mysql

How can I connect to our MySQL database from Dreamweaver?
Knowledgebase Article 123,968 views tags: connecting database dream mysql weaver

Optimizing MySQL: Queries and Indexes Article 1 of 4 Courtesy of: Ian Gilfillan Badly defined or non-existent indexes are one of the primary reasons for poor performance, understanding and then fixing
Knowledgebase Article 121,682 views tags: indexes mysql optimize optimizing queries query

How do I grant permissions to cPanel for my MySQL database administrator without giving them the domain password?
Knowledgebase Article 111,874 views tags: access grant mysql password permission

This article will describe connections strings, what they are used for, and give examples.
Knowledgebase Article 107,446 views tags: connection databases mysql

How do I make my MySQL database compatible with the version you provide?
Knowledgebase Article 99,777 views tags: compatible database mysql

Optimizing MySQL: Queries and Indexes Article 2 of 4 Courtesy of: Ian Gilfillan Some knowledge of how indexes work allows you to use them more efficiently. Firstly, note that when you update a table w
Knowledgebase Article 99,565 views tags: indexes mysql optimize optimizing queries query

Optimizing MySQL: Queries and Indexes Article 3 of 4 Courtesy of: Ian Gilfillan Ordering by surname is a common requirement, so it would make sense to create an index on surname. But in this example o
Knowledgebase Article 93,290 views tags: cpu exceeded index indexes mysql optimize optimizing queries query

I am prompted to set a new MySQL password. What does this mean and how do I change it?
Knowledgebase Article 93,156 views tags: connect database mysql password phpmyadmin username

Optimizing MySQL: Queries and Indexes Article 4 of 4 Courtesy of:Ian Gilfillan Most systems need to be highly optimized for selects - take a news site which performs millions of queries per day, but w
Knowledgebase Article 85,888 views tags: cpu exceeded index indexes mysql optimize optimizing queries query

Instructions on adding a column to your database in phpMyAdmin
Knowledgebase Article 85,271 views tags: databases mysql phpmyadmin

How to backup all of your MySQL databases using the Site Backup & Restore tool
Knowledgebase Article 81,610 views tags: backup database mysql restore site

This article will go over different application available for remote connection to your databases.
Knowledgebase Article 81,386 views tags: database mysql

How to Set different character sets with PHP and HTML to display correctly.
Knowledgebase Article 80,500 views tags: arabic character chinese collation japanese language languages mysql php phpmyadmin sets

How to restore MySQL databases using the Site Backup & Restore tool
Knowledgebase Article 79,558 views tags: backup database mysql restore site

This article will explain how to connect your scripts to your MySQL databases.
Knowledgebase Article 78,359 views tags: database mysql scripts

Instructions on deleting tables from your database using phpMyAdmin
Knowledgebase Article 63,887 views tags: Plesk cpanel databases mysql phpmyadmin

This article will explain how to change the password for a database in the event that the original password is lost.
Knowledgebase Article 60,360 views tags: database mysql password

A step by step guide on how to manipulate data in your mySQL tables using phpMyAdmin
Knowledgebase Article 57,950 views tags: databases mysql phpmyadmin

A tutorial on how to perminately delete columns from your mySQL database using phpMyAdmin
Knowledgebase Article 53,487 views tags: Plesk cpanel databases mysql phpmyadmin

A guide to duplicating a MySQL database using phpMyAdmin
Knowledgebase Article 51,873 views tags: databases mysql phpmyadmin

This article will show you how to rename a database table in phpMyAdmin.
Knowledgebase Article 47,393 views tags: databases mysql phpmyadmin

A guide on performing a standard SQL query using the phpMyAdmin interface
Knowledgebase Article 38,636 views tags: databases mysql phpmyadmin

This article will show a few MySQL errors along with explanations as to why they might be occurring.
Knowledgebase Article 31,977 views tags: errors mysql

Step by step directions on how you can search your database using phpMyAdmin
Knowledgebase Article 30,532 views tags: Plesk cpanel databases mysql phpmyadmin

Guidance on adding tables to your mySQL database in phpMyAdmin
Knowledgebase Article 28,934 views tags: mysql phpmyadmin

This article will explain how to change or reset the password for a MySQL user.
Knowledgebase Article 20,877 views tags: change mysql password reset user

A refrence defining the various mySQL variable types
Knowledgebase Article 16,613 views tags: mysql