# Export/Import DB MySQL

## Export Database from phpMyAdmin

Export Databases dari phpMyAdmin

<figure><img src="https://695498858-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F89GYZ7bCFBFFAobNJ6x5%2Fuploads%2FShb4mb1CGUwtixbsxu85%2Fimage.png?alt=media&#x26;token=22929ad1-6ce7-4442-8d4e-e9f1047e0276" alt=""><figcaption></figcaption></figure>

<figure><img src="https://695498858-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F89GYZ7bCFBFFAobNJ6x5%2Fuploads%2FjaNe171NlrYA8leTlcwP%2Fimage.png?alt=media&#x26;token=4f803101-ed88-491f-9bbf-3e5fdc6b198e" alt=""><figcaption></figcaption></figure>

Kemudian Klik Export Method `Quick`display online the minimal options. Setelah berhasil, database berhasil di export dan silahkan di download.

## Import

Gunakan Mysql Workbench 8.0 CE untuk import databases.

<figure><img src="https://695498858-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F89GYZ7bCFBFFAobNJ6x5%2Fuploads%2FzD5NmBTVtW9lOiYSkBDx%2Fimage.png?alt=media&#x26;token=cba63aa7-6c52-4b99-8e3c-d8cb9f667b63" alt=""><figcaption></figcaption></figure>

Silahkan, klik myDatabases dan masukan user Password.

<figure><img src="https://695498858-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F89GYZ7bCFBFFAobNJ6x5%2Fuploads%2FjnGgzj1WYADiIn6ZmCut%2Fimage.png?alt=media&#x26;token=cffb8800-6469-469c-8924-6dc49d0e391e" alt=""><figcaption></figcaption></figure>

Setelah berhasil, akan di direct ke halaman berikut ini.

<figure><img src="https://695498858-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F89GYZ7bCFBFFAobNJ6x5%2Fuploads%2FjZAIGwBMO6yqmvnHveBo%2Fimage.png?alt=media&#x26;token=b7007dfe-5f32-4429-a032-6e9ae3e77e47" alt=""><figcaption></figcaption></figure>

Untuk mengimport database yang telah di download dari phpmyadmin server, sekarang import database ke localhost/ke server lain, silahkan klik navbar `server` , kemudian pilih data import, seperti gambar di bawah ini.

<figure><img src="https://695498858-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F89GYZ7bCFBFFAobNJ6x5%2Fuploads%2FUssDSxV8lvHN3FBpXVx9%2Fimage.png?alt=media&#x26;token=367263e2-fb8b-4fd5-a50e-8d33b6860606" alt=""><figcaption></figcaption></figure>

Saat import databases, `pilih import from self contained file`, sebelum melakukan import, buat default scheme atau gunakan scheme database yang telah dibuat.

{% content-ref url="akses-database-and-create-new-database" %}
[akses-database-and-create-new-database](https://hermanto.gitbook.io/django/databases/akses-database-and-create-new-database)
{% endcontent-ref %}

<figure><img src="https://695498858-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F89GYZ7bCFBFFAobNJ6x5%2Fuploads%2FhKEnEBvuSzGPVn3nNVL9%2Fimage.png?alt=media&#x26;token=b7e9f908-6895-46d2-a995-be876fc2b0d2" alt=""><figcaption></figcaption></figure>

Kemudian klik start `import`

<figure><img src="https://695498858-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F89GYZ7bCFBFFAobNJ6x5%2Fuploads%2FajmywAFqRBTiYja4VGsm%2Fimage.png?alt=media&#x26;token=479dbbab-2d0b-4fe9-b0fe-cab8d0380d9d" alt=""><figcaption></figcaption></figure>

Database berhasil di import