Down- and uploading CSVs is a tough one that forces you to make a bunch of steps manually which is prone to human error (and typos). My suggestion would be to do something that you can battletest locally in a local copy of your DB. Steps to follow: Make a database dump using the mysqldump … Read more
While at the current point in time there is very little difference, and maybe no difference at all, this is a bad practice if your development environment supposed to replicate the server your code will run on. There is just no point in forking a product without having the intention to change it, and the … Read more
You can do this right in interface: Select posts in need of change in admin post list screen Select Edit in Bulk actions dropdown and press Apply next to it Choose Format > Image in interface panel that appeared Press Update to apply
You should’nt really be using wp query here, use get_user_meta(); Example: $first_name = get_user_meta(2, ‘first_name’, true);
The WordPress current_time() returns the current time in the format specified in the first parameter. In your example code, this is the mysql value. The second parameter represents a timezone option. The default returns the local time for the timezone specified on the site’s Settings > General page, or GMT depending on the value supplied … Read more
You should create a ssh tunnel between the 2 serves. Then you can connect from the WP with only the mysql server ip. ssh -f [email protected] -L 2000:personal-server.com:25 -N The -f tells ssh to go into the background just before it executes the command. This is followed by the username and server you are logging … Read more
There’s quite a lot of information on here about switching to InnoDB https://wordpress.stackexchange.com/search?q=innodb There are a number of things to think about: InnoDB is helpful with you’re faced with contention – ie when you have tables that are being written to as well as being read InnoDB does not support FULLTEXT indexes so plugins that … Read more
What you posted will work fine for all links that are generated by WordPress: permalinks, script/style enqueues for local files, featured images, etc. I tend to define my Site URL and Home URL dynamically like this: <?php define(‘WP_HOME’, ‘http://’ . $_SERVER[‘HTTP_HOST’]); define(‘WP_SITEURL’, WP_HOME . ‘/wp’); Note: HTTP_HOST isn’t always present, use with caution As far … Read more
Try to replace: AND meta_value LIKE %s with AND meta_value LIKE ‘%%%s%%’ so your SQL will become: AND meta_value LIKE ‘%The%’ instead of: AND meta_value LIKE ‘The’
Okay, this always seems to happen to me. I spend ages looking for an answer and finally decide to give up and post here and then one more search finds enough to solve it. Anyway, this is what worked for me: update wp_posts set post_content = replace(post_content, ‘[/tab] [tab title=”1024×576″] <table class=”screenshot-table”>’, ‘[tabby title=”1024 x … Read more