HostGator Web Hosting Help

This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database.

This article will instruct you how to export a database from the command line (SSH).

How do I import a backup of my database (.sql file) using phpMyAdmin?

This article will instruct you how to import a database from the command line (SSH).

How to repair and optimize your database using phpMyAdmin:

How do I create a MySQL backup?

I need to Export or Import a MySQL database

What is CPU Protection

How to Restore your MySQL Database?

A repository of information on how you can manage your database by using the phpMyAdmin interface.

This article will show you how to rename a database table in phpMyAdmin.

I cannot connect to my database locally or remotely, do I have the correct server, username and password?

What version of MySQL are you running?

How to backup all of your MySQL databases using the Site Backup & Restore tool

How do I grant permissions to cPanel for my MySQL database administrator without giving them the domain password?

How to restore MySQL databases using the Site Backup & Restore tool

This article will describe connections strings, what they are used for, and give examples.

How can I connect to our MySQL database from Dreamweaver?

This article will explain how to change the password for a database in the event that the original password is lost.

I would like to dump the Table Structure for my MySQL Database, but none of the data.

I get the following database connection error: Warning: mysql_connect() [function.mysql-connect]: Host 'host#.HostGator.sg' is blocked because of many connection errors; unblock with 'mysqlad

A guide to duplicating a MySQL database using phpMyAdmin

I am prompted to set a new MySQL password. What does this mean and how do I change it?

How do I make my MySQL database compatible with the version you provide?

This article will go over different application available for remote connection to your databases.

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

This article will explain how to connect your scripts to your MySQL databases.

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

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

How to Set different character sets with PHP and HTML to display correctly.

A guide on performing a standard SQL query using the phpMyAdmin interface

Instructions on adding a column to your database in phpMyAdmin

A step by step guide on how to manipulate data in your mySQL tables using phpMyAdmin

A tutorial on how to perminately delete columns from your mySQL database using phpMyAdmin

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

Step by step directions on how you can search your database using phpMyAdmin

This article will explain how to change or reset the password for a MySQL user.

This article will show a few MySQL errors along with explanations as to why they might be occurring.

Guidance on adding tables to your mySQL database in phpMyAdmin

A refrence defining the various mySQL variable types