Return to "cPanel"
View the quick start guide for this product
Available subcategories under Database & Programming
 |
PHP (1) | |
MySQL (3) |
|
Troubleshooting (2) | |
CGI & Perl Scripts (2) |
Most popular articles under category Database & Programming
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...
Connecting to Databases with PHP
PHP and MySQL are extremely easy to use together; most tutorials and books written regarding PHP should have a section explaining the connection between the MySQL database and PHP. A simple MySQL connection can be opened in PHP using the following code: $connection = mysql_pconnect("localhost","username","password") or print "Error connecting to the...
PHP and MySQL are extremely easy to use together; most tutorials and books written regarding PHP should have a section explaining the connection between the MySQL database and PHP. A simple MySQL connection can be opened in PHP using the following code: $connection = mysql_pconnect("localhost","username","password") or print "Error connecting to the...
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...
MySQL Username
USERNAME_ will be added to your database name and database username. You will need to use the full USERNAME_dbname and USERNAME_dbusername in your scripts in order to make a database connection. Important Note: Replace USERNAME with your actual account username ...
USERNAME_ will be added to your database name and database username. You will need to use the full USERNAME_dbname and USERNAME_dbusername in your scripts in order to make a database connection. Important Note: Replace USERNAME with your actual account username ...
CGI-BIN
The cgi-bin is the directory where all of your CGI scripts are stored. Scripts are stored in this directory so that the Web server will know to execute these scripts instead of just displaying them in a browser. This directory has executable permissions, while all of your other directories should...
The cgi-bin is the directory where all of your CGI scripts are stored. Scripts are stored in this directory so that the Web server will know to execute these scripts instead of just displaying them in a browser. This directory has executable permissions, while all of your other directories should...