# mysqldump -u root -p my_db_name > data.sqlĪt a high level, the backup file will drop any table named Customers in the chosen database and insert all backed-up data into it: # cat data.sql ![]() Using a simple command with inline arguments, we can quickly take the backup of the MySQL tables: | Wilman Kala | Matti Karttunen | Keskuskatu 45 | Helsinki | 21240 | Finland |Īs part of the MySQL RDBMS package, the mysqldump utility is used to backup all data in a database into a text file. Erichsen | Skagen 21 | Stavanger | 4006 | Norway | | CustomerName | ContactName | Address | City | PostalCode | Country |
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |