Have you ever got this error? Oh! You are searching for a solution right? You have come to the right place. Let me give you the simplest answer and it works charm. For the time being assume that this is your query. DELETE FROM table_name where coulmn_name IN (SELECT coulmn_name FROM table_name  WHERE coulmn_name > 10); What you can do is change the ...

Indexes! Whooh! Let me tell you what my experience about indexing a table. I had a SQL query which took 8-9 secs to fetch the data I want. After indexing now it only takes 1 sec. Interesting right. Let’s go through what’s indexing and how to and when to and stuff. You could find technical explanation of indexes in ...

Connect to the WordPress database via the phpMyAdmin tool at your web hosting account. Once in phpMyAdmin select the WordPress database & Open the SQL tab (look at the top navigation bar). write the following SQL query: UPDATE `wp_users` SET `user_pass` = MD5( ‘new_password_here‘ ) WHERE `wp_users`.`user_login` = “admin_username“; “new_password_here” – replace this with the new password you wish to ...

Let’s take a look at what’s regular expression and it’s use in the development environment. 1st of all regular expression is a small piece of code which looks for pattern(s). In web development environment Regex are used in the .htaccess file most frequently. Regexs are supposed to make developer’s life easier but most of the time it’s the other way ...

Add this code where you want to put the custom search. Settings : action – set the site url cat field value – should be set to the category id whatever you want to search in(here its 5) <form method="get" id="search form" action="http://localhost/wordpress_test/"> <div> <input type="text" value="" name="s" id="s" /> <input type="hidden" value="5" name="cat" id="scat" /> <input type="submit" value="search"/> </div> ...

So you have a larger mySQL database of more than 30 MB size, you want to move it to a new server, and you’re unable to import your database to the new server via phpMyAdmin, due to its time and size limitations. But don’t worry, its not a big problem. It can be done using a tool BigDump Here are ...