146 lines
No EOL
6.1 KiB
HTML
146 lines
No EOL
6.1 KiB
HTML
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
|
|
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
|
|
|
|
|
<html xmlns="http://www.w3.org/1999/xhtml">
|
|
<head>
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
|
|
|
<title>Import and export — phpMyAdmin 4.4.14 documentation</title>
|
|
|
|
<link rel="stylesheet" href="_static/default.css" type="text/css" />
|
|
<link rel="stylesheet" href="_static/pygments.css" type="text/css" />
|
|
|
|
<script type="text/javascript">
|
|
var DOCUMENTATION_OPTIONS = {
|
|
URL_ROOT: './',
|
|
VERSION: '4.4.14',
|
|
COLLAPSE_INDEX: false,
|
|
FILE_SUFFIX: '.html',
|
|
HAS_SOURCE: true
|
|
};
|
|
</script>
|
|
<script type="text/javascript" src="_static/jquery.js"></script>
|
|
<script type="text/javascript" src="_static/underscore.js"></script>
|
|
<script type="text/javascript" src="_static/doctools.js"></script>
|
|
<link rel="copyright" title="Copyright" href="copyright.html" />
|
|
<link rel="top" title="phpMyAdmin 4.4.14 documentation" href="index.html" />
|
|
<link rel="up" title="User Guide" href="user.html" />
|
|
<link rel="next" title="FAQ - Frequently Asked Questions" href="faq.html" />
|
|
<link rel="prev" title="Other sources of information" href="other.html" />
|
|
</head>
|
|
<body>
|
|
<div class="related">
|
|
<h3>Navigation</h3>
|
|
<ul>
|
|
<li class="right" style="margin-right: 10px">
|
|
<a href="genindex.html" title="General Index"
|
|
accesskey="I">index</a></li>
|
|
<li class="right" >
|
|
<a href="faq.html" title="FAQ - Frequently Asked Questions"
|
|
accesskey="N">next</a> |</li>
|
|
<li class="right" >
|
|
<a href="other.html" title="Other sources of information"
|
|
accesskey="P">previous</a> |</li>
|
|
<li><a href="index.html">phpMyAdmin 4.4.14 documentation</a> »</li>
|
|
<li><a href="user.html" accesskey="U">User Guide</a> »</li>
|
|
</ul>
|
|
</div>
|
|
|
|
<div class="document">
|
|
<div class="documentwrapper">
|
|
<div class="bodywrapper">
|
|
<div class="body">
|
|
|
|
<div class="section" id="import-and-export">
|
|
<h1>Import and export<a class="headerlink" href="#import-and-export" title="Permalink to this headline">¶</a></h1>
|
|
<p>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.</p>
|
|
<div class="section" id="open-document-spreadsheet">
|
|
<h2>Open Document Spreadsheet<a class="headerlink" href="#open-document-spreadsheet" title="Permalink to this headline">¶</a></h2>
|
|
<p>When importing an ODS speadsheet, the spreadsheet must be named in a specific way in order to make the
|
|
import as simple as possible.</p>
|
|
<div class="section" id="table-name">
|
|
<h3>Table name<a class="headerlink" href="#table-name" title="Permalink to this headline">¶</a></h3>
|
|
<p>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).</p>
|
|
</div>
|
|
<div class="section" id="column-names">
|
|
<h3>Column names<a class="headerlink" href="#column-names" title="Permalink to this headline">¶</a></h3>
|
|
<p>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.</p>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="sphinxsidebar">
|
|
<div class="sphinxsidebarwrapper">
|
|
<h3><a href="index.html">Table Of Contents</a></h3>
|
|
<ul>
|
|
<li><a class="reference internal" href="#">Import and export</a><ul>
|
|
<li><a class="reference internal" href="#open-document-spreadsheet">Open Document Spreadsheet</a><ul>
|
|
<li><a class="reference internal" href="#table-name">Table name</a></li>
|
|
<li><a class="reference internal" href="#column-names">Column names</a></li>
|
|
</ul>
|
|
</li>
|
|
</ul>
|
|
</li>
|
|
</ul>
|
|
|
|
<h4>Previous topic</h4>
|
|
<p class="topless"><a href="other.html"
|
|
title="previous chapter">Other sources of information</a></p>
|
|
<h4>Next topic</h4>
|
|
<p class="topless"><a href="faq.html"
|
|
title="next chapter">FAQ - Frequently Asked Questions</a></p>
|
|
<h3>This Page</h3>
|
|
<ul class="this-page-menu">
|
|
<li><a href="_sources/import_export.txt"
|
|
rel="nofollow">Show Source</a></li>
|
|
</ul>
|
|
<div id="searchbox" style="display: none">
|
|
<h3>Quick search</h3>
|
|
<form class="search" action="search.html" method="get">
|
|
<input type="text" name="q" />
|
|
<input type="submit" value="Go" />
|
|
<input type="hidden" name="check_keywords" value="yes" />
|
|
<input type="hidden" name="area" value="default" />
|
|
</form>
|
|
<p class="searchtip" style="font-size: 90%">
|
|
Enter search terms or a module, class or function name.
|
|
</p>
|
|
</div>
|
|
<script type="text/javascript">$('#searchbox').show(0);</script>
|
|
</div>
|
|
</div>
|
|
<div class="clearer"></div>
|
|
</div>
|
|
<div class="related">
|
|
<h3>Navigation</h3>
|
|
<ul>
|
|
<li class="right" style="margin-right: 10px">
|
|
<a href="genindex.html" title="General Index"
|
|
>index</a></li>
|
|
<li class="right" >
|
|
<a href="faq.html" title="FAQ - Frequently Asked Questions"
|
|
>next</a> |</li>
|
|
<li class="right" >
|
|
<a href="other.html" title="Other sources of information"
|
|
>previous</a> |</li>
|
|
<li><a href="index.html">phpMyAdmin 4.4.14 documentation</a> »</li>
|
|
<li><a href="user.html" >User Guide</a> »</li>
|
|
</ul>
|
|
</div>
|
|
<div class="footer">
|
|
© <a href="copyright.html">Copyright</a> 2012 - 2014, The phpMyAdmin devel team.
|
|
Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.2.3.
|
|
</div>
|
|
</body>
|
|
</html> |