How to Import a PostgreSQL database using phpPgAdmin Updated on March 31, 2022 by InMotion Hosting Contributor 0 Minutes, 50 Seconds to Read Now that you’ve installed PostgreSQL and phpPgAdmin on your server, you can begin to create and manage databases. In this tutorial, we’ll show you how to import a PostgreSQL database using phpPgAdmin in cPanel. You must create a PostgreSQL database before you can complete this guide. Importing a Database with phpPgAdmin Login to cPanel. Click the phpPgAdmin button in the Databases section. Note: The phpPgAdmin button, is only available after installing PostGreSQL on your VPS, or Dedicated server. On the top left, click the database you want to import the backup into. Click the SQL tab. Click the Browse button, and select your database backup file, and click Open. Click the Execute button to begin the import process. This will take some time depending on the size of the database. When you see a SQL Executed message, you are finished. You will also see that your tables are now populated. Congratulations, now you know how to import a PostgreSQL database using phpPgAdmin! Learn more about PostgreSQL Hosting options. Share this Article IC InMotion Hosting Contributor Content Writer InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals! More Articles by InMotion Hosting Related Articles How To Create a PHP Redirect (301, 302, and Dynamic Redirect Examples) Connect to SFTP for Shared Hosting Accounts Using FileZilla FTP Basics for Dedicated Servers How to Install Jekyll and Launch a New Site How to Host AI-Prompt Generated Websites on Shared Hosting What is your default PHP.ini file? Getting Started Guide: FTP Configuring your site in WS_FTP Schedule Social Media Posts With Buffer FTP Error – 421 Too Many Connections
Hi, I am getting the same error “No server supplied!” while importing the database. However I have configured the php.in as: max_execution_time = 120max_input_time = 180memory_limit = 1024Mupload_max_filesize = 128MPlease help.
Hello Arvind, Do you have an account with us so we may investigate further? There may be something in the file you are trying to import. If you could just provide us your domain name we can attempt to look into this issue further for you. Best Regards, TJ Edens
Hello Paris, Thank you for contacting us. I found a similar post, where they suggest you can update your settings in the php.ini. Thank you, John-Paul
