You are not logged in [login] | [register]
RSS MAD is both an RSS feed archive and online feed reader.
You can browse our categories, search for a feed, or if you already have a URL, use our online feed reader.
Simply start browsing the site, and if you find some feeds you like, register to view them on your own personalized page!
you are here: home » computers & internet » software
Searching 180777 articles in 8938 feeds.
Do you like RSS MAD? Why not spread the news and tell a friend about it - it's as easy as filling out this form!
added: Sun, 16th October 2005 | 327 views | 0x in favourites
feed url: http://oksoft.antville.org/rss
Learn more about HTML, MsOffice [Viewed: 147]
mysql -e"SELECT CONCAT('OPTIMIZE TABLES ', GROUP_CONCAT(TABLE_SCHEMA, '.', TABLE_NAME ORDER BY TABLE_SCHEMA, TABLE_NAME SEPARATOR ',')) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'dbname' GROUP BY TABLE_SCHEMA\G
" | awk -F: '{print $2}' | mysql
Cheat sheet act as a reference tool which provides cut and paste kind of commands to complete a specific task. I often recommend following set of best cheat sheets to students and IT professionals. It include Linux / UNIX command and shell scripting.
Read more: Top 10 Best Cheat Sheets and Tutorials for Linux / UNIX Commands
scp is the standard command to copy a folder or files. You can also compress the files before sending it as shown below. In this test I am using a folder with 4 files of 3.5 MB size. The time is reduced to 5 seconds from 40 seconds.
# time scp /root/shantanu/* root@172.29.0.131:/root/
root@172.29.0.131's password:
iostat0111.log 100% 46KB 46.3KB/s 00:00
mystats.txt 100% 201KB 201.5KB/s 00:00
top0111.log 100% 3219KB 100.6KB/s 00:32
vmstat0111.log 100% 21KB 20.7KB/s 00:00
real 0m39.844s
user 0m0.053s
sys 0m0.021s
# time tar zcf - shantanu | ssh 172.29.0.131 "cd /root/shantanu/; tar zpxvf -"
root@172.29.0.131's password:
shantanu/
shantanu/top0111.log
shantanu/mystats.txt
shantanu/vmstat0111.log
shantanu/iostat0111.log
real 0m5.326s
user 0m0.068s
sys 0m0.015s
If you type the full path to the folder /root/shantanu/ then a new folder in the destination folder will be created with the same path.
If you use two bash sessions at the same time, which ever you close second will write over the commands you’ve typed in the first one. That means that your history is lost for one of the sessions. Annoying to say the least. Luckily there is a way to fix this.
Open your .bashrc file as detailed above and add the lines:
shopt -s histappend
PROMPT_COMMAND='history -a'
This will append any new history to the existing file rather than rewriting it, as well as adding to the history every time the prompt is shown. Now, all your history will be saved!
www.bradshawenterprises.com
To get started with the JDBC Driver for MySQL (Connector/J), download it from MySQL's Web site, unpack the downloaded file, and move the resulting mysql-connector-java-x.x.x-bin.jar file into the desired location (e.g. your home directory). In OpenOffice.org, choose Tools -> Options -> Java. Make sure that the appropriate Java Runtime Environment is selected and click the Class Path button. Next, click the Add Archive button and select mysql-connector-java-x.x.x-bin.jar. Click OK to save the settings and close the window, then restart OpenOffice.org.
www.mysql.com
Login to the colleagues machine as a root user and type...
# screen -S foo
Ask him to use -x parameter like...
# screen -x foo
Now both of you are using the same window and see / learn each others' commands.
CHECK TABLE performs an integrity check on the structure and content of your tables. For MyISAM tables, it will also update the index statistics. If problems appear, proceed to ...
REPAIR TABLE is for MyISAM tables only and will correct corrupted tables. InnoDB tables should be dumped with mysqldump and restored.
ANALYZE TABLE updates a table's information about keys for queries so that the data can be found faster and not having to hunt for it. This works for both MyISAM and InnoDB.
OPTIMIZE TABLE defragments MyISAM tables, sorts indexes, and updates the statistics to speed up searches.
If you are using Linux on your servers and you ssh to the server and then run the mysql client to access the server you can use a .my.cnf file to speed up access.
[client]
user =username
password =x&r%@ldc
host = localhost
Now you can just type ‘mysql’ and it connects you up automatically.
Often the command you need is in your history, how do you find it? One simple method is to run the history command and pipe it through grep.
$ history | grep cat
110 cat /tmp/foo
You can then run the command by typing ! and the history line number:
$ !110
cat /tmp/foo
The inputrc file handles keyboard mapping for specific situations. This file is the startup file used by Readline — the input-related library — used by Bash and most other shells. suppose you want to run a command witha specific keystroke eg : ctl+e to give the out put ls -la
you will need to append the following to the /etc/inputrc file
Control-e: "ls -la\n"
save the file
bind -f /etc/inputrc
--> to the the changes may be relflected
now try to do a control +e and theout put on the screen will be a ls -la
Here are the useful extensions for students.
Indic Input Extension 1.0
addons.mozilla.org
Girgit
addons.mozilla.org
Clustybar
addons.mozilla.org
clickspeak.clcworld.net
CLiCk, Speak provides point-and-click screen reading, which can be helpful for partially-sighted users or sighted users who have written language difficulties (such as dyslexia).
SQLite Manager
addons.mozilla.org
Quicknote
addons.mozilla.org
Nuke Anything enhanced
addons.mozilla.org
Chatzilla
addons.mozilla.org
fireftp
addons.mozilla.org
Web developer toolbar firefox
addons.mozilla.org
1) Edit - Changes - Record
This option helps you to track changes being made to your spreadsheet.
2) Edit - Compare Document
Compare different versions of the same document.
3) File - Versions
Create versions.
4) Calc and Excel use different default number formats. With Excel, the cells are set to the “General” category number format., so if you entered 25.12345 in a cell it would display “25.12345”. In Calc a default formatted cell is set to the “Number” category in the “General” format. Thus, if 25.12345 is entered, 25.12 will be displayed.
Ctrl + F8 - Highlights cells containing numeric values and formulas (not text)
F11 Opens the Styles and Formatting window
Shift+F11 Creates a document template
Shift+Ctrl+F11 Updates the templates
Alt+Down Arrow Increases the height of current row
Alt+Up Arrow Decreases the height of current row
Alt+Right Arrow Increases the width of the current column
Alt+Left Arrow Decreases the width of the current column
Alt+Shift+Arrow Key Optimizes the column width or row height based on the current cell
Alt+Enter (Alt+Shift+Enter also applies the cell format) Enter into all currently selected cells
1) Localized Software
2) Flexibility
3) Supports Old Hardware
4) Performance
5) Quality
6) Availability
7) Support
8) Cost
9) Security
Calc Tip: Format The Zip Code Column For Five Digits Zip Codes
1. Right-click on the top of the Zip Code column. (A menu appears).
2. Click Format Cells (The 'Format Cells" window appears)
3. Click the Numbers tab.
4. Under Category, select Number.
5. Under Format, select General.
6. In the Leading zeros box, increase the number 1 to a 5.
7. Click OK. (A zero appears at the beginning of the "01111" zip code).
In Word, go to Tools, then Options. Under the File Locations tab, double-click AutoRecover files and make a note of that path location. Click Cancel and Close. Open up that folder in My Computer or Windows Explorer and search for any .ASD files.
To save filtering criteria, use Custom Views:
Step 1: Add the Custom Views icon to the toolbar
1. Place the mouse over one of the toolbars, right click, and select Customize from the shortcut menu.
2. Select the Commands tab.
3. From Categories, select View and drag the Custom Views icon to the Menu bar.
Step 2: Save the filtering criteria
1. Select a cell from the column containing the criteria you want to Filter with.
2. Click the AutoFilter icon
3. Type any text criteria you want into the Custom Views box and click twice to save.
4. Repeat the previous step and save as many filtering criteria as needed from any sheet within the workbook.
www.exceltip.com
I don't remember if I have mentioned this before, but if you want to return the Smallest Non-Zero Value, use array.
=MIN(IF(A1:A5=0,MAX(A1:A5),A1:A5))
(entered by pressing Ctrl+Shift+Enter)
You can make the formula even shorter by turning it around in this manner:
=MIN(IF(A1:A5<>0,A1:A5))
I have noticed an odd thing when it comes to creating CSV files with Excel: the files are not always consistent in how they end each row in the output data. When I create a CSV file that has, perhaps, 70 field (columns) of data and then views the CSV file in a text editor, I noticed that the records all contain carriage returns, but in different places. How do I get the CSV files to contain a consistent number of output fields.
This is actually a problem that has been known to Microsoft for quite some time. The Microsoft Knowledge Base includes an article on this topic as early as Excel 97:
support.microsoft.com
tinyurl.com
Excel include a feature that really annoys some people: Paste Options. When you paste some tidbit of information in your worksheet, Excel displays a small, floating "button" right near the end of the pasted information. Follow these steps to turn it off:
1. Choose Options from the Tools menu. Excel displays the Options dialog box.
2. Make sure the Edit tab is displayed.
3. Clear the Show Paste Options Buttons check box.
4. Click on OK.
A way to quickly search for free comic books online using Google if you are looking for title specific searches.
-inurl:htm -inurl:html intitle:"index of" "Last modified" spider-man cbr
to find simpsons...
-inurl:htm -inurl:html intitle:"index of" "Last modified" simpsons cbr
how to search for a line break (Alt+Enter) in a cell?
Press Ctrl+F to display the Find tab of the Find and Replace dialog box. In the Find What box, hold down the Alt key as you type 0010 on the numeric keypad.
tinyurl.com
You can create a multi-line header or footer in Excel. The trick is to remember that you cannot press Enter while typing your footer. Instead, to start a new line you should hold down the Alt key as you type 0010 on the numeric keypad. This inserts a line-break character in the footer text. The total length of a header or footer cannot exceed 255 characters.
you can jump to the last place that you edited in a document by pressing the Shift+F5 key. In other words, open the document, press the shortcut, and the insertion point jumps directly to the last edit point in the document.
» more
» more
Is RSS MAD missing something? Tell us about new feeds here.