backing up portions of DB

[kelly]

I have a DB of NFL players and stats. What I want to do is a sql 'backup' of just parts of 3 tables i.e. create a new DB for each team. I have tables for nflteams, players and player stats for all the NFL. I want to create a DB for say just the Rams.
help
regards
kelly -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[hannah]

This should work

Try using the "--where" option of mysqldump.
For example, assuming you have a database "nfl_database", containing table "players" , one of whose columns is "teamname":
mysqldump --user=username --password=password --where="teamname = 'Rams'" nfl_database players > players_rams.sql

all the best -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --