且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何将本地MYSQL数据库上移到远程数据库服务器

更新时间:2023-02-02 18:11:23

在phpMyAdmin中打开数据库,然后从菜单中选择导出".向下滚动并选择另存为文件复选框,然后按Go.

Open up your database in phpMyAdmin and then select Export from the menu. Scroll down and select the Save as file checkbox and then press Go.

现在在生产服务器上的phpMyAdmin中打开数据库(注意:您将需要首先创建数据库),然后从菜单中选择Import.浏览到您保存的文件,然后按执行.

Now open up the database in phpMyAdmin on the production server (Note: you will need to create the database first) and then select Import from the menu. Browser to the file you saved and press Go.

如果一切顺利,您现在应该在生产服务器上拥有数据库的镜像! :)

If everything goes well you should now have a mirror image of your database on the production server! :)