[thelist] Moving a MySQL Database

[Hassan Schroeder]

Michael Barrett wrote:
>
> > How can I move the MySQl database off my
> > computer to the server where the site will be hosted for a while.
>
> >From a Unix command line, you can enter:
> mysqldump databasename > filename.txt
>
> This will create a text file containing all the SQL statements needed to
> fully recreate all tables in the database. I'm not sure if this will work in
> a Windoze environment.

It does - I've used it to transfer stuff from a W2K development box
to a Linux server - no problem at all.

--
H*
Hassan Schroeder ----------------------------- hassan at webtuitive.com
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

    -- creating dynamic Web sites and applications since 1994 --