RSS Feed
Knowledgebase : MySQL & Databases
\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.
\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...
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 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...
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...
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...
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...
WHAT IS THE NUMBER OF MAXIMUM CONNECTIONS ALLOWED TO A SINGLE MYSQL DATABASE? We allow up to 50 simultaneous connections per MySQL user, and up to 1500 simultaneous connections per server.
WHY AM I GETTING MYI ERROR CODES? This is an MYI error caused by our recent upgrade to mySQL 4. If you open PHPMyAdmin, select the database, on the page to the right of screen, scroll down and click on check all (bottom of table lists) and to the right of that is a drop down box, select "repair" and wait for the page to re-load.
DOES YOUR MYSQL SERVER SUPPORT EXTENDED CHARACTER SETS, FOREIGN CHARACTER SETS, AND COLLATION SETS? At the time of this writing (June 24, 2004), our MySQL servers do not support collation sets yet. Collation sets were introduced into MySQL in MySQL version 4.1.0 and was fully implemented in MySQL version 4.1.1. If you already have an account with us, please check your control panel. In the control panel's left-hand side of the page, there should be a MySQL version for your server. If the ...
CAN I USE MYSQL FRONT TO ACCESS MY DATABASE? You can remotely connect to your database by using your domain name as the host you are connecting to. You would also need to add your ip address to the remote access list in the mysql manager in your cpanel. Or, rather than entering your IP, enter the % symbol - this acts as a wildcard and will allow connections from any remote IP.
CAN I CONNECT TO MYSQL REMOTELY?  Yes, you can connect to your MySQL database remotely on our Linux servers only using a client such as MySQL Administrator which is part of the MySQL GUI Tools found at http://mysql.org/downloads/ [http://mysql.org/downloads/] Please remember to enter your own IP address or % for a wildcard in the REMOTE MYSQL area in Cpanel. Additionally, you must create a database as well as a user and then add the user to the database prior to establishing a connection. Your...
VB has a function to test if the connection is up, unfortunately it seems to return the wrong value. What can I do to resolve this? You will need to code in a custom keep-alive query that polls the DB every 200 seconds or less to correct this error.
TABLE TYPES We offer ISAM, MyISAM, HEAP, MEMORY, and InnoDB table types. IMPORTING TABLES INTO A DATABASE Open phpMyAdmin. Select the database you want to import the table(s) in. Go to the SQL tab. Look at the bottom for "Or location of the textfile" and browse to the dumpfile. Doubleclick on it so that the file address appears in the textbox. Then hit Go. All SQL statements will be executed and you will get a notification after the file is processed.