How do i recreate the structure of my database in MYSQL using PHPmyAdmin or even through a query somehow? What i want is to get the skeleton of the database, something i can transfer onto any server.
PHPmyAdmin provides the PHP code only when you create a particular table. Anybody knows how i can get that PHP code after i've created the tables?
If i could get that i'd just have to PHP this code onto any server and my database would be recreated instantly.
PHPMyAdmin allows you to create an SQL dump of your database. This SQL dump contains the CREATE statements for the tables in the database, possibly followed by the INSERT statements for the data (which you can remove by hand or by asking PHPMyAdmin not to generate them).
You can also query for the creation SQL statement of a table using SHOW CREATE TABLE foobar.