Dagu on April 24th, 2009

A few days ago, Oracle, a company which is known by it’s RDBMS, Oracle Database, bought Sun Microsystems ($7.4 billion.. wheewwww), a company which is known by it’s famous programming language, Java. As we know, Sun had bought MySQL, the famous open source database. Hmm… can you imagine how big Oracle now?
I just wonder what [...]

Continue reading about After Oracle Bought Sun

Dagu on March 22nd, 2009

jtablesession::Store Failed
DB function failed with error number 145
Table ‘./joomla_database/jos_session’ is marked as crashed and should be repaired SQL=INSERT INTO `jos_session` (`session_id`,`time`,`username`,`gid`,`guest`,`client_id`) VALUES (’1ecb458814b53d190db10cafee822dc0′,’1237429551′,”’0′,’1′,’0′);
Error message above usually happens to CMS Joomla. One of Joomla tables jos_session (the table name depends on prefix) is crash. Don’t worry if you experience this problem. It’s easy to overcome [...]

Continue reading about Joomla Database Crash

Dagu on January 8th, 2009

There are a few ways to create a database (known as schema) in MySQL, such as using command line or third party software.
Using Command Line
If we decide to use command line, then we must know the syntax to create it. It’s pretty simple: CREATE DATABASE database_name. Of course we should have a MySQL account which [...]

Continue reading about Creating Database in MySQL