Hello.
On Tue 2002-12-10 at 05:59:00 -0800, topmailbox@stripped wrote:
> 2 questions...
>
> My tutorial db has a number of tables in it... some
> with data... some with no records.
>
> 1 - How can I ask MySQL to tell me the number of
> records in my tables?
> ..a) all at once? Meaning one command to list...
> tbl_1 6 records
> tbl_2 3 records
> tbl_3 0 records
> etc
Have a look at SHOW TABLE STATUS
http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html
> ..b) one table at a time? Meaning one command per tbl
Have a look at the LIKE clause of SHOW TABLE STATUS
> 2 - How can I dump the contens of _all_ tables to the
> screen or to a text file?
Have a look at the command line tool mysqldump:
mysqldump your_database > some_file.dump
HTH,
Benjamin.
--
benjamin-mysql@stripped
