Results 1 to 3 of 3
May 13th, 2006, 11:30 PM #1
How can I get the structure on a DB
- Join Date
- August 4th, 2005
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?
May 14th, 2006, 02:50 AM #2
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.
- ScottHatred stirs up strife, But love covers all transgressions.
May 18th, 2006, 02:01 AM #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.
By Maim133 in forum Midnight Cafe'Replies: 1Last Post: October 2nd, 2006, 11:12 AM
By appbizz in forum AmazonReplies: 2Last Post: June 24th, 2003, 03:46 AM
By walton in forum Cusimano.com ScriptsReplies: 3Last Post: February 27th, 2003, 01:19 PM