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 :) Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.