Get Started Site Tools control panel Set Up Site Site Tools Site Section Statistics Section Devs Section Email General Security Section Speed Section Domain Section Hosting Subscription Billing Questions Supported Technology Transitions And Upgrades Resource Usage Client Profile Other Website Help SiteGround CDN SuperCacher Cloudflare SSL Issues FTP inquiries Security Speed And Uptime PHP Questions Transfer Site Delete And Suspend Site Stats and Errors HTTP Status Codes File Manager SEO Other WordPress Autoupdates Configuration Plugins Themes Upgrades And Migrations How To Questions AI Agent for WordPress Getting Started Domain Issues Domain Transfer Registration And Renewal WHOIS And Domain Management DNS Management Other Website Builder Getting Started Pages & Content Editing Contact form Global Settings & Site Navigation Marketing, SEO and Analytics Colors, Fonts & Style Templates Ecommerce Getting Started System users Products Discounts Managing Orders Reviews Customers Analytics Store Settings Payments Shipping Taxes Pages & Sections AI Studio Getting Started Chat Agents Projects Connectors Prompts Usage Public Sharing History Files Coderick AI Integrations Usage Guidelines Credits Database Builder Service Management AI Tokens Overview AI Tokens Management Email Marketing Getting Started Usage Guidelines Campaigns Creating Emails Contacts Segments Custom Fields Groups Lead Generation Plugin Billing Analytics Other Google Workspace Email Management Account Setup Account Management Expert Care Overview Pricing and Subscription Database Support Database Optimization MySQL Basics Advanced MySQL Features MySQL Error Troubleshooting Database Management Email Support Email Configuration Receiving Email Sending Email Webmail Issues SPAM Prevention Forwarders and Autoresponders Advanced Site Tools SSH Git Cron jobs Other Collaborators and White-Label Clients Manage Collaborators Manage White-Label Clients Abilities and Аccess Other Applications Moodle vBulletin phpBB VirtueMart SMF Magento Drupal PrestaShop Weebly Joomla! MediaWiki Miscellaneous Affiliate and Referral Programs Compliance and Policies Tracking and Reporting Marketing Materials Campaign Management Getting Started Referral Program Affiliate Support Payments and Earnings Services Management Services Renewal Cancellations Home / Database Support Database Support Learn to fix database errors, optimize performance, and manage MySQL/PostgreSQL in Site Tools. Database Optimization How to reduce the database size of a WordPress application? MySQL optimization using indexes How to optimize a MySQL database? Show All MySQL Basics What is my MySQL Server Hostname? How to check the MySQL version? What databases can I use with my SiteGround account? Show All Advanced MySQL Features What are MySQL foreign key constraints and checks What are MySQL triggers and how to use them? How to use MySQL stored procedures and routines? Show All MySQL Error Troubleshooting I have problems setting up the MySQL database for my application I don't have enough privileges for creating/dropping databases in phpMyAdmin SQL Error 1064: A Beginner's Guide to Fixing the Error Show All Database Management How can I import a large database to my account? Can I change the name of a MySQL database? How to change the MySQL timezone? Show All