Hi-
I need to move an existing e-commerce site to a newer, more capable server. I can export/import the database using phpmyadmin, but is there a way to also transfer user privlidges and rights for those databases? (With out, of course, doing it manually)

Thanks-
Eli

If you have root, also export the "msyql" database. Specifically the "user" and "db" tables. You may have to edit the SQL a little to avoid copying user accounts you don't want to, or if the MySQL version is different on the target server.

Well, it shouldn't be hard to find the config file for that application and see what the username/password for the database are. So, just set them up on the new server along with the database and export/import the database only. That's the approach that always works.

You will likely need new grants on the new host anyway -- you should contact them about this.

Either way, we have a faq on this here:

http://www.modwest.com/help/kb6-54.html