Re: How to start MySQL

[Peter Brawley]

Queries sent to MySQL by PHP depend on a database structure---tables, indexes, perhaps stored routines---created before the PHP webapp runs.

To work with this DB, you need the same version of MySQL installed on your local machine, plus a local web server eg Apache, plus PHP. If you're unfamiliar with MySQL, you'll need to work through the initial chapters of the manual. Ditto for PHP.

Then you need to use phpMyAdmin or another such utility to export the web DB to your local machine, and a FTP utility to export the PHP scripts to your local machine, so that you have a working copy of the website. Now use a local copy of phpMyAdmin, and or MySQL Workbench, to study the DB. And make backups.

Then you need to analyse the DB and how the PHP scripts use it, and document that exhaustively.

Into that document, you plug the change requirements, then you analyse hwat has to be changed in the database structure, and finally in the code.

Then you code.

You've a long learning curve ahead. You may want to hire a PHP-MySQL consultant to get you started.



Edited 2 time(s). Last edit at 03/26/2016 02:08PM by Peter Brawley.