Halo teman-teman Saya ada masalah untuk restore database hasil nge dump yang isinya seperti ini:
INSERT INTO `messages`(`id`, `fromid`, `toid`, `message`, `is_read`,
`subject`, `send_date`) VALUES ('148', '1', '1', 'Looks like his account
is already set up.. And it's not suspended...', '1', '2820',
'1009375896'); ^^^^
INSERT INTO `messages`(`id`, `fromid`, `toid`, `message`, `is_read`,
`subject`, `send_date`) VALUES ('156', '2', '1', 'Hey,
I just wanted to let you know that I am going skiing tomorrow morning,
so I probably won't be around during your regular shift.', '1', 'ski
trip', '1009521906');
Perhatikan kata it's dan won't di atas.
Kalau itu di import lagi ke mysql pasti error, dan database ini lumayan
banyak, ada 16989 lines
Sudah dicoba search and replace tiap kata, tp masih ada juga kata-kata
yang mengandung '
Bagaimana sih cara nge dump yang benar untuk kasus di atas ?
Terima Kasih
Nyoman
signature.asc
Description: This is a digitally signed message part
