Msql Backup/Restore
//Backup Single Database mysqldump -u username -p example_database > example_database.sql //Backup Single Table mysqldump -u username -p database_name table_name > single_table_dump.sql // Export specific columns from a table to XML mysql -u username -p DATABASE --execute='SELECT this,that,other FROM TABLE' -X > FILENAME.xml //Restore Database mysql -u username -p database_name < database_name.sql //Backup Everything mysqldump -u username -p -x -A > name_of_file.sql
Comments
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎