How To Analyze Database Size with phpMyAdmin | HostGator Support

How To Analyze Database Size with phpMyAdmin

Providing information in a structure that everyone can understand is the main function of a database and keeping a database optimized is one way of reducing the database system response time. The size of your database plays a vital role in terms of optimization, including the type of data that was stored, how it was written and if indexing is used. The larger the database is, the more information is stored. Thus, it uses more resources, and response time could take longer.

To analyze your database size:

Log in to the cPanel.
Look for the Databases section, then click phpMyAdmin.
On the next page, select your database by clicking the + icon to expand and see its tables.
Once collapsed, all tables of that database will be displayed.
Scroll a little bit to the right to view the Size column.
The phpMyAdmin shows the sizes of each table with the total size of all tables at the bottom page.

HostGator is committed to making it easy to transfer your site to your new hosting account. We can transfer website files, databases, scripts, and one free domain registration transfer.

What qualifies me for a free transfer?

HostGator provides free transfers for new accounts within 30 days of sign-up, and to newly upgraded accounts. For upgraded accounts it must be an inter-server upgrade to qualify. Please note that downgraded accounts do not qualify for free transfers.

Depending on which type of account you sign up for, we offer differing numbers of free transfers. Please refer to the chart below to see what we include for new packages.

Full cPanel Transfers is the number of cPanel to cPanel transfers that are included.

Max. Manual Transfers is the maximum number of Manual Transfers that are included with your account.

Total Free Transfers is the total number websites that we will move for you.

Account Type	Total Free Transfers	Full cPanel Transfers	Max. Manual Transfers
?Shared	1	1²	1
?Reseller	30	30²	30
?VPS	Unlimited¹	Unlimited²	10 per VPS level
?Dedicated (Basic)	Unlimited¹	Unlimited²	75
?Dedicated (Standard, Elite, Pro)	Unlimited¹	Unlimited²	100

¹While we can do unlimited cPanel to cPanel transfers for you, depending on your account, you will have a limited number of Manual Transfers.

²Full cPanel transfers include all domains, Addon Domains, Subdomains, and cPanel settings. This will also include your emails and email accounts. Please note that this does require that your old host's cPanel backup generator to be active.

A few examples: An Aluminium Reseller account includes up to 30 free transfers. Out of this 30, you can have 20 cPanel to cPanel transfers and 10 Manual Transfers, or any combination of the two that totals 30 or less websites. Another example: A Pro Dedicated server includes unlimited cPanel to cPanel transfers, this means you can have 150 sites (or even more) moved. Also since there is an unlimited total number of transfers, you can utilize up to 100 Manual Transfers.

For more information please see ourTransfers Support Article, contact our transfers department at [email protected], or call 866.96.GATOR