€cdocutils.nodes
document
q)q}q(U	nametypesq}q(X   column namesqNX   import and exportqNX   open document spreadsheetqNX
   table nameq	NuUsubstitution_defsq
}qUparse_messagesq]qUcurrent_sourceqNU
decorationqNUautofootnote_startqKUnameidsq}q(hUcolumn-namesqhUimport-and-exportqhUopen-document-spreadsheetqh	U
table-namequUchildrenq]qcdocutils.nodes
section
q)q}q(U	rawsourceqU UparentqhUsourceqXK   /mnt/autrexfs/phpmyadmin/release/phpMyAdmin-4.5.0-rc1/doc/import_export.rstqUtagnameq Usectionq!U
attributesq"}q#(Udupnamesq$]Uclassesq%]Ubackrefsq&]Uidsq']q(haUnamesq)]q*hauUlineq+KUdocumentq,hh]q-(cdocutils.nodes
title
q.)q/}q0(hX   Import and exportq1hhhhh Utitleq2h"}q3(h$]h%]h&]h']h)]uh+Kh,hh]q4cdocutils.nodes
Text
q5X   Import and exportq6…q7}q8(hh1hh/ubaubcdocutils.nodes
paragraph
q9)q:}q;(hXÅ   In addition to the standard Import and Export tab, you can also import an SQL file directly by dragging and dropping
it from your local file manager to the phpMyAdmin interface in your web browser.q<hhhhh U	paragraphq=h"}q>(h$]h%]h&]h']h)]uh+Kh,hh]q?h5XÅ   In addition to the standard Import and Export tab, you can also import an SQL file directly by dragging and dropping
it from your local file manager to the phpMyAdmin interface in your web browser.q@…qA}qB(hh<hh:ubaubh)qC}qD(hU hhhhh h!h"}qE(h$]h%]h&]h']qFhah)]qGhauh+Kh,hh]qH(h.)qI}qJ(hX   Open Document SpreadsheetqKhhChhh h2h"}qL(h$]h%]h&]h']h)]uh+Kh,hh]qMh5X   Open Document SpreadsheetqN…qO}qP(hhKhhIubaubh9)qQ}qR(hX„   When importing an ODS speadsheet, the spreadsheet must be named in a specific way in order to make the
import as simple as possible.qShhChhh h=h"}qT(h$]h%]h&]h']h)]uh+K
h,hh]qUh5X„   When importing an ODS speadsheet, the spreadsheet must be named in a specific way in order to make the
import as simple as possible.qV…qW}qX(hhShhQubaubh)qY}qZ(hU hhChhh h!h"}q[(h$]h%]h&]h']q\hah)]q]h	auh+Kh,hh]q^(h.)q_}q`(hX
   Table nameqahhYhhh h2h"}qb(h$]h%]h&]h']h)]uh+Kh,hh]qch5X
   Table nameqd…qe}qf(hhahh_ubaubh9)qg}qh(hX-  During import, phpMyAdmin uses the sheet name as the table name; you should rename the
sheet in your spreadsheet program in order to match your existing table name (or the table you wish to create,
though this is less of a concern since you could quickly rename the new table from the Operations tab).qihhYhhh h=h"}qj(h$]h%]h&]h']h)]uh+Kh,hh]qkh5X-  During import, phpMyAdmin uses the sheet name as the table name; you should rename the
sheet in your spreadsheet program in order to match your existing table name (or the table you wish to create,
though this is less of a concern since you could quickly rename the new table from the Operations tab).ql…qm}qn(hhihhgubaubeubh)qo}qp(hU hhChhh h!h"}qq(h$]h%]h&]h']qrhah)]qshauh+Kh,hh]qt(h.)qu}qv(hX   Column namesqwhhohhh h2h"}qx(h$]h%]h&]h']h)]uh+Kh,hh]qyh5X   Column namesqz…q{}q|(hhwhhuubaubh9)q}}q~(hXa  You should also make the first row of your spreadsheet a header with the names of the columns (this can be
accomplished by inserting a new row at the top of your spreadsheet). When on the Import screen, select the
checkbox for "The first line of the file contains the table column names;" this way your newly imported
data will go to the proper columns.qhhohhh h=h"}q€(h$]h%]h&]h']h)]uh+Kh,hh]qh5Xa  You should also make the first row of your spreadsheet a header with the names of the columns (this can be
accomplished by inserting a new row at the top of your spreadsheet). When on the Import screen, select the
checkbox for "The first line of the file contains the table column names;" this way your newly imported
data will go to the proper columns.q‚…qƒ}q„(hhhh}ubaubeubeubeubahU Utransformerq…NUfootnote_refsq†}q‡Urefnamesqˆ}q‰Usymbol_footnotesqŠ]q‹Uautofootnote_refsqŒ]qUsymbol_footnote_refsqŽ]qU	citationsq]q‘h,hUcurrent_lineq’NUtransform_messagesq“]q”Ureporterq•NUid_startq–KUautofootnotesq—]q˜Ucitation_refsq™}qšUindirect_targetsq›]qœUsettingsq(cdocutils.frontend
Values
qžoqŸ}q (Ufootnote_backlinksq¡KUrecord_dependenciesq¢NUrfc_base_urlq£Uhttp://tools.ietf.org/html/q¤U	tracebackq¥ˆUpep_referencesq¦NUstrip_commentsq§NUtoc_backlinksq¨Uentryq©Ulanguage_codeqªUenq«U	datestampq¬NUreport_levelq­KU_destinationq®NU
halt_levelq¯KUstrip_classesq°Nh2NUerror_encoding_error_handlerq±Ubackslashreplaceq²Udebugq³NUembed_stylesheetq´‰Uoutput_encoding_error_handlerqµUstrictq¶Usectnum_xformq·KUdump_transformsq¸NUdocinfo_xformq¹KUwarning_streamqºNUpep_file_url_templateq»Upep-%04dq¼Uexit_status_levelq½KUconfigq¾NUstrict_visitorq¿NUcloak_email_addressesqÀˆUtrim_footnote_reference_spaceqÁ‰UenvqÂNUdump_pseudo_xmlqÃNUexpose_internalsqÄNUsectsubtitle_xformqÅ‰Usource_linkqÆNUrfc_referencesqÇNUoutput_encodingqÈUutf-8qÉU
source_urlqÊNUinput_encodingqËU	utf-8-sigqÌU_disable_configqÍNU	id_prefixqÎU U	tab_widthqÏKUerror_encodingqÐUANSI_X3.4-1968qÑU_sourceqÒhUgettext_compactqÓˆU	generatorqÔNUdump_internalsqÕNUsmart_quotesqÖ‰Upep_base_urlq×Uhttp://www.python.org/dev/peps/qØUsyntax_highlightqÙUlongqÚUinput_encoding_error_handlerqÛh¶Uauto_id_prefixqÜUidqÝUdoctitle_xformqÞ‰Ustrip_elements_with_classesqßNU_config_filesqà]qáUfile_insertion_enabledqâˆUraw_enabledqãKUdump_settingsqäNubUsymbol_footnote_startqåK Uidsqæ}qç(hhohhChhYhhuUsubstitution_namesqè}qéh h,h"}qê(h$]h']h&]Usourcehh%]h)]uU	footnotesqë]qìUrefidsqí}qîub.