Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I duplicate a database using phpmyadmin?

I want to duplicate my database with phpmyadmin.

How should I proceed?

phpmyadmin Version: 3.4.5deb1

like image 282
Anis_Stack Avatar asked May 10 '13 11:05

Anis_Stack


People also ask

How do you duplicate a database?

Expand Databases, right-click the desired database, point to Tasks, and then select Copy Database... If the Welcome to the Copy Database Wizard splash page appears, select Next. Select a Source Server page: Specify the server with the database to move or copy. Select the authentication method.

How can I copy my localhost database?

Inside the phpMyAdmin tool, select the database that you want to copy (on the left) and then click the Export tab and choose the SQL format option. Then click the “Go” button. For example: Then in the dialog box that pops up, choose “Save File” to save the database.


1 Answers

Go to the database you want to duplicate and click the Operations tab. In the Operations page under Copy database to section enter the name of the new database and click Go button.

like image 96
Madhura Jayaratne Avatar answered Oct 04 '22 11:10

Madhura Jayaratne