Skip to main content

admin

phpMyAdmin database export "Save as file" template

Whenever you do a database backup using phpMyAdmin, you are presented with a default file name structure for saves, usually like so:

__DB__

which basically gives you the name of the database you just backed up. Which is ok, however, most people would also like the date and time stamp included as well...

So...

This is how it's done... replace the above with :

__DB__-%F-%T

__DB__ = name of database Example: my_database
%F = Same as "%Y-%m-%d" (year-month-day) Example: 2009-11-25
%T = time stamp . (24 hour format, hour_minute_second) Example: 11_07_31

which will save a file with the naming structure similar to:

my_database-2009-11-25-11_07_31.sql

You can easily use other date/time structure, to suit your personal preference.

chmod directories only

To chmod only directories within the directory you're in...

find ./ -type d -exec chmod 755 {} \;

To chmod only files within the directory you're in...

find . -type f -exec chmod 644 {} \;

Linux server: Set date and time

Set your correct timezone:

# timeconfig

* You may need to install timeconfig 'yum install tzdata'

select your timezone.. select "system clock uses UTC"

chattr (in /usr/sbin)

If something refuses to run, try:

chattr -R -suSiadAc /usr/sbin

Example: if dovecot doesn't run or install/upgrade, try doing...

whoami
lsattr /usr/sbin/dovecot