Automated Tool To Rename files using MySQL database

On my computer I have approx 15,000 songs that are named is a less than helpful way, for example:

[login to view URL]

I want to rename these files using the information stored in a MySQL database.

a) Check to see if any new files have been added since the script was last run. (This script will be run every week and I don’t want to start renaming files that have already been renamed.

b) Copy new files to c:\Users\Quiz\Sync\01 Nick Burrett\Music\Sunfly B5014

c) Lookup the first file (for example: [login to view URL]) in MySQL “files” table and retrieve “trackid”

d) Lookup “trackid” in MySQL “tracks” table and store the “title” into memory.

e) Lookup “trackid” in MySQL “artists” table and store the “name” into memory.

f) Rename the file from [login to view URL] to name - [login to view URL]

The resulting track should be something like Adele - [login to view URL] instead of [login to view URL]

Skills: MySQL, Python

See more: copy database mysql query, mysql duplicate database with different name, clone mysql database to another server, mysql workbench duplicate schema, mysql workbench duplicate database, mysql copy database to new database, mysql clone database same server, copy database mysql command line, tool apple script rename files depending on entries, rename files using powershell, gui matlab using mysql database, monthly reports using mysql database, java rmi using mysql database, create reports php using mysql database mysql php, using mysql database asterisk ivr, using mysql database generate pages wordpress, jsms using mysql database, java swing login using mysql database, quickbooks using mysql database, using mysql database netbeans j2me

About the Employer:
( 169 reviews ) Bridgwater, United Kingdom

Project ID: #16313899

Awarded to:


Hi, I understand what you need and I could perform your task. the only thing I want to clarify: "b) Copy new files to c:\Users\Quiz\Sync\01 Nick Burrett\Music\Sunfly B5014" is the path always the same or shou More

$30 USD in 1 day
(15 Reviews)

6 freelancers are bidding on average $27 for this job


I don't have a lot of experience with Python, but I'm very familiar with PHP. My proposal is for writing a PHP script that will do exactly what you describe, with easy to edit options (where the tracks are located, More

$25 USD in 1 day
(139 Reviews)

I am expert of mysql Database I have 5 years of experience in Database Management. Feel free to contact me .

$10 USD in 1 day
(27 Reviews)

I’m dedicated professional Web, Desktop and Apps Programmer & Developer and freelancer only. I have been working with challenge and hope to improve future plan with good network every client. I am ready to work.

$25 USD in 1 day
(5 Reviews)
$55 USD in 1 day
(1 Review)

Good afternoon! Currently working with Business Intelligence, where my job is to turn data into relevant information and present it in reports and dashboards. I work daily with multiple data sources at the same tim More

$15 USD in 2 days
(0 Reviews)