I have a 16 character string that comes through something like this:
I need to be able to format the string as it would appear in a system i.e
NOTE that the 4567 digits shown above relate to the last four digits of the card number.
This question helps format the string to something like 1234-5678-9123-4567
But it does not help with the format required above.
On one of our mysql databases the size on disk is way larger (28GB) than the actual data (~5GB) so I had a closer look to the files contained in mysql-data
The above remain even after mysql restart, server reboot etc
Any idea if these are temporary tables that survived e.g. a crash? on a production system is it safe to just remove them or do I need to handle them in a different way?
By the way we do have file_per_table set to true.
The table files you are seeing are most likely resulting from an ALTER TABLE operation which could not be completed. The relevant portion of the MySQL docs says:
Possible Duplicate:
A comprehensive regex for phone number validation
but how to add rule in this so it can also handle the second one?
© 2025
