How to copy mysql database

Use the exporting feature table to get the contents of the original database in the form of instructions to the SQL language. To do this, downloading the phpMyAdmin interface and login on the SQL server that hosts the source database, navigate to it by clicking the appropriate link in the left frame. Then click "Export" in the right frame.

Click on the link "Select all", placed above the list of tables of the database in the section "Export" the right frame of the application interface. In the section "Settings" all settings can be left in the form in which phpMyAdmin puts them by default. If the amount of data stored in the tables of the database is very large, the transfer is better to use a file - check the box next to "Save as file". Without this mark exported data the application will be placed in a multiline TextBox from which it can be easy to copy, and then paste it into the appropriate field on the SQL server destination. Click "OK" and the program will be sent the necessary queries, and then either prompts you to save the exported file, or displays them in the appropriate field on the next loaded page.

Log in to the same application interface is phpMyAdmin on the SQL server where you want to place a portable database. Do it in a new browser tab, if data will be transferred using "copy/paste". Enter the database name in the "New database" and click "Create". The application will send the request, performing the server creates an empty database with the specified name, notify the application and it will open the page is blank while the base.

Use the function import to create in this database are copies of source tables and stored data, if the transfer is done using files. Clicking on the "Import" tab in the right frame you will open a form where you have to press the "Browse" button to find generated when you export a data file, and then click the "OK" button. The app will upload to the server contained in the instruction file, and after they are executed, will update the page, moving in the left frame the list of created tables, and the right - more detailed information about them.

Instead of the previous step, click on the SQL tab, if the transfer is carried out without using intermediate files. Then switch to the browser tab where you have opened the form with the SQL instructions in the exported data, select and copy them. Switching back to paste all copied in the box under "Run SQL query(s) to the database and click "OK". The application will send requests to the server, he will create the tables, populate them and return the report results. PhpMyAdmin will show you this report and update information about the contents of the now empty database.