This tutorial will cover how a user can manage MySQL databases.
It assumes you have first logged into Virtualmin.
Click Edit Databases. You should now see a list of your current databases on the Edit Databases page.
Select the MySQL database you want to back up from the left-hand column under Database name and click Manage...
Click Execute SQL. You should now see the Execute SQL page and than click on TAB Run SQL from file.
Near the bottom of the page either enter a location on your account where you want the data base to be restored from for From local file (clicking … will allow you to browse and select the file) or select From uploaded file and click Choose File to select a file from your local machine.
For File format, leave it as Tab separated
Now, click Execute. You should now see the Import Data page confirming a successful restoration and your MySQL database.
--------------------------------------------
Ovaj tutorial pokazuje kako korisnik može upravljati MySQL bazama podataka.
Prijavite se na Virtualmin Panel.
Kliknite Edit Databases. Trebali bi vidjeti popis svojih trenutnih baza podataka na stranici Edit Databases page.
Odaberite MySQL bazu podataka kojom želite upravljati, kliknite checkbox ispred, a zatim kliknite Manage ...
Kliknite Execute SQL. Trebali bi vidjeti Execute SQL stranicu, a zatim kliknite na TAB Run SQL from file.
Izaberite opciju From local file (klikom na "..." će vam se omogućiti da pregledate i odaberite lokalnu datoteku), ili odaberite From uploaded file i kliknite Choose File da odaberite datoteku sa vašeg računara.
Kliknite Execute.
Trebali bi vidjeti stranicu Import Data za uspješno vraćanje-restore baze kao i vašu MySQL baze podataka.
Bosanski
Engleski