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? Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.