Available Functions - Extra Examples - Download
dbUtils is a collection of functions to manipulate mySQL databases and perform tasks not normally available in database manipulation programs like the popular phpMyAdmin.
Version: 1.1
Description: Moves one table from one database to another.
Syntax: dbTableMove(Server,Database,Database,Table);
Example: dbTableMove("ServerOne","FromDatabase","ToDatabase","SomeTable");
Version: 1.1
Description: Copies one database from one server to another.
Syntax: dbSpecificCopy(Server,Server,Database,Database);
Example: dbSpecificCopy("ServerOne","ServerTwo","LocalDatabaseName","RemoteDatabaseName");
Version: 1.0
Description: Copies one table from one database to another.
Special Notes: Identical to dbTableMove, but does not delete the original table.
Syntax: dbTableCopy(Server,Database,Database,Table);
Example: dbTableCopy("ServerOne","FromDatabase1","ToDatabase2","Table");
Version: 1.0
Description: Renames a database.
Syntax: dbRename(Server,Database,Database);
Example: dbRename("ServerOne","OldDatabaseName","NewDatabaseName");
Version: 1.0
Description: Copies databases and tables matching regular expressions.
Special Notes: Use dbCopy with caution, and always test out regular expressions first.
Syntax: dbCopy(Server,Server,DatabaseRegEx,TableRegEx);
Example: dbCopy("ServerOne","ServerTwo","/.*/","/.*/");
### Copy ALL databases and all tables that have the letters "old" in their names from one server to another
dbCopy("ServerOne","ServerTwo","/.*/","/old*/");
### Copy the "JustMine" database and ALL tables within it from one server to another
dbCopy("ServerOne","ServerTwo","/JustMine/","/.*/");
### Copy the "JustMine" database and just the "Records" table within it from one server to another
dbCopy("ServerOne","ServerTwo","/JustMine/","/Records/");
View the source here: Source
Download it here: Download
|
