RE: mysqldump question

2002-07-23 Thread Bill Bernat
IL 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

mysqldump question

2002-07-15 Thread Bill Bernat
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 -ur

RE: watch batch?

2002-07-08 Thread Bill Bernat
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

two mysql questions

2002-07-02 Thread Bill Bernat
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 Wind

RE: URL for detailed description of SQL left/right inner/outer join concepts?

2002-07-01 Thread Bill Bernat
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:

RE: er diagramming

2002-07-01 Thread Bill Bernat
x27;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

er diagramming

2002-07-01 Thread Bill Bernat
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 -- alon

SQL Server design

2002-06-18 Thread Bill Bernat
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