Since I am a “everything has to be stored”-freak, I created a way to extract short messages (SMS) from my cellphone and store them into a MySQL-Datebase. I also wrote a simple PHP frontend which allows to display messages, to filter them by sender’s or receiver’s name and also to arrange them to (so called) conversations.Conversations may be very useful if you write lots of messages with a certain person and some short messages are about a specific topic.Here’s what you need:

  • a cellphone with Symbian (e. g. UIQ3, S60v3)
  • BestMessageStorer
  • a Perl script
  • a MySQL database
  • an Apache webserver
  • a PHP interpreter
  • lots and lots of short messages 🙂

This is how to set up the database tables:

Database tables sms and sms_conversations:

  ID int(5),
  conversation int(3),
  src text,
  dest text,
  weekday text,
  year int(4),
  month text,
  day int(2),
  time text,
  text text,
  timestamp timestamp,

CREATE TABLE sms_conversations (
  ID int(3),
  name text,

I won’t post the Perl scripts (one for reverting the order of extracted short messages, one for storing them in the database) here. I neither won’t post the PHP file. You may get in touch with me to optain them.

Once you have this database up and running, you collected some short messages on your cellphone, getting them stored is as easy as 1-2-3. Here we go:

  1. safe messages to a file using BestMessageStorer
  2. transfer file onto a computer
  3. safe file with encoding “ANSI” (or anything else, whatever fits your needs)
  4. transfer file onto your server (on which you have the Perl scripts installed)
  5. process the file using: cat FILENAME | ./reverse_file | ./process_sms
  6. finished

Have fun! 🙂

Hat’s gefallen?

Wenn der Artikel gefallen hat oder hilfreich war, bitte folgende Funktionen benutzen:


    Can I transfer my sms’s on my Nokia 6600 to the PC? I do have the dedicated PC Suite from Nokia for the 6600 but it seems it does not allow transfer of sms’s, only contacts and calendar.

  • Hi Neeraj!

    As I mentioned above, all you need is a cellphone which supports the software called “BestMessageStorer” to extract and save all your short messages.

    Just get and install this software on your cellphone, use it and save all short messages on a local drive on your device. Then transfer the file onto your PC.

    I cannot tell you whether or not your cellphone supports BestMessageStorer. Please just take a look for yourself.

    If you need the Perl scripts to get your short messages stored in a database, just let me know your e-mail address. I will send them to you.

    Cheers, Thomas

  • Mr thomas,
    i need information and way of trck the SMS. Those SMS hava a format. from those formated data i need to get MySql database.HOW am i do this?

  • embet:

    hi can you pls send me the perl scripts thanks a lot.

Leave a Reply