richrock Posted December 18, 2008 Share Posted December 18, 2008 Hi all, I've been developing a system to administrate the backend operations of a website, extending the functionality of an existing database. I'd like to run some tests from scratch, so I'd like to create an identical copy of the database, retaining the table structures and any default values, but with empty rows. How would I do this? I don't have much experience with mysql, though I can write basic commands and am reasonably familiar with phpmyadmin too. TIA Rich Link to comment https://forums.phpfreaks.com/topic/137557-solved-creating-copy-of-database-without-entries/ Share on other sites More sharing options...
Maq Posted December 18, 2008 Share Posted December 18, 2008 Do you have PhpMyAdmin? Just click on your database and export it with no data. Link to comment https://forums.phpfreaks.com/topic/137557-solved-creating-copy-of-database-without-entries/#findComment-718938 Share on other sites More sharing options...
Maq Posted December 18, 2008 Share Posted December 18, 2008 Or if you want to copy the database to the same server, click on the DB>>operations>>copy database (make sure you select Structure only) and copy it with a new name. Link to comment https://forums.phpfreaks.com/topic/137557-solved-creating-copy-of-database-without-entries/#findComment-718942 Share on other sites More sharing options...
richrock Posted December 18, 2008 Author Share Posted December 18, 2008 Thanks guys - worked a charm. I'll have to remember that! Link to comment https://forums.phpfreaks.com/topic/137557-solved-creating-copy-of-database-without-entries/#findComment-718955 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.