{"id":2637,"date":"2025-03-12T12:00:31","date_gmt":"2025-03-12T11:00:31","guid":{"rendered":"https:\/\/hoganhost.com.ng\/blog\/?p=2637"},"modified":"2025-03-12T12:00:31","modified_gmt":"2025-03-12T11:00:31","slug":"how-to-upload-and-import-an-sql-database-in-cpanel-and-via-terminal-ssh","status":"publish","type":"post","link":"https:\/\/hoganhost.com.ng\/blog\/cpanel\/how-to-upload-and-import-an-sql-database-in-cpanel-and-via-terminal-ssh\/","title":{"rendered":"How to Upload and Import an SQL Database in cPanel and via Terminal (SSH)"},"content":{"rendered":"

<\/h2>\n

\"\"<\/h1>\n

<\/h1>\n

How to Upload and Import an SQL Database in cPanel and via Terminal (SSH)<\/strong><\/h1>\n

Importing an SQL database is essential for website migration, backups, or setting up a new project. This guide covers two simple methods: using cPanel (phpMyAdmin)<\/strong> for beginners and SSH (Terminal)<\/strong> for advanced users.<\/p>\n

With cPanel<\/strong>, you can easily upload and import an SQL file via phpMyAdmin<\/strong>, making it a user-friendly option. For larger databases, SSH (Terminal)<\/strong> offers a faster and more efficient way to import using MySQL commands.<\/p>\n

Follow our step-by-step instructions to restore your database seamlessly and keep your website running smoothly.<\/p>\n

<\/h2>\n

Method 1: Import an SQL Database Using cPanel (phpMyAdmin)<\/strong><\/h2>\n

<\/h3>\n

Step 1: Log in to cPanel<\/strong><\/h3>\n
    \n
  1. Open your web browser and go to: https:\/\/yourdomain.com\/cpanel<\/code>.<\/li>\n
  2. Enter your cPanel username and password<\/strong>.<\/li>\n<\/ol>\n

    Step 2: Open phpMyAdmin<\/strong><\/h3>\n
      \n
    1. In cPanel, scroll down to the Databases<\/strong> section.<\/li>\n
    2. Click on phpMyAdmin<\/strong>.<\/li>\n<\/ol>\n

      Step 3: Select the Database<\/strong><\/h3>\n
        \n
      1. In phpMyAdmin, look at the left sidebar.<\/li>\n
      2. Click on the database where you want to import the SQL file.<\/li>\n<\/ol>\n

        Step 4: Upload and Import the SQL File<\/strong><\/h3>\n
          \n
        1. Click the Import<\/strong> tab at the top.<\/li>\n
        2. Under “File to Import,” click Choose File<\/strong> and select your .sql<\/code> file.<\/li>\n
        3. Leave all settings as default and click Go<\/strong>.<\/li>\n
        4. Wait for the process to complete. If successful, you\u2019ll see a green success message.<\/li>\n<\/ol>\n

          \u2705 Done! Your database is now imported using cPanel!<\/strong><\/p>\n

          \n
          \n<\/div>\n

          Method 2: Import an SQL Database Using SSH (Terminal)<\/strong><\/h2>\n

          If your SQL file is large or you prefer the command line, use SSH to import your database efficiently.<\/p>\n

          Step 1: Upload the SQL File<\/strong><\/h3>\n

          Before importing, you need to upload your .sql<\/code> file to the server.<\/p>\n

          Option 1: Upload via cPanel File Manager<\/strong><\/h4>\n
            \n
          1. Go to cPanel > File Manager<\/strong>.<\/li>\n
          2. Navigate to \/home\/your_cpanel_username\/<\/code> (Recommended: Do NOT upload inside public_html for security reasons<\/strong>).<\/li>\n
          3. Click Upload<\/strong>, select your .sql<\/code> file, and wait for it to finish.<\/li>\n<\/ol>\n

            Option 2: Upload via FTP (FileZilla)<\/strong><\/h4>\n
              \n
            1. Open FileZilla and connect using your FTP credentials.<\/li>\n
            2. Upload your SQL file to a safe location (e.g., \/home\/your_cpanel_username\/<\/code>).<\/li>\n<\/ol>\n

              Step 2: Access SSH (Terminal)<\/strong><\/h3>\n

              If you have SSH access, follow these steps:<\/p>\n

                \n
              1. Open your terminal (Mac\/Linux) or use PuTTY<\/strong> (Windows).<\/li>\n
              2. Connect to your server:\n
                ssh your_cpanel_username@your_server_ip -p 22<\/code><\/pre>\n