dumping mysql file

pplastiras · #1 (**permalink**) 06-29-11, 05:49

Hi,

I’m new to this forum and I need some help. I’m 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 I’m trying to create a file with only data I take nothing. Please help me!!!!!

Harisankar.A · #2 (**permalink**) 07-04-11, 03:33

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;