≡ Menu

mysql database

trillr1: Build a Twitter-like Microblogging Website

Twitter is a free social networking and micro-blogging service, that allows its users to send and read other users' updates (also known as tweets). Now, you can build your own Twitter like service using trillr1.
[click to continue…]

Upgrade WordPress 2.7 in 3 Simple Steps

WordPress version 2.7 has been released and can be upgraded easily using UNIX / Linux shell prompt. A few assumptions:

  1. WordPress database name: wptheosblog
  2. WordPress directory name: /var/www/html/theos.in
  3. WordPress domain name: theos.in
  4. Operating system: Linux
WARNING! If you are not comfortable with UNIX shell prompt (IF YOU ARE new to a UNIX/Linux os), please follow traditional way of upgrading wordpress and DO NOT use the three Steps described here.

[click to continue…]

This sounds like a good idea to me. Never thought one can use OpenOffice to import MySQL database and do all sort of crazy things. I can even build PDF file of all top posts and provide it as download option for a small fee. From the article:

If you are running a blog (or any Web publishing system, for that matter) that relies on a database back end, you will sooner or later face the problem of backing up the content stored in the database. One way to go about it is to build a backup tool using OpenOffice.org Base. Since Base can pull data from a MySQL or any ODBC-compliant data source, you can create a simple database that connects to the blog's back end and extracts content from it, which you can then export in different formats.

Read more...

Usually you run mysqldump to create a database copy and backups as follows:
[click to continue…]