A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
need help with mysqldump...
Joined: Jan 24, 2006
Dec 08, 2007 10:40:00
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,
You down with OOP? Yeah you know me!
Joined: Oct 06, 2007
Dec 08, 2007 15:46:00
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
I agree. Here's the link:
subject: need help with mysqldump...
MySql db: how to backup data only and backup tables only
Login and Sessions
export database in mysql
copy of existing database
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014