jasonc Posted February 12, 2009 Share Posted February 12, 2009 i wish to grab all the databases and table structures from the mysql database, which is hosted on a windows hosting, i am moving to a linux server but host will not help me. unable to access the page properly and server is very slow or at a stand still at times !! is there a way to grab all the tables and databases, as i do not know all the names and the table fields now and dont want to annoy the host to much or they will just close my account and i'll lose everything. i have ready a long time ago that someone wanted to do this from another forum that i cant remember now and hoped that someone maybe able to help me out. Link to comment https://forums.phpfreaks.com/topic/144899-how-to-grab-all-databases-and-table-structure-from-my-site/ Share on other sites More sharing options...
aschk Posted February 12, 2009 Share Posted February 12, 2009 From the cmd prompt mysqldump --opt -uUSERNAME -p DATABASE_NAME > "C:/path/to/dump/file.sql" Link to comment https://forums.phpfreaks.com/topic/144899-how-to-grab-all-databases-and-table-structure-from-my-site/#findComment-760386 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.