restore a db after bad backup

If you are not moving to a different domain name, the file path shouldn’t really matter. Try these first: Made a copy of your original backup bd Open the new copy and search/replace example.com/ to example.com/blog/ This should get you going no matter what server setup you have. If it doesn’t, and you already have … Read more

Create database on installation

Your SQL command is invalid. The error says: WordPress database error: [Incorrect table definition; there can be only one auto column and it must be defined as a key] CREATE TABLE to_issues ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(125) NOT NULL ) Try: $sql =”CREATE TABLE {$wpdb->prefix}to_issues ( id int(11) unsigned NOT NULL auto_increment, … Read more

wordpress database restore – broken link

It sounds like you probably need to go into the wp_options table and change the rows ‘site_url’ and the ‘home_url’ to match up with the new location. site_url is on the first page of the wp_options table, and ‘home_url’ is on the second page. If you can access the wp dashboard those can be changed … Read more

pull data from a remote wordpress database

Ok. There are few things wrong here. query_posts isn’t mean to be used that way so don’t. Try the same code with $likes=new WP_Query(array(… instead. $likes=new WP_Query(array( ‘post_type’ => ‘post’, ‘ignore_sticky_posts’ => true, ‘filter_type’ => ‘user_liked’, ‘filter_user’ => $user_id )); That is problem one. Then even if $likes were set correctly you’d clobber it. $likes= … Read more

Changing MySQL password via WHM – does this affect WordPress?

If that changes the MySQL password that WordPress is using, and it sounds like it does, then yes you will have a problem, but not a big one. You’d need to edit wp-config.php and change define(‘DB_PASSWORD’,’oldpass’); to define(‘DB_PASSWORD’,’newpass’); Beyond that, the question is a CPanel question and would be off topic here. http://codex.wordpress.org/Editing_wp-config.php#Set_Database_Password