I would appreciate your bid to train me how to use myphpadmin to manage my mySQL database for the below steps. This probably is best accomplished by 30 to 60 minute screen sharing SKYPE conferencing session (screen and phone) depending on how long you think it will take to demonstrate all the steps. MyPhpAdmin is already installed on my godaddy account.
You should be very proficient with MyPhpAdmin, mySQL, in spoken English and have a Skype account. The training should occur 9am to 9pm Pacific Time, USA
Note, my database runs several surveys as well as the survey program itself, isalient, and there are about 30-40 tables in the database, which I’m not familiar with.
Here are the areas I require training:
1 How to copy or backup the pertinent tables if editing or adding data to them.
2 How to Query the tables/records of a particular survey for a count of how many respondents meet one or several criteria. This includes
a) how to find the right tables for my purposes
b) how to run a query of multiple tables together, if possible and needed.
c) Optionally, if there is a way to “save” a complex search for future use, that would be good.
3 How to mark matching or selected records as “approved” or “disapproved” or other labeling, by adding one or more fields and entering content into those fields, for later querying.
4 When adding additional fields to the record of surveys, make sure we’re not destroying functionality in the survey package — maybe I just have to run regular copies or backups?
5 Export matching records containing emails to a CSV for use with an email management system.
Please include in your response if you believe if all the steps can be easily handled or not, and if the time I’ve outlined is about right, or not.
Your quote should include both the training and a couple emails to followup on for any problems that come up.