CFLib.org – duplicateDB

duplicateDB(datasource, source, target [, copyData])

Last updated February 21, 2011

author

Version: 1 | Requires: ColdFusion 8 | Library: DataManipulationLib

Rated 0 time(s). Average Rating: 0

Description:
This function will duplicate any small to medium sized MySQL databases on the same DB server. I strongly discourage using this on large DBs! You can dupe schema only or schema + data.

Return Values:
Returns nothing.

Example:

view plain print about

<!--- Duplicate schema only --->
<cfset duplicateDB(application.dsn,"old_db","new_db") />

<!--- Duplicate schema AND data --->
<cfset duplicateDB(application.dsn,"old_db","new_db",true) />

<cfset duplicateDB(application.dsn,"old_db","new_db") />


<cfset duplicateDB(application.dsn,"old_db","new_db",true) />

Parameters:

Name	Description	Required
datasource	DSN	Yes
source	Source for duplication.	Yes
target	Target for duplication.	Yes
copyData	Boolean that determines if data along with structure. Defaults to false.	No

Full UDF Source:

	
	
			
			
			
				
				view plain
				
				
				copy to clipboard
				
				
				
				
				print
				
				
				about
				ColdFISH is developed by Jason Delmore.  Source code and license information available at coldfish.riaforge.org.  Version 3.1.1
				
			<!---
 Duplicates small to medium MySQL databases.
 
 @param datasource 	 DSN (Required)
 @param source 	 Source for duplication. (Required)
 @param target 	 Target for duplication. (Required)
 @param copyData 	 Boolean that determines if data along with structure. Defaults to false. (Optional)
 @return Returns nothing. 
 @author Steve Good (&#115;&#116;&#101;&#118;&#101;&#64;&#115;&#116;&#101;&#118;&#101;&#103;&#111;&#111;&#100;&#46;&#111;&#114;&#103;) 
 @version 1, February 21, 2011 
--->
<cffunction name="duplicateDB" access="public" returntype="void" output="false" hint="I duplicate a MySQL database locally on the same server.">
	<cfargument name="datasource" type="string" required="true" />
	<cfargument name="source" type="string" required="true" />
	<cfargument name="target" type="string" required="true" />
	<cfargument name="copyData" type="boolean" required="false" default="false" />
	
	<cfquery datasource="#arguments.datasource#">
	CREATE DATABASE  IF NOT EXISTS #arguments.target#;
	</cfquery>
	
	<cfdbinfo datasource="#arguments.datasource#" name="local.tbls" type="tables" />
	
	<cfloop query="local.tbls">
		<cfquery datasource="#arguments.datasource#">
		CREATE TABLE #arguments.target#.#table_name# LIKE #arguments.source#.#table_name#;
		</cfquery>
		
		<cfif arguments.copydata>
			<cfquery datasource="#arguments.datasource#">
			INSERT INTO #arguments.target#.#table_name# SELECT * FROM #arguments.source#.#table_name#;
			</cfquery>
		</cfif>
	</cfloop>
</cffunction>
		<!---
 Duplicates small to medium MySQL databases.
 
 @param datasource      DSN (Required)
 @param source      Source for duplication. (Required)
 @param target      Target for duplication. (Required)
 @param copyData      Boolean that determines if data along with structure. Defaults to false. (Optional)
 @return Returns nothing. 
 @author Steve Good (steve@stevegood.org) 
 @version 1, February 21, 2011 
--->
<cffunction name="duplicateDB" access="public" returntype="void" output="false" hint="I duplicate a MySQL database locally on the same server.">
    <cfargument name="datasource" type="string" required="true" />
    <cfargument name="source" type="string" required="true" />
    <cfargument name="target" type="string" required="true" />
    <cfargument name="copyData" type="boolean" required="false" default="false" />
    
    <cfquery datasource="#arguments.datasource#">
    CREATE DATABASE  IF NOT EXISTS #arguments.target#;
    </cfquery>
    
    <cfdbinfo datasource="#arguments.datasource#" name="local.tbls" type="tables" />
    
    <cfloop query="local.tbls">
        <cfquery datasource="#arguments.datasource#">
        CREATE TABLE #arguments.target#.#table_name# LIKE #arguments.source#.#table_name#;
        </cfquery>
        
        <cfif arguments.copydata>
            <cfquery datasource="#arguments.datasource#">
            INSERT INTO #arguments.target#.#table_name# SELECT * FROM #arguments.source#.#table_name#;
            </cfquery>
        </cfif>
    </cfloop>
</cffunction>