mysqlCreate dump (backup) for all databases
mysqldump --all-databases > backup.sqlctrl + c--all-databasesthis option will make sure all databases on the server are dumped | backup.sqlname of dump file |
Related
More of Mysql
- How to find my.cnf config file
- What is the INT column max value and size
- Insert/update multiple rows in single query
- Get default charset of a database
- How to find duplicate varchar/text column values in table
- What is the TINYTEXT column max size (length) in Mysql
- Truncate all tables in a specific database
- Create user with root privileges
- Insert new values only if row doesn't exist already
- Replace string with regex
See more codes...