General PHP question

I am a PHP newbie and need help on hosting and moving databases

[BlueGhost]

Hello all, i work for a real estate company and we want to get into database based sites, for customers and also a realtor based site that only our realtors will see.

My Host limits me to 100 databases, and i can only use myphpadmin, which seems simple but im not sure if i like it.

Also, is it hard to move database's across web hosting companies? If i create 10 database's with 10+ tables, will i have to enter each one by hand or is there a way to export it and import into a new database?

[edited by: jatar_k at 5:41 am (utc) on Dec. 31, 2006]
[edit reason] no specific hosts thanks [/edit]

[IanKelley]

I'm not sure that suggesting a specific host would be in the spirit of the WW TOS.

As far as your other concerns...

PHPMyAdmin is a fanstastic database management application for MySQL. Short of writing your own from scratch you won't find better.

You'll find an export/dump option in PHPMyAdmin. The resulting files can be imported at your new location.

[BlueGhost]

Thanks for the reply, i didnt realize how great myphpadmin is.

[edited by: jatar_k at 5:41 am (utc) on Dec. 31, 2006]