RSS Feed
Knowledgebase : MySQL Server
"There is a bug with the Windows Parallels Plesk Control Panel that can sometimes cause a domain to get added to the BIND service twice. This would prevent the domain from being accessible and would show no DNS records even though the Blacknight Control P...
You can import your backup .sql files through phpMyAdmin. IMPORTING: * Log in to your MySQL database server via phpMyAdmin * Select your database name on the left * Click on the "IMPORT" tab on top * Click the "BROWSE" button and locate y...
This article goes over exporting a database in phpMyAdmin. * Log into Control Panel [1]. * Once logged in, GO TO YOUR DOMAIN DATABASES * Select the database * Click on WebAdmin * Click the EXPORT tab at the top of the page for the selected ...
* Login to Control Panel https://control.chillox.net/cp * Under your subscription/domain go to "Databases" * Click database name * Click "Webadmin" * Click "Import" * Click "Browse" to select the database then click "Go"
HOW TO EXPORT OR BACKUP OR DUMP A MYSQL DATABASE To export a MySQL database into a dump file, simply type the following command syntax in the shell. You can use Telnet or SSH to remotely login to the machine if you don't have access to the physical ...
The syntax is as follows to import the data created by mysqldump command: mysql -u {DB-USER-NAME} -p {DB-NAME} < {db.file.sql} mysql -u {DB-USER-NAME} -h {MySQL-SERVER-HOST-NAME} -p {DB-NAME} < {db.file.sql} In this example import a file called c...
They're located in _/VAR/LIB/MYSQL/_ Each database has a sub-folder here. You'll also find the MySQL log files here.
On Plesk servers the link to access phpmyAdmin can be slightly hard to find. This guide will walk through the menu options to choose in order to access phpmyAdmin for a specific domains database. The step by step instructions detailed below are from th...