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

Open the config.inc.php file located on the folder where your phpmyadmin is. Every time you need to add a new server, you need to add $i++; on top of your new configuration and also you need to append the new configuration at the bottom of the current configuration as seen on the image above. Bookmark on Delicious Digg this post Recommend on Facebook share via Reddit Share with Stumblers Tweet about it Subscribe to the comments on this post

After using Apache Webserver for 4 years I had no doubt of its simplicity and performance.  Reading several articles about the comparison of apache and nginx [engine x], I came to a point of using nginx.  Last night I kinda ditched apache and had a long time with nginx.  I have now an nginx webserver with mysql and php or other call it “LEMP”.  I found several tutorials of how to install nginx with php and mysql and found a

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: