IT/Software/Database Applications/mysql command line/mysqldump

From msgwiki
< IT‎ | Software‎ | Database Applications‎ | mysql command line
Revision as of 17:13, 6 February 2020 by Nathan (talk | contribs) (Added dumping to a remote host section)
Jump to navigation Jump to search

Options

  1. You can do this from phpMyAdmin or other gui based apps.
    1. See the Applications page for this.
  2. You can perform the dump to various resources.
    1. Dump to a text file.
    2. Dump to a zipped file
    3. Dump to another database
    4. Dump to another Database on another server

Dumping To a Remote Host

When running a mysql dump to a remote host directly over ssh the host database will be locked until the sync has finished. (Can be up to 5-10 minutes for lager databases)

The above problem can be easily circumvented by dumping to a file and than cating the file into ssh to the remote host as such. 

mysqldump --verbose -u<localDbUser> -p<localDbPassord> <localDbName> > /tmp/<dbName>.sql && cat /tmp/<dbname>.sql | ssh user@remote.host mysql -u<remoteDbUser> -p'<remoteDbPassword>' <remoteDbName>
Retrieved from "https://msgwiki.msgeducation.com/index.php?title=IT/Software/Database_Applications/mysql_command_line/mysqldump&oldid=424"