https://old.andunix.net/ 2026-06-03T19:26:53+00:00 https://old.andunix.net/ https://old.andunix.net/_media/favicon.ico text/html 2013-02-04T22:18:02+00:00 Anonymous (anonymous@undisclosed.example.com) 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/html 2016-01-25T11:49:04+00:00 Anonymous (anonymous@undisclosed.example.com) 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/html 2013-03-01T20:36:05+00:00 Anonymous (anonymous@undisclosed.example.com) 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/html 2013-03-01T20:26:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/accounts_with_objects Oracle: List Accounts with Objects To list all accounts (users) the objects (like tables), you can query them with: SELECT DISTINCT OWNER FROM DBA_OBJECTS ORDER BY OWNER; If you want to list all accounts, you can query them with: SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME; text/html 2013-02-04T22:17:27+00:00 Anonymous (anonymous@undisclosed.example.com) 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 sql text/html 2013-02-04T22:17:25+00:00 Anonymous (anonymous@undisclosed.example.com) 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 sql text/html 2013-12-17T09:09:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/user/password MySQL: Change Password * Replace {passwd} with the password of the user. * Replace {user} with the name of the user. GRANT USAGE ON *.* TO '{user}'@'%' IDENTIFIED BY '{passwd}'; FLUSH PRIVILEGES; Or you can alternatively use the following: UPDATE mysql.user SET Password=PASSWORD('{passwd}') WHERE User='{user}'; FLUSH PRIVILEGES; text/html 2014-01-27T14:49:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/tag/sql sql Pages Bookmarks text/html 2013-03-01T20:38:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/resize_instance Oracle: Resize Instance In this example, the SGA will be resized to 6GB and the PGA to 2GB. First, change the SPFile: ALTER SYSTEM SET pga_aggregate_target = 2G SCOPE=SPFILE; ALTER SYSTEM SET sga_target = 6G SCOPE=SPFILE; Then, (optionally) export the SPFile to a PFile: text/html 2013-02-04T22:17:25+00:00 Anonymous (anonymous@undisclosed.example.com) 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/html 2013-02-04T22:17:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/permissions/view MySQL: View Permissions View Permissions SHOW PRIVILEGES; SHOW GRANTS FOR '{user}'@'%'; admin database mysql sql text/html 2013-02-04T22:17:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/database/remove MySQL: Remove Database Remove Database DROP DATABASE IF EXISTS `{db}`; admin database mysql sql text/html 2013-02-04T22:17:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/permissions/grant MySQL: Grant Permissions Grant Permissions GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; admin database mysql sql text/html 2013-02-04T22:17:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/permissions/revoke MySQL: Revoke Permissions Revoke Permissions REVOKE ALL PRIVILEGES ON `{db}` . * FROM '{user}'@'%'; admin database mysql sql text/html 2013-03-01T20:24:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/rman Oracle: Recovery Manager Start Recovery Manager rman target / Delete Archive Logs Delete all archive logs but keep the last 45 days: DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; To remove archive logs older than 3 days without prompting, e.g. via cron, after backup run: text/html 2013-03-01T20:30:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/sqlplus_scripting Oracle: SQLplus Scripting To show only data in SQLplus and no header or other stuff, enter the following: SET NEWPAGE 0 SET SPACE 0 SET LINESIZE 80 SET PAGESIZE 0 SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SET MARKUP HTML OFF SPOOL OFF text/html 2020-09-15T19:10:57+00:00 Anonymous (anonymous@undisclosed.example.com) 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 pressing