≡ 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…]

Back up and print WordPress blog with OpenOffice.org Base

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.


Copy MySQL Database From One Server To Another Remote Server

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