mysql db help?

Need to make a SQL file.....

[Par5Golf]

I need to know how to make a file of a db i already have. that doesnt have the SQL file to make the tables it self. the db was made for me and i want to use the same tables but for a diffrent site. I need a SQL file to build my tables. I just need to know if there is a way to make one from the db i have..

Thanks
Eric

[andreasfriedrich]

Assuming you are using MySQL you could use mysqldump [mysql.com] to dump both table structure and data.

The same can be done from within phpmysqladmin.

Andreas

[Par5Golf]

yepper that worked thanks