HostGator Web Hosting Help
Help Content Tagged Mysql - 40 results
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
Knowledgebase Article
387,230 views
tags: cpu database mysql optimize peak performance query script slow
How to Restore your MySQL Database?
A repository of information on how you can manage your database by using the phpMyAdmin interface.
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?
This article will show you how to rename a database table in phpMyAdmin.
How do I grant permissions to cPanel for my MySQL database administrator without giving them the domain password?
This article will describe connections strings, what they are used for, and give examples.
I would like to dump the Table Structure for my MySQL Database, but none of the data.
How to backup all of your MySQL databases using the Site Backup & Restore tool
How can I connect to our MySQL database from Dreamweaver?
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
This article will explain how to change the password for a database in the event that the original password is lost.
How to restore MySQL databases using the Site Backup & Restore tool
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?
A guide to duplicating a MySQL database using phpMyAdmin
This article will go over different application available for remote connection to your databases.
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
Knowledgebase Article
222,322 views
tags: cpu exceeded index indexes mysql optimize optimizing queries query
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
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
216,823 views
tags: cpu exceeded index indexes mysql optimize optimizing queries query
How to Set different character sets with PHP and HTML to display correctly.
Knowledgebase Article
215,949 views
tags: arabic character chinese collation japanese language languages mysql php phpmyadmin sets
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 guide on performing a standard SQL query using the phpMyAdmin interface
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
Knowledgebase Article
115,254 views
tags: mysql phpmyadmin