Moving a large MySQL DB from Shared -> Dedicated

[outline]

After development, we will be moving the database from a shared environment to a dedicated environment so that we can customize and tune the server to meet our specific needs.[nbsp][nbsp]What do you all recommend as the best method to do this?

I have the PHP MysqlAdmin tool installed.[nbsp][nbsp]Do you all know of a the best way to actually replicate a database, its structure, tables, and data for large amounts of data?

We have written a PHP script to go through and pull records and then put those records into the new database but the process times out b/c PHP scripts can only run for 20 seconds on the shared server.

You all are always such a help.[nbsp][nbsp]Thanks in advance!
------------------

[Dan Kaplan]

I don't know how to do it, but if you don't get an answer, contact Alex at Gossamer Threads:[nbsp][nbsp]alex@gossamer-threads.com

He's written an Import/Export script for Links SQL that runs via telnet and can handle thousands of records (I don't know if it has a tested limit) without timing out problems.[nbsp][nbsp]You could probably use his script directly, or maybe get him to customize something for you.

Dan

p.s. I have no financial interest in recommending this route, I'm just a big believer in Alex's scripts and programming abilities.[nbsp][nbsp]:)

[PaulKroll]

The best place for information on mysql is the home page, http://www.mysql.com.[nbsp][nbsp]In your case, you probably want to look at "Dumping the structure and data from MySQL databases and tables" at http://www.mysql.com/Manual_chapter/manual_Tools.html#mysqldump