Reply
Forum and blog database merged
Old 01-18-2010, 11:53 PM Forum and blog database merged
Novice Talker

Posts: 7
Trades: 0
Hello friends,
i am new bie in databse so when i tried to move my blog and forum from old domain to new site i checked my phpmyadmin and saw that all the tables are sitting under wp databse
__________________
webdesign

Last edited by chrishirst; 01-19-2010 at 05:10 AM.. Reason: superfluous links removed
sash_007 is offline
Reply With Quote
View Public Profile Visit sash_007's homepage!
 
 
When You Register, These Ads Go Away!
Old 01-19-2010, 12:04 AM Re: Forum and blog database merged
webcosmo's Avatar
Ultra Talker

Posts: 420
Location: Boston, MA
Trades: 1
moving the blog database would be much easier because there are less no of tables to deal with. then you can rename the db for forum if you like.
__________________
JOIN US * FAST GROWING WEBMASTER FORUM * JOIN US
Join the fun loving, helpful community of webmasters
Free Classified Ads
webcosmo is offline
Reply With Quote
View Public Profile Visit webcosmo's homepage!
 
Old 01-19-2010, 05:11 AM Re: Forum and blog database merged
chrishirst's Avatar
Super Moderator

Posts: 26,515
Location: Blackpool. UK
Trades: 0
Quote:
Originally Posted by sash_007 View Post
Hello friends,
i am new bie in databse so when i tried to move my blog and forum from old domain to new site i checked my phpmyadmin and saw that all the tables are sitting under wp databse
And your question is??
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Growing old is mandatory - Growing up is optional
Code Samples | Crowded Nightclub? | Bits & Bobs
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 01-21-2010, 06:30 AM Re: Forum and blog database merged
Novice Talker

Posts: 7
Trades: 0
Quote:
Originally Posted by chrishirst View Post
And your question is??
ok now i have backed by wp datbsae from my old domain with phpmyadmin and dumped on my pc then i import in my new domain in php myadmin now to make it work with my website i think i need to edit my wp-config file here is my wp-config before edit
HTML Code:
<?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/Editing_wp-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', 'webdesi1_wrdp1');

/** MySQL database username */
define('DB_USER', 'webdesi1_wrdp1');

/** MySQL database password */
define('DB_PASSWORD', '<removed>');

/** 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.
 *
 * Change these to different unique phrases!
 * You can generate these using the {@link https://api.wordpress.org/secret-key/1.1/ 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', 'f7sXx[2wbB@LBwlxS{A56y>+6iNvbUSbpMtTXz iq\\Ms}?(;_a#ypoR5\'3w<G5>FL~1X');
define('SECURE_AUTH_KEY', '-\"r642fed3E1d>}MdGFlh@tR!QPU%/!S_6;CjO0}^>6T6iNvbUSbpMtT+ <?)3 U#*X;');
define('LOGGED_IN_KEY', 'Q^l\"6-pL6iNvbUSbpMtT\zkw>OG<U$�:9H:Jl)+d$~jIBTt&CPL[Dp<KY4zL3y');
define('NONCE_KEY', 'asdasdjkasdjk6iNvbUSbpMtTjklasdjklasdkl&^%^&*(&*(jklasdjklasdjkl&*)))');
/**#@-*/

/**
 * 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', '');

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

/** WordPress 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');
and here is what i have edited
HTML Code:
// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'webdesi1_wrdp');

/** MySQL database username */
define('DB_USER', 'webdesi1_webdesi');

/** MySQL database password */
define('DB_PASSWORD', 'xxxxxxx');

/** MySQL hostname */
define('DB_HOST', 'localhost');
i took backup and named sql webdesi1_wrdp

then i added anew user and set password and changed in wp-config

but it shows mysqlconnection failure
__________________
webdesign
sash_007 is offline
Reply With Quote
View Public Profile Visit sash_007's homepage!
 
Old 01-21-2010, 07:12 AM Re: Forum and blog database merged
chrishirst's Avatar
Super Moderator

Posts: 26,515
Location: Blackpool. UK
Trades: 0
And did you give the username permission to access the appropriate database?

And what is the full eror message for the connection failure?
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Growing old is mandatory - Growing up is optional
Code Samples | Crowded Nightclub? | Bits & Bobs
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 01-22-2010, 07:03 PM Re: Forum and blog database merged
Novice Talker

Posts: 5
Name: Chris
Trades: 0
I'm currently moving a WP database as well, I think the issue that I was having was not putting the password in correctly. Going to reenter it and see if that works. Thanks for reminding me of that lol.
__________________
Read my $4000-$6000 a month story:
My Successful Blogging Story
Markco is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Forum and blog database merged
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.10959 seconds with 13 queries