fr@nkie Posted November 7, 2006 Share Posted November 7, 2006 Hi. I have a database MySQL in a server, and I am building a application where I can copy a part of the database from the server to my pc (for example, all clients with the name "peter"), and after this I want to add that especific information to my local database in MySQL.What the better way to do this? Save the information in a file and open it with the program? And what kind of file?Thanks a lot :) Link to comment https://forums.phpfreaks.com/topic/26403-mysql-database-export/ Share on other sites More sharing options...
fenway Posted November 7, 2006 Share Posted November 7, 2006 Well, mysqldump with produce an SQL-style text file export; if you want something like CSV, you can SELECT.... INTO OUTFILE... with appropriate parameters. As for XML, I've never tried; I'm sure someone's written a script for this, though it wouldn't be to difficult to roll-your-own. Link to comment https://forums.phpfreaks.com/topic/26403-mysql-database-export/#findComment-120896 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.