|
|
phpMyAdmin 3.0.0-alpha (Development branch)
08-10-2008
phpMyAdmin is a tool intended to handle theadministration of MySQL over the Web. It cancreate, rename, and drop databases,create/drop/alter tables, delete/edit/add fields,execute any SQL statement, manage keys on fields,create dumps of tables and databases,export/import CSV data, and administrate onesingle database and multiple MySQL servers.|
|
Wiki::Toolkit::Setup::MySQL(3pm) User Contributed Perl Documentation Wiki::Toolkit::Setup::MySQL(3pm) NAME
Wiki::Toolkit::Setup::MySQL - Set up tables for a Wiki::Toolkit store in a MySQL database. SYNOPSIS
use Wiki::Toolkit::Setup::MySQL; Wiki::Toolkit::Setup::MySQL::setup($dbname, $dbuser, $dbpass, $dbhost); Omit $dbhost if the database is local. DESCRIPTION
Set up a MySQL database for use as a Wiki::Toolkit store. FUNCTIONS
setup use Wiki::Toolkit::Setup::MySQL; Wiki::Toolkit::Setup::MySQL::setup($dbname, $dbuser, $dbpass, $dbhost); or Wiki::Toolkit::Setup::Mysql::setup( $dbh ); You can either provide an active database handle $dbh or connection parameters. If you provide connection parameters the following arguments are mandatory -- the database name, the username and the password. The username must be able to create and drop tables in the database. The $dbhost argument is optional -- omit it if the database is local. NOTE: If a table that the module wants to create already exists, "setup" will leave it alone. This means that you can safely run this on an existing Wiki::Toolkit database to bring the schema up to date with the current Wiki::Toolkit version. If you wish to completely start again with a fresh database, run "cleardb" first. cleardb use Wiki::Toolkit::Setup::MySQL; # Clear out all Wiki::Toolkit tables from the database. Wiki::Toolkit::Setup::MySQL::cleardb($dbname, $dbuser, $dbpass, $dbhost); or Wiki::Toolkit::Setup::Mysql::cleardb( $dbh ); You can either provide an active database handle $dbh or connection parameters. If you provide connection parameters the following arguments are mandatory -- the database name, the username and the password. The username must be able to drop tables in the database. The $dbhost argument is optional -- omit if the database is local. Clears out all Wiki::Toolkit store tables from the database. NOTE that this will lose all your data; you probably only want to use this for testing purposes or if you really screwed up somewhere. Note also that it doesn't touch any Wiki::Toolkit search backend tables; if you have any of those in the same or a different database see either Wiki::Toolkit::Setup::DBIxFTS or Wiki::Toolkit::Setup::SII, depending on which search backend you're using. ALTERNATIVE CALLING SYNTAX
As requested by Podmaster. Instead of passing arguments to the methods as ($dbname, $dbuser, $dbpass, $dbhost) you can pass them as ( { dbname => $dbname, dbuser => $dbuser, dbpass => $dbpass, dbhost => $dbhost } ) or indeed as ( { dbh => $dbh } ) Note that's a hashref, not a hash. AUTHOR
Kake Pugh (kake@earth.li). COPYRIGHT
Copyright (C) 2002-2004 Kake Pugh. All Rights Reserved. Copyright (C) 2006-2008 the Wiki::Toolkit team. All Rights Reserved. This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. SEE ALSO
Wiki::Toolkit, Wiki::Toolkit::Setup::DBIxMySQL, Wiki::Toolkit::Setup::SII perl v5.14.2 2011-09-25 Wiki::Toolkit::Setup::MySQL(3pm)