Hi,

I'm about to upgrade from 3.21.29a gammma debug to 3.22.32 on WinNT 4.0.

But before I put this onto a live server, I wanted to test the upgrade procedure
on a local NT server.

I want to duplicate the existing live database onto the local NT server first,
so that I can test functionality before and after the upgrade process.

But I'm having problems in duplicating the database.

I've tried:

1 - using phpmyadmin to get a structure & data dump and doing:

mysql databasename < dumpedfilename

-> this creates the tables correctly but falls over when doing the insert
commands

2 - using phpmyadmin to get a csv dump and doing:

mysqlimport databasename dumpedcsvfilename

-> this has problems with the dataformat of the csv file.

3 - using

mysql select ... into outfile 'outfilename.txt'

-> this falls over cos I don't have the rights to create the file remotely

Surely there must be some easier way to duplicate a database? Or am I doing
something blatantly wrong?

Cheers,