Support Forum

Bear with me now...lol...I have been looking in my PHP Admin, and I see I have a separate database with things with wp-sf on......so I have my old wp databsse, my new database and a SP database.

So do I need to zip up the SF database and then what do I do with it...sorry to sound like an idiot.

I'll go and have a look in my wp-config.php  I wish I could find out what is doing it.

So where do I put the exported SF database once I'm ready to upload it, because my WP database and SF databases are seperate, can I import it from the SP plugin.  Can I install that to my fresh WP install first.

I can't see it, this is what it says

<?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
 * by visiting {@link http://codex.wordpress.org/Edi.....config.php Editing
 * wp-config.php} Codex page. You can get the MySQL settings from your web host.
 *
 * This file is used by the wp-config.php creation script during the
 * installation. You don't have to use the web site, you can just copy this file
 * to "wp-config.php" and fill in the values.
 *
 * @package WordPress
 */

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'web97-a-word-239');

/** MySQL database username */
define('DB_USER', 'web97-a-word-239');

/** MySQL database password */
define('DB_PASSWORD', '2D^NKt-9k');

/** MySQL hostname */
define('DB_HOST', 'localhost');

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');

/**#@+
 * Authentication Unique Keys and Salts.
 *
 * Change these to different unique phrases!
 * You can generate these using the {@link https://api.wordpress.org/secr...../1.1/salt/ WordPress.org secret-key service}
 * You can change these at any point in time to invalidate all existing cookies. This will force all users to have to log in again.
 *
 * @since 2.6.0
 */
define('AUTH_KEY',        'nn`1er&HX~4:#?j?*KtcyC#.Y&DBIp}I7O}b#4aDOSNTg6a(+=w(Uwc-Vck:te5}');
define('SECURE_AUTH_KEY', 'mKkvw[S+NtY+-{~.YX%,KhCq5,R>hzdr)Y Jtd}ar+>+L ||5}$2dt_W_/nO_[x8');
define('LOGGED_IN_KEY',   'Yykb-Ui_Sm~FJpPbL-I w?Kf1sq,w[dotUUTLp^@SK[L-R;qbw3G0I6uC)h`f|0!');
define('NONCE_KEY',       '(Fk-ON1.w|B|]|5;8]TnJ]$/D:K+E(Z<;K!cA.sg17;jF,_ys6GyGw%CTl!$N%Ek');
define('AUTH_SALT',        'Y<udC[9@QFCR9Em{o1<dLT%4>mcubs%l+&rx%{+&Z,S+!6(J/{K5N|[E>^C$KUM}');
define('SECURE_AUTH_SALT', 'c=fn$3&x-DGrrKdJEfQWMpqy^oEsch>J+qn3L2%_P+UVb 3></$@3^Zn0$iQ8fO-');
define('LOGGED_IN_SALT',   'y.hD~tTGC/e^f2o?fPN[!=br.yMhyi4gj]+=)AUf9EUr->m1*jVA3|]:J5#[l]4>');
define('NONCE_SALT',       'OtZI*B?J-9 W0JD5nj5@4|by{j&Ciz)2)`kHk~X6{:Zz1,Ux{:{t81V-+Tiv;e~[');

/**#@-*/

/**
 * WordPress Database Table prefix.
 *
 * You can have multiple installations in one database if you give each a unique
 * prefix. Only numbers, letters, and underscores please!
 */
$table_prefix  = 'wp_';

/**
 * WordPress Localized Language, defaults to English.
 *
 * Change this to localize WordPress.  A corresponding MO file for the chosen
 * language must be installed to wp-content/languages. For example, install
 * de.mo to wp-content/languages and set WPLANG to 'de' to enable German
 * language support.
 */
define ('WPLANG', '');

/**
 * For developers: WordPress debugging mode.
 *
 * Change this to true to enable the display of notices during development.
 * It is strongly recommended that plugin and theme developers use WP_DEBUG
 * in their development environments.
 */
define('WP_DEBUG', false);

/**
 *  Change this to true to run multiple blogs on this installation.
 *  Then login as admin and go to Tools -> Network
 */
define('WP_ALLOW_MULTISITE', false);

/* That's all, stop editing! Happy blogging. */

/** Absolute path to the WordPress directory. */
if ( !defined('ABSPATH') )
    define('ABSPATH', dirname(__FILE__) . '/');

/** Sets up WordPress vars and included files. */
require_once(ABSPATH . 'wp-settings.php');

/* Destination directory for file streaming */
define('WP_TEMP_DIR', ABSPATH . 'wp-content/');

I have WAMP on my computer that I've been setting up this morning so I'm going to try it on that test site and see but that failed because I have a limit of the size of uploads on myPHPadmin, so I tried adding it to my new wp and that failed.

SQL query:

-- -- Dumping data for table `wp_comments` -- INSERT INTO `wp_comments` (`comment_ID`, `comment_post_ID`, `comment_author`, `comment_author_email`, `comment_author_url`, `comment_author_IP`, `comment_date`, `comment_date_gmt`, `comment_content`, `comment_karma`, `comment_approved`, `comment_agent`, `comment_type`, `comment_parent`, `user_id`, `comment_subscribe_optin`, `comment_subscribe_optin_verified`, `comment_subscribe_optin_mailed`) VALUES (194, 1397, 'Eresin', 'eresin84@gmail.com', 'http://eresininstitches.wordpress.com', '193.62.251.30', '2013-01-29 09:04:06', '2013-01-29 09:04:06', 'it looks greats, you''re right the sewing of it is very neat ', 0, '1', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.56 Safari/537.17', '', 0, 0, 'N', '000000000000000', 'N'), (2, 33, 'julie-bookworm', 'grey@blueyonder.co.uk', '', '94.172.149.88', '2012-05-18 09:17:03', '2012-05-18 09:17:03', 'sharon -shes coming along great i think she''ll look l[...]

MySQL said: Documentation

#1054 - Unknown column 'comment_subscribe_optin' in 'field list'