I recently had an issue with mysql database and the datbase has grown too large about 200k records and i was needing to delete all junk and needless data of approx 50k rows in my table. As soon as i hit delete sql query using WHERE clause, it almost took …
Effective March 1, 2011 the new rules are coming to effect as announced by paypal, citing RBI regulations. This had dramatically effected lot of small and medium businesses thriving online and of course indian freelancers who already took a beating because of this spat by the events happened exactly same …
Ever since the latest wordpress update, something weird happening with the comments. Whenever somebody posts a comment, they see a blank page from wp-comments-post.php. As a result of which comments posted by users are lost.
I quickly realized the problem has to do something with wp-comments-post.php or perhaps it could be …
Compatibility is one of the most important issues when it comes to WordPress. If you want to install a a copy on your local machine, then you have to follow some simple steps.
First, download the archive on wordpress.org. For the purpose of this tutorial we are going to use wordpress-2.9.tar.gz …
I wanted to post here the holidays observed by paypal both in US and in India. So, next time you are withdrawing funds to to your bank account, just watch out for these official paypal holidays both in India and US. You can anticipate a delay …
If you are just starting up demons souls, you will find killing red eyed knight with winged spear, almost impossible and may sound pretty difficult. I have tried this over 100 times and now i how easy to kill him. Just you will need to understand his moves.
Here are some …
Lets say you have to import a large text file to mysql and fields are totally irregular but only separated by spaces. For example. Since it is only text file and highly irregular data you have to use other methods to import data to database.
17876 …
It is very easy to import fixed width CSV data into your mysql database and LOAD DATA INFILE is the fastest method i have seen. If you are on shared hosting be sure you first upload the csv file to your hosting server and specify LOCAL if not you will …
I cant believe how slow the performance of mysql was, assuming that i had a large database table of over 100k record. I technically directly imported to mysql from csv and there was no primary key in the database. Infact i never used a auto incrementing primary key.
The performance was …
I was on shared hosting and thought i could import a CSV file using PHP to mySQL database and whe
LOAD DATA INFILE ‘/home7/topbestg/OFFICES2_ALL.CSV’
REPLACE INTO TABLE `tbl`
FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘\”‘
LINES TERMINATED BY ‘\n’
IGNORE 1 LINES;
i was thrown this error
Access Denied user@localhost using password …
