DBMS Category
HeidiSQL: Another Free MySQL Client Tools
I bet many of you know what is MySQL and probably use it a lot. One of the best MySQL client tools is MySQL Workbench as it have all fancy features. But it is too heavy to use. So instead of design the... [More...]
Free Database Designer For MySQL With MySQL Workbench
If you are looking for a nice and good database designer for MySQL, then i’m very recommend you to use MySQL Workbench. Beside it is free (GPL License for Community Edition), it is also easy to use.... [More...]
![[HowTo] Check And Repair MySQL Database](http://www.ivankristianto.com/wp-content/themes/codemaniac/tools/timthumb.php?src=wp-content/uploads/2010/04/mysql_logo.jpg&h=30&w=30&zc=1){kind=logo}
[HowTo] Check And Repair MySQL Database
Sometimes your MySQL database data is corrupted. Usually it is not properly close when querying to the database, because of high server load or MySQL server suddenly down. This will make your database... [More...]
Regular Expressions Cheat Sheet
Regular expressions (regex or regexp) provide a concise and flexible means for matching strings of text, for instance particular characters, words, or patterns of characters. A regular expression is written... [More...]
Beginners Guide: Backup And Restore Compressed MySQL Dump File
As you know your website data is stored in your database server, in this case is MySQL. To prevent disaster, backup your data regularly is a must for you and every website owner. There are many ways to... [More...]
Things You Can Do With String.Format In C#
Formatting output string with String.Format is really helpful, and it’s been mostly use when you develop application using C# or VB.Net. String.Format firstly released in .NET Framework 1.1. String.Format... [More...]
Copy MySQL Data Across The Server
If you move or change your hosting server, beside the files you also need to move your mysql data as well. MySQL database hold all your website data including content, configuration, user account and other... [More...]
AutoMySQLBackup: Regularly Backup Your MySQL
If you have blogs or websites, you databases is one the most important thing. Your data will be store on your database, for this case it is MySQL. MySQL is a free database management system (DBMS) and... [More...]
Backup All Your MySQL Database With One Script
MySQL is a relational database management system (RDMS), and one of the most powerful DBMS. Most of the websites including this blog using MySQL technology behind it. Since it free and it always bundled... [More...]
[HowTo] Extract Database Information From Information_schema Table in Mysql
INFORMATION_SCHEMA provides access to database metadata. Metadata is data about the data, such as the name of a database or table, the data type of a column, or access privileges. Other terms that sometimes... [More...]
[HowTo] Replace String In Mysql With One Query
Yesterday i was helping my friend’s blog. She want to change her domain and move her hosting server for some reasons. She is using wordpress as her blog engine and of course using mysql as database... [More...]
[HowTo] Make User Defined Function In SQLite ADO.NET With C#
Sometime we want to make user defined function and use it in our query to the database. In Ms. SQL Server and Oracle DBMS support user defined function, stored procedure and transactional. Since SQLite... [More...]
[HowTo] Use SqLite ADO.NET with C#
SQLite is software library written in C that implement self-contained (very minimal support from external libraries), serverless (read/write process directly to database file), cross-platform (run in any... [More...]
[HowTo] Run ASP.NET on Linux With Apache Web Server (Mono + Mod_Mono)
Mono is an open source project led by Novell (formerly by Ximian) to create an Ecma standard compliant, .NET-compatible set of tools, including among others a C# compiler and a Common Language Runtime.... [More...]
