<div>
This message appears when PHP MyAdmin completes the import. &nbsp; It ignores 2 records.<br />
<br />
&nbsp;Import has been successfully finished, 5 queries executed. (participants-database-Aug<wbr />ust-12-201<wbr />6.csv)
</div>


This message appears when PHP MyAdmin completes the import.   It ignores 2 records.

 Import has been successfully finished, 5 queries executed. (participants-database-August-12-2016.csv)

<div>
Never mind the 5 vs 7 records imported. &nbsp;Solved that one.<br />
<br />
Still wondering if this method is the best to get files from WordPress thru PHP MyAdmin to the host db.
</div>


Never mind the 5 vs 7 records imported.  Solved that one.

Still wondering if this method is the best to get files from WordPress thru PHP MyAdmin to the host db.

<div>
Thanks Jason! &nbsp;You've given me a focused direction.
</div>


Thanks Jason!  You've given me a focused direction.

<div>
<div class="content wysiwyg-content">
I have exported Website data from Wordpress into a Linux LibreOffice &nbsp;Calc file in CSV format (which cannot be opened with Calc), and then imported that CSV data &nbsp;into the hosting database using PHP MyAdmin. &nbsp;Is this a common method, and why is it downloading only 5 rows of data, when 7 rows appear on Wordpress Participants Database?
</div>
</div>


I have exported Website data from Wordpress into a Linux LibreOffice  Calc file in CSV format (which cannot be opened with Calc), and then imported that CSV data  into the hosting database using PHP MyAdmin.  Is this a common method, and why is it downloading only 5 rows of data, when 7 rows appear on Wordpress Participants Database?

Wordpress data download

WordPress is a free and open-source content management system (CMS) based on PHP and MySQL for creating websites and blogs. Features include a plugin architecture, a template system and strong management, customization and search systems; through its dynamic presentation of content, webmasters have the flexibility to create websites easily.

WordPress

LibreOffice is a free and open source office suite. The LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. It is available in 110 languages. LibreOffice uses the international ISO/IEC standard OpenDocument file format as its native format to save documents for all of its applications. LibreOffice is also compatible with other major office suites through a variety of import/export filters. LibreOffice is available for a variety of computing platforms, including Windows, OS X) and Linux.

LibreOffice

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.