We look at how to gain structure from unstructured data, via AI/ML analytics to create new records, selecting object data via SQL and storing unstructured files in NoSQL formats.

FTP Download Step one is to fetch the latest data from another server via FTP. In Windows you can accomplish this using a script to send ftp commands.

Or, maybe you want to search the subject line and the content of a set of forum posts for certain keywords. Query multiple columns in a mySQL database using PHP to issue the mySQL commands.

If a web-based GUI is better suited to your admin skills, Jack Wallen wants to show you how to back up and restore your MySQL/MariaDB databases with one of the easiest tools on the market.