Articles

 Backup MySQL Database via SSH/Command Line

With mysqldump, you have a handy tool for creating logical backups of your MySQL databases. The...

 Check all MySQL Databases on Plesk Linux via SSH/Command Line

Should you require a thorough database check and repair, you will need the MySQL root password,...

 Do I use localhost or remotemysqlhost for my mysql connection?

You can view whether your account is using localhost or remotemysql host in your cPanel account....

 How can I connect to a MySQL database from Dreamweaver?

To connect to a MySQL database from Dreamweaver follow the below steps:Login to your cPanel...

 How do I create a MySQL backup?

There are two ways to back up your MySQL databases. You can use the backup utility in your cPanel...

 How do I create a MySQL database?

To create a MySQL database please follow the steps below:- Login to your control panel at...

 How do I import a MySQL database?

To import a database follow the below steps:I have a backup of my database that I need to...

 How do I restore a MySQL database?

To restore a MySQL database please follow the below steps:- Login to your control panel...

 How to Create a Database in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on MySQL Databases.3. In the...

 I can't log into MySQL from a remote computer using a MySQL admin tool.

To add yourself to the whitelist so that you can connect to mysql remotely using admin tools such...

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

The command line option from SSH is: mysql -d -p database_name > file.sql. Where...

 MySQL Crashing Randomly or Frequently

Experiencing MySQL crashes on your VPS now and then (or often)? The most probable cause is that...

 Optimizing MySQL on Linux Systems

Boost MySQL's performance by leveraging MySQL Tuner. Here's a comprehensive guide on enhancing...

 Repair and Optimize all MySQL Databases on server SSH

At times, SQL databases may become corrupted, disrupting your website's functionality....

 What are the Basic Connection Settings for MySQL?

There are two different ways to connect to a MySQL database: Locally - from a script on the...

 How to Rename a Database in cPanel

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases.3. Under...

 How to Delete a Database in cPanel

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 3....

 How to Create a Database Username in cPanel

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases.3. Under...

 How to Add a User to a Database and Grant Privileges

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases.3....

 How to Import a Database via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin.3. From the...

 How to Export Database Table via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin. 3. From the...

 How to Edit a Database Table via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin.3. Click on the...

 How to Delete a Database Table via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin. 3. Click on...

 How to Optimize a Database via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin. 3. Click on...

 How to Repair a Database via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin.3. Click the...