Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    1

    Unanswered: Dumping Table Data to text file

    Hi,

    I would like to know how to change the following syntax in order to create text file that include table’s columns names.

    mysqldump -uuser -ppassword -T with --fields-enclosed-by=' --tab=path-to-some-directory --no-create-info database table

    Thanks,

    Ronen

  2. #2
    Join Date
    Dec 2002
    Posts
    11
    just install phpMyAdmin and it will do it for you.

    you can get it here http://phpmyadmin.sourceforge.net/


    mysqldump -d --database > backup-file.sql


    I believe that will work if you are doing it from the command line.
    Last edited by scoutt; 12-13-02 at 10:29.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •