RSS Feed
Knowledgebase : MySQL Databases
Yes, RFE Hosting's mysql databases are unicode compatible.
Creating a database in cPanel using the MySQL Database Wizard: 1. Log into your cPanel 2. Click the MySQL Database Wizard under the Databases heading 3. Next to New Database enter a name for your database and click Next Step 4. Next to Username en...
This will show you how to whitelist your IP to allow remote MySQL connections for Shared, Reseller, VPS/cPanel and Linux Dedicated Servers. Allowing remote MySQL connections is often done to enable a program on your personal computer (such as Adobe Drea...
You can view whether your account is using localhost or remotemysql host in your cPanel account. Click on 'phpMyAdmin', in the 'Datebases' menu. Your database host will be displayed on the next screen after Server. It will be listed as localhost or remote...
There are two ways to back up your MySQL databases. You can use the backup utility in your cPanel account or you can manually backup using phpMyAdmin. To manually backup using phpMyAdmin follow these steps: - Login to your control panel at www.yourdoma...
To create a MySQL database please follow the steps below: - Login to your control panel at www.yourdomain.com/cpanel - Click on 'MySQL Databases' in the 'Databases' menu - Enter the name of your new database and then click on 'Create Database' - Add da...
To import a database follow the below steps: I have a backup of my database that I need to import/transfer to my new account. - Once you have your .sql file you will need to log into your cPanel at www.yourdomain.com/cpanel - Click on 'phpMyAdmin' und...
To restore a MySQL database please follow the below steps: - Login to your control panel www.yourdomain.com/cpanel - Click on 'Backups' in 'Site Management' - Click on 'Browse' to locate the Database you want to restore then click 'Upload' It may take a...
To add yourself to the whitelist so that you can connect to mysql remotely using admin tools such as phpMyAdmin, Navicat, MySQLFront or MySQL-Admin follow the below steps: - Log into your control panel at www.yourdomain.com/cpanel - Click on the 'Remote...
The command line option from SSH is: mysql -d -p database_name > file.sql. Where 'database_name' is the name of your database, and 'file.sql' is the name of the file you would like to write the table structure to. You will be prompted you for a password (...
Since we run a shared hosting environment, we have to uniquely identify your usernames to your account only. We do this by attaching your system username and an underscore '_' before all the databases and users that you create. This only applies to your d...
There are two different ways to connect to a MySQL database: Locally - from a script on the server, to the server for which the settings are: Hostname: localhost Username: username_dbuser Password: dbpassword db_name: username_dbname db_table: dbname...
A database is a structured, organized set of data. In computing terminology a database refers to a software used to store and organize data. Think of it as a file cabinet where you store data in different sections called tables. When you need a particular...
MYSQL is a database management system that is used by WordPress to store and retrieve all your blog information. Think of it this way. If your database is a filing cabinet that WordPress uses to organize and store all the important data from your website ...