Copy MySQL structure across servers via PHP

views:

338

answers:

Copy MySQL structure across servers via PHP

Hi to all, 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,

+3 A:

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

ceejayoz 2009-01-26 00:33:04

Thanks CeeJay, There's a scaled down version of phpMyAdmin on the 1and1 control panel that they've muddled around with - I've found the export link and managed the migration in seconds :) Thanks..

Paul Green 2009-01-26 01:09:06

Glad to hear it! :-)

ceejayoz 2009-01-26 01:32:04

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

da5id 2009-01-26 00:34:59

+1 A:

Look at this post.

http://stackoverflow.com/questions/459796/what-would-be-the-best-way-to-backup-and-restore-mysql-dumps-with-just-php

Ian P 2009-01-26 00:36:11

ansaurus

tags:

views:

answers:

Copy MySQL structure across servers via PHP

related questions