Cant download my database

5 posts / 0 new
Topic locked
Last post
#1 Thu, 09/29/2016 - 17:50
autopri

Cant download my database

Hi,

I am trying to download my database from my virtualmin to upload it to a new hosting. I have already make a virtualserver backup of all my files, but i cant seem to find the etc_etc.msql file in there.

when i go to the database backup section it show me the database, but when i try to make a backup i have this error.

Database backup failed : mysqldump failed : cannot create /usr/home/flyspeck/: Is a directory

Thu, 09/29/2016 - 21:24
applejack

If you have SSH access you can dump the database using

mysqldump -uUSER -pPASSWORD -hlocalhost --add-drop-table DATABASE_NAME > FILE.sql

Thu, 09/29/2016 - 21:55
Freddy63
Freddy63's picture

Are you using Virtualmin as root user? If you have root access, this is how you download a MySQL dump file with Virtualmin. If you don't have root access, see if phpMyAdmin is available to you.

I provide FREE Server Management Services in exchange of money

Fri, 09/30/2016 - 16:27
cruiskeen

if you've downloaded a normal Virtualmin backup, you're probably not seeing the database because it's in a hidden UNIX directory called .backup .

Mon, 10/03/2016 - 20:39 (Reply to #4)
autopri

these are the files that are on the .backup

none of them are the .mslq

none

Topic locked