Exporting selected rows in phpMyAdmin?

FerdieQO

Well-known member
Joined
Jul 15, 2016
Messages
199
Best answers
0
Ratings
25
Points
18
#1
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
442
Best answers
1
Ratings
36
Points
28
#2
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,218
Replies
2
Views
1,164
fwh
Replies
4
Views
1,469
Replies
7
Views
1,727
Newer Threads
Replies
8
Views
2,827
Replies
16
Views
10,262
Latest Threads
  • Deleted
  • Deleted by fwh
Replies
0
Views
1
Replies
1
Views
20
  • Deleted
  • Deleted by fwh
Replies
0
Views
2
  • Deleted
  • Deleted by fwh
Replies
0
Views
1
Recommended Threads

Latest Hosting OffersNew Reviews

Sponsors

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