I was wondering if anyone knows of a way to write the structure of a database to a file so you could easily import it from one server to another without having to write all the table creation queries again. All i need to be able to import from one server to the next is the database structure. The information does not have to stay intact. I heard it could be done but have not figured it out. Any help would be greatly appreciative.
Hi Nick, the mysqldump command can output all your table data including table definitions and entries. This can be redirected to a file, and then you can use 'mysql -u user -p database_name< filename.sql' to restore that information on your new server. It looks like using the '-d' or '--no-data' flag for mysqldump will skip dumping the rows.