backing up mysql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
pinehead18
Forum Contributor
Posts: 329
Joined: Thu Jul 31, 2003 9:20 pm

backing up mysql

Post by pinehead18 »

Is their anyway to dump the db structure.. LIke the tables and fields in the tables without dumping the contents as well?

Thanks
anthony
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

when using mysql -> mysqldump -u username -p databasename --no-data[/php_man]
McGruff
DevNet Master
Posts: 2893
Joined: Thu Jan 30, 2003 8:26 pm
Location: Glasgow, Scotland

Post by McGruff »

And if you don't have shell access, you could use a db manager like phpMyadmin.
Post Reply