Exporting selected rows in phpMyAdmin?

FerdieQO

Well-known member
Joined
Jul 15, 2016
Messages
208
Points
28
I have a table 1500 rows and I want to export selected 80 rows from phpMyAdmin to import to another table. Is it possible to do this? can you guys guide me?
 

Dr. McKay

Well-known member
Joined
Nov 26, 2016
Messages
479
Points
28
Clicking on rows you want to export and click export, you will have a .sql file and store it on your computer.

Exporting selected rows in phpMyAdmin 2.png

In this step, it will export rows from "your table" you chose

Exporting selected rows in phpMyAdmin 3.png

Back to the table you want to add extra rows and click on import

Exporting-selected-rows-in-phpMyAdmin-1.jpg

In the case you don't want to use this function to add extra rows from a file, opening .sql file and finding the command start with INSERT INTO...
For examples
Code:
--
-- Dumping data for table `wp_posts`
--

INSERT INTO `wp_posts` (`ID`, `post_author`, `post_date`, `post_date_gmt`, `post_content`, `post_title`, `post_excerpt`, `post_status`, `comment_status`, `ping_status`, `post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`, `post_modified_gmt`, `post_content_filtered`, `post_parent`, `guid`, `menu_order`, `post_type`, `post_mime_type`, `comment_count`) VALUES
(24, 1, '2016-05-31 07:05:49', '2016-05-31 07:05:49', ' ', '', '', 'publish', 'closed', 'closed', '', '24', '', '', '2016-06-01 15:47:08', '2016-06-01 15:47:08', '', 16, 'http://example.com/?p=24', 31, 'nav_menu_item', '', 0),
(25, 1, '2016-05-31 07:05:49', '2016-05-31 07:05:49', ' ', '', '', 'publish', 'closed', 'closed', '', '25', '', '', '2016-06-01 15:47:08', '2016-06-01 15:47:08', '', 16, 'http://example.com/?p=25', 36, 'nav_menu_item', '', 0),
(26, 1, '2016-05-31 07:05:49', '2016-05-31 07:05:49', ' ', '', '', 'publish', 'closed', 'closed', '', '26', '', '', '2016-06-01 15:47:08', '2016-06-01 15:47:08', '', 16, 'http://example.com/?p=26', 32, 'nav_menu_item', '', 0),
(27, 1, '2016-05-31 07:05:49', '2016-05-31 07:05:49', ' ', '', '', 'publish', 'closed', 'closed', '', '27', '', '', '2016-06-01 15:47:08', '2016-06-01 15:47:08', '', 16, 'http://example.com/?p=27', 33, 'nav_menu_item', '', 0);
and adding into SQL tab and click Go to run these queries
Selected rows will be added to your chosen tables.

Exporting-selected-rows-in-phpMyAdmin-4.jpg
 

Attachments

Older Threads
Replies
1
Views
1,416
Replies
2
Views
1,346
fwh
Replies
4
Views
1,687
Replies
7
Views
2,022
Newer Threads
Replies
8
Views
3,088
Replies
16
Views
13,119
Latest Threads
Recommended Threads

Latest Hosting OffersNew Reviews

Sponsors

Latest Blog ArticlesMost Viewed Threads

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top