Results 1 to 3 of 3
  1. #1
    Join Date
    August 4th, 2005
    How can I get the structure on a DB
    Someone that is doing a little work for me asked for the SQL of my database structure. How do I get that. I am a little familier with phpmyadmin. Can anyone give me a tip?

  2. #2
    ABW Ambassador Snib's Avatar
    Join Date
    January 18th, 2005
    You want to Export your database. If he needs the data you can choose to include it or not. You can even export it as a file so you don't need to cut and paste. It's fairly straightforward with phpmyadmin.

    - Scott
    Hatred stirs up strife, But love covers all transgressions.

  3. #3
    Join Date
    January 4th, 2006
    In phpmyadmin, select the database from the drop down menu on the left. Once you have done that you will get to the main screen of that database there should be a menu option in the main page there that says "export", click that and then you will be presented with a page that has a lot of options, what you need to do is select ALL tables by pressing the "select all" link (depends on what version of phpmyadmin you have though) then you need to tick the radio button/tick box that says "structure only". You do not need structure and data! and then you want to select "save as file", if your database is not huge there is no need to select compression or archive just press go and there you have it.

  4. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Commission Structure
    By Maim133 in forum Midnight Cafe'
    Replies: 1
    Last Post: October 2nd, 2006, 12:12 PM
  2. New Commission Structure
    By appbizz in forum Amazon
    Replies: 2
    Last Post: June 24th, 2003, 04:46 AM
  3. Tree Structure
    By walton in forum Scripts
    Replies: 3
    Last Post: February 27th, 2003, 02:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts