mysql dumping

[Robin]

Hello

I am new to MySQL and I need some sort of assistance. I am trying to export data only from a db using mysqldump. By using same methods I can export both data and its structure; following command I am using:

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

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

I get results when I use this command, but when I am trying to create a file with only data. I get nothing. Can you help me?

[Stanley Fisher]

You want to use –no-create-info option while dumping the data, so it will only dump data from tables. For an example. -> mysqldump -u user_name -p password db name –no-create-info > dumpfile:

[rajan2907]

use this script

backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql