Skip to content

Instantly share code, notes, and snippets.

@tiago-peres

tiago-peres/Getting the Database File from Mysql PHPmyAdmin.md

Created March 22, 2025 22:07
Show Gist options
  • Save tiago-peres/c7f838bf71bff0ed032f2dce84213cc3 to your computer and use it in GitHub Desktop.
Save tiago-peres/c7f838bf71bff0ed032f2dce84213cc3 to your computer and use it in GitHub Desktop.
Download ZIP
Getting the Database File from Mysql PHPmyAdmin
Raw
Getting the Database File from Mysql PHPmyAdmin.md

1. Get database from phpMyAdmin

To get the database, the quickest way is to export it

  1. Open phpMyAdmin. If you are using XAMPP, click in the MySQL admin button

Open phpMyAdmin through XAMPP

  1. Click in the database you want to export.

  2. Click on the Export tab at the top.

Export Dabatase in phpMyAdmin

  1. Keep the default settings and click "Export".

Database exported from phpmyadmin

You can open it with something like Notepad++ and see the SQL file used to generate the database

phpmyadmin database file

2. Which file should be imported into phpMyAdmin?

You can only import .sql files or compressed files (.sql.zip) containing SQL dump files.

Since you've generated one before you can create a database with the name you want (for example, fertilitycare2)

Create database in phpMyAdmin

once created, click on the Import tab at the top.

Import database into phpMyAdmin

then click the import button in the bottom of that form

Imported database successfully

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment