Backup/Restore MySQL database

//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.