Re: Easiest way to create a duplicate of a db?

2001-07-10 Thread Jack Challen
would most likely have to make the edits by hand to products.sql. or in keeping with my 'dangerous ideas' theme: mysqldump products | grep s/products/products1/ mysql (I am rusty on my regex so I'd check that s// expression before I used it) You'd want to use sed, not grep. -- Jack

Re: Hello please help me out

2001-06-28 Thread Jack Challen
[EMAIL PROTECTED] wrote: try echo file.sql mysql -u username -p password databasename You mean: ^ cat file.sql | mysql -u username -p password databasename ^ Or, better: mysql -u username -p password databasename file.sql -- Jack Challen

Re: Compiling MySQL 3.23.39 on HP-UX 11.00.

2001-06-25 Thread Jack Challen
Michael Widenius wrote: Jack Configure Command: Jack -- Jack CFLAGS=-D_REENTRANT Jack CXXFLAGS=-D_REENTRANT \ Jack ./configure Jack --prefix=/opt/mysql Jack \ Jack --with-pthread Jack --with-named-thread-libs=-lpthread

Re: Compiling MySQL 3.23.39 on HP-UX 11.00.

2001-06-21 Thread Jack Challen
ok, good call :) Ran the mysql-test (it failed some), details below: FAILURES: $./mysql-test-run --force 2/dev/null | grep \[ fail \] rpl01 [ fail ] rpl04 [ fail ] rpl07

Compiling MySQL 3.23.39 on HP-UX 11.00.

2001-06-20 Thread Jack Challen
Hi, First of all, this is irrelevant if you're not using HP-UX. Second, apologies if this isn't the correct list, but I've been unable to find a more suitable one. This is just some info on how I got Mysql-3.23.39 to compile on HP-UX 11.00 using gcc, because I