strago Posted February 21, 2015 Share Posted February 21, 2015 Using mysqldump -u root -pXXXXXXXX db > /path/back-ups/db-$datestamp.sqlInstead of showing up like...INSERT INTO `phpbb_reports_reasons` VALUES (1,'warez','The post contains links to illegal or pirated software.',1),(2,'spam','The reported post has the only purpose to advertise for a website or another product.',2),(3,'off_topic','The reported post is off topic.',3),(4,'other','The reported post does not fit into any other category, please use the further information field.',4);is there a way to change the mysqldump code to make it come out like...INSERT INTO `phpbb_reports_reasons` (`reason_id`, `reason_title`, `reason_description`, `reason_order`) VALUES(1, 'warez', 'The post contains links to illegal or pirated software.', 1);INSERT INTO `phpbb_reports_reasons` (`reason_id`, `reason_title`, `reason_description`, `reason_order`) VALUES(2, 'spam', 'The reported post has the only purpose to advertise for a website or another product.', 2);INSERT INTO `phpbb_reports_reasons` (`reason_id`, `reason_title`, `reason_description`, `reason_order`) VALUES(3, 'off_topic', 'The reported post is off topic.', 3);INSERT INTO `phpbb_reports_reasons` (`reason_id`, `reason_title`, `reason_description`, `reason_order`) VALUES(4, 'other', 'The reported post does not fit into any other category, please use the further information field.', 4);in the back-up? Link to comment https://forums.phpfreaks.com/topic/294765-changing-database-format-of-mysqldump-back-up/ Share on other sites More sharing options...
kicken Posted February 21, 2015 Share Posted February 21, 2015 Use the --skip-extended-insert option. Link to comment https://forums.phpfreaks.com/topic/294765-changing-database-format-of-mysqldump-back-up/#findComment-1506306 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.