HostMonster Web Hosting Help

Sort by

Help Content Tagged Mysql - 48 results RSS


This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database. (updated 54 days ago)
Knowledgebase Article 450,248 views tags: creation database mysql

This article will instruct you how to export a database from the command line (SSH). (updated 599 days ago)
Knowledgebase Article 426,512 views tags: database mysql ssh

How do I import a database using command line? (SSH) (updated 1010 days ago)
Knowledgebase Article 383,878 views tags: command database import line mysql phpmyadmin ssh

I need to Export or Import a MySQL database (updated 599 days ago)
Knowledgebase Article 215,500 views tags: mysql phpmyadmin ssh

Why does my site get throttled, or why did my account get suspended for performance? (updated 15 days ago)
Knowledgebase Article 202,187 views tags: cpu database mysql optimize query script slow throttling

How to repair and optimize your database using phpMyAdmin: (updated 1021 days ago)
Knowledgebase Article 182,718 views tags: database mysql optimizing repairing slow speed

How to Restore your MySQL Database? (updated 1017 days ago)
Knowledgebase Article 150,116 views tags: admin database mysql php phpmyadmin restore

How do I create a MySQL backup? (updated 360 days ago)
Knowledgebase Article 149,411 views tags: backup database mysql

A repository of information on how you can manage your database by using the phpMyAdmin interface. (updated 829 days ago)
Knowledgebase Article 143,518 views tags: commands database mysql phpmyadmin

How do I import a backup of my database (.sql file) using phpMyAdmin? (updated 828 days ago)
Knowledgebase Article 128,008 views tags: database mysql phpmyadmin

I would like to dump the Table Structure for my MySQL Database, but none of the data. (updated 2009 days ago)
Knowledgebase Article 121,439 views tags: mysql ssh

What version of MySQL are you running? (updated 1222 days ago)
Knowledgebase Article 119,261 views tags: mysql sql

I cannot connect to my database locally or remotely, do I have the correct server, username and password? (updated 1895 days ago)
Knowledgebase Article 118,797 views tags: cannot connect mysql name

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 (updated 1823 days ago)
Knowledgebase Article 99,872 views tags: blocked connection host mysql

What necessitates "Database Repair"? (updated 1002 days ago)
Knowledgebase Article 98,065 views tags: corruption damaged database mysql postgres repair tables

How can I connect to our MySQL database from Dreamweaver? (updated 1034 days ago)
Knowledgebase Article 96,678 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 (updated 942 days ago)
Knowledgebase Article 94,041 views tags: indexes mysql optimize optimizing queries query

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 (updated 1333 days ago)
Knowledgebase Article 82,162 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? (updated 2023 days ago)
Knowledgebase Article 81,559 views tags: access mysql password permission

How do I make my MySQL database compatible with the version you provide? (updated 2025 days ago)
Knowledgebase Article 81,247 views tags: database mysql

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 (updated 1333 days ago)
Knowledgebase Article 75,056 views tags: cpu exceeded index indexes mysql optimize optimizing queries query

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 (updated 1333 days ago)
Knowledgebase Article 69,157 views tags: cpu exceeded index indexes mysql optimize optimizing queries query

What character sets are supported for MySQL? (updated 2009 days ago)
Knowledgebase Article 67,667 views tags: character mysql set sets

This article will describe connections strings, what they are used for, and give examples. (updated 454 days ago)
Knowledgebase Article 64,194 views tags: connection databases mysql

I am prompted to set a new MySQL password. What does this mean and how do I change it? (updated 968 days ago)
Knowledgebase Article 64,173 views tags: connect database mysql password phpmyadmin username

Instructions on adding a column to your database in phpMyAdmin (updated 818 days ago)
Knowledgebase Article 63,887 views tags: databases mysql phpmyadmin

How to Set different character sets with PHP and HTML to display correctly. (updated 1992 days ago)
Knowledgebase Article 63,537 views tags: character language mysql php phpmyadmin sets

Users having problems connecting to mysql database using SSH and/or putty/other client. (updated 1724 days ago)
Knowledgebase Article 60,066 views tags: connection ip mysql putty ssh whitelist

How to backup all of your MySQL databases using the Site Backup & Restore tool (updated 1356 days ago)
Knowledgebase Article 57,900 views tags: backup database mysql restore site

How to restore MySQL databases using the Site Backup & Restore tool (updated 995 days ago)
Knowledgebase Article 56,015 views tags: backup database mysql restore site

Do you allow the SUPER privilege on MySQL 5.x.x so I can use triggers ? (updated 1103 days ago)
Knowledgebase Article 50,889 views tags: mysql trigger

How to restore MySQL databases using the Site Backup & Restore tool (updated 1222 days ago)
Knowledgebase Article 44,576 views tags: backup database mysql restore site

This article will go over different application available for remote connection to your databases. (updated 825 days ago)
Knowledgebase Article 43,064 views tags: database mysql

Site Backup & Restore tool displays unexpected dates. (updated 1414 days ago)
Knowledgebase Article 41,771 views tags: backup database dump mysql restore sql

A step by step guide on how to manipulate data in your mySQL tables using phpMyAdmin (updated 829 days ago)
Knowledgebase Article 39,550 views tags: databases mysql phpmyadmin

A tutorial on how to perminately delete columns from your mySQL database using phpMyAdmin (updated 827 days ago)
Knowledgebase Article 35,008 views tags: Plesk cpanel databases mysql phpmyadmin

Instructions on deleting tables from your database using phpMyAdmin (updated 829 days ago)
Knowledgebase Article 34,461 views tags: Plesk cpanel databases mysql phpmyadmin

Instructions on changing the name of your database using phpMyAdmin (updated 829 days ago)
Knowledgebase Article 33,329 views tags: cpanel databases mysql phpmyadmin

A guide to duplicating a MySQL database using phpMyAdmin (updated 829 days ago)
Knowledgebase Article 28,851 views tags: databases mysql phpmyadmin

This article will explain how to change the password for a database in the event that the original password is lost. (updated 821 days ago)
Knowledgebase Article 27,098 views tags: database mysql password

This article will explain how to connect your scripts to your MySQL databases. (updated 821 days ago)
Knowledgebase Article 25,403 views tags: database mysql scripts

An exported .sql file shows as a different size than the reported size in cPanel (updated 1414 days ago)
Knowledgebase Article 23,711 views tags: backup database dump export mysql mysqldump size sql

A guide on performing a standard SQL query using the phpMyAdmin interface (updated 829 days ago)
Knowledgebase Article 14,900 views tags: databases mysql phpmyadmin

Guidance on adding tables to your mySQL database in phpMyAdmin (updated 828 days ago)
Knowledgebase Article 13,646 views tags: mysql phpmyadmin

This article will show a few MySQL errors along with explanations as to why they might be occurring. (updated 818 days ago)
Knowledgebase Article 13,451 views tags: errors mysql

A guide on renaming the tables inside of your database using phpMyAdmin (updated 12 days ago)
Knowledgebase Article 13,229 views tags: databases mysql phpmyadmin

Step by step directions on how you can search your database using phpMyAdmin (updated 829 days ago)
Knowledgebase Article 11,786 views tags: Plesk cpanel databases mysql phpmyadmin

A refrence defining the various mySQL variable types (updated 828 days ago)
Knowledgebase Article 10,702 views tags: mysql