Clan Themes, We Make Clans Look Good!

CT on Facebook

Latest Product

Mech Warrior Online Xtreme Theme

User Box

Anonymous

38.107.179.216

PND Downloads Feed

How to Delete or Reset yo...

Lost your admin password ?Â Cant login to your admin account ? This s...

Back Online & Stuff

Look at us with our nifty website back up and running… Seriously...

How to edit the admins in...

Here is a way to make someone admin in your forums on your Evo site. I...

Demo Splash Screen

Ped @ Clan Themes has released a simple splash screen entrance hack.Â ...

Free Phpnuke Business The...

This is the 6th Business theme for Phpnuke that Clan Themes has releas...

Tricked Out Slider

We have seen some great new things come out of Tricked Out News and th...

Phpnuke Downloads

Custom Work

www.clanthemes.com :: View topic - Database question

Database question

5 Replies / 512 Views


www.clanthemes.com Forum Index » General PhpNuke	View previous topic :: View next topic

KillerBee123
Reputation: 12.5
Local time: 6:50 AM
Location: England

Armour Whore

0.04 posts per day
Medals: 0

Joined: May 14, 2009
Last Visit: 25 May 2012
Posts: 42
Points: 2242

Database question Posted: Tue Oct 04, 2011 10:01 pm

hi there,

i have made a sub domain so i can do some testing from my website, the problem i am having is i don't want to use the same database, i need to duplicate the main database so i can have 2 that are the same but run 2 different sites. if you get what i mean lol

i want to know if i can just d/load a copy of the main site database and change the name, then re upload it to the test site and if so how can i re upload, obviously changing the config for the new database.

any questions just ask :)

thank you for your help!

p.s i am using cPanel

Ped
Reputation: 94
votes: 37
Local time: 11:50 AM
Location: Great British Empire

Site Founder

1.82 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 26 May 2012
Posts: 3675
Points: 191995

Re: Database question Posted: Wed Oct 05, 2011 12:26 am
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

Have you not thought about installing XAMPP on your computer, its what I use

Can be a bit tricky for a first timer, but ones its installed its awsome, plenty of tutorials on Google on "How to install XAMPP"

I bet there is tutorials on "How to install PHPNuke on XAMPP" too

Other than that, what I would do is

-------------------------------------------

Download yoursite.com on FTP

Make a new folder yoursite.com/testsite and re-upload all your sites files

Go into Cpanel / Databases and download your current database

Make a new database in Cpanel and add user rights

Upload old database to new database in Cpanel

edit the yoursite.com/testsite/config.php to read the new database name

-------------------------------------------

Sounds confusing but its more time consuming than anything Angel

KillerBee123
Reputation: 12.5
Local time: 6:50 AM
Location: England

Armour Whore

0.04 posts per day
Medals: 0

Joined: May 14, 2009
Last Visit: 25 May 2012
Posts: 42
Points: 2242

Re: Database question Posted: Wed Oct 05, 2011 7:18 am

Hey ped thanks for the reply, couldnt get it to work, doing the upload download rubbish lol,

if any one else wants to know this is how i done it:

go to phpMyAdmin, then the database you want to duplicate, then go to, operations, on theat page you should have the option to copy the database, input your new database name and hit copy. it will then duplicate the database and create it! then make sure you have changed the database info in yoursite.com/config.php.

p.s what is XAMPP for?

thanks alot guys!

Noto
Reputation: 1072.7
votes: 13
Local time: 11:50 AM
Location: Sunny UK !

Site Admin

0.60 posts per day
Medals: 3 (View more...)

Theme Guru

Joined: May 03, 2007
Last Visit: 26 May 2012
Posts: 1118
Points: 73959

Re: Database question Posted: Wed Oct 05, 2011 2:00 pm

XAMPP is an easy to install Apache Distribution for Linux, Windows, Mac OS X, and Solaris.

Its really good ive been using it for years.

Tactical Combat Evolved - Sig Showcase

Ped
Reputation: 94
votes: 37
Local time: 11:50 AM
Location: Great British Empire

Site Founder

1.82 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 26 May 2012
Posts: 3675
Points: 191995

Re: Database question Posted: Wed Oct 05, 2011 5:18 pm
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

Xampp is so you can run a database (several if need be) and CMS (PHPNuke) from your computer

Its great, instant page refreshes !!

KillerBee123
Reputation: 12.5
Local time: 6:50 AM
Location: England

Armour Whore

0.04 posts per day
Medals: 0

Joined: May 14, 2009
Last Visit: 25 May 2012
Posts: 42
Points: 2242

Re: Database question Posted: Thu Oct 06, 2011 6:12 pm

installing it as i type :)

thank for the help!

www.clanthemes.com Forum Index » General PhpNuke

5 Replies / 512 Views
Page 1 of 1
All times are GMT

Display posts from previous:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke

Clan Themes, We Make Clans Look Good!

Sponsors

CT on Facebook

Latest Product

User Box

PND Downloads Feed

Custom Work