If your server is not changed, you don’t need to do something with your database. Just leave it as it is. Additionally I would like to recommend you to read Moving WordPress article from the codex. You will find all answers on your questions about migration.
get all data from DB1( non-wp-database ) and save to an $array. Use this wordpress code inside your functions.php for insert users into DB2 ( wordpress database). function cxg_wp_insert_user() { foreach ( $array as $arr ) { $user_data = array( ‘ID’ => ”, ‘user_pass’ => wp_generate_password(), ‘user_login’ => $loginName, ‘user_nicename’ => $nicename, ‘user_url’ => ”, … Read more
why is $wpdb->update() causing a DB error from within wp_set_password()
Silly mistake on my part, At some point I defined my wp-content directories right in wp-config. define( ‘WP_CONTENT_DIR’, ‘/home/user/public_html/site/subdirectory/wp-content’ ); define( ‘WP_CONTENT_URL’, ‘http://www.seocial.ly/site/subdirectory/wp-content’ ); Completely overlooked this when editing my wp-config.
I simplified your query, but wouldn’t something like this accomplish it? SELECT * FROM $wpdb->posts AS p LEFT JOIN $wpdb->postmeta AS pm ON p.ID = pm.post_id LEFT JOIN users AS u ON pm.meta_value = u.user_id WHERE pm.meta_key = ‘user_id’ AND post_status=”publish” ORDER BY p.ID DESC LIMIT 50;
I am not sure why lately ppl define the path to their DB_HOST like you do. (Assuming it is a way server is configurated (or using a MAC) and/or as pseudo layer of security?) Anyway, you will have your reason for it, maybe one of these codelines below could help you. define(‘DB_HOST’, ‘:/var/run/mysqld/mysqld.sock’); I could … Read more
I found the reason: term_id is the ID of a term in the terms table. term_taxonomy_id is a unique ID for the term + taxonomy pair. see: What’s the difference between term_id and term_taxonomy_id Still, I think it’s a bit strange to do it this way. Also because I think it doesn´t make sence to … Read more
Why are my WordPress post queries so slow?
The Solution is: every normal character stored in weird starts with &# ends with ; like this ٪ So you can simply 1-open you dreamweaver 2- new HTML file 3- code tab 4- delete all the code in it 5- put one weird code like this ٪ 6- design tab 7- you can see the … Read more
You can update just joining both table on comparing same userid. like: update t1 join t2 on t1.user_id = t2.user_id set t1.meta_value = t2.desc;