diff options
author | Michal Čihař <mcihar@suse.cz> | 2012-11-12 11:59:53 +0400 |
---|---|---|
committer | Michal Čihař <mcihar@suse.cz> | 2012-11-12 11:59:53 +0400 |
commit | 937a3778215fbdc39e40f72ea967e1a9eb698e29 (patch) | |
tree | c5f31a43ee74ea747f28b77a31bf2a19b18d4860 /doc/intro.rst | |
parent | f5b862c36f51c693afae40067b938b6a602d3968 (diff) |
Move to doc directory
Diffstat (limited to 'doc/intro.rst')
-rw-r--r-- | doc/intro.rst | 71 |
1 files changed, 71 insertions, 0 deletions
diff --git a/doc/intro.rst b/doc/intro.rst new file mode 100644 index 0000000000..2613379a7f --- /dev/null +++ b/doc/intro.rst @@ -0,0 +1,71 @@ +.. _intro: + +Introduction +============ + +phpMyAdmin can manage a whole MySQL server (needs a super-user) as +well as a single database. To accomplish the latter you'll need a +properly set up MySQL user who can read/write only the desired +database. It's up to you to look up the appropriate part in the MySQL +manual. + + +Currently phpMyAdmin can: ++++++++++++++++++++++++++ + +* browse and drop databases, tables, views, columns and indexes +* display multiple results sets through stored procedures or queries +* create, copy, drop, rename and alter databases, tables, columns and + indexes +* maintenance server, databases and tables, with proposals on server + configuration +* execute, edit and bookmark any :abbr:`SQL (structured query + language)`-statement, even batch-queries +* load text files into tables +* create [#f1]_ and read dumps of tables +* export [#f1]_ data to various formats: :term:`CSV`, + :term:`XML`, :term:`PDF`, :abbr:`ISO (International Standards + Organisation)`/:abbr:`IEC (International Electrotechnical Commission)` + 26300 - OpenDocument Text and Spreadsheet, :abbr:`Word (Microsoft Word + 2000)`, and LATEX formats +* import data and :term:`MySQL` structures from :term:`OpenDocument` spreadsheets, as + well as :term:`XML`, :term:`CSV`, and :term:`SQL` files +* administer multiple servers +* manage MySQL users and privileges +* check referential integrity in MyISAM tables +* using Query-by-example (QBE), create complex queries automatically + connecting required tables +* create :abbr:`PDF (Portable Document Format)` graphics of your + Database layout +* search globally in a database or a subset of it +* transform stored data into any format using a set of predefined + functions, like displaying BLOB-data as image or download-link +* track changes on databases, tables and views +* support InnoDB tables and foreign keys see :ref:`faq3_6` +* support mysqli, the improved MySQL extension see :ref:`faq1_17` +* create, edit, call, export and drop stored procedures and functions +* create, edit, export and drop events and triggers +* communicate in `62 different languages + <http://www.phpmyadmin.net/home_page/translations.php>`_ +* synchronize two databases residing on the same as well as remote + servers see :ref:`faq9_1` + + +A word about users: +------------------- + +Many people have difficulty understanding the concept of user +management with regards to phpMyAdmin. When a user logs in to +phpMyAdmin, that username and password are passed directly to MySQL. +phpMyAdmin does no account management on its own (other than allowing +one to manipulate the MySQL user account information); all users must +be valid MySQL users. + +.. rubric:: Footnotes + +.. [#f1] + + phpMyAdmin can compress (:term:`Zip`, :term:`GZip` :term:`RFC 1952` or + :term:`Bzip2` formats) dumps and :term:`CSV` exports if you use PHP with + :term:`Zlib` support (``--with-zlib``) and/or :term:`Bzip2` support + (``--with-bz2``). Proper support may also need changes in :file:`php.ini`. |