sqlserver - mysql如何将数据库文件备份出来？

Question

以前用的sqlserver是mdf、ldf，那么mysql是什么文件格式？应该如何导出或者叫备份出来？

Answer 1

If it is Linux, you can use mysqldump
If it is Windows, you can use various tools to export the database

Answer 2

mysqldump -hx.x.x.x -uxxxx -pxxxx databasename > backdata.sql

Answer 3

If you want to export the database using the web interface, you can consider using phpmyadmin. If it is a GUI, it is recommended to use mysql workbeach. If it is the command line, use the official mysqldump. If you want to export through a script, it depends on the client API of the language you use