Gary, > [h24-85-217-157:/usr/local/bin] garydr% mysqldump -h localhost -u root > bpw_db>bpw_db_backup.sql > bpw_db_backup.sql: Permission denied.
This means that MySQL is not allowed to write in this directory. Which directory? ;-) Well, as you don't specify a path, bpw_db_backup.sql will be created in the bin/ subdirectory of your MySQL installation directory, because the mysqldump executable is located there. > I have no idea what's going on. I understand that this command should create > an sql file with my database structure and data in it. Sounds good. However, > I can't run the command. mysqldump -u root bpw_db > some-nice-directory/bpw_db_backup.sql should do the trick, where "some-nice-directory" is a location where the MySQL server has write access. (BTW, you don't have to specify "-h localhost" when it's localhost.) > I read in a manual I could get help as follows: > [h24-85-217-157:/usr/local/bin] garydr% mysqldump --help > mysqldump: Command not found. This is strange. As I can see above, mysqldump was found in the first place. > Can anyone help me, or direct me to a good source of information related to > running mysql on OS X? For example, I can't figure out where in my system > the mysql database files are located. If I could, at least I could just make > backup copies to CD. If you want a better understanding about MySQL, and you have half an hour to spend, read this: http://www.mysql.com/articles/mysql_intro.html For mysqldump, the manual is here: http://www.mysql.com/doc/en/mysqldump.html If you want to find out where your database directory is, you can start the mysql client tool (named mysql, in exactly the same location where mysqldump is), and issue: SHOW VARIABLES LIKE 'datadir'; If you're not able to locate where all the MySQL binaries are, you can try: which mysqld AFAIK, OS X is Unix, so this should work. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Gary Reimer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 01, 2003 4:12 AM Subject: New user on OS X > I'm a new mysql user running on OS X. I have set up a test database and am > trying to use mysqldump to create a backup. However here is what happens: > > [h24-85-217-157:/usr/local/bin] garydr% mysqldump -h localhost -u root > bpw_db>bpw_db_backup.sql > > bpw_db_backup.sql: Permission denied. > > I have no idea what's going on. I understand that this command should create > an sql file with my database structure and data in it. Sounds good. However, > I can't run the command. > > I read in a manual I could get help as follows: > > [h24-85-217-157:/usr/local/bin] garydr% mysqldump --help > mysqldump: Command not found. > > But as you can see, it doesn't work. > > Can anyone help me, or direct me to a good source of information related to > running mysql on OS X? For example, I can't figure out where in my system > the mysql database files are located. If I could, at least I could just make > backup copies to CD. > > Any help would be greatly appreciated. > > Thanks in advance, > Gary > > -- > Gary Reimer > Winnipeg MB Canada > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
