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?
3
- I assume from your rep that you have been here for a while to know that such questions won't get answered without a starting point. That's probably why you got downvoted, I didn't downvote you though.user3066913– user30669132013-12-21 14:05:10 +00:00Commented Dec 21, 2013 at 14:05
- 1I don't understand the downvotes. I have a database that I want to export using phpMyAdmin. With phpMyAdmin I can select "Dump some row(s)" only if I export a single table. How could I possibly export all tables at once and select "Dump some row(s)" at the same time?Flavio– Flavio2013-12-21 14:23:45 +00:00Commented Dec 21, 2013 at 14:23
- 2@flavio I up voted you, because I, myself, am got stuck on this issue once and I deem it a reasonable question.Syntax Error– Syntax Error2015-04-30 13:23:19 +00:00Commented Apr 30, 2015 at 13:23
Add a comment |
1 Answer
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.
