A single term can, theoretically, be present in multiple taxonomies (and have a different description in each). That’s where term_taxonomy_id comes into play, referencing a single term within a single taxonomy. In practice, WP tries to avoid that, and will create a term with the same name and a -2 (iirc) suffix on the slug … Read more
If your database is set up to deny remote connections (i.e. only applications on the same server can interact with the database) then there’s no danger in giving your WordPress user full access. As a matter of fact, most automated installation scripts used by web hosts grant full access to their WordPress user by default. … Read more
I can confirm that the imported post will get a new unique ID if (and only if) there already is an existing/conflicting ID in the target database. Given a post to be imported with an ID of 7579 (represented in the WXR export file as <wp:post_id>7579</wp:post_id>) and an existing post with that exact same ID … Read more
As a general rule, dbDelta does not yet support FOREIGN KEY, though I’ve been told it works on MySQL 5.1 (I can confirm it doesnt work on MySQL 5.5).
To recap the comment chain above: I think that’s a perfectly valid way of storing some options in the database, however, it’s good practice to prepend your option name with some unique characters pertaining to your site or something, like ‘my_simple_links’ to avoid possible collisions with other plugins and themes that add_options. Also, if you’re … Read more
I would suggest manually creating your first page (a custom post type might make more sense here?) in WordPress and then use the fantastic WP CSV plugin to export the page. Using the first page fields as a guide, simply copy your car data into the appropriate cell in a chart and import the completed … Read more
THE SHORT Export sudo mysqldump -u root -pPASSWORD DBNAME > filename.sql Import wp db import filename.sql THE LONG So this turns out to be very painless. The server dump is exactly what WP-CLI needs to import. REMOTE sudo mkdir backup Make a directory for the file. sudo chown -f -R ec2-user:group backup Set permissions to … Read more
Before getting into Importing, I would familiarize yourself with both the standard post type and post_meta as well as custom post types and taxonomies. If your end goal would benefit from the latter, you will save yourself quite a bit of headache utilizing them during the import preparation. If you prefer working with the database … Read more
Overview That’s the one main caveat of WordPress development, that even a seasoned WordPress developer still wonders what’s the perfect automation for syncing database content from local environment to live server. You can’t just upload your database dump from your local development environment to the server and be happy with the results. WordPress actually stores … Read more
First of all you probably created an isolated file that is not under the umbrella of WP files. That’s why you are not getting $wpdb. I guess you may not following the general rules/conventions of theme development. my question is now how are you accessing the file? whatever, if you include the wp_config.php in your … Read more