MySQL database - backup problem

Question

Hi I need to backup MySQL database and then deploy it on another MySQL server.

The problem is, I need it backup without data , just script which creates database, tables, procedures, users, resets autoincrements etc. ...

I tried MySQL administrator tool (Windows) and UNchecked "complete inserts check box", but it still created it ... Thanks in advance

Answer 1

From within phpMyAdmin you can export the structure, with or without the data. The only thing I'm not sure of, is wether it exports users as well. If you like, I can test that tomorrow morning. It exports users too. You can check all sorts of options.

_{(source: obviousmatter.com)}