| Home Profile Fun |
#54 Linux 03.04.2007
The command mysqldumpCreate a dump of a mysql database as user root. mysqldump databasename --opt -u root -p > backup.sql Import a dump of a mysql database as user root. mysql databasename -u root -p < backup.sql Create a dump of all mysql databases as user root. mysqldump --opt --all-databases -u root -p > backup.sql Import a dump of all mysql databases as user root. mysql -u root -p < backup.sql Secure copy of a mysql dump to a remote server with scp. scp ./backup.sql username@servername:./folder1/ |