Updating database with phpmyadmin
It is pre-installed with your web hosting subscription.In php My Admin you can, import, export, optimize or drop tables.This file can be found in the root directory of the domain you have installed it on, unless you have relocated it.
Each field corresponds with the information you should already have, so inputting your correct database connection strings should be quite straight forward.
Upon inputting the information about your database, you can then save the file and upload it.
Hi folks Just wondering if there's a best practice in regard to updating a live database from the same database maintained at home.
Currently I update my DB at home using PHPMy Admin and then do an export of all the data tables etc.
*/ define('DB_CHARSET', 'utf8'); /** The Database Collate type. */ define('DB_COLLATE', ''); Your details related to the above need to be put in the corresponding fields within the file.