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 heimlersimon@gmail.com 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 jfoster81747@gmail.com:
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 jfoster81747@gmail.com 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