var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
How to import database through webmin?
How do you import a database using webmin?
You can do it via ssh and command line by just dropping the files into the mysql directory you have created and then chown the files.
Or you can use Phpmyadmin to import the files a bit easier.
Yeap, if you have a phpmyadmin you could be able to export the database too.
Webmin -> Servers -> MySQL Server
Originally Posted by
If the database already exists and you want to overwrite it with the contents of a .sql file (a mysqldump), click to select the database in the list.
Otherwise, click to create a new database. After creation, click to select that database.
The click "Execute SQL" and then "Run SQL from File". Browse to find the .sql file and do it.
If you're using Virtualmin the process is similar, except you start in:
Virtualmin -> (Choose Virtual Server) -> Edit Databases.
When you do it in Virtualmin the domain account is automatically granted access to new databases when you create them.
Thanks sleddog! Very clear instruction. Without this I would have struggled forever, as "run sql command" doesn't convey to me "import db"...
From command line it would be easier to upload and import
You can use command mysql mysql_databasename < /path /of/dump.sql where dump.sql isthe sql file file which you uploaded
If you will be doing a lot of database work from a web interface, you might find it easier to install phpMyAdmin and forgo the webmin module for day to day use.
yes I am somewhat used to phpmyadmin too, but they haven't installed it as they charge £20 extra a MONTH for that and backup. I thought why bother if both can easily be done for free.
By worldbus in forum Hosting Security and Technology
Last Post: 12-13-2008, 03:51 PM
By Cool Surfer in forum Hosting Software and Control Panels
Last Post: 05-06-2007, 10:58 AM
By GoBengals in forum Employment / Job Offers
Last Post: 11-02-2006, 05:09 AM
By RealityHost in forum Other Offers & Requests
Last Post: 09-01-2005, 09:39 AM
By vietkool in forum Hosting Security and Technology
Last Post: 04-24-2005, 02:54 PM