Next privilege 125 Rep.
Next badge 0/1
0 people reached
- 0 posts edited
- 0 helpful flags
- 4 votes cast
How can I monitor the progress of an import of a large .sql file?
@Pacerier I would guess that mysql might have a buffer, in which some data can be piped in, without being fully "processed" (i.e. if it errors out, pv may have slightly over-reported what actually gets in). But in general, this is how pipes work. It's the same reason you can do
How can I move a MySQL database to another drive?
This gave me errors when trying to start mysql (permissions issues). I settled on the solution I post here, which I hope helps save someone some time.