need help with mysqldump...

[Justin Fox]

ok I have phptriad.

and I need to make a dump file of my mysql database so I can connect to it via php.

I've tried a million different ways, and nothing seems to work.

This is what I last tried.

    
 
mysql> mysqldump -u root -p --databases mycustomballs > backup.sql;
 

now, it says I have a syntax error and thats it, no specification or anything like that.

and also when i do:

    
 
$connection = mysql_connect("localhost","username","password");
// is that the username and password to the database?
 

Thanks for the help,

Justin Fox

[Paul Campbell]

Two things... there shouldn't be a space between -u and root.

If you are in windows do the following.

mysqldump is standalone application

Copy the path to your MySQL bin folder.

Open a command prompt

Paste your path and type mysqldump -uroot -p mycustomballs >backup.sql
Enter your password