Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

phpMyAdmin "Dump some row(s)" for more than one table at once

I have a MySQL database with about 50 tables and thousands of records in each table. How can I create a dump of the database containing all tables and only 10 records of each table?

like image 336
Flavio Avatar asked Dec 21 '13 13:12

Flavio


1 Answers

In phpMyAdmin, you will have to export table by table. For each table, click on Export, then choose "Export method custom", choose "dump some rows" and write 10 as the number of rows.

I hope that there are no relations between your tables, as you might be missing some foreign key values when reimporting.

like image 75
Marc Delisle Avatar answered Sep 28 '22 02:09

Marc Delisle