The author selected the Free and Open Source Fund to receive a donation as part of the Write for DOnations program. Show IntroductionImporting and exporting databases is a common task in software development. You can use data dumps to back up and restore your information. You can also use them to migrate data to a new server or development environment. In this tutorial, you will work with database dumps in MySQL or MariaDB (the commands are interchangeable). Specifically, you will export a database and then import that database from the dump file. PrerequisitesTo import or export a MySQL or MariaDB database, you will need:
Note: As an alternative to manual installation, you can explore the DigitalOcean Marketplace’s MySQL One-Click Application. Step 1 — Exporting a MySQL or MariaDB DatabaseThe Use
The command will produce no visual output, but you can inspect the contents of Run the following command:
The top of the file should look similar to this, showing a MySQL dump for a database named
If any errors occur during the export process, Step 2 — Importing a MySQL or MariaDB DatabaseTo import an existing dump file into MySQL or MariaDB, you will have to create a new database. This database will hold the imported data. First, log in to MySQL as root or another user with sufficient privileges to create new databases:
This command will bring you into the MySQL shell prompt. Next, create a new database with the following command. In
this example, the new database is called
You’ll see this output confirming the database creation.
Then exit the MySQL shell by pressing
If the command runs successfully, it won’t produce any output. If any errors occur during the process, ConclusionIn this tutorial you created a database dump from a MySQL or MariaDB database. You then imported
that data dump into a new database. To learn more about MySQL, check out our MySQL resource page. To learn more about MySQL queries, check out our tutorial, “An Introduction to Queries in MySQL”. Apakah MySQL dan MariaDB sama?Seperti yang telah disebutkan bahwa MariaDB adalah pengembangan dari MySQL. Oleh karena itu, kedua aplikasi database ini tidak memiliki perbedaan yang signifikan, baik fitur maupun fungsi. Perbedaan terbesarnya terletak di MariaDB yang merupakan relational DBMS tingkat lanjut.
Langkah langkah import database?Berikut adalah langkah-langkahnya.. Pada tab bagian atas, silakan klik Import.. Setelah itu silakan tekan tombol Choose File atau Browse.. Pilih file database Anda berupa .sql, kemudian klik Open. Anda akan melihat name file yang Anda pilih di samping tombol Browse.. Pastikan Anda memilih SQL pada menu drop down.. Bagaimana cara import SQL?Impor file SQL ke database MySQL. Masuk ke phpMyAdmin.. Di phpMyAdmin, di menu sebelah kiri, pilih nama database yang ingin Anda gunakan. ... . Di menu bagian atas, pilih Impor.. Gunakan Pilih file.. Temukan dan pilih file yang ingin Anda impor, lalu pilih Buka.. Di bagian bawah halaman, pilih Mulai.. Langkah untuk masuk di MySQL?MySQL Membuat Database dan Table. Buka command prompt dengan cara tekan ctrl + R keudian ketik cmd lalu enter.. Buka MySQL dengan cara mengetikan cd AppServ\MySQL\bin\MySQL.. Bila meminta password, masukkan password yang kalian buat (tapi biasanya password defaultnya “root”). |