You searched for mysql - Page 9 of 11

How to increase the size of /tmp partition?

Following steps could be referred for the same:- a.. First stop MySQL, Apache, and cPanel to prevent writing to the /tmp partition b. Take a …

Control Panel

How do I change my CPanel password

a) Login to your websites CPanel b) Under the “Preferences Menu” option, click “Change Password” c) Now Enter your old password and then your …

Control Panel

How to manage databases with the Webadmin

Webadmin allows you to manage your MySQL or MS SQL database via your web browser, without the need to download & install a database management …

Operating System

How to Fix Internal Server Error 500

Sometimes, an error in permissions or syntax within a script will result in an Internal Server Error 500, also known as an HTTP Error 500. …

Database

Backup a database from the shell prompt

Another technique for backing up a database is to use the mysqldump program or the mysqlhotcopy script. Create a full backup of your database: shell> …

Database

Use the Load DATA statement?

After creating your table, you need to populate it. The LOAD DATA and INSERT statements are useful for this. Suppose that your pet records can …

Customer Service

What database software does Hivelocity support?

Hivelocity supports Microsoft SQL server AKA MSSQL , PostgreSQL , and MYSQL.

Database

Manage Query Cache

You can check whether the query cache is present in your MySQL server using the following statement: mysql> SHOW VARIABLES LIKE ‘have_query_cache’; You can defragment …

Database