backup only all tables you need from localhost so your .sql file contain only the tables you need & after this go to your live server keep your databse as it the use the following cmd from unix/linux SSH to keep the old tables & only restore the new tables mysql -u username -ppassword databasename … Read more
Reading through the source code for the wpdb class, I see no reason why something like this shouldn’t work: $otherdb = new wpdb(DB_USER, DB_PASSWORD, DB_NAME, DB_HOST); $otherdb->prefix = ‘wp2_’; And then (if I’m understanding this right) you can use all the existing $wpdb methods and variables. Eg: $x = $otherdb->get_results( $sql_query ); (If I’m wrong … Read more
A key must be defined for a table by using a single column, or multiple. So on your code, you need to a line to the sql KEY id (id) – $sql = “CREATE TABLE $table_name ( id int NOT NULL AUTO_INCREMENT, feedurl text NOT NULL, category text NOT NULL, KEY id (id) );”;
You want the query to look like this: SELECT email FROM wp_my_users WHERE email=”[email protected]” instead of this: SELECT email FROM ‘wp_my_users’ WHERE email=”[email protected]” So try to construct your query with: $sql = “SELECT email FROM {$my_table_name} WHERE email = %s”; $result = $wpdb->get_var( $wpdb->prepare( $sql, $email_address ) ); where you don’t need to escape the … Read more
Of course, minutes after posting this I work it out. The following worked: SELECT m.* FROM wp_postmeta m WHERE m.meta_key = ‘image’ AND NOT EXISTS (SELECT * FROM wp_posts p WHERE m.meta_value = p.ID)
You shouldn’t be calling get_the_ID() outside of a post loop, and the post ID is handed to you using the filter as a function argument: function insert_new_table( $post_id ){ So use $post_id Added notes Don’t use mysql_connect etc that extension was deprecated and is no longer included by default in newer versions of PHP. This … Read more
The steps to take would be: 1 – Extract files 2 – Create DB and import 3 – modify wp-config.php for database name and user credentials if changed Do not modify db tables to change the site url as they are serialized and this will create more issues than you want to deal with. 4 … Read more
I am not sure where you got that export code but I don’t see the PRIMARY KEY defined as it should be. Take a look at the code from Core that creates the table: 87 CREATE TABLE $wpdb->commentmeta ( 88 meta_id bigint(20) unsigned NOT NULL auto_increment, 89 comment_id bigint(20) unsigned NOT NULL default ‘0’, 90 … Read more
Create a new file names wp-config.php and paste all the code than enter your db credentials it will solve your wp-config issue. <?php /** * The base configurations of the WordPress. * * This file has the following configurations: MySQL settings, Table Prefix, * Secret Keys, WordPress Language, and ABSPATH. You can find more information … Read more
This is pretty straightforward. You can use phpMyAdmin or MySQL Workbench to change the prefix on all the tables at once, or you can do it one-at-a-time with a tool like SequelPro. If you need to run the SQL by hand, the syntax is… RENAME TABLE `old_name` TO `new_name`; Once all the table names are … Read more