pwrusr.com

  • Home
  • Download
  • About
  • Contact

[amatesi@pwrusr.com:~]$->  sudo su

Andrea Matesi

My name is Andrea and I'm a flexible ICT specialist. I use this blog to catalog and organize my various activities, helping me not to forget. English is my favourite language, although everyone is welcome.

View Andrea Matesi's profile on LinkedIn

Support my blog <3

Tweets by @amatesi

feel free to middle-click any of these…

tricks under my sleeve.

ActiveFTP+NAT+iptables add-raid1md2running at 12.45 halt +ctrl+shft+d burnISO-RClick=isorecorder.alexfeinman.com CentOS-Upg debian usb boot dec2bin grub-splashimages h-v-fast-diff-vm-deployment hw-loop-adapter ie:jscript=actve-scrptng ifcfg-eth0=1:etc-syscfg-nw-scripts-ifcfg-eth0 ifcfg-eth0=2:ln etc-syscfg-nw-scripts-ifcfg-eth0 etc-syscfg-nwking-devs ifcfg-eth0=3:ln etc-syscfg-nw-scripts-ifcfg-eth0 etc-syscfg-nwking-profiles-default ipconfig /flushdns Joomla joomla-flsh-intro LANdebian mirror lvm-scan:vgscan | vgchange -a y m6600 ncq ich9 ahci xp nocti120 ntfsclone1:dmpPartTable=sfdisk -d /dev/sdb > /bck/partition-table.dmp nwn2+wine nwn2-motb-wine ospf-easy-topo phpmyadmin-adminer pwdless-putty pwdless-ssh pwdless-sshd+freenx rbt-2210 ubuntu rndc flush rsync -aHvzh --progress SRC DST scancodemap-disblPgUpPgDn ssh-keygen -b 4096 svchost.exe-groups:tasklist /svc svchost.exe-reg:HKLM-SW-MS-WinNT-CurVer-Svchost synology-block-lvl-synch sys-restore-Win2k8r2 ubu-upg sudo do-release-upgrade win-pwd-reset WinDevMgrErrCode31 xhtml xp-clone2nwhdd+sysprep+new-mb xp-ide2sata-clone+hack

Andrea on Google+

Creative Commons License
This work by Andrea Matesi is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.

The 200k that challenged phpMyAdmin.

May 29th, 2011 by Andrea Matesi 21 Views

mySQL cli is a fast and nice tool to manage your DBs. I suppose we'll never get rid of it because of it's extreme usefulness.

I bet you already know what it means to "slip your hands in the jam" (just an italianism, not to be taken too seriously), and end up searching for that darn query command, re-learn its syntax, copy-paste and repeat until you found that combination that simply works™…

Hopefully, some clever devs came to our help and invented GUIs (well, sort-of), like phpMyAdmin, (and plenty others too!).

These tools allow poor sysadmins, pwrusrs and the like, for an easier DB administration and a frustration-free INSERT query.

Today, through programmazione.it newsletter, I discovered this two-years old new kid in town: Adminer.

Basically, it's just a 200k, single-file phpMyAdmin alternative. You simply upload it to your "DB-powered-website", toggle some switches and you're good to mess-up your DB!

If you're using Joomla!, WordPress or Drupal, you can have it as an installable plugin too (here: J!, WP or D).

The author of this tool is this European czech guy called Jakub Vrána, who does seem to be knowing what he's up to.

Posted in LINUX, System Administration | No Comments »

Typography++ by Andrea Matesi design by Six Shooter Media Sponsored by Web Hosting Provider