Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
7
Impact
~1k people reached

Sep
22
awarded  Citizen Patrol
Aug
14
comment How to tune MySQL for restoration from MySQL dump?
I have 4 different flavors of linux running online servers and some distro's mysql package managers disable it! It can be the different between 12 hours to reload a WP database and 8 minutes when its on. I find the managers explanation is "availability of incremental backups". My best understanding is if the server is routinely backed up, it could be off by default. Then the user must manually add the --opt option to specify this is not an incremental backup attempt.
Aug
7
comment How to tune MySQL for restoration from MySQL dump?
I just want to make sure you are using --opt with the mysqldump utility. This is a HUGE time saver when reloading. without it mysqldump creates the sql file row by row. --opt does: Adds locks, drop and recreate with all create options enabled, temporarily disables the keys for a quick reload and then turns keys back on at the end to rebuild the indexes after the writing is done. It concatenates several rows together in inserts to reduce filesize AND parsing time of each statement (by up to 70%) and enables --quick to reduce the load against the dumping DB when running. reduces load time by 80%
Jun
23
revised How to open XPS files in Firefox
added 130 characters in body
Sep
24
awarded  Autobiographer
Aug
26
comment How to reset shortcuts (.lnk file) in Windows 7?
That worked instantly to repair damage left behind by malware
May
22
answered How to open XPS files in Firefox
Mar
6
awarded  Revival
Feb
18
awarded  Supporter
Feb
18
awarded  Excavator
Feb
18
revised How to install the real Firefox on Debian?
Explained the default language
Feb
18
awarded  Editor
Feb
18
revised How to install the real Firefox on Debian?
snaffu on 'get'
Feb
18
suggested approved edit on How to install the real Firefox on Debian?
Feb
18
suggested approved edit on How to install the real Firefox on Debian?
Feb
18
comment Moving files inside my NTFS partition is as slow as copying them. What could be the cause of this?
oh! look under the user protection folder to see if the file or directories were copied there.
Feb
18
answered Moving files inside my NTFS partition is as slow as copying them. What could be the cause of this?
Oct
20
awarded  Teacher
May
12
answered Regedit F3 (Find Next) not working in Windows 7