MySQL table ‘IN USE’ fix

Salah satu table dari database kami muncul pesan “IN USE”, karena tidak sempat discreenshoot, kami ambil/copy kan dari google screen yang mana kasus nya hampir sama. Beberapa orang sempat menyarankan, copy file bla-bla dan bla-bla dari windows ke linux, pokoknya saya gak mudeng caranya (karena menyangkut window-window), jadi pengennya gak pakai saran windows-windowsan namun pakai cara lain yang lebih sederhana dan tidak melibatkan windows.

Contoh: table IN USE, gambar di copy dari http://www.hostingformula.net/wp-content/uploads/2009/02/table_in_use.jpg

Maka cara mengatasi masalah tersebut yang lebih sederhana adalah:

• Pilih tabel yang bermasalah, click centang tabel tersebut.

Centang tabel yang bermasalah

• Pilih Action “repair table”, dan execute dengan cara klik “Go” di bagian bawah.

Pilih repair table

• Abaikan warning, cek kembali tabel bersangkutan. Insya ALLAH kembali normal.

Walhamdulillah.

Import Project SVN [eclipse] dari Repository

Melanjutkan tulisan berjudul Subversive Eclipse, setelah subversive eclipse terinstall selanjutnya adalah melakukan import project svn dari repository svn server. Berikut langkah-langkahnya:

Import Project SVN dari Repository

• Buat Project baru di File > New > PHP Project.

Membuat project baru

• Pilih folder yang akan digunakan sebagai folder project.

Pilih folder

Pilh Folder

• Setelah project tercipta, klik kanan pada project, pilih Import.

Pilih project > import

Pilih SVN Project

• Pilih “Use existing repository location:”.

Pilih "Use existing repository location:"

• Pilih repository yang dikehendaki. Klik Next. Klik Finish.

Pilih "Use existing repository location:"

• Maka akan keluar window Check Out As, pilih “Check out as a folder into existing project”.

pilih "Check out as a folder into existing project"

• Klik Next, Pilih project yang dikehendaki untuk di import source dari SVN server/repository.

Pilih project yang dikehendaki untuk di import source dari SVN server/repository

• Klik Finish. Tunggu beberapa saat karena eclipse sedang men-check out source.

Tunggu beberapa saat karena eclipse sedang men-check out source

Hasilnya

Cara Lainnya:

1. Klik kanan di Tab Workspace. Pilih “Import…”, kemudian keluar window Import, pilih folder SVN > Project from SVN.
2. Klik Next, pilih “Use existing repository location:” dan pilih svn repository yang dikehendaki.
3. Klik Next, Pilih Head Revision, Klik Next.
4. Klik Finish.
5. Muncul window “Check Out As”.
6. Pilih “Check out as a project with the name specified:”, masukkan nama project yang digunakan untuk source dari svn repository ini. Klik Next.
7. Hilangkan centang “Use default workspace location”, kemudian pilih lokasi folder yang dikehendaki.
8. Klik Finish. Tunggu proses yang sedang berlangsung.

Selesai, walhamdulillah.

Alternatif AutoCad yaitu DraftSight

DraftSight now available: Free CAD software *

DraftSight generally takes just a few minutes to download, and supports Microsoft® Windows XP®, Windows Vista®, Windows® 7 (General Release), Mac® and Linux®** (Mac and Linux currently in Beta).
More than ONE MILLION people have downloaded DraftSight.  Download now!

DraftSight™ was built with CAD users in mind and includes:

User Environment & Features

• Cartesian coordinate system
• Command line input
• Traditional toolbars and menus
• Wheel-mouse pan & zoom
• Blocks & reference files
• Layers & layer manager
• Polygonal ViewPorts
• ViewPort locking
• Freeze, lock or turn off layers per ViewPort
• Background masks for notes
• Property manager
• View proxy objects
• Dynamic pan & zoom
• Command aliases
• Menu files
• CTB and STB print style tables
• SHX and TTF fonts
• LineStyle files
• Hatch pattern files
• Templates

Interoperability

• Read and write support for DWG/DXF files*
• Save DWG/DXF files back to previous versions*
• Create binary or ASCII DXF files*
• Attach image files (.bmp, .gif, .jpg, .jpeg, .png, .tif, & .tiff)
• Attach external reference drawings
• Export to file (.jpg, .pdf, .png, & svg.)
• Save as .wmf, .jpeg, .pdf, .png, .sld, .svg, .tif, & .stl file formats
• Multi-page PDF creation
• Publish to eDrawings or Drawings Now

Productivity Enhancers

• Consolidated options dialog
• Enhanced, easy to read, command prompts
• Home palette
• Smart calculator
• Quick print
• Context sensitive help

Setup and Administration

• Support for Windows®, Mac & Linux operating systems
• Multi-language character set support including Unicode fonts
• Customizable interface: command aliases, double-click actions, menus, right-click menus, shortcut keys, toolbars, etc.
• Quick and free to download
• Fast “one-click” installation

Entities

• Arcs, circles, & lines
• Notes & SimpleNotes
• Tables
• Blocks and BlockAttributes
• Ellipses & elliptical arcs
• RichLines, PolyLines, 3D PolyLines, & Splines
• Points & rings
• Hyperlinks
• ViewPorts
• Masks & region
• ISO, ANSI & Traditional Hatch patterns
• Solid & gradient Fill
• Dimensions: Arc length, radius, diameter, baseline, linear, ordinate, etc.
• Tolerances, Leaders & CenterMarks

Drafting Tools

• Snap & Grid
• Chamfer & Fillet
• Tracking guides & Polar guides
• Get area, distance, or coordinates information
• Double-click editing
• Undo/Redo
• EntityGrips, EntitySnaps, Entity
• InfiniteLines, Rays & Reference Points
• Select entities using filters, SmartSelect, or by window, crossing window, crossline, polygonal window, etc.

Drawing Setup Tools

• Customizable coordinate system
• RichLine styles
• Layer manager
• Table styles
• Points format
• Text Styles
• Unit system
• Multiple layout
• Dimension styles
• Named page layouts

Edit Tools

• Move, scale & rotate
• Stretch & change length
• Mirror, copy, offset and pattern copy
• Trim & extend
• Split & weld
• Edit blocks in-place or isolate for edit
• Open reference drawings from within the base drawing
• Clip references and images
• Modify Hatch and fill pattern, origin, etc
• Edit note properties: direction, justification, line spacing, text height, TextStyle, etc.

* Uses the Teigha™ Classic for .dwg files and Teigha for .dwg files specifications from the Open Design Alliance.

DraftSight and the DraftSight logos are trademarks of Dassault Systèmes in the US and/or other countries. Other brand and product names are trademarks of their respective owners. Copyright © 2010 Dassault Systèmes.

*Standalone license. Activation required.

**DraftSight supports Ubuntu^®, Fedora^®, Suse^®, and Mandriva^®. For information regarding system requirements for DraftSight on Linux^® please click here.

Cari dan Ubah di Vim

Berfungsi pada mode command (:),

:s/foo/bar/g
:%s/foo/bar/g
:%s/foo/bar/gc
:%s/\<foo\>/bar/gc
:%s/foo/bar/gci
:%s/foo/bar/gcI

semoga menginspirasi dan bermanfaat.

Selisih data dari database dibanding dengan waktu dari time()

Diasumsikan database yang digunakan adalah “coba”, koneksi database ke localhost dengan username: dpd, dan password: debip.

<?php
mysql_connect("localhost","dpd","debip");
mysql_select_db("coba");
$sekarang = mysql_fetch_object(mysql_query("select unix_timestamp(now()) sekarang"))->sekarang;
echo "waktu saat ini di database: $sekarang <br>";
sleep(60);
$saatini = time();
echo "waktu saat ini setelah sleep: $saatini<br>";
echo "selisih keduanya:".(($saatini-$sekarang)/60)." menit";
?>

Hasilnya:

waktu saat ini di database: 1319708790
waktu saat ini setelah sleep: 1319708850
selisih keduanya:1 menit