Jump to content


Photo

MySQL dump to local or text file


  • Please log in to reply
1 reply to this topic

#1 programguru

programguru
  • Members
  • PipPipPip
  • Advanced Member
  • 133 posts

Posted 08 December 2005 - 11:14 PM

Is there a way, from command line linux, to make a copy of a MySQL db into a text file on my local machine, or another directory on the server?

I have been at shell connecting to the MySQL server, but can not figure out how to export the db and create a txt dump file.

Any tips?
THIS FORUM KEEPS PUTTING ME IN MY PLACE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

#2 KrisNz

KrisNz
  • Members
  • PipPipPip
  • Advanced Member
  • 271 posts
  • LocationAuckland, New Zealand

Posted 09 December 2005 - 01:50 AM

[a href=\"http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html\" target=\"_blank\"]Yes.[/a]




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users