True, that won't work! 2015-05-15 19:54 GMT+02:00 Larry Silverman <[email protected]>:
> The description of mysqldumper kinda doesn't sound like you'd end up with > something transactionally consistent. > > Larry Silverman > Chief Technology Officer > TrackAbout, Inc. > > On Fri, May 15, 2015 at 11:49 AM, Simon Heimler <[email protected]> > wrote: > >> I've had good experiences with http://www.mysqldumper.net/ >> >> It tries to split the import / export to smaller batches. This will take a >> while longer, but it works with bigger databases. >> >> Best, >> Simon >> >> 2015-05-15 18:03 GMT+02:00 John Foster <[email protected]>: >> >> > I'm using the basic mysqldump for dumping and mysql syntax for >> importing. >> > Moving from a Linux Mint LMDE server to an Ubuntu Enterprise server. >> > pretty vanilla stuff. The database is too big for phpmyadmin to do >> either & >> > it's just too slow. Also tried BigDump but that did not perform either. >> > Mostly figure I need to beef up mysql timing & tuning & have no >> experience >> > doing that. >> > >> > >> > On 05/14/2015 09:58 PM, John wrote: >> > >> >> are you using the dump/import script or a feature of the database >> >> software? >> >> mysql or mariadb? >> >> >> >> On Thu, May 14, 2015 at 10:52 PM, John Foster <[email protected]> >> >> wrote: >> >> >> >> I have to move a mediawiki site that has a database of approx 4.1GB. >> It >> >>> is >> >>> somthing I have done before and I usually just use the command line >> >>> syntax >> >>> to do it. However I have tried 3 times to export it and the files are >> >>> always either incomplete due to server (Mysql) disconnect. I finally >> did >> >>> get one that seemed to complete OK but then I tried several times to >> >>> import >> >>> it into the new server and likewise got server disconnect errors. I am >> >>> aware that there are a multitude of possibilities, so what I'm asking >> >>> here >> >>> is for any tips on moving databases of this size or larger. I'm >> beginning >> >>> to wonder if Mysql is the way to go here. >> >>> Thanks! >> >>> >> >>> -- >> >>> John Foster >> >>> JW Foster & Associates >> >>> >> >>> >> >>> _______________________________________________ >> >>> MediaWiki-l mailing list >> >>> To unsubscribe, go to: >> >>> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l >> >>> >> >>> _______________________________________________ >> >> MediaWiki-l mailing list >> >> To unsubscribe, go to: >> >> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l >> >> >> > >> > -- >> > John Foster >> > JW Foster & Associates >> > >> > >> > _______________________________________________ >> > MediaWiki-l mailing list >> > To unsubscribe, go to: >> > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l >> > >> _______________________________________________ >> MediaWiki-l mailing list >> To unsubscribe, go to: >> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l >> > > _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
