Copy MySQL Database Structure without Data

Three easy steps to copy the structure of a MySQL database, i.e. the table definitions but no rows/records/data: 1. Create the new database, either from MySQL Query Browser (part of MySQL GUI Tools) or MySQL Command Line: CREATE DATABASE `new_database_name`; 2. Copy the database structure using the mysqldump command from a dos command prompt. Note:… Continue reading Copy MySQL Database Structure without Data

Published
Categorized as MySQL