> -----Original Message-----
> From: Neil R Porter [mailto:[EMAIL PROTECTED]]
> Sent: 31. joulukuuta 2001 13:55
> To: Expert Mandrake List
> Subject: [expert] Moving MySQL databases to hosting server - help!
> want to be able to transfer it up to my web hosting space.
> They claim to support MySQL, although I have no idea how to move
> the actual files I've developed on my development server here at
> home.
Easiest way is to do full dump (or backup) with mysqldump:
mysqldump --opt -uyour_mysql_user -p your_dbase > your_dbase.sql
and then read it back in your web hosting server with mysql client:
mysql -uyour_mysql_user -p your_dbase < your_dbase.sql
> Also, how would I make sure
> the permissions I've setup in the mysql tables can be
> transfered so that I
> can use the database I've created?
How to set permissions depends from your hosting company.
As an example in my web hosting company gives me
one username for my mysql database who has all rights
to it and only to it (and database name is also defined by them,
which in my case is my username).
Which means that I'm not able to define any permissions by using
mysql own permission system.
So you need to be very careful that you check everything what
your users are sending to database (if they do).
Happy New Year
-- juhani --
