backup only structure of tables

Hello all,

Is there a simple way to backup only the structure of the database.
If I now run a backup, the data is also backuped.

Regards,
John Kuiper

On 16 Apr, 14:01, jkuiper <jkui...@thematec.nl> wrote:
> Hello all,
>
> Is there a simple way to backup only the structure of the database.
I think so

> If I now run a backup, the data is also backuped.
I guess that totally depends on how you are actually doing he backup

>Is there a simple way to backup only the structure of the database.
>If I now run a backup, the data is also backuped.

mysqldump -d (or --no-data) omits the data.

Thanks, that was exactly what I needed.

John

Gordon Burditt wrote:
>> Is there a simple way to backup only the structure of the database.
>> If I now run a backup, the data is also backuped.
>
> mysqldump -d (or --no-data) omits the data.
>
>