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. Quote Link to comment 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" Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.