首先创建数据库备份
mysqldump -v -u databaseuser -p databasename > db-name.out
然后将备份传送到远程服务器
scp db-name.out root@yourserver.com:/home/user
最后导入数据到新的数据库里
mysql -u newdatabaseuser-p newdatabasename < /home/user/db-name.out
If you would like to make a comment, please fill out the form below.
