Wordpress data download

Member_2_7968517
Member_2_7968517 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
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)

Author

Commented:
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.
Don't talk to me.
Commented:
No, it isn't. The best way would be to use PHPmyadmin on the source site to dump the entire WordPress database in SQL format then import that file at the target.

If you need to alter the data before import, SQL filters are just text so any decent text editor will do.

If you can't use PHPmyadmin on the source, then use a plugin like Backup Buddy to effect a transfer

Author

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial