You can use plugins such as BackupBuddy, but I prefer to script this and use wp-cli, which reads wp-config.php and means you don’t have to worry about mysql credentials. wp-cli allows you to: export the db: wp db export <filename> import the db: wp db import <filename> safe search and replace (including serialised data): wp … Read more
With everything moving towards OOP programming with classes and the use of objects increasing and favored above the use of arrays as such, I would definitely go with returning results as an object. This just makes everything easier for future use But at the end of the day, you should always use what you are … Read more
It might work to use a view as essentially a table alias, by doing the something like the following with the WordPress instance mysql database DROP TABLE wp_users CREATE VIEW wp_users AS SELECT * FROM CI.users; However will probably need to tweak the view creation to map the columns the password encoding may well be … Read more
you can export tables of your database that you want to transfer, and Import to another database, then you should change Prefixes of those .
Well after a lot of digging, I think I uncovered what happened. The clue came from the fact that I noticed it was wp_options and all alphabetically subsequent tables that lost their primary keys. On import, first the tables are created. Next it goes through all those tables in alphabetical order and applies the primary … Read more
The table name needs to be in quotes on the line where you’re checking if it exists. I tested it, and after that was fixed, the table was successfully created. Here is the full code: function mm_booking_activate() { global $wpdb; $mm_booking_table_name = $wpdb->prefix . “mm_booking”; $mm_booking_db_version = ‘1.0’; $charset_collate = $wpdb->get_charset_collate(); if ( $wpdb->get_var( “SHOW … Read more
Are the new image dimensions registered in the database in any way or does the resizing just occur in the uploads directory? No, the image size system is similar to the post type system, sizes are registered at runtime, not in the database. The size of some sizes are stored in the database as they’re … Read more
If this is a standard CMS (not something you came up with yourself), I would say that a WXR solution is the way to go. It might take some extra work, but it will be a good learning experience and a nice way to build up your WordPress skills. The WXR route will be an … Read more
I’d say (and that’s just my opinion), that prefixing global available stuff like: functions classes tables … should always share the same prefix. Aside from making your code more unique & therefore collision save, it helps when searching for plugin code, plus it serves as branding for your plugin too. Adding plugin_ to the table … Read more
imagecreatefrom* functions return an image resource identifier, which when cast to a string (saving an option) will result in an empty string(0) “” container. Raw images created by these functions do not have any specific data structure that can be serialized out of the box. Two solutions I can think of: image files Use imagepng, … Read more