transfer the structure (not the data) of my mySQL database to another server
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!
Lord Maverick posted this at 23:14 — 19th May 2006.
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.
ablaye posted this at 06:41 — 21st May 2006.
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.