Hi fellows, I have the following condition in front of me: Have to select all the data from the client machine, where dbase is used to store the data. Then this data has to be imported in the mysql database server. How can I accomplish it?
Thanks in advance to the suggesting guys... Animesh
I'd export as CSV
you can use mysqldump -u blah -p pass databasename > ./filename.sql
then, to re-create the database
mysql>create databasename;
mysql>grant * ..... mysql>flush privileges;
prompt>mysql -u blah -p pass databasename < ./filename.sql
