
<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>Or this from the shell:</div><div><br></div><div><blockquote type="cite"><blockquote cite="mid:CACRH01Y5UHGzk65e3+JZpxPWWPBH4fWrfUu7xaCzERrLpv8_uw@mail.gmail.com" type="cite"><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: rgb(204, 204, 204); padding-left: 1ex;"><div bgcolor="#FFFFFF" text="#000000"><div class="h5"><blockquote type="cite"><div dir="ltr"><p><font color="#000000"><span style="background-color: rgba(255, 255, 255, 0);">mysqldump -uUSERNAME -h localhost -pPASSWORD DBNAME > /PATH/FILENAME</span></font></p></div></blockquote></div></div></blockquote></div></div></blockquote></blockquote><br><div><br></div></div><div><br>On May 1, 2015, at 11:44 AM, Richard Sidlin <<a href="mailto:richard@sidlin.co.uk">richard@sidlin.co.uk</a>> wrote:<br><br></div><blockquote type="cite"><div><blockquote type="cite"><span></span><br></blockquote><blockquote type="cite"><span>Hi Rich,</span><br></blockquote><blockquote type="cite"><span></span><br></blockquote><blockquote type="cite"><blockquote type="cite"><span>How do I extract one MySQL database out of the mysqldum.sql file as I</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>need to restore one that has been hacked? The size of the dump file is</span><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span>134MB but the import limit in phpMyAdmin is 8MB.</span><br></blockquote></blockquote><blockquote type="cite"><span></span><br></blockquote><blockquote type="cite"><span>You can edit the .sql file with your favorite text-editor. Search for the</span><br></blockquote><span>db</span><br><blockquote type="cite"><span>name, and you will see a statement with the dump of that database starts.</span><br></blockquote><blockquote type="cite"><span>Delete every other dump of other databases in that text file (be sure to</span><br></blockquote><span>save</span><br><blockquote type="cite"><span>a copy before doing so), and you will have a dump file of that one</span><br></blockquote><span>particular</span><br><blockquote type="cite"><span>db, which by itself can be imported.</span><br></blockquote><blockquote type="cite"><span>--</span><br></blockquote><blockquote type="cite"><span>Maurice</span><br></blockquote><blockquote type="cite"><span>_______________________________________________</span><br></blockquote><span>Thanks Maurice. </span><br><span></span><br><span>_______________________________________________</span><br><span>Blueonyx mailing list</span><br><span><a href="mailto:Blueonyx@mail.blueonyx.it">Blueonyx@mail.blueonyx.it</a></span><br><span><a href="http://mail.blueonyx.it/mailman/listinfo/blueonyx">http://mail.blueonyx.it/mailman/listinfo/blueonyx</a></span><br></div></blockquote></body></html>