backup only structure of tables

#1 (**permalink**) 04-17-2008, 05:09 PM

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

#2 (**permalink**) 04-17-2008, 05:09 PM

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

#3 (**permalink**) 04-17-2008, 05:09 PM

>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.

#4 (**permalink**) 04-17-2008, 05:09 PM

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.
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode