Clue Mediator

How to Import an .sql File into a Remote Server from a Local Machine

📅July 24, 2023
🗁MySQL

Importing an .sql file into a remote server is a common task when working with databases. Whether you're migrating data or deploying a new application, it's essential to know how to import an .sql file from your local machine to a remote server. In this blog post, we'll guide you through the process step by step.

Prerequisites:

Before we begin, ensure you have the following:

  1. An .sql file that you want to import.
  2. Access to the remote server where you want to import the .sql file.
  3. SSH access to the remote server and the necessary permissions to access and modify the database.

Importing an .sql File into a Remote Server: Step-by-Step Guide:

Follow these steps to import an .sql file from your local machine into a remote server:

Step 1: Open a terminal or command prompt on your local machine.

Step 2: Navigate to the directory where the .sql file is located using the cd command.

Step 3: Use the following command to transfer the .sql file from your local machine to the remote server using SCP (Secure Copy):

scp /path/to/local_file.sql username@remote_server_ip:/path/on/remote_server

Replace /path/to/local_file.sql with the actual path to the .sql file on your local machine, username with your SSH username, remote_server_ip with the IP address or domain name of the remote server, and /path/on/remote_server with the desired path on the remote server where you want to place the .sql file.

Step 4: Enter your SSH password when prompted to authenticate the file transfer. The .sql file will be copied from your local machine to the specified location on the remote server.

Step 5: Once the file transfer is complete, establish an SSH connection to the remote server using the following command:

ssh username@remote_server_ip

Replace username with your SSH username and remote_server_ip with the IP address or domain name of the remote server.

Step 6: Once connected to the remote server, navigate to the directory where the .sql file is located using the cd command.

Step 7: Import the .sql file into the remote server's MySQL database using the following command:

mysql -u username -p database_name < file.sql

Replace username with your MySQL username, database_name with the name of the target database on the remote server, and file.sql with the name of the .sql file.

Step 8: Enter your MySQL password when prompted. The .sql file will be read and executed, importing its contents into the specified database on the remote server.

Step 9: Once the import is complete, you can verify the imported tables and data in the MySQL database on the remote server.

Conclusion:

Importing an .sql file into a remote server from your local machine is an important skill when working with databases. By following the step-by-step guide provided in this blog post, you can seamlessly transfer and import an .sql file to a remote server using SSH and MySQL command-line tools. This method allows you to efficiently manage your databases and deploy applications without any hassle. With the power of SCP and MySQL, you can ensure smooth and reliable data migration and deployment processes.

That’s it for today.
Thank you for reading. Happy Coding..!! 🙂