MySQL: Run in batch mode
The following code can be written in windows batch file (.bat): cd "D:\EasyPHP-5.3.3.1\mysql\bin>"D:\EasyPHP-5.3.3.1\mysql\bin>mysql -u root -p < c:\run_this_file.sql
HTML: Timezones select list
The following is a simple format of all world timezones: <option value="-12">International Date Line (west) 04:08</option><option value="-11">Samoa 05:08</option><option value="-10">Hawaii 06:08</option><option value="-9">Alaska 07:08</option><option value="-8">Los Angeles 08:08</option><option value="-7">Denver 09:08</option><option value="-6">Chicago 10:08</option><option value="-5">New…
Linux: Backup Shell Script for Joomla
The following is an example of backup Joomla website filesystem and database, keeping always the newest backups, using shell script: #!/bin/bash#this script is in: /home/html/myScripts/scripts#backup is in: /home/admin/backupsysdate=`date '+%Y%m%d'`echo "This…
MS-DOS: BackUp Script Example
DOS backup example: Put the files in a new directory and cleanup the 11th oldest Using EnableDelayedExpansion the variables are preserved @echo offsetLocal EnableDelayedExpansionSET DESTINATION_DIR="D:\TEST_DESTINATION"SET SOURCE_DIR="C:\TEST_SOURCE"REM MAKE A NEW DIRECTORY…
Oracle DB: Data Types
Oracle Built-In Data Types: Datatype Description VARCHAR2(size [BYTE | CHAR]) Variable-length character string having maximum length size bytes or characters. Maximum size is 4000 bytes or characters, and minimum is…
css-example
<style type="text/css"> .tableCell, .simpleTableCell, .simpleTableDarkCell, .subTable, .rowHeaderCell, .rowHeaderDarkCell, .columnHeaderCell, .columnHeaderDarkCell, .subRowHeaderCell, .subRowHeaderDarkCell, .subRowTotalCell, .subRowTotalDarkCell, .subRowCell, .subRowDarkCell { border:2px solid rgb(60,60,60); text-align:center; font-size:12px; font-family:Arial; padding:0px; margin:0px; border-collapse:collapse; } .simpleTableCell,.simpleTableDarkCell{ border:1px…
Joomla: Sections VS Categories
A Section contains one or more categories, and each Category can have articles assigned to it. One Article can only be in one Category and Section. For example, you might…
Joomla: Special VS Registered items
The difference between Special and Registered items in Joomla is that any user created as Author Editor Publisher Manager Administrator Super Administrator is considered a Special User, therefore can view…
HTML: Color Codes
aliceblue F0F8FF aliceblue aliceblue aliceblue aliceblue antiquewhite FAEBD7 antiquewhite antiquewhite antiquewhite antiquewhite aqua 00FFFF aqua aqua aqua aqua aquamarine 7FFFD4 aquamarine aquamarine aquamarine aquamarine azure F0FFFF azure azure azure azure…
MySQL: BackUp – Restore DB (mysqldump)
mysql> show databases; MySQL Export:-------------mysqldump -u root -p --databases myschema > /var/www/html/myschema/backup_db/MySchema_20101228.sqlMySQL Import:-------------mysql -u root -p --database myschema < /home/nista/myschema_temp/MySchema_20101228_1458.sqlMySQL Export just the schema:------------------------------mysqldump -u root -p --no-data myschema >…