Hi All

We use mysql to store customer order data. Each day's orders are added to the same mysql db.

So, for example, the whole year could all be in that one db.

What we're trying to do is select out a single day's orders from the monster db and dump just that day's orders to a file or to the monitor.

We would also like to format that dump with our choice of delimiter, etc., just like with the dump utility in Mysqlman.

Is it possible to select out data by date and have it dumped to either a file or to the monitor?

Many thanks.

------------------------------------------

Hi,

If you do a select, then you should see a link 'Save Result'. Click on this and you can export the contents of your select to a file.

Cheers,

Alex
--
Gossamer Threads Inc.

Hi Alex

Thanks for your reply.

Actually, what I'm trying to do is dump only a portion of a selected table.

The sample db has fields like the following:

Date
Name
Order_Contents
Shipping_Address

All order data is stored in this db. So, a full year's data could be there.

What I'm trying to do is select out the orders for, say, 04-JUL-01 and dump just that day's order data to a file.

I know how to dump the entire table. That's not a problem. It's trying to slice out just one day at a time that I can't figure out.

Is dumping a slice do-able?

Many thanks.

------------------------------------------

Yes, you click on Select, check off the field names you want, then add in the where clause (so only the day you want is selected), run the select, and on the next screen is a link "Save Result". This will let you save your search to a file.

Cheers,

Alex
--
Gossamer Threads Inc.

Hi Alex

Thanks for your help.

I have to admit that I'm struggling with this one.

Here is what I'm doing:

1. Login

2. Databases displayed

3. Select db

4. Select Mysql Dump

5. "Select Tables" - check off desired tables

6. At this point, I don't see any place to enter a "Where" clause. This is as far as I have gotten.

=====

Also, when I try to dump to either the screen or a writeable file, I am denied.


Is this because my host will not allow this?

Thanks, Alex.

------------------------------------------

** bump **

------------------------------------------