English (United Kingdom)
Jms Multi Site, formerly joomla multisite.
Create, share multiple joomla sites in few clicks !
Message
  • EU e-Privacy Directive

    This website uses cookies to manage authentication, navigation, and other functions. By using our website, you agree that we can place these types of cookies on your device.

    View e-Privacy Directive Documents

Welcome, Guest
Please Login or Register.    Lost Password?

New slave, Want to copy existing DB to NEW DB
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: New slave, Want to copy existing DB to NEW DB
#5289
New slave, Want to copy existing DB to NEW DB 14 Years, 3 Months ago Karma: -1
I want to be able to use the Master website as a blank template to be used as the starting point for the slave databases! When I create a new slave, I want my new database to be duplicated from the Master Database with all components, modules, and plugins!

How is the easiest way to do this?

j
Jweber72
Junior Boarder
Posts: 23
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5292
Re: New slave, Want to copy existing DB to NEW DB 14 Years, 3 Months ago Karma: 54
All depends your environement and the admin tool that you have.
For example, if you are using cPanel, you can create different DB and also assign several MySQL user to a same DB.
To reduce potential MySQL privileges problem, it is easiest to have a same MySQL user for several DB. So that you just have to change the DB in Jms Multisites and the copy of the DB will be performed with the same MySQL user.

So you could have a tmplate rule like
Select the template site = <master_db>
New DB name = a rule that could be computed based on site ID (ie. db_{site_id} )
New DB user = empty (if you are using the same MySQL user than the master db)
New DB psw = empty
New table prefix = {site_id}_ In general I recommend to have a specific table prefix (event when using different DB - just in case where you are doing a mistake and write in wrong DB)

When you have the rule, you can use it in "manage site".

If you want to see some sample on how the JMS Templates is working, see our tutorial video 13, 16, cp-05
www.jms2win.com/tutorial
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5298
Re: New slave, Want to copy existing DB to NEW DB 14 Years, 3 Months ago Karma: -1
Yes, my setup is to usa a different Database for each Site, I use a single Database User for all Databases and I'm using cPanel.

Currently, I maintain a "STARTER" joomla website which I use when I create a new site. It has all my components and configuration already setup. With all the changes that get copied from the "STARTER" site to the new site, probably save me about 10 hours. To create a new site, I simply copy the STARTER Joomla directory to a new directory for my new webiste. Once the physical files have been copied, I then create the new site's database and use the MySQL backup and restore to copy the existing database from my STARTER website. From here I have an exact copy of the STARTER Website. I would like to replicate that type of setup with JMS!


From what I'm reading in your last post, I need to setup a template and select the Master Site's template! The problem as I understand it, using this option only creates a new set of tables in the existing database with a new prefix? It says just above the "template site" field "Replicate the tables from an existing DB prefix into a new tables prefix using the same DB"

j
Jweber72
Junior Boarder
Posts: 23
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5301
Re: New slave, Want to copy existing DB to NEW DB 14 Years, 3 Months ago Karma: 54
When you are using the JMS Template, you can also specify that you want copy the STARTER DB into another DB.
This is what I give you in my previous post with the parameter

New DB name = a rule that could be computed based on site ID (ie. db_{site_id} )

New DB mean other DB. Not the same DB. If you let the field empty, this in the same DB (because you don't want a new DB).
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5321
Re: New slave, Want to copy existing DB to NEW DB 14 Years, 3 Months ago Karma: -1
I'm thinking this must be in the newer version because I'm not seeing the options you are talking about.. I need to find time to backup and upgrade JMS to the newer version.

How about all the components that are installed in the STARTER? Will they copy over with this option "Copy Database" option?
Jweber72
Junior Boarder
Posts: 23
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#5323
Re: New slave, Want to copy existing DB to NEW DB 14 Years, 3 Months ago Karma: 54
Which JMS Multisites version do you use.
This is something available in all JMS Multisites 1.2.x version.

When JMS Multisites replicate a website, it copies all the tables of the website and therefore all the data, compoent, module, plugin definitions.
This will clone your "starter" website.
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
get the latest posts directly to your desktop
2Win, Multisite(s) are trademarks of Edwin2Win.
Joomla