By default, PhpMyAdmin in a cPanel server imposes an upload limit of 50MB. So, importing a SQL file larger than 50MB may time out. To increase the default upload limit, just follow these steps. First, log in with SSH and root. Next, search the path of php.ini (generally, it’s located
If your cPanel account is giving you the error “Sorry the domain is already set up,” it’s probably due to one of two different reasons. On it’s own, this error simply means that the domain in question still exists within the virtualhost in the apache httpd.conf configuration file. In the
What is mysql_upgrade? If your server runs MySQL databases, then the mysql_upgrade command is one you’ll want to familiarize yourself with. Available only in Unix, mysql_upgrade is a command that checks all tables in all databases for incompatibilities with your current version of the MySQL Server. After checking your databases,
With it’s ease of use and high reliability, MySQL is one of the most popular database solutions in the world. If you’re looking for instructions on how to download, install, and perform basic functions using MySQL, this guide will teach you everything you need. Downloading the Current Release of
In a replication setup, a master MySQL server updates one or more slaves. Transactions are committed sequentially, and a slow transaction can cause the slave to lag behind the master. This means that if the master fails, it is possible that the slave might not have recorded the last few
If your MySQL connection is failing and returning the message ERROR 2002 (HY000): Can’t connect to local MySQL server through socket, then chances are your MySql.sock file is missing or has been deleted. By following these steps, you’ll be able to diagnose and determine which actions must be taken to
How to View a Table in a SQL Server Database Need to know how you can view a table within a SQL server database? Using the Enterprise Manager, this can be achieved with just a few simple steps. First, you’ll need to open Enterprise Manager and expand the registered SQL
To restore a database on SQL Server using .mdf, .ldf, or .ndf files, rather than performing a restore, you will actually need to attach the database. There are two ways to do this. Using Enterprise Manager To attach a database using Enterprise Manager, follow these instructions: Expand the registered
Executing a SQL Script in 6 Easy Steps Need to know how to execute a SQL script in MSSQL? Just follow these 6 simple steps: To execute a .sql file, you’ll first need to open the “Query Analyzer” tool. To do this, navigate to the Start menu -> Programs ->
Overview WebHost Manager (WHM) enables you to list all subdomains on your server. This function will display all subdomains and parked domains, sorted by domain name. Steps To list out your subdomains using WHM, just follow these steps: To access the Account Information Menu, click on Account Information, on
Overview This function allows users to display all domains that are parked on top of other domains. Steps To see a list of all parked domains, just follow these steps: To access the Account Information Menu, click on Account Information, on the main screen of your WebHost Manager interface.