Export/Import mySQL query with PHP

Question

I'm looking to implement an Export/Import feature in a WordPress Plug-in. The only scenario that I can think of, is exporting the data after querying the database to some format and then re-reading it (for import) and creating a query with that data.

I'm thinking if there is a shortcut for that. What I want basically is a function to get the SQL query of the data I have in the database and then execute it when importing. This is basically the same function in PHPmyAdmin that exports the database.

Anyone have an idea?

Dereleased · Accepted Answer · 2011-04-19 21:31:33Z

3

Check out MySQL's SELECT Syntax, specifically the ... INTO OUTFILE portion. Couple that with MySQL's LOAD DATA INFILE Syntax and you might be in business.

answered Apr 19, 2011 at 21:31

Dereleased

10.1k3 gold badges39 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export/Import mySQL query with PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related