i am a complete novice at php first of all. but i have a vbulletin forum that i hosted on a free hosting service. of course i maxed out my mysql quota, so now i have to change hosts. i found one, but i want to keep my forum in tact the way it is now. how can transfer the databases using phpmyadmin? in detail if possible.

thanks for all your help, it is greatly appreciated!

Open phpmyadmin
Select the Database
Goto "Export"
Click "SQL" (Should already be selected)
Click "Go"
Copy that SQL code
*Database is backed up*

To insert on the new host
Again, select the database (after you create it)
Click the "SQL" tab
Paste the code into the box that says "Run SQL query/queries on database xxx"
Click "Go"
*Database is restored*

Good luck!

okay maybe i'm too stupid for this. how do you "Select the Database"? because when go to export and select sql and then click go, nothing happens. i see no code. i have no idea what im doing wrong. i tried to save it to a file. the file has things in it, so i go to the sql tab on the new host phpmyadmin screen and try to "Run SQL query/queries on database Databasename" from the file. then it says "No SQL query!"

help please :(

im not dumb im just to lazy to google it!

also, the options selected by default are...

SQL options:

Add 'drop table'
Add AUTO_INCREMENT value
Enclose table and field names with backquotes

Data

im not dumb im just to lazy to google it!

To Select the Database, the first thing you see when you open phpmyadmin should literally say "Database: Please Select a database" and there will be a dropdown menu to choose your database from. It's on the lefthand side of the screen.

"also, the options selected by default are...
SQL options:

Add 'drop table'
Add AUTO_INCREMENT value
Enclose table and field names with backquotes

Data"

Yeah, that's fine. To the left of that, it should say "Export." Make sure "SQL" is checked.