phpMyAdmin lets you view and modify a database. You can change database values, run queries, and create, view and modify your database structure. Go to the Hosting Control Center to access phpMyAdmin.
NOTE: Programs like WordPress® and Joomla® provide their own Web interface for modifying a database. If you are using one of these programs, [...]
Here’s the Lowdown: MySQL and MSSQL may be different databases, but in the Hosting Control Center, the process of backing up and restoring them is virtually the same.
You can back up and restore databases as often as you’d like, however, you can only initiate a restore after any previous backup or restore request has completed.Backing [...]
You can create a read-only database user to allow a third party to browse the data in a database, to use for your reporting tools, or to ensure that your scripts are not writing to the database.
NOTE: You cannot add a read-only database user to an already-created database. This feature is only for new [...]
If you have a Shared Hosting account with one or more databases, you may receive an email indicating the server hosting the database has or will change. The change is a necessary part of our continuing effort to improve product quality. Once all of your databases are upgraded, not only will your account be hosted [...]
Errors such as: …”Got error: 1016: Can’t open file: ‘YOUR_TABLE_NAME.MYI’. (error:145)
when using LOCK TABLES”… (as well as numerous other noted below) are
caused by MySQL table corruption. Table corruption can be caused by a
variety of events, and will make some or all of a table unavailable.
Table corruption can also significantly decrease the performance of
queries on effected [...]
This is most likely caused by your site having met its maximum concurrent connection limit. Shared hosting accounts are subject to the following limits:
LinuxLinux Economy – 50 Concurrent Connections
Linux Deluxe – 100 Concurrent Connections
Linux Unlimited – 200 Concurrent ConnectionsWindowsWindows Economy – 50 Concurrent Connections
Windows Deluxe – 100 Concurrent Connections
Windows Unlimited – 150 Concurrent ConnectionsMySQL connection [...]
Note: If you no longer plan to use Pligg Content Management System, you may remove the associated database from the Hosting Control Center.
You may disable or delete the module from the Pligg Administration Control Panel.Log into your Pligg site.
Click the ‘Admin’ link.
Click ‘Module Management’.
Click disable next to Page Statistics v 0.2If you need to continue [...]
You can remove or disable the database associated with the Pligg Administration Control Panel from the Hosting Control Center.
NOTE: Only remove Pligg Content Management System if you no longer plan to use it.
To Remove or Modify Page Statistics v. 0.2 from PliggLog into your Pligg site.
Click Admin.
Click Module Management.
Click the Disable button for Page [...]
To connect remotely to a database, you must create a database and enable direct database access. If a database was created without this option selected, you will not be able to connect remotely.
For more information on creating a database with direct database access, see Setting up a MySQL or SQL Server Database for Your [...]
Here’s the lowdown: We provide database management tools with our shared hosting databases. You can, however, connect remotely to your shared hosting databases if you specify to Allow Direct Database Access when you create the database.
Direct Database Access allows you to remotely manage your hosting account databases with external tools such as Microsoft SQL [...]
It is possible to restore a SQL Server database from a backup file (.bak) created outside the Hosting Control Center or from an MDF file. Doing so requires Microsoft Database Publishing Wizard and SQL Server with Management Studio.
For information on Database Publishing Wizard, see What are the Database Publishing Service and Database Publishing Wizard?.
Download [...]
Collation controls the way string values are sorted. The default collation sorts alphabetically using the standard Latin character set. Other collations will sort in different orders. For example, a traditional Spanish collation places words beginning with “ch” at the end of a list of words beginning with “c.”
It is not necessary to [...]
ASP.NET starter kits can be downloaded from the ASP.NET website.
The following instructions use the ASP Time Tracker starter kit as an example. However, you can use this upload procedure for any starter kit that uses a SQL database (running from a local MDF file or a standalone server). The directions assume the following:You have [...]
If you no longer want a specific Cron Job to run, you can delete it from your list of saved Cron Jobs.
To Delete a Cron JobLog in to your Account Manager.
In the My Products section, select Hosting.
Next to the hosting account you want to modify, click Manage Account.
In the Content section of the Hosting [...]
You can edit any saved Cron Job to change the frequency at which a specific task runs or retain the frequency and change the task that runs at that interval.
To Edit a Cron JobLog in to your Account Manager.
In the My Products section, select Hosting.
Next to the hosting account you want to modify, [...]