Howto: Full DirectAdmin backup

I found a password n usr/local/directadmin/scripts/setup.txt .

It works for dumping any mysql database on the system, so I guess I'm okay in presuming it's the master password :) .

You wrote:
Unless you have changed that password, which you should, that would be your mysql root password.
So my question now is:

If I change the mysql root password, do I have to put the new master password anywhere so DA can use it?

(I know where to put it so sysbk can put it.)

Thanks.

Jeff
 
No, setup.txt is for the first installation only, and im 99% certain the password is only there for you to know, nothing else :)

Chris
 
Thanks, Chris, but what I'm thinking is, then where does PHPmyAdmin get it's password from?

Thanks.

Jeff
 
jlasman said:
Thanks, Chris, but what I'm thinking is, then where does PHPmyAdmin get it's password from?

As a user logs into phpmyadmin, it uses mysql itself to check the passwords / login combinations... and grab the data.... pma doesnt require any password/username files unless you specify to use it like that ;)

Chris
 
can i exclude certains dirs in /home that sysbk doesn't backup

f.i. /home/admin/user_backups is useless, cause they already tarred, and take large amounts of extra diskspace


and why do i get these errors in mysql stage 2 backup?
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: MyISAM file /var/lib/mysql/nurburg_forum/phpbb_posts.MYI
m
 
With Freebsd:

Performing sanity checks: -en \033[62G
[ -en \033[1;31m
$FAILED-en \033[0;39m
]
/bin/gunzip not found, aborting...
Performing cleanup operations: [: 1: unexpected operator
-en \033[62G
[ -en \033[1;32m
$COMPLETED-en \033[0;39m
]



Can anyone fix this for me plz????
Thanks
 
Thanks for bringing this to my attention; I've added an edit at the top of the thread to indicate that sysbk is now included with DirectAdmin.

Jeff
 
ProWebUK said:
It may sound difficult, however it's actually very easy..... move all of the tar.gz backups to your root directory (/root/) then simply unpack them - tar -zxvf *.tar.gz

Shouldn't you unpack using tar -zxpvf *.tar.gz to perserve permissions? i think things will be pretty messed up without the -p switch.
 
I believe that by default tar preserves permissions; I don't believe I've never seen otherwise.

Jeff
 
Odd that it's actually listed as a seperate switch then in the man pages o_O

p Restore the named files to their original modes, and
ACLs if applicable, ignoring the present umask(1).
This is the default behavior if invoked as super-user
with the x function letter specified. If super-user,
SETUID and sticky information are also extracted, and
files are restored with their original owners and per-
missions, rather than owned by root. When this func-
tion modifier is used with the c function, ACLs are
created in the tarfile along with other information.
Errors will occur when a tarfile with ACLs is
extracted by previous versions of tar.

Ah, yep, default if you run it as su
 
Last edited:
I was just looking through the file list in the first post of this thread and noticed that one of the files in the list is...

Code:
/etc/exim.crt

At least on my installation I do not see that file but I do see this file...

Code:
/etc/exim.cert

Is there possibly a typo in the file list?
 
mysql root password

Hmmm, this thread might be out of date, but Jeff; you don't mention if you found the place where the root PW for MySQL is stored, if you're still wondering; I believe it is in /usr/local/directadmin/conf/mysql.conf

gr david
 
Yes, that's been in my list for some time. Thanks for updating the thread.

Jeff
 
Back
Top