€cdocutils.nodes document q)q}q(U nametypesq}q(X column namesqNXimport and exportqNXopen document spreadsheetqNX table nameq NuUsubstitution_defsq }q Uparse_messagesq ]q Ucurrent_sourceqNU decorationqNUautofootnote_startqKUnameidsq}q(hU column-namesqhUimport-and-exportqhUopen-document-spreadsheetqh U table-namequUchildrenq]qcdocutils.nodes section q)q}q(U rawsourceqUUparentqhUsourceqcdocutils.nodes reprunicode qXS/usr/local/apache2/htdocs/phpmyadmin/release/phpMyAdmin-4.4.8/doc/import_export.rstq …q!}q"bUtagnameq#Usectionq$U attributesq%}q&(Udupnamesq']q(Uclassesq)]q*Ubackrefsq+]q,Uidsq-]q.haUnamesq/]q0hauUlineq1KUdocumentq2hh]q3(cdocutils.nodes title q4)q5}q6(hXImport and exportq7hhhh!h#Utitleq8h%}q9(h']q:h)]q;h+]quh1Kh2hh]q?cdocutils.nodes Text q@XImport and exportqA…qB}qC(hh7hh5ubaubcdocutils.nodes paragraph qD)qE}qF(hXÅ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.qGhhhh!h#U paragraphqHh%}qI(h']qJh)]qKh+]qLh-]qMh/]qNuh1Kh2hh]qOh@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.qP…qQ}qR(hhGhhEubaubh)qS}qT(hUhhhh!h#h$h%}qU(h']qVh)]qWh+]qXh-]qYhah/]qZhauh1Kh2hh]q[(h4)q\}q](hXOpen Document Spreadsheetq^hhShh!h#h8h%}q_(h']q`h)]qah+]qbh-]qch/]qduh1Kh2hh]qeh@XOpen Document Spreadsheetqf…qg}qh(hh^hh\ubaubhD)qi}qj(hX„When importing an ODS speadsheet, the spreadsheet must be named in a specific way in order to make the import as simple as possible.qkhhShh!h#hHh%}ql(h']qmh)]qnh+]qoh-]qph/]qquh1K h2hh]qrh@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.qs…qt}qu(hhkhhiubaubh)qv}qw(hUhhShh!h#h$h%}qx(h']qyh)]qzh+]q{h-]q|hah/]q}h auh1Kh2hh]q~(h4)q}q€(hX Table nameqhhvhh!h#h8h%}q‚(h']qƒh)]q„h+]q…h-]q†h/]q‡uh1Kh2hh]qˆh@X Table nameq‰…qŠ}q‹(hhhhubaubhD)qŒ}q(hX-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).qŽhhvhh!h#hHh%}q(h']qh)]q‘h+]q’h-]q“h/]q”uh1Kh2hh]q•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).q–…q—}q˜(hhŽhhŒubaubeubh)q™}qš(hUhhShh!h#h$h%}q›(h']qœh)]qh+]qžh-]qŸhah/]q hauh1Kh2hh]q¡(h4)q¢}q£(hX Column namesq¤hh™hh!h#h8h%}q¥(h']q¦h)]q§h+]q¨h-]q©h/]qªuh1Kh2hh]q«h@X Column namesq¬…q­}q®(hh¤hh¢ubaubhD)q¯}q°(hXaYou 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±hh™hh!h#hHh%}q²(h']q³h)]q´h+]qµh-]q¶h/]q·uh1Kh2hh]q¸h@XaYou 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»(hh±hh¯ubaubeubeubeubahUU transformerq¼NU footnote_refsq½}q¾Urefnamesq¿}qÀUsymbol_footnotesqÁ]qÂUautofootnote_refsqÃ]qÄUsymbol_footnote_refsqÅ]qÆU citationsqÇ]qÈh2hU current_lineqÉNUtransform_messagesqÊ]qËUreporterqÌNUid_startqÍKU autofootnotesqÎ]qÏU citation_refsqÐ}qÑUindirect_targetsqÒ]qÓUsettingsqÔ(cdocutils.frontend Values qÕoqÖ}q×(Ufootnote_backlinksqØKUrecord_dependenciesqÙNU rfc_base_urlqÚUhttp://tools.ietf.org/html/qÛU tracebackq܈Upep_referencesqÝNUstrip_commentsqÞNU toc_backlinksqßUentryqàU language_codeqáUenqâU datestampqãNU report_levelqäKU _destinationqåNU halt_levelqæKU strip_classesqçNh8NUerror_encoding_error_handlerqèUbackslashreplaceqéUdebugqêNUembed_stylesheetqë‰Uoutput_encoding_error_handlerqìUstrictqíU sectnum_xformqîKUdump_transformsqïNU docinfo_xformqðKUwarning_streamqñNUpep_file_url_templateqòUpep-%04dqóUexit_status_levelqôKUconfigqõNUstrict_visitorqöNUcloak_email_addressesq÷ˆUtrim_footnote_reference_spaceqø‰UenvqùNUdump_pseudo_xmlqúNUexpose_internalsqûNUsectsubtitle_xformqü‰U source_linkqýNUrfc_referencesqþNUoutput_encodingqÿUutf-8rU source_urlrNUinput_encodingrU utf-8-sigrU_disable_configrNU id_prefixrUU tab_widthrKUerror_encodingrUANSI_X3.4-1968rU_sourcer US/usr/local/apache2/htdocs/phpmyadmin/release/phpMyAdmin-4.4.8/doc/import_export.rstr Ugettext_compactr ˆU generatorr NUdump_internalsr NU smart_quotesr‰U pep_base_urlrUhttp://www.python.org/dev/peps/rUsyntax_highlightrUlongrUinput_encoding_error_handlerrhíUauto_id_prefixrUidrUdoctitle_xformr‰Ustrip_elements_with_classesrNU _config_filesr]rUfile_insertion_enabledrKU raw_enabledrKU dump_settingsrNubUsymbol_footnote_startrKUidsr}r(hh™hhShhvhhuUsubstitution_namesr }r!h#h2h%}r"(h']r#h-]r$h+]r%Usourcer&h!h)]r'h/]r(uU footnotesr)]r*Urefidsr+}r,ub.