Exporting databases and tables with phpMyAdmin Print

  • 0

This tutorial is to teach you how to export databases and tables with phpMyAdmin. We will assume that you are currently logged into phpMyAdmin, and for the purpose of this tutorial, we will use a database with two tables as our example. The phpMyAdmin main screen is broken into two sections. The left hand side is blue, and this is where you will find your database listed. Below the database, you will see the names of the tables that are in the database. The right hand side is a large white window, and this is where the activity takes place.

Let's start learning how to export tables and databases. To export a database, the first step is to click on it in the left hand panel. This will open the right hand panel to a screen showing the details of the database. Now, from the menu at the top of the right hand side, click on the Export button. This will open up a new screen, called View dump (schema) of database. There are many options listed for exporting the database. One option is to export the entire database in SQL format, so that it can easily be imported later. This is an excellent way to back-up your database. To use this option, scroll down almost to the bottom of the box. On the left hand side, you will see a radio button and the letters SQL. Click on this. Make sure you go back to the top of the box and check any options you want before you move on with the export. For example, you might wish to uncheck or check things like : Add Auto_Increment Value, or Add Into Comments, Creation/Update/Check Dates.

When you are ready, scroll down, and check the Save as file box. Then click the Go button. You will get a pop-up asking you what to do with the file that you have chosen to open. Save to disk should be checked. Click on OK. That completes the export. The database has now been exported to your local computer.

If you only want to export a table, begin by clicking on the table name in the left hand side. That will open a window showing the table details on the right hand side. Again, click on the Export button from the menu at the top of the window. That will open the View dump (schema) of table screen. You are going to check the SQL again, and make sure all the options you wish to mark are checked. Scroll to the bottom, and click on the Save as file. Then click on Go. The pop-up will ask what you want to do with the file. Save to Disk should be checked. Click on OK. That completes the export of the table. It has now been exported to your local computer.

Remember that exporting a database will export all the tables, providing they are all selected, but exporting tables only exports the selected table from within a database. This ends this tutorial. You now know how to export databases and tables to your local computer using phpMyAdmin.


Was this answer helpful?

« Back

SERVICES

ezyexchange  hosted microsoft exchange
ezytel  enterprise-grade hosted PBX
ezycloudsms  2-way cloud SMS
ezybroadband  NBN, wireless or fibre ethernet
ezy365  microsoft 365 licensing
ezywebhosting  enterprise web hosting
ezyssl  build trust, secure your brand
ezydomains  your name in the cloud
ezyreseller  our services, your clients


CONNECT

ezycloud | powered by Digital Hybrid
PO Box 7208, South Penrith, NSW, 2750


SALES & ENQUIRIES

Call   1300 882 942
SMS   0409 19 88 66


COPYRIGHT © 2009 -       Digital Hybrid Pty Ltd | really communicate       ACN 139 660 585   |   ABN 37 139 660 585   |   ALL RIGHTS RESERVED WORLDWIDE