Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Sign In
Not a member yet? Click here to register.

Backing up and restoring DB: alternatives


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

to restore.

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?


Thread Information
1 post
1,156 times
Last Post
Last updated on 10 years ago
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.
Users who participated in discussion: hen3ry