\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.