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…
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…
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…
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…
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…
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,…