PHPMyAdmin dump correct syntax ( I am in trouble!)

[cabernet]

Hello
I cannot remember and do not find example on how correctly write in PHPMyAdmin the following
I need to perform a mysqldump from a given table (that is the one presently selected in PHPMyAdmin; so I think the table name does not need to be again typed in the query)

<<
mysqldump WHERE 'sectionID=4';
>>
obviously it does not work

I need to get that dump from my archives for I made the wrong move earlier with active files- not the brightest move! -

 

[thedaver]

I don't believe that you can selectively dump a table. You can dump the whole table and take the output text file offline and grep for the matches you require.

You could potentially do a &quot;select into&quot; for the fields from your current table and store them in a temp table. You could then dump that temp table which would only have the records you wanted....

Surfinbox.com Business Internet Services - National Dialup, DSL, T-1 and more.

http://www.surfinbox.com/business/

 

[cabernet]

Good point yes I may dump the whole thing in a temp
and filter it out
that will presently help me

however I looked in the PHP manual and yes with dump one may add as option a &quot;where clause&quot;
still the question is how to write it correctly

thanks

 

[sleipnir214]

cabernet:
MySQL's SELECT...INTO OUTFILE will allow you to selectively dump records from a table into a file. (

http://www.mysql.com/doc/en/SELECT.html)

What PHP function are you talking about?



Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[cabernet]

I was trying to use mysqldump within a query originated from within PHPMyAdmin
as per the PHP manual (not the PHPmyAdmin manual)
it is ok to use a where clause with mysqldump

I tried a few ways of writing the query but none worked

the reason is fortuantely I have an archive but
(my mistake when I did set it) the archives do archive

everything so I need to get my data selectively from
archive where sectionID=...
thanks