Read Full Post

Mysql: Export select rows to CSV on server

Use the following command to export the query rows to a file on the server in the CSV format:

[…]

Development
Read Full Post

Updating the URL of a WordPress website with SQL commands

Use the following commands to change the URL of a WordPress website directly inside the mysql database:

 

Development
Read Full Post

WordPress – db_term_taxonomy reset count

Reset the term count:

Development
Read Full Post

Set internal encoding to UTF-8 for php

Use the following code in your script to set the internal php encoding to UTF-8:

Also, for mysql and […]

Development