开发者

Copying Mysql data to a remote server

开发者 https://www.devze.com 2023-01-06 12:54 出处:网络
I am running mysql server on my computer.I would like to copy the databases i have created and their tables to a remote server,and that is my website.Is there a开发者_运维百科 software(a windows softw

I am running mysql server on my computer.I would like to copy the databases i have created and their tables to a remote server,and that is my website.Is there a开发者_运维百科 software(a windows software) that can help me copy my databases to a remote server?.


If you have external access to both mySQL servers, HeidiSQL is a great Windows GUI for mySQL with a good export function.

Alternatively (also needing external access), install the mySQL binaries on your machine and do a simple

mysqldump -h hostname_source -u username -p databasename > dump.sql
mysql -h hostname_target -u username -p databasename < dump.sql
0

精彩评论

暂无评论...
验证码 换一张
取 消