Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Forum and blog database merged
Old 01-19-2010, 12:53 AM 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
__________________

Please login or register to view this content. Registration is FREE

Last edited by chrishirst; 01-19-2010 at 06:10 AM.. Reason: superfluous links removed
sash_007 is offline
Reply With Quote
View Public Profile Visit sash_007's homepage!
 
 
Register now for full access!
Old 01-19-2010, 01:04 AM Re: Forum and blog database merged
Banned

Posts: 421
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.
webcosmo is offline
Reply With Quote
View Public Profile Visit webcosmo's homepage!
 
Old 01-19-2010, 06:11 AM Re: Forum and blog database merged
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,517
Name: Chris Hirst
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!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 01-21-2010, 07: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
__________________

Please login or register to view this content. Registration is FREE
sash_007 is offline
Reply With Quote
View Public Profile Visit sash_007's homepage!
 
Old 01-21-2010, 08:12 AM Re: Forum and blog database merged
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,517
Name: Chris Hirst
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!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 01-22-2010, 08: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:

Please login or register to view this content. Registration is FREE
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.72320 seconds with 12 queries