Exporting selected rows in phpMyAdmin?

FerdieQO

Well-known member
Joined
Jul 15, 2016
Messages
213
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
Registered
Joined
Nov 26, 2016
Messages
565
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
2,522
Replies
2
Views
2,275
fwh
Replies
4
Views
3,039
Replies
7
Views
3,404
Newer Threads
Replies
8
Views
4,369
Replies
16
Views
34,218

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