Knowledgebase

Knowledgebase : MySQL & Databases
How do I connect to my database from Dreamweaver MX? We're going under the assumption that you have already set up a MySQL database on your server. When you set up your site in Dreamweaver make sure these are your settings: LOCAL INFO Site Name: Whatever you like Local Root Folder: Navigate to where you keep your files for the site on your home computer HTTP Address: http://yourdomainname.com/ [1] REMOTE INFO Access: FTP FTP Host: yourdomain.com or servername.yoursite.com (change ...
The hostname to connect to is "localhost" if connecting from a script on the server, or your domain name for connecting remotely. The database name and username need to be entered exactly as they appear in the MySQL manager in your control panel (CPanel) ie cpanelusername_dbname, etc. The password is the one you specified when creating the username. When you create a username in cpanel, please be aware that there is an 8 character limit. Extra characters will be dropped. Also, you can h...
\N\NIS THERE A WAY FOR ME TO COPY AN ENTIRE DATABASE IN CPANEL?\N\N You will need to export the original database, and import to a new database. HOW TO EXPORT? * Go to existing database in phpMyAdmin * Click Export at the top * Leave the settings as they are, click the "Save as file" checkbox and click Go * This will download a .sql file to your computer HOW CAN I IMPORT A DATABASE? * Create a new database in cPanel * Go to phpMyAdmin * Click the new database name in th...
When you install a script from Cpanel which requires a MySQL database, you must have 1 available unused database. This can be a waste for simple scripts like the Advanced Guestbook which doesn?t get a lot of interaction or entries compared to other scripts. It is also a bit of a pain if you only want to check out some of the scripts to see what they do. You have to install a script, do the setup and testing, and then delete the database to try out the next. It would be nice to be able to chec...
You can backup your database two ways. STEP 1: Click on Backup in Cpanel then click on the database name. This will download a gzipped copy to your computer. STEP 2: Use the PHPMyAdmin feature in your control panel by clicking on MySQL and then phpmyadmin at the bottom. In PHPMyAdmin, select the database you want to backup and select "Export" tab on the right screen. Choose the tables you wish to backup (or "Select All" for all tables). Scroll down and tick "Save File As..." and click o...
This can be used to back up a database or to move database information from one server to another. STEP 1: Export A MySQL Database This example shows you how to export a database. It is a good idea to export your data often as a backup. # mysqldump USERNAME -pPASSWORD DATABASE_NAME > FILE.sql Replace username, password and database_name with your MySQL username, password and database name. File FILE.sql now holds a backup of your database, download it to your computer. STEP 2: Import A MySQ...
How do I connect to a MySQL database using Python? First, import the MySQLdb module: import MySQLdb Next, create a connection object: connection=MySQLdb.connect(host="localhost",db="",user="",passwd="") Finally, create a cursor object: cursor=connection.cursor() Use the 'execute' method on the 'cursor' object to submit SQL to the database.
Here is a step-by-step for renaming a table: 1. Log into cPanel 2. Click on "MYSQL DATABASES" 3. On the page that loads, click on the "PHPMYADMIN" link at the bottom. This should load a new window. 4. In this new window, select the DB that contains the table you want to modify from the drop down menu at the left (in the darker blue). 5. The screen should refresh with all of the tables in that DB. On the table you want to modify, click thePROPERTIES button, which is in the "_ACTION_" c...
\N\NFORGOT YOUR DATABASE'S PASSWORD?\N\N You must create a new user with a new password. Do not worry, this will not erase or change any of the data in your database! * Go to cPanel, click Mysql Databases. * Create a new user with the desired password. * Add User to Database. * Replace the username and password settings in your program's configuration file.
There is no limit for the size of databases. MySQL is only limited to the size of your cPanel's disk space.

Powered by WHMCompleteSolution