Easiest way to migrate one db to another?

[Tim_Myth]

I'm being my typical lazy self and wondering teh easiest way to move an existing install of phpld to another server. I have little knowledge of mySQL, but I can make the time to learn what I need to know.

[Tim_Myth]

And of course, the only thing I accomplish by being lazy and asking silly questions is showing off my ignorance... :D

http://www.clockwatchers.com/mysql_dump.html Has a nice simple tutorial that showed me just how simple it is to import and export a database.

[David]

Good, I'm glad you worked it out.
Usually, I use the dump function from phpmyadmin.

[vkaryl]

Yup, soon as you start messing about with databases phpMyAdmin becomes your best friend. You'd be surprised what you can do with it....

[Tim_Myth]

I managed to dump the database from one web host without a problem, but when I tried importing the database into the new host, I kept getting a **censored****censored****censored****censored**ed "1044: You are not authorized" error. I wasn't pleased with phpMyAdmin at that point... :D

But there's more than one way to skin a cat! I simply exported all the tables instead of the whole database, then added the tables to my new database on the new web host. Might be a good factoid to file away since I found numerous blokes like me who had the exact same problem, but very few who could explain a fix in simple terms a guy like me could understand.

And now for my next trick, watch me pull a rabbit out of my hat!

But seriously, now I have to figure out how to add an rss feed to the top of my directory. :wink:

[vkaryl]

That's a weird one. Never had that happen! Good to have the alternative idea though, thanks for the info!