I can see that the 7.x admin panel --> System Admin --> Database Backup provides for DB backup and restore, as it should and that's probably sufficient for most uses.
But just in case, I'd like to explore alternatives. I think there are two other ways of backing up and restoring DBs, one by using a command shell on the web server and the commands, broadly
mysqldump > dumpfile.sql
to dump and
sql < dumpfile.sql
The second alternative is to use commands in phpMyAdmin, assuming of course this utility is available on the webserver.
Here is my question: What exact commands will produce equivalent results using "mysqldump" and "mysql" and phpMyAdmin, such that a database dump produced by one of these three methods can be restored by the other two, interchangeably?
You can view all discussion threads in this forum. You cannot set up a bounty in this discussion thread. You can start a new discussion thread in this forum. You cannot reply in this discussion thread. You cannot start on a poll in this forum. You cannot upload attachments in this forum. You can download attachments in this forum. You cannot up or down-vote on the post in this discussion thread.