MySQL Archives - Page 3 of 77

WordPress

IT Nursery

Insert all post IDs in new database table

I have a plugin which creates a new database table. Upon activating the plugin is there a way to insert all my posts ...

June 3, 2022
0 Comments

WordPress

IT Nursery

Is it good practice to use wpdb->query() function?

I am using custom php code to perform data insertion, deletion, updating and other tasks. I am able to insert data into a ...

June 3, 2022
0 Comments

MySQL, Programming

IT Nursery

How to recover MySQL database from .myd, .myi, .frm files

How to restore one of my MySQL databases from .myd, .myi, .frm files? 11 Answers 11

June 3, 2022
0 Comments

MySQL, Programming

IT Nursery

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’

Error message on MySql: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' I have gone through several other posts and was ...

June 3, 2022
0 Comments

Programming, sql

IT Nursery

How do you run a single query through mysql from the command line?

I’m looking to be able to run a single query on a remote server in a scripted task. For example, intuitively, I would ...

June 3, 2022
0 Comments

MySQL, Programming

IT Nursery

Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, ...

June 2, 2022
0 Comments

PHP, Programming

IT Nursery

MySQL Great Circle Distance (Haversine formula)

I’ve got a working PHP script that gets Longitude and Latitude values and then inputs them into a MySQL query. I’d like to ...

June 2, 2022
0 Comments

MySQL, Programming

IT Nursery

How do I turn off the mysql password validation?

It seems that I may have inadvertently loaded the password validation plugin in MySQL 5.7. This plugin seems to force all passwords to ...

June 2, 2022
0 Comments

WordPress

IT Nursery

PHP/MySQL issues when running WP on EC2 cloud [closed]

Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for ...

June 2, 2022
0 Comments

WordPress

IT Nursery

theme options echoing multiple times

I tried to strip down the Twenty Eleven theme options page and add my own fields correction: I followed a tutorial somewhere, but ...

June 2, 2022
0 Comments