So are you going to automate your backup as well to be triggered before the DB upgrade starts? While the question has merit especially in a multisite context (in which the scenario is a little different) I am not sure that it is smart thing to do. That message could have said “this is your … Read more
That table is essentially the same as for all of the other “meta” tables in the WordPress architecture. It holds misc. bits of extra, usually optional, information about the associated post, user, or in this case comment. You can store whatever information you need to add to a comment– perhaps a plugin wants to implement … Read more
Personally, I use none of them. And an NDB cluster instead. NDB is MySQL’s built-in master-master replication engine. The only limitation of NDB in practice is the lack of full text index. But you can always use yahoo or google’s API for searches within your site. I found it worth the extra redundancy, especially when … Read more
In wp-admin/includes/upgrade.php are version specific functions for database upgrades. They include changes for the schema. Examples for 3.4.0 and 3.5.0: /** * Execute changes made in WordPress 3.4. * * @since 3.4.0 */ function upgrade_340() { global $wp_current_db_version, $wpdb; if ( $wp_current_db_version < 19798 ) { $wpdb->hide_errors(); $wpdb->query( “ALTER TABLE $wpdb->options DROP COLUMN blog_id” ); … Read more
As the codex says, it is legacy with probably no use in any modern version. I have been around wordpress since 2.0.4 and I don’t remember it being used or referenced so my guess is that it is a really old legacy thing.
Re-install a new copy of wordpress and then put in the credentials to your database in the new install. If you install wordpress and try to load the domain with no database attached, it will start the site creation wizard. Just enter the correct database credentials (username, database name, password, and location) and it will … Read more
That’s a Serialized Array which turns an array into a simple string so that it can be inserted into a database ( since you cannot just insert arrays into a database as they are ). For more information you can read into the PHP docs for serialize() There is also some WordPress functions which do … Read more
I got the problem solution myself. See the code below this will do that. Put the code inside your newly created custom template. <?php if (!empty($_POST)) { global $wpdb; $table = wp_achord; $data = array( ‘name’ => $_POST[‘yourname’], ‘chord’ => $_POST[‘chord’] ); $format = array( ‘%s’, ‘%s’ ); $success=$wpdb->insert( $table, $data, $format ); if($success){ echo … Read more
You’re missing the point that there is collation not only for the DB but as well for tables and even fields. Therefore from your point of view, I assume that your CREATE TABLE statement is “not complete”. Before using SQL statements, please learn the language first. See CREATE TABLE Syntax (MySQL Manual). Especially table_options / … Read more
It is that simple for WordPress too. I use the following to back up my WP sites: mysqldump -u <user> -p<pass> –quick –extended-insert <db-name> > backup.sql The mysqldump document gives the details on all the parameters. –extended-insert is quicker when updating a DB from a dump file and makes the dump file smaller. –quick makes … Read more