Tag Archives: export mysql db using query

Export data into the outfile using select statement. mysql>Select * from tutorials_tbl into OUTFILE ‘/tmp/tutorials.txt’; ‘mysqldump’ is used to copy or back up tables and databases $mysqldump -u root -p TUTORIALS tutorials_tbl>dump.txt password $mysqldump -u root -p TUTORIALS > database_dump.txt password **** $mysqldump -u root -p –all-databases>database_dump.txt password**