Blog - William Bargent

I'm a Network Engineer with AWS and Azure Ops experience. A hobbyist Web Design / Developer blogger and Linux Server Engineer; taking on private development work and contributing to open-source projects.


October 2017

Re-sort MySQL table ID’s

SET @count = 0; UPDATE `users` SET `users`.`id` = @count:= @count + 1;

MySQL Import Progress

Doing a large MySQL import and want to view its progress. apt-get install pv root@WB-SRV-02:/# pv /var/www/moodle_db_backup.sql | mysql -u root moodledev 6.94MiB 0:00:28 [99.6KiB/s] [> ] 1% ETA 2:26:34

© 2019 Blog – William Bargent — Powered by WordPress

Theme by Anders NorenUp ↑