ALTER TABLE thing MODIFY description BLOB(999999);
ALTER TABLE thing MODIFY description LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

When using the command: k:\apps\rr.exe * “(\D+)(\d)\.jpg” “$1000$2.jpg”

To pad the filename with numbers to 4 digits with zeros, I’ve found that this works ok except when the placing the $1 at the start of any replacement filename.

I’ve tried many possible combinations of placing “^” and “$” and in the search filename text with no joy.

The below shows an example:

pic_1.jpg -> $10001.jpg
pic_2.jpg -> $10002.jpg
pic_3.jpg -> $10003.jpg
pic_4.jpg -> $10004.jpg
pic_5.jpg -> $10005.jpg
pic_6.jpg -> $10006.jpg
pic_7.jpg -> $10007.jpg
pic_8.jpg -> $10008.jpg
pic_9.jpg -> $10009.jpg

Is there a way to overcome this apparent bug?

Hi Jason!

Within your Shopify site, you will see a minified version of something like this:

https://akamai.github.io/boomerang/oss/tutorial-loader-snippet.html

To stop the snippet from loading shopify-boomerang-1.0.0.min.js, you may be able to set a flag via JavaScript that will trick the loader snippet to not load the main JavaScript.

For example:


window.BOOMR = { snippetExecuted: true };


However I’m also interested in understanding the issue you’re seeing with the body tag, I’ll reach out offine.

Thank you so much Nic for creating the script, it really helps us on fixing the incorrect encoding on our 30GB database size of MySQL data.

Our Best Regards

One thing to remember is that the search and replacement patterns are regular expressions, and a “period” (.) in a regular expression matches any character.

So this command:

rr *.txt "..txt" "2.txt"

Really means “replace [anything][anything]txt” with “.txt”.

Instead, you’ll want to escape the period so it’s taken literally:

rr *.txt "\.\.txt" ".txt"

Then it should just replace files with “..txt” in the name.

My test examples:

RR.exe *.txt " .txt" ".txt"
name with space .txt -> name with space.txt

RR.exe *.txt "\..txt" ".txt"
name with double period at end..txt -> name with double period at end.txt

Hope that helps!

To rename:
“file..ext” to “file.ext”
rr *.txt “..txt” “.txt”
It doesn’t work, I rename all the files.
What am I wrong?

Each layout shift will cause the browser to have to recalculate layout and paint the new view. So in my view layout shifts don’t really impact the rendering performance directly, rather, they cause more renders to happen.

Hi Viktor!

One way to debug Layout Shifts is by using Chrome Developer Tools (Lighthouse Audits). When I ran a Performance Audit on your homepage for mobile for example, I see the page come in with the menu fully expanded (Home through About), then it later “collapses” into the three-bar as the first content comes in:

https://nicj.net/wp-content/uploads/2021/02/cls-mobile.png

This may be due to your CSS or JavaScript and how it loads? You can see the corresponding Layout Shifts when you load that Audit into the Performance tab, under “Experience” it shows all of the shifts.

Here’s my current post
https://thediyplan.com/diy-floor-rocking-chair/
Thanks

So awesome to hear!

I modified and tested your script from GitHub to convert latin1_swedish_ci -> utf8mb4 and the transition went fairly well. I’ll share bugs on Github as requested. Just wanted to say thanks first!

The file match is based on the regex, we’re not relying on the OS matching at all.

@huynh: I don’t think rename-regex is needed for that, but you should be able to do a loop in a batch file starting with the highest number, moving it forward by one, decrementing the number by one, moving that forward by one, etc.

Thank you VERY much!
Tom

wp-comments-posts.php to wp-comments-post.php.bak

because PHP will no longer parse wp-comments-posts.php.bak and the hackers can see the file contents of the PHP source; for WP it probably doesn’t matter too much (as it is opensource) but generally this is not good practice.

Much better to rename to-

wp-comment-posts.2020apr22.php

Nothing yet, unfortunately. There is discussion around a “FetchObserver” or another mechanism to listen for the “start” of resources.

There’s some discussion here: https://github.com/w3c/resource-timing/issues/137 and please include your feedback as it can help push issues forward!

Quick question: Is there a way to get the list of resources that are “in progress”?

I’ve notices that the performance.getEntries() array populates when the transfer is done, but does not give any hints about the resources that are in-progress.

For UNC paths, can you “pushd” to them first so the folder is mapped as a local letter?

I’ve just verified that this command should work:

RR *.txt "([0-9]+)_([a-z]+)" "$2_$1" /p
123_xyz.txt -> xyz_123.txt (pretend)

I need to rename file like in your example: “123_xyz.txt” to “xyz_123.txt”.

.\RR.exe *.txt "([0-9]+)_([a-z]+)" "$2_$1" showed the help, so I modified in this:
.\RR.exe *.txt "(?[0-9]+)_(?[a-z]+)" "${1}_${2}" but the result is the following:
124_xyz.txt -> _.txt (pretend)

Where am I wrong?
Thank you very much

Hi Peter! I hope to have some time soon to add that option (and others). I’ve filed some Github issues to track this: https://github.com/nicjansma/rename-regex/issues

You have the recommendation to change this line 56 in Program.cs:

Hmm, I am not a programmer. If it that easy: could you provide a changed RR version WITH upper/lowercase attention?

Thank you
Peter

@Luca I don’t fully understand the difference you’re pointing out.

The code is https://github.com/nicjansma/mysql-convert-latin1-to-utf8/blob/master/mysql-convert-latin1-to-utf8.php#L125


$colDefault = '';
if ($col->COLUMN_DEFAULT !== null) {
$colDefault = "DEFAULT '{$col->COLUMN_DEFAULT}'";
}


The above DEFAULT ' is a single apostrophe, not a double apostrophe? So this output doesn’t make sense, which has a double apostrophe in it:


MODIFY `grouplevel` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT ”all”,


Did something get changed when copied/pasted possibly?

Regardless, please open a Github issue if you think there’s an problem here:

https://github.com/nicjansma/mysql-convert-latin1-to-utf8/issues

@Jim – Feel free to open an Issue on the Github project page or a Pull Request if you’re inclined!

https://github.com/nicjansma/rename-regex/

MODIFY `grouplevel` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT ”all”,
MODIFY `start` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT ””,

!!! ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘all”,
MODIFY `start` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT ””,’ at line 6

result in this example NOT NULL DEFAULT ”all”,
should be NOT NULL DEFAULT ‘all’,
so i’ve removed apex here $colDefault = “DEFAULT {$col->COLUMN_DEFAULT}”;

Unfortunately there isn’t a similar analysis for rum.js (which is EOL and not being actively worked on).

Thanks for the reply 🙂 Happy to see that you are open to allow API access

I was thinking about having an API that we give me the same result as the tool does but in JSON format.

To provide more context, if GTM is used to add scripts on production and is owned by the media team then it is difficult to control what is getting loaded on production.

I’m trying to use RUM data to proactively look for new third-party scripts. Nothing fancy though, during the first run system will list of all third-party scripts, use resource timing and/or 3rdParty-io data to rank the script. In the subsequent run, I should be able identify a new third-party script, rank it and alert if it is a risk to security or performance.

Thanks & Regards,
Nikhil

Thanks Nikhil! I’m definitely open to having an API.

What kind of queries would you want?

This looks awesome! Great Job!!

is there a way to use this tool through REST API?

Thanks & Regards,
Nikhil Pawar

Interesting! I would assume it would work that way as well, but haven’t tested it. I’m using MediaWiki for a few sites as well, so I may have to try it out soon!

You could use something like this maybe, with a replacement pattern?

rr * “(.*set[0-9]+img[0-9]+).*” “$1” /p

That would remove everything after set#img#

I have a filename pattern like .*set.*[0-9]img.*[0-9].*
To explain that in plain english (if my regex is off) the filenames start with any string of unknown characters (including periods, hyphens, commas, apostrophes, etc) followed by a specific pattern set#img# (where the number is between 1-4 digits long), followed by another string of unknown characters.

I need to remove all characters after the set#img# pattern in the middle. Any advice?

Hi Kyle!

You may need to install additional packages once Cygwin has been installed. In the version of Cygwin that I’m using, I have to run cygwin\setup-x86.exe.

Then search for package “ssh” and under the “Net” category you should find “openssh”.

Good luck!

If you maybe have a copy of these files hosted somewhere or could advise on where I might find them, that would be greatly appreciated. (I’m still learning all of this so forgive me if the answer is obvious)