You now know how to export databases and tables to your local computer using phpMyAdmin. Click on Export in order to begin the export process. In the top right of the phpMyAdmin interface, you should see a row of options starting with Browse. Click on the table name that you want to export. 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. Next, click on the plus sign (‘+’) next to the database that contains the table the you wish to export. It has now been exported to your local computer. The pop-up will ask what you want to do with the file. Scroll to the bottom, and click on the Save as file. You are going to check the SQL again, and make sure all the options you wish to mark are checked. That will open the View dump (schema) of table screen. Again, click on the Export button from the menu at the top of the window. phpMyAdmin akan memproses database dan menghasilkan file ekspor sesuai dengan opsi yang Anda pilih. Klik tombol Go atau Export untuk memulai proses ekspor. That will open a window showing the table details on the right hand side. Cara export database di phpMyAdmin selanjutnya adalah mengatur opsi ekspor sesuai kebutuhan Anda. If you only want to export a table, begin by clicking on the table name in the left hand side. The database has now been exported to your local computer. You will get a pop-up asking you what to do with the file that you have chosen to open. Select the 'Custom' radio button and SQL as the file type (which is the default anyway, so theres nothing to change, just double-check it). When you are ready, scroll down, and check the Save as file box. From within phpMyAdmin, youll go to the Export page of the database you wish to export. For example, you might wish to uncheck or check things like : Add Auto_Increment Value, or Add Into Comments, Creation/Update/Check Dates. Make sure you go back to the top of the box and check any options you want before you move on with the export. On the left hand side, you will see a radio button and the letters SQL. To use this option, scroll down almost to the bottom of the box. This is an excellent way to back-up your database. One option is to export the entire database in SQL format, so that it can easily be imported later. There are many options listed for exporting the database. This will open up a new screen, called View dump (schema) of database. Now, from the menu at the top of the right hand side, click on the Export button. This will open the right hand panel to a screen showing the details of the database. To export a database, the first step is to click on it in the left hand panel. Let's start learning how to export tables and databases. The right hand side is a large white window, and this is where the activity takes place. Below the database, you will see the names of the tables that are in the database. The left hand side is blue, and this is where you will find your database listed. The phpMyAdmin main screen is broken into two sections. 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. This tutorial is to teach you how to export databases and tables with phpMyAdmin.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |