MySQLADMIN How to edit tables via CSV and Google Excel Document back up tips included in this post

This video is great if you want to edit things in MySQLAdmin. MySQL comes with hosting on most hosting sites. When you create a PHP based website or other sites certain databases are created in MYSQL which is updated via access on your hosting from the backend of your website. You can also get access to these details and edit them if you know what you are doing. This is why a backup is recommended. A backup can be done for the whole database of every site just in case any serious corruptions occur during editing. Also you will find out in this video how to just edit one website database, how to find the correct name in FTP file host then locate in MYSQLADMIN to begin editing. Once you have located the file in FTP, got the name from the correct place (Watch Video!) you can go into MYSQLADMIN and start editing. The next stage of this helpful video shows how to locate a file where data might me and how to check you have found the right one before editing or backing up. The video shows the difference of various files to upload as CSV, how to edit the settings so the transfer from CSV to EXCEL sheets in Google Docs goes well and does a great job of using an Excel sheet and how to quickly add new data, edit columns and save the new file for uploading to MYSQL for uploading back again from the edited Excel Spreadsheet. The other tip I am hoping is correct is that from this video you will be one step closer to building email database on the backend of your Wordpress site, be able to import and export emails to Excel and put back into website afterwards. This is great for quickly checking emails that are false, and locating real names before sending mail to subscribers. Any suggestions on this please leave a comment below.

Here is a list of other helpful videos on understanding Wordpress. The obvious one is learning PHP, the next is how to edit permissions in SQL and create conversations between your PHP site regardless of what that might be. From Wordpress to BB forums depending on the access permissions you are allowed within your hosting plan. The cheapest plan is what I am thinking here. Again if you have any suggestions on why it might be good to upgrade let me know here. This is just a educational quick brainstorming post. Here are the other helpful links I watched before coming to the video you see above. The original video is available on VIMEO and I have provided the link, (I uploaded just in case it disappears).

• Vimeo original link for video above. [http://vimeo.com/23517883] Viewed 9/5/2014
• How to configure MYSQLAdmin with a Gmail or Live account so you can send emails [http://blogs.msdn.com/b/suhde/archive/2009/07/12/how-to-configure-sql-server-database-mail-to-send-email-using-your-windows-live-mail-account-or-your-gmail-account.aspx?PageIndex=1] Viewed 9/5/2014 posted 12/7/2009
• Creating Database with Studio Express (just one of the many alternative options to making an email database [http://mrbool.com/creating-databases-using-sql-server-management-studio-express/4672] Viewed 9/5/2014
• How to Create an SQL Database, user or delete it via Hostgator page [https://support.hostgator.com/articles/cpanel/how-do-i-create-a-mysql-database-a-user-and-then-delete-if-needed] Viewed by Robert Bridge on 9/5/2014 
• Perhaps helpful problems some people had on Wordpress forum with PHP code in Wordpress so you can understand how to get things right the first time setting and editing tables in your database via MYSQLADMIN [http://wordpress.org/support/topic/how-to-enter-php-code-for-accessing-mysql-database-tables] viewed 9/5/2014
• NEWBOSTON Playlist for PHP. NEWBOSTON has a great PHP forum and a really great source of video information for editing PHP and many other IT solutions. [https://www.youtube.com/watch?v=iCUV3iv9xOs&list=PL442FA2C127377F07]
• The post I found the original video uploaded above. [http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415] viewed 9/5/2014

My hope is to come back here and update this post when more information comes to my attention. The goal is to create a step by step site on how to set up a solid SQL database for sending emails to clients without having to do to much. You may also be able to import and export users on website and comb through editing users who are not real emails and names in Excel, then upload back into database. The problem still seems to be how do I create a table for sending HTML emails out to announce new posts on website or promote any shares on social media. If you are interested in this too. Please leave some blurbs here on Bloggers.