andunix.net
https://old.andunix.net/
2026-06-04T02:49:11+00:00andunix.net
https://old.andunix.net/
https://old.andunix.net/_media/favicon.icotext/html2013-02-04T22:18:02+00:00Anonymous (anonymous@undisclosed.example.com)Travian Map Download Script
https://old.andunix.net/z/travian/travian_map_download_script
Travian Map Download Script
This is my script(s) which I use to downoad the map.sql from Travian and import it to the database.
config.inc
#
# database
DB_USER="travian" # set this to your database user
DB_PASS="travian" # set this to your database password
DB_INST="travian" # set this to your database instance
#
# directories
MAP_DIR=${HOME}/opt/travian
DUMP_DIR=/srv/glassfish/domains/domain1/docroot/sql
#
# executables
MYSQL="/srv/mysql/bin/mysql --default-character-set=utf8 -u${DB_USER} -…text/html2013-04-24T12:11:00+00:00Anonymous (anonymous@undisclosed.example.com)Android Backup
https://old.andunix.net/info/android/backup
Android Backup
To backup your device, use this command. It will automatically insert the current date in the filename:
adb backup -apk -shared -all -f $(date '+%Y-%m-%d').db
If you are havong problems with the connection (“adb: unable to connect for backuptext/html2013-02-04T22:17:25+00:00Anonymous (anonymous@undisclosed.example.com)MySQL: Backup
https://old.andunix.net/info/mysql/database/backup
MySQL: Backup
Export a Database
# set or replace the variables $USER, $PASS and $DB
mysqldump --add-drop-table -u${USER} -p${PASS} ${DB}
Export all Databases individually
# set or replace the variables $USER and $PASS
DATE_YMD=$(date "+%Y-%m-%d")
DATABASES=$(mysql --batch -u${USER} -p${PASS} mysql --execute='show databases')
for db in ${DATABASES}
do
mysqldump --add-drop-table -u${USER} -p${PASS} ${DB} > ${DB}_${DATE_YMD}.sql &
bzip2 ${DB}_${DATE_YMD}.sql &
# sleep 10 # option…text/html2013-03-01T20:36:05+00:00Anonymous (anonymous@undisclosed.example.com)Oracle: SPFile and PFiles
https://old.andunix.net/info/oracle/spfile_and_pfiles
Oracle: SPFile and PFiles
Oracle reads its parameters from a file called “SPFile”.
You can't change it directly as it's a binary file.
Additionally, Oracle can read the parameters from “PFiles”, which are regular text files.
Create PFile
To export the SPFiles to a PFile, just enter the following in SQLplus:text/html2016-01-25T11:49:04+00:00Anonymous (anonymous@undisclosed.example.com)MySQL: Create User
https://old.andunix.net/info/mysql/user/create
MySQL: Create User
Create User
CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}';
Create User and Database
* Usually, {user} == {db}
CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}';
GRANT USAGE ON * . *
TO '{user}'@'%'
IDENTIFIED BY '{passwd}'
WITH
MAX_QUERIES_PER_HOUR 0
MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0
MAX_USER_CONNECTIONS 0 ;
CREATE DATABASE IF NOT EXISTS `{db}`;
GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%';text/html2013-02-04T22:17:25+00:00Anonymous (anonymous@undisclosed.example.com)MySQL: Create Database
https://old.andunix.net/info/mysql/database/create
MySQL: Create Database
Create Database
CREATE DATABASE IF NOT EXISTS `{db}`;
Create Database and Grant Rights to a User
CREATE DATABASE IF NOT EXISTS `{db}`;
GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%';
admin database mysql sqltext/html2013-02-04T22:17:27+00:00Anonymous (anonymous@undisclosed.example.com)MySQL: Remove User
https://old.andunix.net/info/mysql/user/remove
MySQL: Remove User
Remove User
DROP USER '{user}'@'%';
Remove User and Database
* Usually, {user} == {db}
DROP USER '{user}'@'%';
DROP DATABASE '{db}';
admin database mysql sqltext/html2013-02-04T22:17:26+00:00Anonymous (anonymous@undisclosed.example.com)MySQL: Revoke Permissions
https://old.andunix.net/info/mysql/permissions/revoke
MySQL: Revoke Permissions
Revoke Permissions
REVOKE ALL PRIVILEGES ON `{db}` . * FROM '{user}'@'%';
admin database mysql sqltext/html2013-02-04T22:17:26+00:00Anonymous (anonymous@undisclosed.example.com)MySQL: Grant Permissions
https://old.andunix.net/info/mysql/permissions/grant
MySQL: Grant Permissions
Grant Permissions
GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%';
admin database mysql sqltext/html2013-02-04T22:17:25+00:00Anonymous (anonymous@undisclosed.example.com)MySQL: Remove Database
https://old.andunix.net/info/mysql/database/remove
MySQL: Remove Database
Remove Database
DROP DATABASE IF EXISTS `{db}`;
admin database mysql sqltext/html2020-09-15T19:10:57+00:00Anonymous (anonymous@undisclosed.example.com)Formatting Syntax
https://old.andunix.net/wiki/syntax
Formatting Syntax
DokuWiki supports some simple markup language, which tries to make the datafiles to be as readable as possible. This page contains all possible syntax you may use when editing the pages. Simply have a look at the source of this page by pressingtext/html2013-02-04T22:17:37+00:00Anonymous (anonymous@undisclosed.example.com)fstyp
https://old.andunix.net/info/solaris/fstyp
fstyp
fstyp reports the type of file system.
With the -v (verbose) option reports even more informations.
* man page: fstyp(1M)
Example
UFS: ''fstyp''
fstyp /dev/rdsk/c1t0d0s0
ufs
UFS: ''fstyp -v''
fstyp -v /dev/rdsk/c1t0d0s0
ufs
magic 11954 format dynamic time Wed Dec 23 17:26:29 2009
sblkno 16 cblkno 24 iblkno 32 dblkno 760
sbsize 2048 cgsize 8192 cgoffset 64 cgmask 0xffffffc0
ncg 427 size 20972160 blocks 20654449
bsize 819…