TutorialsDev

Loading a database in the Virtualmin administration panel

In this article, we will present the necessary steps to upload a database in the Virtualmin administration panel.

7
Views 503Updated 7 luniPublished on 29/01/2020by Sebastian Szlivka

Introduction

  • In this article, we will present the necessary steps to upload a database in the Virtualmin administration panel.

Requirements

  • Access to the Virtualmin control panel, username and password.
  • Database we want to upload to the server (generally a file with the .sql extension).

Steps

  • First, we will log in to the administration panel

virtualmin, login, panou, autentificare

  • Once logged in to the control panel, we will click on Edit Databases

edit databases, baza date

  • Click on Manage on the right side of the database onto which we want to upload the file.

manage database

  • Click on Execute SQL

sql, execute, query, baza de date

  • After that, we will click on Run SQL from file at the top

run sql command

  • On the next page, we will check From Uploaded File, we will click on the paperclip icon, we will upload the file, and we will click on Execute.

executare comanda sql

  • If the upload was successful, we will be greeted by a message similar to the one in the image below.

mesaj succes, baza date

  • If there are errors in the SQL commands from the uploaded file, they will be displayed on the screen.