colap Posted April 7, 2011 Share Posted April 7, 2011 How can i dump a mysql table and restore it? Quote Link to comment Share on other sites More sharing options...
mellis95 Posted April 7, 2011 Share Posted April 7, 2011 mysqldump http://www.patrickpatoray.com/?Page=30 Quote Link to comment Share on other sites More sharing options...
Maq Posted April 7, 2011 Share Posted April 7, 2011 How can i dump a mysql table and restore it? This is the typical way to do it: mysqldump --opt [db_name] [table_name] > [outputfile_name].sql But, as Mellis directed you to, check the manual for specific parameters and options to suit your needs. Quote Link to comment Share on other sites More sharing options...
colap Posted April 8, 2011 Author Share Posted April 8, 2011 How can i do the same thing from mysql prompt? I logged in from mysql prompt. mysql -u root -p password: mysql> Now is it possible to do mysqldump? Quote Link to comment Share on other sites More sharing options...
Maq Posted April 8, 2011 Share Posted April 8, 2011 How can i do the same thing from mysql prompt? I logged in from mysql prompt. mysql -u root -p password: mysql> Now is it possible to do mysqldump? You do it from the command line but NOT while you're in the MySQL prompt. 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.