WikiSysop: Update external links

2023-11-05T20:44:41Z

Update external links

← Older revision		Revision as of 22:44, 5 November 2023
Line 24:		Line 24:
	=== Listing existing MySQL tables ===		=== Listing existing MySQL tables ===

	The following command illustrates one method to list the tables contained in an existing MySQL database using the <code>[~~http~~://dev.mysql.com/doc/refman/5.0/en/mysqlshow.html mysqlshow]</code> command.		The following command illustrates one method to list the tables contained in an existing MySQL database using the <code>[https://dev.mysql.com/doc/refman/8.0/en/mysqlshow.html mysqlshow]</code> command.

	mysqlshow -h DATABASE.SERVER.COM -u USER_NAME -p DATABASE_NAME		mysqlshow -h DATABASE.SERVER.COM -u USER_NAME -p DATABASE_NAME

WikiSysop: Hide section edit links

2023-11-05T20:41:42Z

Hide section edit links

← Older revision		Revision as of 22:41, 5 November 2023
Line 37:		Line 37:

	[[Category:Database Information]]		[[Category:Database Information]]
			__NOEDITSECTION__

WikiSysop: Original page content from 13-Mar-2007

2023-11-05T20:36:40Z

Original page content from 13-Mar-2007

New page

MySQL tables used by refbase:

* [[Table auth|auth]]
* [[Table deleted|deleted]]
* [[Table depends|depends]]
* [[Table formats|formats]]
* [[Table languages|languages]]
* [[Table queries|queries]]
* [[Table refs|refs]]
* [[Table styles|styles]]
* [[Table types|types]]
* [[Table user_data|user_data]]
* [[Table user_formats|user_formats]]
* [[Table user_options|user_options]]
* [[Table user_permissions|user_permissions]]
* [[Table user_styles|user_styles]]
* [[Table user_types|user_types]]
* [[Table users|users]]

== Note ==

As of refbase 0.9.0 installation via the web interface (''install.php'') does not offer to set a MySQL table prefix which permits multiple instances of refbase to coexist within a single database, or to install refbase into an existing database. However, refbase table names can be renamed in files ''initialize/db.inc.php'' & ''install.sql'' (or ''update.sql'') to avoid any name conflicts with existing database tables. See [[Installing refbase#Installation over an existing database|Installation over an existing database]] for more info.

=== Listing existing MySQL tables ===

The following command illustrates one method to list the tables contained in an existing MySQL database using the <code>[http://dev.mysql.com/doc/refman/5.0/en/mysqlshow.html mysqlshow]</code> command.

mysqlshow -h DATABASE.SERVER.COM -u USER_NAME -p DATABASE_NAME

Items in uppercase must be adjusted to suit your setup. The <code>-h DATABASE.SERVER.COM</code> argument is not required to access a database on a localhost. A <code>USER_NAME</code> with read permission suffices. Note that MySQL special characters in the <code>DATABASE_NAME</code> (such as the _ underscore character) require shell escapes. Example: With ''litwww'' being an authorized MySQL user and ''literature'' as the name of your local refbase database, your command would read:

mysqlshow -h localhost -u litwww -p literature

Alternatively, you could use a tool such as [http://www.phpmyadmin.net/ phpMyAdmin] or run the MySQL command line interpreter and execute this MySQL command:

show tables from DATABASE_NAME;

[[Category:Database Information]]

MySQL tables - Revision history

WikiSysop: Update external links

WikiSysop: Hide section edit links

WikiSysop: Original page content from 13-Mar-2007