Hi guys, I've made my database via phpmyadmin and now I've decided to add the whole structure to a .php file which creates the database in case it doesn't exist. How can I export the structure (without values) including "CREATE" functions of an existing SQL database? Cheers, Scorpiono
when you created the database in phpmyadmin, it will return a query of how it executes/creates the database.. try creating a sample database in phpmyadmin and it will give you that query.
That's a solution but what if my database has tons of tables, isn't there an easier way to strip it ?
show create table students; would show you the create table syntax for the table students. Alternatively you can use mysqldump command to get the create syntax of all table , and not the data using appropriate switch/options