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

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.

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

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.