A simple command to dump or import large data on a mysql database: mysql -h localhost -uroot -pAa5sD1 nightcrawler < /home/tux/Desktop/nightcrawler.sql where: -h localhost is for my mysql host or server -u root is the mysql user -p pAa5sD1 is the user’s password nightcrawler is the empty database /home/tux/Desktop/nightcrawler.sql is the data to import or usually a back of the database < is use to import and > is used to export data from a mysql database Bookmark on Delicious Digg this

I was able to successfully install Gnokii and used Nokia 5000d-2 connected through the bluetooth media.  Here is the identity of the phone that I am using. The details of the Phone using one of nokia’s hidden code: *#06#. Result: Nokia 5000d-2 V 06.31 24-03-09 RM-362 (c) Nokia Variant: 167.01 Virtual Variant: No Virtual Variant Language: V 06.31 24-03-09 RM-362 (c)Nokia T Using Gnokii’s commands to identify the mobile I used. gnokii ‐‐identify The output was, GNOKII Version 0.6.28 Assuming:

    I installed Apache, MySQL and PHP on windows 7.  I tried to install drupal version 7.9 and went through an error as shown in the image below: The error “Your web server does not appear to support any common PDO database extensions.” can be fixed by following these steps: Open your php.ini file Around line 966 uncomment the line “extension=php_pdo_mysql.dll” Make sure you have php_pdo_mysql.dll on your ext folder or download it here php_pdo_mysql Restart Apache and you can

I created a web application that managers collected links.  The web application was called duplicate checker where premium links collected are being stored in a mysql database.  Previously they are doing it on an excel file which automatically highlights the duplicate entry but as months pass by the file is running so slow and so I came up to a solution which is the duplicate checker. Its been almost 5 months and the system was running without any problem, its

My friend forgot his mysql password and the database needs to be accessed by the root user.  My friend is running MySQL 5.1 and as I browsed the MySQL manual the solution provided is not working though a slight change was made.  Just like the provided step in the manual: Log on to your system as Administrator. Stop the MySQL server if it is running. For a server that is running as a Windows service, go to the Services manager:

Knowing the right MySQL statement is the most important part in having thousands of data in your database, one false move and you can’t undo things.    If you want to change a string or character in your database and doing it manually in thousands or millions of entries then that should consume all of your time. One example scenario is when you want to change all the entries containing a character ‘_’ to this character ‘-’ .  All you need