If you need to create a backup of a remote MySQL database, you can use the mysqldump command. The mysqldump application is known as a client utility and installed alongside MySQL itself. Show When executed, mysqldump will create a dump file of the database that includes all the data and the structure of the database in In this tutorial, I’ll work through a simple example of using mysqldump to create a local copy of a remote database. I’ll be connecting to a remote server running Ubuntu Server via SSH, running the mysqldump command to backup the database to a file, and then downloading that file to my local machine using SCP. 1. Login to the remote server using SSHFirst, open a terminal and use SSH to login to the remote server hosting your MySQL database. You will need to enter your remote server username before the server IP address using the @ symbol. After running the command enter your password to login. 2. Use mysqldump to create a backup of your MySQL databaseNext, on the remote server, run the It may take a few minutes depending on the size of your database. The
For the next step you’ll need the full path to the backup file, so enter 3. Logout of the SSH connectionLogout of the SSH connection to your remote machine and return to the shell on your local machine by entering 0. This will return you to the shell on your local machine.4. Use SCP to download the SQL backup to your local machineFinally, on your local machine, we’ll use the SCP or secure copy application to download the MySQL backup file from the server via SSH. In the command below we’re starting 1 and creating an SSH connection for the user 2 on the IP address 3.Once logged in, SCP will look for the file at 4 on the remote server and download it to 5 on the local machine. It will give you a useful progress bar, so you can track how much of the database has been downloaded.
Creating a local copy of your MySQL database is a good idea for several reasons. Firstly, it keeps your data backed up. Secondly, it allows you to create your own development environment where you can safely run complex MySQL queries against your database without the risk of slowing down your production database. To create a local development environment for data science projects running on MySQL databases my preferred approach is to run MySQL in a Docker container. This is a great way to create a development environment for data science projects that can be run on a local machine without the need to install a full-blown server. Yang pertama saya akan membahas bagaimana saya mengambil semua data dan structure dari database kedalam satu file yaitu file .sql. Login ke server via sshkalian harus login dulu ke server via ssh untuk bisa mengakses database yang ada pada server. kalian bisa login via ssh menggunakan perintah berikut
namadomain.local diganti dengan domain yang diinginkan, ini tanya sebagai contoh. setelah itu kalian akan diminta masukan password/katasandi user tersebut. Jika berhasil login akan muncul command prompt seperti ini :
itu berarti anda berada pada direktori ~ pada server. Menurut pengalaman saya, saya login ke mysql untuk mengakses database, untuk masuk ke mysql, bisa dilakukan dengan perintah :
Setelah masuk, command prompt akan berubah menjadi :
itu artinya kalian sudah berada pada aplikasi mysql, nah setelah itu kalian bisa meng-export database yang diinginkan dengan perintah :
keterangan :
jika kalian melakukan yang seperti ini, maka perintah yang kalian lakukan sudah benar tapi penggunaannya keliru. saat kalian menekan enter, maka akan muncul pesan error : |