HostMonster Web Hosting Help

Sort by

Help Content Tagged Mysql - 50 results RSS


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

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

This article will instruct you how to import a database from the command line (SSH). (updated 116 days ago)
Knowledgebase Article 415,635 views tags: database mysql ssh

I need to Export or Import a MySQL database (updated 722 days ago)
Knowledgebase Article 228,584 views tags: mysql phpmyadmin ssh

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

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

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

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

How do I create a MySQL backup? (updated 483 days ago)
Knowledgebase Article 156,436 views tags: backup database mysql

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

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

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

What version of MySQL are you running? (updated 1345 days ago)
Knowledgebase Article 121,503 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 (updated 120 days ago)
Knowledgebase Article 105,669 views tags: blocked connection host localhost mysql

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

How can I connect to our MySQL database from Dreamweaver? (updated 1158 days ago)
Knowledgebase Article 101,225 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 1066 days ago)
Knowledgebase Article 97,291 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 2146 days ago)
Knowledgebase Article 85,970 views tags: access mysql password permission

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 1456 days ago)
Knowledgebase Article 85,449 views tags: indexes mysql optimize optimizing queries query

How do I make my MySQL database compatible with the version you provide? (updated 2149 days ago)
Knowledgebase Article 84,585 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 1457 days ago)
Knowledgebase Article 77,706 views tags: cpu exceeded index indexes mysql optimize optimizing queries query

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

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 1456 days ago)
Knowledgebase Article 71,199 views tags: cpu exceeded index indexes mysql optimize optimizing queries query

What character sets are supported for MySQL? (updated 2133 days ago)
Knowledgebase Article 69,591 views tags: character mysql set sets

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

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

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

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

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

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

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

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

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

Site Backup & Restore tool displays unexpected dates. (updated 1538 days ago)
Knowledgebase Article 44,474 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 953 days ago)
Knowledgebase Article 43,023 views tags: databases mysql phpmyadmin

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

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

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

A guide to duplicating a MySQL database using phpMyAdmin (updated 953 days ago)
Knowledgebase Article 31,868 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 945 days ago)
Knowledgebase Article 31,344 views tags: database mysql password

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

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

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

Guidance on adding tables to your mySQL database in phpMyAdmin (updated 952 days ago)
Knowledgebase Article 16,080 views tags: mysql phpmyadmin

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

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

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

A refrence defining the various mySQL variable types (updated 952 days ago)
Knowledgebase Article 12,115 views tags: mysql

This article will explain how to change or reset the password for a MySQL user. (updated 65 days ago)
Knowledgebase Article 1,192 views tags: change mysql password reset user

This article will explain how to convert a MySQL database to UTF-8. (updated 50 days ago)
Knowledgebase Article 816 views tags: character database encoding mysql utf