copy mySQL structure plus make id number 3 characters in length

[unwashed potato!]

just a quick question, kind of embarrassed that i have to ask as i'm sure it's very simple but it's something i have never had to do so never found out.

been using laptop over weeked do create databases in mySQl, now i want to copy the databases, just the structure not the information stored in them, across to my pc, how do i do this?

and also one of the fields is an id field which i want to be 3 numbers long, so 101, 333 etc, how can i have auto_increment be 3 characters in length? and if possible allow zeros at the front, so 001, 002 etc doesn't get shortened to 1?

 

[shine]

First of all upgrade to the latest version of MySQL Administrator.

To create a backup :

• Click on the Backup icon in the left hand side of the MySQL Administrator
• Click on the New Project button at the bottom of the window
• Give your project a name
• Select the schemas you want to backup
• Click on the Execute Backup Now button

To restore from a backup :

• Click on the Restore icon in the left hand side of the MySQL Administrator
• Click on Open Backup File and select the backup file
• Eventually change options
• Click on Start Restore

Hope this helps