<div>
If you don't want to do it via shell/command line, you can always install phpMyAdmin (<a href="http://www.phpmyadmin.net" rel="ugc">www.phpmyadmin.net</a>) and use the GUI via Apache/PHP to export the database without the data.<br />
<br />

</div>


If you don't want to do it via shell/command line, you can always install phpMyAdmin (www.phpmyadmin.net [http://www.phpmyadmin.net]) and use the GUI via Apache/PHP to export the database without the data.



<div>
you can also use sqlyog <a href="http://www.webyog.com" rel="ugc">www.webyog.com</a>, a little easier than pma
</div>


you can also use sqlyog www.webyog.com [http://www.webyog.com], a little easier than pma

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
Is it possible to create a new database based on the structure of an existing database. Basically you are making a copy of an existing database without the data. I didn't know if this was something you could do with mysql or perhaps there are native sql commands for this<br />
<br />
I am a database novice so I don't know these things.<br />
Thanks
</div>
</div>


Hi

Is it possible to create a new database based on the structure of an existing database. Basically you are making a copy of an existing database without the data. I didn't know if this was something you could do with mysql or perhaps there are native sql commands for this

I am a database novice so I don't know these things.
Thanks

mysqldump database structure only

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.