Just Host Limited

Category » Databases

There were 9 articles found in this category:

1. How do I restore a MySQL database?
   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 while to upload your .sql and populate the ...
2. 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 '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 (-p). Normally mysqldump gives you the ...
3. 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 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 MySQL' under the 'Databases' menu - Type ...
4. 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 server, to the server for which the settings are: Hostname: localhost Username: username_dbuser Password: dbpassword db_name: username_dbname db_table: dbname_table Remotely - from a remote computer, usi ...
5. 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 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' under the 'Databases' menu - A drop down of you ...
6. 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 account or you can manually backup using phpMyAdmin. To manually backup using phpMyAdmin follow these steps: - Login to your control panel at www.yourdomain.com/cpanel - Click on 'phpMyAdmin' und ...
7. 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 account at www.yourdomain.com/cpanel. Click on 'MySQL Databases' under the 'Databases' menu. Add a new user by entering a username and password if you don't have one you would like to use. Add the user t ...
8. 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. 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 remotemysql host.
9. How do I create a MySQL database?
   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 database users by assigning them a username ...