How to upload sql database

MySQL is one of the most popular to date systems database management. Often users have the need to export database data using this system. For beginners, as a rule, this task is impossible, therefore, to solve this problem you need to know a few tricks and have some theoretical knowledge of DBMS.

You will need

- access to hosting.

Instruction

To create a backup of the MySQL database (that is unload) go into the control center for your hosting, where you host all the files on your web resource, including the database files. On the manage page, find phpMyAdmin and run it (this application is installed on most modern hosting). After launching the application, go to the tab "Export". Open a large number of parameters. Study them.

In that case, if you need only backup the MySQL database, don't change anything in the export settings. If you are planning to put backup DB back to the server, then use the option "Add DROP DATABASE". In this case, when you boot the server backup database with the same name as the DB is already hosted, uploaded the dump will replace the old database data. The same thing, but for the tables in the database does the option "Add DROP TABLE". After setting all necessary settings, click OK.

Then, the page will be able to download the MySQL database dump on your computer. To download this backup to a new host (and in most cases, the unload of the database is done just for this purpose), then again use the phpMyAdmin. Go to the tab "Import", select the backup MySQL database and click OK.

There is also a method of unloading a database without using phpMyAdmin. To do this, use the command line of your host. Type in the console this line: mysqldump my_database --user=imya_pol'zovatelya --password=moi_parol > kopiya.sql. After that will appear on hosting backup called kopiya.sql. In order to load a dump database in the hosting enter the following command: mysql-u username-p database < kopiya.sql. Enter the password when prompted.

Is the advice useful?