mysql masking PHP script – Upwork


need to have a PHP script to mask and randomise date in mysql database
The script will need to run as CLI with DB connection details  passed as arguments

We'll have approximately the following Tables and fields that needs to be masked:

user_profiles (id,birthday)
testimonials (id,email,first_name,last_name)
phones (id,phone_number)
transactions (id, paypal_email, stripe_transfer_id)
accounts (id,name,paypal_email,routing_number, account_number)
users (id,first_name,last_name,email,password,facebook_id)

The script will need to randomise user names in USERS table using database of names, which will be supplied.
Then replace email addresses where email = "{​$row->id}​.{​$first_name}​.{​$last_name}​@example.com

Then replace data in other tables…

The script will be used on a database which is about 1T in size, which contains up to 1M record per table.

The script need to run as fast as possible so speed optimisation is one of the most important metrics.

Please include your time zone and availability during the day

Budget: $100

Posted On: June 01, 2018 08:05 UTC
Category: Web, Mobile & Software Dev > Web Development

Skills: MySQL Programming, PHP
Country: Australia
click to applyPosted on Upwork.com