{"id":3176,"date":"2025-08-30T09:32:01","date_gmt":"2025-08-30T09:32:01","guid":{"rendered":"https:\/\/www.devopssupport.in\/blog\/?p=3176"},"modified":"2025-08-30T11:08:39","modified_gmt":"2025-08-30T11:08:39","slug":"how-to-import-an-sql-file-through-command-line","status":"publish","type":"post","link":"https:\/\/www.devopssupport.in\/blog\/how-to-import-an-sql-file-through-command-line\/","title":{"rendered":"How to Import an SQL File Through Command Line"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

Importing an SQL file through the command line is a useful skill when working with MySQL databases. Whether you’re migrating data, setting up a fresh database, or restoring a backup, the command line method is quick and effective. This guide will walk you through the process of importing an SQL file into a MySQL database using the Command Prompt (CMD).<\/p>\n\n\n\n

Prerequisites:<\/h4>\n\n\n\n
    \n
  1. MySQL installed<\/strong>: Ensure that MySQL is installed on your machine. If you are using a local development environment like XAMPP or WAMP, MySQL will already be included.<\/li>\n\n\n\n
  2. Access to MySQL<\/strong>: You must have access to MySQL with sufficient privileges (i.e., a user with the right to import data).<\/li>\n\n\n\n
  3. SQL file<\/strong>: The SQL file that you want to import should be available on your system.<\/li>\n<\/ol>\n\n\n\n

    Step-by-Step Guide to Import SQL File:<\/h3>\n\n\n\n

    Step 1: Open Command Prompt<\/h4>\n\n\n\n

    First, open the Command Prompt<\/strong> on your system.<\/p>\n\n\n\n

      \n
    • On Windows<\/strong>: Press Windows + R<\/code>, type cmd<\/code>, and hit Enter.<\/li>\n\n\n\n
    • On macOS\/Linux<\/strong>: Open the Terminal application.<\/li>\n<\/ul>\n\n\n\n

      Step 2: Navigate to MySQL Bin Directory<\/h4>\n\n\n\n

      To interact with MySQL, you need to navigate to the bin<\/code> directory of MySQL. This is where the mysql<\/code> command-line tool is located.<\/p>\n\n\n\n

      For example, if you’re using XAMPP<\/strong>, the MySQL bin directory is located at:<\/p>\n\n\n\n

      cd C:\\xampp\\mysql\\bin\n<\/code><\/pre>\n\n\n\n
      If you have a different MySQL installation, the path might be different, so adjust accordingly.<\/p>\n\n\n\n
      Step 3: Log into MySQL<\/h4>\n\n\n\n
      Now that you are in the MySQL bin directory, log into MySQL using the mysql<\/code> command. You will need your MySQL username and password.<\/p>\n\n\n\n
      Run the following command:<\/p>\n\n\n\n
      mysql -u root -p\n<\/code><\/pre>\n\n\n\n
      Here:<\/p>\n\n\n\n
        \n
      • -u root<\/code>: Specifies the username (in this case, root<\/code>).<\/li>\n\n\n\n
      • -p<\/code>: Prompts you for the MySQL password.<\/li>\n<\/ul>\n\n\n\n
        After entering your password, you will be logged into the MySQL shell.<\/p>\n\n\n\n
        Step 4: Create or Select a Database<\/h4>\n\n\n\n
        Before importing the SQL file, ensure you\u2019re in the correct database. You can either select an existing database<\/strong> or create a new one<\/strong>.<\/p>\n\n\n\n
          \n
        1. To select an existing database<\/strong>:<\/li>\n<\/ol>\n\n\n\n
          USE database_name;\n<\/code><\/pre>\n\n\n\n
          Replace database_name<\/code> with the name of your database.<\/p>\n\n\n\n
          To create a new database<\/strong> (if it doesn’t already exist):<\/p>\n\n\n\n
          CREATE DATABASE database_name;\n<\/code><\/pre>\n\n\n\n
          Then, use the USE<\/code> command to switch to the new database:<\/p>\n\n\n\n
          USE database_name;\n<\/code><\/pre>\n\n\n\n
          Step 5: Import the SQL File<\/h4>\n\n\n\n
          Now that you’re in the correct database, it’s time to import the SQL file.<\/p>\n\n\n\n
            \n
          1. Exit MySQL shell<\/strong> by typing exit<\/code> and hitting Enter.<\/li>\n\n\n\n
          2. Return to the Command Prompt<\/strong> (if you\u2019ve exited MySQL shell) and use the mysql<\/code> command to import the SQL file directly.<\/li>\n<\/ol>\n\n\n\n
            Run the following command:<\/p>\n\n\n\n
            mysql -u root -p database_name < \"C:\\path\\to\\your\\file.sql\"\n<\/code><\/pre>\n\n\n\n
            Where:<\/p>\n\n\n\n
              \n
            • -u root<\/code>: MySQL username (replace root<\/code> if you’re using a different username).<\/li>\n\n\n\n
            • -p<\/code>: Prompts you to enter your password.<\/li>\n\n\n\n
            • database_name<\/code>: The name of the database you want to import the SQL file into.<\/li>\n\n\n\n
            • \"C:\\path\\to\\your\\file.sql\"<\/code>: The full path to your SQL file. Use forward slashes<\/strong> or double-backslashes<\/strong> for Windows paths.<\/li>\n<\/ul>\n\n\n\n
              Step 6: Verify the Import<\/h4>\n\n\n\n
              Once the import is complete, you can verify that the tables have been imported correctly:<\/p>\n\n\n\n
                \n
              1. Log back into MySQL<\/strong>:<\/li>\n<\/ol>\n\n\n\n
                mysql -u root -p\n<\/code><\/pre>\n\n\n\n
                Select the database<\/strong>:<\/p>\n\n\n\n
                USE database_name;\n<\/code><\/pre>\n\n\n\n
                Show the imported tables<\/strong>:<\/p>\n\n\n\n
                SHOW TABLES;\n<\/code><\/pre>\n\n\n\n
                  \n
                1. This will display all the tables that were imported from the SQL file.<\/li>\n<\/ol>\n\n\n\n
                  Troubleshooting:<\/h4>\n\n\n\n
                    \n
                  • Invalid File Path<\/strong>: If you receive an error regarding the file path, ensure the path to your SQL file is correct and uses the right slashes. On Windows, use double-backslashes (\\\\<\/code>) or forward slashes (\/<\/code>).<\/li>\n\n\n\n
                  • Database Already Exists<\/strong>: If you are trying to import an SQL file into an existing database and it already has tables, ensure you\u2019re not overwriting or conflicting with any existing data.<\/li>\n\n\n\n
                  • Permissions<\/strong>: If you encounter permission errors, ensure your MySQL user has the correct privileges to import data.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
                    Importing an SQL file through the command line is a useful skill when working with MySQL databases. Whether you’re migrating data, setting up a fresh database, or… <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[1183,2726,1181,1187,965,2770,2766,100,2769,2767,2772,567,2768,2771,60],"class_list":["post-3176","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-command-line-2","tag-command-prompt","tag-data-migration","tag-database-backup","tag-database-management","tag-database-restore","tag-import-sql-file","tag-mysql","tag-mysql-commands","tag-mysql-import","tag-mysql-tips","tag-sql","tag-sql-commands","tag-sql-file-import","tag-xampp"],"_links":{"self":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts\/3176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/comments?post=3176"}],"version-history":[{"count":1,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts\/3176\/revisions"}],"predecessor-version":[{"id":3178,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts\/3176\/revisions\/3178"}],"wp:attachment":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/media?parent=3176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/categories?post=3176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/tags?post=3176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}