Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 7. Importing Structure and Data > Importing other formats
Importing other formats
In addition to SQL and CSV formats, phpMyAdmin can import Open Document Spreadsheet and XML files. However, these files need to have been exported by phpMyAdmin itself, or closely follow what phpMyAdmin does when exporting.
Open Document Spreadsheet
By default, when we export via phpMyAdmin in this format, the Put column names in the first row option is not marked. This means that the exported file contains only data. At import time, a corresponding option The first line of the file contains the table column names is offered and should not be marked if the file does not contain the column names in its first line.
