Command to backup the database status in the old database

mysqldump fairroot -h lxsaliq.gsi.de -P 3306 -u fairroot --password=strengGeheim > 
     mysql_backup_lxsaliq_fairroot.sql

Command to load the backup to new database

mysql fairroot -h mysql.gsi.de -P 3306 -u fairroot --password=strengGeheim <
    mysql_backup_lxsaliq_fairroot.sql

-- FlorianUhlig - 15 Sep 2010

This topic: Homepages > HomepageFlorianUhlig > MysqlFlorianUhlig
Topic revision: 2010-09-15, FlorianUhlig
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding CBM Wiki? Send feedback
Imprint (in German)
Privacy Policy (in German)