I need to Import data information into my MySQL database for my video website running on a script called Social Media produced by [url removed, login to view]
The video files each have data record including such as title, description, Category number, and file name as well as other details. I have a back up data file that includes a record for each file name. File names will match for the majority of the videos on the new Mysql database. I need the title, description, category number, tags, view count , for each record bulk inserted using the File Name as the identity for each record into the new Mysql data base.
I've attached two files .
1. [url removed, login to view] this is actually a .sql file but I was unable to upload it here so I had to save it as a .txt file . This is the Files Table from the new database used phpMyAdmin in cpanel on my server to copy the table with data for Files, from the MySQL database that my website script uses to operate I then exported it to my hard drive on my local computer but since I could not send the .sql file I opened it in open office and then saved it as a text file.
2. [url removed, login to view] is the original backup data that has all the record information for each video file Its only a back up of the Files Table this was from the sql data base of the same script that was running on another server that I ended up losing and did not have a complete backup. I only had a backup of all the video files that were in the scripts file directory. Regarding my new server I installed a fresh copy of the social media script and have been bulk importing the video files 10 at a time as I get the time and I still have a lot of video files to import.
The job now is to update the video files that are in the new data base and I can provide the .sql table/ data files and access to my cpanel.