export mySQL to CSV

Posted by ray | Posted in mySQL | Posted on March 22nd 2009

0

All you need is to do the following:

SELECT a,b,a+b INTO OUTFILE ‘/tmp/result.text’
FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘
LINES TERMINATED BY ‘\n’
FROM test_table;

And the results are sent to /tmp/result.text in CSV format.

Share and Enjoy:
  • Print this article!
  • E-mail this story to a friend!
  • Facebook
  • Twitter
  • Digg
  • del.icio.us
  • Google Bookmarks
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati

remove windowsXP from Vista boot menu

Posted by ray | Posted in Uncategorized | Posted on March 22nd 2009

0

Open System properties and click on “Advanced System Settings”.
Click on “Settings” button in “Startup and recovery” section and disable
“Time to display list of operating systems ” checkbox.
Make sure Windows Vista is selected in “Default Operating System” drop down box.
Apply it.

or

Edit the Windows Vista Boot Menu Options – BCDEDIT
Click start>All Programs>Accessories>Right Click on Command Prompt and select Run As Administrator
Then type BCDedit.exe
bcdedit /timeout 15 Changes the default 30 second time-out of the boot menu to
15 seconds or any other value inserted.
Msconfig – System Configuration Utility
The System Configuration Utility (msconfig) is accessible from the Windows
Vista start menu, Start>All Programs>Accessories>System Tools>System
Configuration. It has limited funcionality as regards the BCD store however,
with the only relevant functionalities being to change the default boot
operating system, to delete a boot menu item and to change the timeout display
period of the boot menu.

Share and Enjoy:
  • Print this article!
  • E-mail this story to a friend!
  • Facebook
  • Twitter
  • Digg
  • del.icio.us
  • Google Bookmarks
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati

Timezone dropdown list

Posted by ray | Posted in php | Posted on March 22nd 2009

0

builds a nice dropdown select list.

/*
$all = DateTimeZone::listAbbreviations();

$timeZones = DateTimeZone::listIdentifiers();
echo ‘

‘;
*/

Share and Enjoy:
  • Print this article!
  • E-mail this story to a friend!
  • Facebook
  • Twitter
  • Digg
  • del.icio.us
  • Google Bookmarks
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati

Breadcrumbs in CMS pages

Posted by ray | Posted in Magento | Posted on March 22nd 2009

0

There is an option in the admin panel under configuration/general/web,
click default pages, then there is an option for Show Breadcrumbs on CMS pages.
You can turn off breadcrumbs for CMS here.

Share and Enjoy:
  • Print this article!
  • E-mail this story to a friend!
  • Facebook
  • Twitter
  • Digg
  • del.icio.us
  • Google Bookmarks
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati

Magento – admin login problem on localhost

Posted by ray | Posted in Magento | Posted on March 10th 2009

0

cookie

via Magento – 1.2.1 admin login problem in local installation – Magento 1.2.0 Upgrade Issues – eCommerce Software for Growth.

Share and Enjoy:
  • Print this article!
  • E-mail this story to a friend!
  • Facebook
  • Twitter
  • Digg
  • del.icio.us
  • Google Bookmarks
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati

How To Setup Multiple Magento Stores

Posted by ray | Posted in Uncategorized | Posted on March 10th 2009

0

Crucial Web Hosting » Blog » How To Setup Multiple Magento Stores.

Share and Enjoy:
  • Print this article!
  • E-mail this story to a friend!
  • Facebook
  • Twitter
  • Digg
  • del.icio.us
  • Google Bookmarks
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati

remove xp from system boot on Vista

Posted by ray | Posted in Uncategorized | Posted on March 6th 2009

0

2. Open System properties and click on “Advanced System Settings”. Click on “Settings” button in “Startup and recovery” section and disable “Time to display list of operating systems
” checkbox. Make sure Windows Vista is selected in “Default Operating System” drop down box. Apply it.

Edit the Windows Vista Boot Menu Options – BCDEDIT

Click start>All Programs>Accessories>Right Click on Command Prompt and select Run As Administrator

Then type BCDedit.exe

bcdedit /timeout 15 Changes the default 30 second time-out of the boot menu to

15 seconds or any other value inserted.

Msconfig – System Configuration Utility

The System Configuration Utility (msconfig) is accessible from the Windows

Vista start menu, Start>All Programs>Accessories>System Tools>System

Configuration. It has limited funcionality as regards the BCD store however,

with the only relevant functionalities being to change the default boot

operating system, to delete a boot menu item and to change the timeout display

period of the boot menu.

Share and Enjoy:
  • Print this article!
  • E-mail this story to a friend!
  • Facebook
  • Twitter
  • Digg
  • del.icio.us
  • Google Bookmarks
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati