Howto: Full DirectAdmin backup

nobaloney

NoBaloney Internet Svcs - In Memoriam †
Joined
Jun 16, 2003
Messages
26,119
Location
California
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
 

ProWebUK

Verified User
Joined
Jun 9, 2003
Messages
2,326
Location
UK
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
 

nobaloney

NoBaloney Internet Svcs - In Memoriam †
Joined
Jun 16, 2003
Messages
26,119
Location
California
Thanks, Chris, but what I'm thinking is, then where does PHPmyAdmin get it's password from?

Thanks.

Jeff
 

ProWebUK

Verified User
Joined
Jun 9, 2003
Messages
2,326
Location
UK
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
 

sander815

Verified User
Joined
Jul 29, 2003
Messages
474
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
 

Mathieu

Verified User
Joined
Sep 23, 2004
Messages
15
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
 

nobaloney

NoBaloney Internet Svcs - In Memoriam †
Joined
Jun 16, 2003
Messages
26,119
Location
California
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
 

jaapvstr

Verified User
Joined
Sep 15, 2006
Messages
51
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.
 

nobaloney

NoBaloney Internet Svcs - In Memoriam †
Joined
Jun 16, 2003
Messages
26,119
Location
California
I believe that by default tar preserves permissions; I don't believe I've never seen otherwise.

Jeff
 

jaapvstr

Verified User
Joined
Sep 15, 2006
Messages
51
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:

roarkh

Verified User
Joined
Aug 30, 2005
Messages
141
Location
Bellingham, WA
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?
 

DavidJacobs

New member
Joined
Jan 27, 2007
Messages
3
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
 

nobaloney

NoBaloney Internet Svcs - In Memoriam †
Joined
Jun 16, 2003
Messages
26,119
Location
California
Yes, that's been in my list for some time. Thanks for updating the thread.

Jeff
 
Top