The need to save the contents of databases on the local disk of your computer arises quite often. If we are talking about the data of any Internet site, then, apparently, the data is stored in the MySQL format - now it is the dominant DBMS in the web industry. Below is the procedure for unloading databases from the MySQL DBMS.
Instructions
Step 1
The best option is to use the phpMyAdmin online interface. It is offered by almost all hosting providers as a MySQL database administration tool. At the first step of the data uploading operation, you should find the Databases section in your hosting control panel, which contains a link to phpMyAdmin. Open it and go to the database where the tables to be dumped are located. Select the required database in the left pane of the interface.
Step 2
After entering the database, go to the upload page - at the top of the right pane, click the link that says "Export".
Step 3
In the group of settings with the heading "Export" you need to select all tables to be unloaded. You can click the Select All link, or select just a few by clicking each table of interest while holding down the CTRL key.
Step 4
Now choose a format to save the uploaded data. If you intend to upload them to another SQL server, then leave the SQL format, and select the appropriate format to work with data in some other applications.
Step 5
If the SQL format was selected, then in the group of settings with the heading "Parameters" check the necessary boxes. The most important here are the settings in the "Structure" section - a checkmark opposite the inscription "Add DROP TABLE" will lead to the fact that before loading data into their new storage location, existing tables there with the same names will be destroyed. If you want not to overwrite, but to add data to the existing ones, then this mark should be unchecked. The "Add IF NOT EXISTS" option has a similar purpose - the table will be created if the same does not exist on the new server, otherwise the data will be added to the existing ones.
Step 6
If you want to get the data in a text file, check the box next to the "Save as file". Without such a mark, the data will be displayed in a text field, from which it can be copied and also saved to a file or used in some other way.
Step 7
In the end, all that remains is to press the "OK" button to start the procedure.
