UBB.Developers Forums Community Development Programming MySQL and Server Configuration How to move database structure to new database

Greetings,
I realize this is a very elementary question. I'm a very low tech forum administrator with zero sql and db admin tools. My host will not allow MyPHPAdmin or similar tools on their servers. So, now that my forum database is about to max out its space allocation, I need to archive it and start a new one (at the same time upgrade to ver 6.2.x

My question is how to move the empty database structure to the new database which may or may not be on the same server?

The users table, of course, will need to be transferred with content in tact.

Your suggestions, options, whatever, will probably all be useful and educational.

thanks!

Do you have command line access? If so you can use the mysql command line tools ( see mysql.com for docs on mysqldump ).

If not, you will need to write a script to do the work. Which is exactly what phpmyadmin is, just a php script. A set of scripts, actually. As long as you don't hard code the username and password into the phpmyadmin config I don't see what the harm is.

Lacking any of that I guess you would have to ask your current host to make a database dump for you.