duanqian9593
duanqian9593
2009-01-26 00:22

通过PHP在服务器之间复制MySQL结构

已采纳

I'm in need of help - I've got two mysql databases on different servers with a web host, and I need to copy a Joomla installation from one to the other. The problem I have is that the only way I can access the data is via php, as direct odbc connections to the database are locked down.

I don't mind doing it table by table, but have no idea of how to code the script :(

My knowledge of php is limited (hence using Joomla), so if anyone has a couple of minutes to point me in the right direction, it'd be appreciated.

Thanks in advance,

PG

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

3条回答

  • dtnd30892 dtnd30892 12年前

    Can you install phpMyAdmin? If so, it has a database export/import functionality that would likely be perfect for this.

    点赞 评论 复制链接分享
  • dongmeng2509 dongmeng2509 12年前
    点赞 评论 复制链接分享
  • duanfa2014 duanfa2014 12年前

    You could use mysqldump, though I would try phpMyAdmin first as the other poster has suggested.

    点赞 评论 复制链接分享