//Export Database
mysqldump -uUsername -p Database > db_backup.sql
//Export Multiple databases
mysqldump -uUsername -p --databases db_name1 [db_name2 ...] > db_backup.sql
//Export All databases
mysqldump -uUsername -p --all-databases > db_backup.sql
//Export a table
mysqldump -uUsername -p Database Tablename > table_backup.sql
//Export multiple tables
mysqldump -uUsername -p Database Table1 [Table2 ...] > tables_backup.sql
//Restore database
mysql -u username --p database_name < dump.sql
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.