Just Host Web Hosting Help

How to import and export a MySQL Database from the command line. (updated 267 days ago)

This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database. (updated 203 days ago)

How do I import a database using command line? (SSH) (updated 398 days ago)

I need to Export or Import a MySQL database (updated 1397 days ago)

What version of MySQL are you running? (updated 610 days ago)

Why does my site get throttled, or why did my account get suspended for performance? (updated 38 days ago)

How do I create a MySQL backup? (updated 93 days ago)

I cannot connect to my database locally or remotely, do I have the correct server, username and password? (updated 1283 days ago)

A repository of information on how you can manage your database by using the phpMyAdmin interface. (updated 217 days ago)

How to repair and optimize your database using phpMyAdmin: (updated 408 days ago)

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

How can I connect to our MySQL database from Dreamweaver? (updated 422 days ago)

How to Restore your MySQL Database? (updated 405 days ago)

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 331 days ago)

I would like to dump the Table Structure for my MySQL Database, but none of the data. (updated 1397 days ago)

How do I grant permissions to cPanel for my MySQL database administrator without giving them the domain password? (updated 1411 days ago)

What necessitates "Database Repair"? (updated 390 days ago)

How to Set different character sets with PHP and HTML to display correctly. (updated 1380 days ago)

Users having problems connecting to mysql database using SSH and/or putty/other client. (updated 1112 days ago)

How do I make my MySQL database compatible with the version you provide? (updated 1413 days ago)

What character sets are supported for MySQL? (updated 1397 days ago)

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

I am prompted to set a new MySQL password. What does this mean and how do I change it? (updated 357 days ago)

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 721 days ago)

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 721 days ago)

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 721 days ago)

Do you allow the SUPER privilege on MySQL 5.x.x so I can use triggers ? (updated 492 days ago)

How to backup a MySQL database using the Site Backup & Restore tool (updated 383 days ago)

How to restore MySQL databases using the Site Backup & Restore tool (updated 383 days ago)

How to backup all of your MySQL databases using the Site Backup & Restore tool (updated 744 days ago)

An exported .sql file shows as a different size than the reported size in cPanel (updated 803 days ago)

Site Backup & Restore tool displays unexpected dates. (updated 803 days ago)

This article will go over different application available for remote connection to your databases. (updated 213 days ago)

How to restore MySQL databases using the Site Backup & Restore tool (updated 610 days ago)

This article will describe connections strings, what they are used for, and give examples. (updated 209 days ago)

This article will explain how to change the password for a database in the event that the original password is lost. (updated 209 days ago)

This article will explain how to connect your scripts to your MySQL databases. (updated 209 days ago)

Instructions on deleting tables from your database using phpMyAdmin (updated 218 days ago)

A guide to duplicating a MySQL database using phpMyAdmin (updated 217 days ago)

A guide on performing a standard SQL query using the phpMyAdmin interface (updated 217 days ago)

This article will show a few MySQL errors along with explanations as to why they might be occurring. (updated 206 days ago)

Step by step directions on how you can search your database using phpMyAdmin (updated 217 days ago)

A tutorial on how to perminately delete columns from your mySQL database using phpMyAdmin (updated 216 days ago)

Instructions on changing the name of your database using phpMyAdmin (updated 218 days ago)

Guidance on adding tables to your mySQL database in phpMyAdmin (updated 216 days ago)

A refrence defining the various mySQL variable types (updated 216 days ago)

Instructions on adding a column to your database in phpMyAdmin (updated 206 days ago)

A step by step guide on how to manipulate data in your mySQL tables using phpMyAdmin (updated 217 days ago)

A guide on renaming the tables inside of your database using phpMyAdmin (updated 217 days ago)