I've mainly been programming with ASP/Access, so I'm pretty new to using PHP/MYSQL. I like the PHP language, but developing on a MYSQL database on the other hand has been troublesome...
The main issue that I've had is that when I I create the database on my development server (local machine), I can't just quickly upload the database to the real server (hosting company), I end up having to recreate the entire database then use PHPMyAdmin to tediously copy all of the records.

Is there something that I am missing in all of this? Is there a way to quickly copy my MYSQL database to a hosting company's MYSQL?

Thanks

Dear Contact,
Use the Export tab in phpmyadmin - then Import at your host - depending on permissions, you may have copy the sql file to a host directory.

If your file is relatively small, you can cut & paste the export contents into the SQL execution field in phpmyadmin as well.

This process takes approx. 1 minute or so for my tables w/10,000+ records...

Regards,
Brent

What i do is use a little app called mysql-front, create all my tables on my machine test input data whatever then export the table to an sql file, then on the php admin main page instead of creating tables i run a sql querry, browse to the file on my hd and it imports the table, works a treat for me.

If you post your email i can send you mysql-front if needed.

hope this helps you

Iain

head hurts, 'mental note to self, stop banging head !'

Great, Thanks a lot