RE: mysqldump question
Hey, thanks *so* much for checking into this. Your message did help. In case you're curious. First, I had the admin create a 777 dump directory from root. Still couldn't write out. Then, though, I just tried going to /tmp as you had done, and that was fine. /tmp -- I feel like an idiot, but at least I'm an idiot who can dump the database now:) Also, do you happen to know how old is 3.23.21-beta-log? Our MYSQL is old, but I can't find out how old, is there a version history online anywhere? -billb -Original Message- From: Diana Soares [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 3:22 AM To: Bill Bernat Cc: [EMAIL PROTECTED] Subject: Re: mysqldump question On Tue, 2002-07-16 at 02:31, Bill Bernat wrote: Question: is there anything I need to be aware of when writing dump files to a local directory for my user, I'm having the following problem. 1. I create a directory in my own home directory (linux, red hat 7.2) ~/dumps and give it 777 permissions 2. I run /usr/local/mysql/bin/mysqldump -uroot -ppass --tab ~/dumps dbname table1 table2 3. The .sql file for table1 gets created, correctly, in the dumps directory fine. 4. mysqldump pukes when trying to write the .txt file: /usr/local/mysql/bin/mysqldump: Got error: 1: Can't create/write to file '/home/bbernat/dumps/customer_relations_database.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE' QUESTION: What have I done wrong and how can I fix it? Hi, I was curious about your problem and decided to try it. As user root (in the filesystem, redhat7.2), i created the dir ~/dumps with 777 permissions and have run root@cartman:~# mysqldump -uroot -p --tab ~/dumps/ test (root mysqluser has FILE permissions). It gave me the same error. Then i tried with a common filesystem user (dsoares): dsoares@cartman:~$ mysqldump -uroot -p --tab ~/dumps/ test And it worked! I went to see my /root permissions and it was: dsoares@cartman:~$ ll -d /root/ drwxr-x--- 31 root root 4096 Jul 16 11:09 /root/ So the problem was there! mysql user doesn't have permissions to access /root directory. Maybe this is your problem. (also as root i tried with /tmp/dumps directory, 777 permissions, and it worked.) -- Diana Soares - 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
mysqldump question
Question: is there anything I need to be aware of when writing dump files to a local directory for my user, I'm having the following problem. 1. I create a directory in my own home directory (linux, red hat 7.2) ~/dumps and give it 777 permissions 2. I run /usr/local/mysql/bin/mysqldump -uroot -ppass --tab ~/dumps dbname table1 table2 3. The .sql file for table1 gets created, correctly, in the dumps directory fine. 4. mysqldump pukes when trying to write the .txt file: /usr/local/mysql/bin/mysqldump: Got error: 1: Can't create/write to file '/home/bbernat/dumps/customer_relations_database.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE' QUESTION: What have I done wrong and how can I fix it? Thanks for any help! -billb - 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
RE: watch batch?
If I want to run a batch (shell mysql batch-file | more) and have the script echoed out to the terminal as it runs so that I can more easily locate my error(s), how can I do that? Normal operation just shows errors and that's not enough to uniquely identify the problem in this case, there must be a way, some sort of shell command? I know I can just comment out or run in pieces, but thought I'd ask Thanks, -billb - 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
two mysql questions
1. If all I want to do is use InnoDB tables for declarative referential integrity and nothing else, do I need mysql-max or can I just use the standard build of mysql 3.23.51? (Wondering about both Windows and Linus, though the answer should be the same in both places) 2. What's the best Windows based MySQL GUI out there, without regard to price? Thanks, -billb - 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
er diagramming
ERwin, in which I did the logical data model for a MySQL database, doesn't support MySQL data types or specific MySQL code export. Do any tools? Notepad and vi look like my best physical design tools at this point, which is okay. But I wanted to be sure I wasn't missing anything out there -- along the lines of ERwin but with MySQL support. Thanks. -billb - 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
RE: er diagramming
Yeah, found it (per your other message), Dezign for Databases, looks great for what I need to do and although I haven't had a chance to do much with it it seems to work for basic entity relationships. I never seem to use the full $3000++ functionality of Erwin/ER Designer, etc., which don't have MySQL support ... eventually they'll have to add it though. -billb -Original Message- From: MikeParton [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 2:11 PM To: Bill Bernat; [EMAIL PROTECTED] Subject: Re: er diagramming Somewhere within www.mysql.com is a link to a site that has an ERD tool that supports MySQL...think the name is Dezigner or EasyDezign or something like that. Search through the MySQL site and you'll find it. Free trial version (limited entities) and the full tool isn't very expensive. - Original Message - From: Bill Bernat [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 01, 2002 3:25 PM Subject: er diagramming ERwin, in which I did the logical data model for a MySQL database, doesn't support MySQL data types or specific MySQL code export. Do any tools? Notepad and vi look like my best physical design tools at this point, which is okay. But I wanted to be sure I wasn't missing anything out there -- along the lines of ERwin but with MySQL support. Thanks. -billb - 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
RE: URL for detailed description of SQL left/right inner/outer join concepts?
Books on Line for Microsoft SQL server explain it nicely, and are free whether you use SQL Server or not at http://www.microsoft.com/sql/techinfo/productdoc/2000/default.asp -billb -Original Message- From: David M. Karr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 3:56 PM To: [EMAIL PROTECTED] Subject: URL for detailed description of SQL left/right inner/outer join concepts? Is there a good URL that explains in detail exactly the concepts of SQL left/right inner/outer join? I've found several that give very high-level hints, but nothing that really summarizes exactly what these do. -- === David M. Karr ; Java/J2EE/XML/Unix/C++ [EMAIL PROTECTED] - 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
SQL Server design
Okay, suppose I know all about SQL Server 2000 design and what is and isn't good and I'm suddenly tasked with designing a MYSQL database tomorrow. Are there any guidelines for design that I should note? Obvious things are don't count on transactional/relational integrity to be enforced by the database and don't rely on a data structure that demands subselects for performance. Other than that, doesn't seem to be an major limitations, but I won't know till I've built such a thing and thus I'm looking to the list to benefit from the MYSQL design experience of others. Thanks, -billb - 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