Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2011
    Posts
    4

    Exclamation Unanswered: dumping mysql file

    Hi,

    Im new to this forum and I need some help. Im trying to export only data from a database using mysqldump method. In a similar use of this method I can export both data and structure using the commant below:


    Code:
    $creatBackup = "c:/xampp/mysql/bin/mysqldump.exe -u ".$username." --password=".$password." ".$db_name." applications> ".$backupFile;

    Where:
    $username = database username
    $password = database password
    $db_name = database name
    $backupFile = file name + path

    When I use this command, I get a result. But when Im trying to create a file with only data I take nothing. Please help me!!!!!

  2. #2
    Join Date
    May 2011
    Posts
    11

    dumping mysql file

    Hi,

    Use --no-create-info option while dumping data, it will dump only data from tables.

    Ex:

    -> mysqldump -u username -p password databasename --no-create-info > dumpfile;

  3. #3
    Join Date
    Jun 2011
    Posts
    4
    Quote Originally Posted by Harisankar.A View Post
    -> mysqldump -u username -p password databasename --no-create-info > dumpfile;
    thanks a lot that was exactly what I was looking for... thanks again for your help and sorry for my delay to answer you...

Posting Permissions

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