Wells-it.com - Web Hosting

transfer the structure (not the data) of my mySQL database to another server

You are viewing this site as a guest. Join our community to get your questions answered and share knowledge. Active members may advertise and ask for a website critique.

They have: 1 posts

Joined: May 2006

I'm looking to transfer the structure (not the data) of my mySQL database to another server. I'm going to be making copies of a website.

Can anyone point me in the right direction for how I would learn to do this? I use phpmyadmin to access the data. Any suggestions, places to start, etc. are much appreciated. Thanks!

They have: 34 posts

Joined: May 2006

In phpmyadmin goto to Export. Than select all tables, check structure, uncheck data and you will get mysql dump without data.

Sponsor

They have: 140 posts

Joined: Apr 2006

Use PhpMyAdmin (your web host probably has this installed) and download your database structure that way.

You can check out the phpMyAdmin for more documentation if you need it: http://www.phpmyadmin.net/home_page/index.php