Re: [cobalt-users] mysql database

[Nell Bolen <nell@xxxxxxxxxxxxxx>]

Brian Feliciano wrote:

> i have a problem uploading my mysql database.
> i am using WSFTP and logged in as the admin user and located the mysql
> folder but unable to upload because it said "permission denied".
> is there a way that i can transport my local mysql database to the cobalt
> database?by the way our cobalt is remote.
>
> thanks a lot
>
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users

You can ask your current db to do a "dump" and then import the txt file you
get from the dump to the new MySql db, either via telnet or a web interface
like PhpMyAdmin. When you say that your cobalt is remote, do you mean that
people who will be using your new db will be using it from a different
network machine? If so, and if that's a different situation than before,
you'll have to change your grant tables before using the new db is possible.
At least that's my best guess. Someone on this list can surely tell you step
by step exactly what you need to do. Contributors here seem to be very
helpful that way, at least that's been my brief experience. A good one.

Regards, Nell
nell@xxxxxxxxxxxxxx