Changing databases

[Anon]

Hello everyone, soon I am going to switch to a better and faster host. They only let you use the database that they provide. I somehow need to get everything off the database I have now and onto the new database. The host im at now does let me use PhpMyAdmin, I know with that you can load .sql files, but can you create them out of the database you have? And how? Thanx!

[yelvington]

Using phpMyAdmin:

1. Click on the database's name on the left side of the screen.

2. Look in the middle where it says "View dump (schema) of database."

3. Click "Structure and data" and "send"

4. Click "Go"

You will receive (as a download) a .sql file that contains both the schema and the data. Importing that file into a new mysql setup will restore your complete database.

After you move, you can use phpMyAdmin to do the import, or (if you can telnet or ssh) you can use one of the command-line mysql utilities, or you can write your own PHP code to do so (it should not take more than five or so lines of code).

[Anon]

Thankyou!! That is exactly what I needed!