Return to "Database & Programming"
View the quick start guide for this product
All articles under MySQL
Using SSH to Import and Export your Data and Databases
You can export your database by using the "mysqldump" command. From the SSH command line, enter the command: mysqldump your_db_name > your_db_name.dmp This will push all data from the specified database into a dump file for backup. To import data from a dump file you can simply direct it into the MySQL command. mysql...
You can export your database by using the "mysqldump" command. From the SSH command line, enter the command: mysqldump your_db_name > your_db_name.dmp This will push all data from the specified database into a dump file for backup. To import data from a dump file you can simply direct it into the MySQL command. mysql...
Creating a MySQL Database
To create a database: 1. Login to your account control panel 2. Select "MySQL Databases" from the Databases section. 3. Enter the new database name and click "Create Database". 4. Click go back Important Note: The name of the database will be amended with your cPanel username as a prefix. 5. Next create...
To create a database: 1. Login to your account control panel 2. Select "MySQL Databases" from the Databases section. 3. Enter the new database name and click "Create Database". 4. Click go back Important Note: The name of the database will be amended with your cPanel username as a prefix. 5. Next create...
Managing databases with phpMyAdmin
Your databases can be managed with phpMyAdmin, an open source application designed for managing MySQL. To get to your installation of phpMyAdmin: • Log into your cPanel through your customer manager at https://my.opensourcehost.com • Click on “My Products” and then “Control Panel” across from your hosting package • Once logged into your cPanel, click on...
Your databases can be managed with phpMyAdmin, an open source application designed for managing MySQL. To get to your installation of phpMyAdmin: • Log into your cPanel through your customer manager at https://my.opensourcehost.com • Click on “My Products” and then “Control Panel” across from your hosting package • Once logged into your cPanel, click on...