MySQL 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 the internet. So let me elaborate…
Connect to the WordPress database via the phpMyAdmin tool at your web hosting account or open up a MySQL terminal to execute the below MySQL command. 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…
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 around. Let’s stop the chit-chat…
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> </form> Yeah ! Simple as…
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 Steps Here are the steps involved in…
