From the course: Learning phpMyAdmin
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Exporting partial data
- When creating a backup or exporting data for transfer, the resulting file might be too big to upload to your remote server. On the other hand, you might want to merge data from one table into another. And the custom export options won't produce the result you want. PhpMyAdmin lets you choose exactly what you export. Let's start with the example of a table that's too big to upload in a single operation. The sample database we've been working with doesn't have any large tables, but we can still use it to demonstrate the principle. So in the panel on the left, expand up_and_running, and select the cars table, then click the Export tab and Custom. When a single table is selected, you get the option to dump or export some rows or to dump all rows, that's the default. Our table's got only 35 rows, but if I select Dump some row(s), I can then edit these two fields. So let's say we've got a table that's got hundreds of thousands of rows, and the dump file will be too big to upload to the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
Importing data from Excel or a CSV file8m 12s
-
Importing data from an OpenDocument Spreadsheet7m 25s
-
Importing data from a SQL dump file5m 6s
-
Exporting a database the quick way4m 8s
-
Exporting multiple databases6m 13s
-
Creating a custom export for a single database8m 47s
-
Exporting partial data5m 47s
-
Enhanced export features in phpMyAdmin 4.55m 28s
-
-
-
-
-
-