MySQL database - backup problem

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

The problem is, I need it backup without dat开发者_StackOverflowa , 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

use mysqldump with option -d or --no-data
don't forget option -R to get the procedures
this page could help you: http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

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.

According to the page, there isn't a good way to dump the routines and have them easily able to be recreated.

What they suggest is to dump the mysql.proc table directly. Including all the data.

Then use your myback.sql to restore the structure. Then restore the mysql.proc table with all of its data.

"... If you require routines to be re-created with their original timestamp attributes, do not use --routines. Instead, dump and reload the contents of the mysql.proc table directly, using a MySQL account that has appropriate privileges for the mysql database. ..."